SELECT od.product_id, count(*), name, price02_min, price01_min, main_list_image  
FROM dtb_order AS o 
INNER JOIN dtb_order_detail AS od 
 ON o.order_id = od.order_id 
INNER JOIN vw_products_allclass AS allcls using(product_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 = $product_id
 AND o.create_date >= current_date - integer '360'
)
 AND allcls.status = 1 
GROUP BY od.product_id , name, price02_min, price01_min, main_list_image 
ORDER BY count(od.product_id) DESC, price02_min DESC 
LIMIT 5 OFFSET 0