SQL | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number FROM `myyingxichina`.`ecs_goods` AS g, `myyingxichina`.`ecs_order_info` AS o, `myyingxichina`.`ecs_order_goods` AS og WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('5','182','375','372','369','376','408','373','370','410','374','371','181','382','380','378','381','379','368','178','179','366','180','377','367','4','387','144','398','388','385','404','145','401','400','403','399','402','389','386','406','405','146','397','411','394','391','395','392','396','393','390','3','113','383','110','384') OR g.goods_id IN ('293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','309','310','311','312','313','315','316','317','320','321','322','323','325','326','327','330','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','353','355','356','357','358') ) AND g.goods_number > 0 AND og.order_id = o.order_id AND og.goods_id = g.goods_id AND (o.order_status = '1' OR o.order_status = '5') AND (o.pay_status = '2' OR o.pay_status = '1') AND (o.shipping_status = '1' OR o.shipping_status = '2') GROUP BY g.goods_id ORDER BY goods_number DESC, g.goods_id DESC LIMIT 8 |