| SQL | SELECT IFNULL(o.num,0) AS salenum, g.goods_id, g.goods_name, g.click_count, g.goods_number, g.goods_name_style, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, g.promote_price, g.goods_type, g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img FROM `lggemuterc`.`tww0ogj_goods` AS g LEFT JOIN `lggemuterc`.`tww0ogj_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' LEFT JOIN (SELECT SUM(og.`goods_number`) AS num,og.goods_id FROM ecs_order_goods AS og, ecs_order_info AS oi WHERE oi.pay_status = 2 AND oi.order_status >= 1 AND oi.order_id = og.order_id GROUP BY og.goods_id) AS o ON o.goods_id = g.goods_id WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('5','239','345','342','339','336','346','343','340','337','347','344','341','338','335','348','236','249','246','262','243','259','256','253','250','247','263','244','260','257','254','251','248','264','245','261','258','255','252','233','297','298','299','296','300','392','410','407','417','414','411','408','421','415','412','409','422','416','413','240','352','349','353','350','351','237','313','310','307','304','301','311','308','305','302','312','309','306','303','234','265','281','278','275','272','269','266','282','279','276','273','270','267','280','277','274','271','268','241','361','377','358','374','355','371','368','365','362','359','375','356','372','369','366','363','360','376','357','373','354','370','367','364','238','329','326','323','320','317','333','314','330','327','324','321','318','334','315','331','328','325','322','319','316','332','235','294','291','288','285','295','292','289','286','283','293','290','287','284') OR g.goods_id IN ('') ) AND g.supplier_id>0 ORDER BY salenum DESC LIMIT 36 |