SELECT
    class.product_id,
    coalesce(cnt,0) as cnt,
    class.price01
FROM
    dtb_products_class AS class LEFT JOIN
 (SELECT
     od.product_id,
     count(*) as cnt
 FROM
     dtb_order AS o  INNER JOIN dtb_order_detail AS od   ON o.order_id = od.order_id
 WHERE
     customer_id in (SELECT
                         customer_id
                     FROM
                         dtb_order AS o   INNER JOIN dtb_order_detail AS od    ON o.order_id = od.order_id
                     WHERE
                         product_id = 2
                     )  AND
     o.create_date >= current_date - integer '360'
 GROUP BY
     od.product_id
 ) AS ranking ON class.product_id = ranking.product_id
ORDER BY
    cnt DESC     ,
    price01 DESC LIMIT 5 OFFSET 0;