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