SELECT mb_trade_name,t1.pt_id,t1.pt_category,t1.pt_sub_category,t1.pt_type1,t1.pt_type2,t1.pt_name,t1.pt_price,t1.pt_sub_photo0,COUNT(t2.inquiry_id) as total FROM shop_parts AS t1,shop_inquiry_parts AS t2,m_branch AS t3,m_client AS t4 WHERE t1.pt_flg=2 AND t1.pt_shop_cd=t3.branch_id AND t3.client_cd=t4.client_cd AND t3.mb_pubflg=1 AND t4.mc_review_indicator=1 AND t3.mb_parts_division=1 AND t3.mb_parts_from<=20250401 AND t3.mb_parts_to>=20250401 AND t1.pt_id=t2.pt_id GROUP BY t1.pt_id ORDER BY total DESC LIMIT 5
