| 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','240','353','350','351','352','349','237','311','308','305','302','312','309','306','303','313','310','307','304','301','234','279','276','273','270','267','280','277','274','271','268','265','281','278','275','272','269','266','282','392','407','417','414','411','408','421','415','412','409','422','416','413','410','241','359','375','356','372','369','366','363','360','376','357','373','354','370','367','364','361','377','358','374','355','371','368','365','362','238','327','324','321','318','334','315','331','328','325','322','319','316','332','329','326','323','320','317','333','314','330','235','295','292','289','286','283','293','290','287','284','294','291','288','285','239','343','340','337','347','344','341','338','335','348','345','342','339','336','346','236','247','263','244','260','257','254','251','248','264','245','261','258','255','252','249','246','262','243','259','256','253','250','233','299','296','300','297','298') OR g.goods_id IN ('') ) ORDER BY salenum DESC LIMIT 36 |