| 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.cat_id, g.shop_price as ori_shop_price, 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 `zxc`.`zxc_goods` AS g LEFT JOIN `zxc`.`zxc_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 ('941') OR g.goods_id IN ('374','383','384','385','386','390','391','392','393','395','396','397','398','399','400','401','402','408','409','410','411','412','413','414','415','416','417','418','419','420','421','423','424','425','426','427','428','429','430','431','432','433','434','435','436','438','439','440','441','442','443','444','445','446','447','448','449','450','452','453','458','460','461','462','463','464','465','466','468','469','470','471','472','473','474','475','476','477','487','488','489','499','500','501','502','503','504','505','506','507','508','509','510','511','512','513','514','515','516','517','518','519','520','521','522','523','524','566','567','568','572','576','578','581','582','583','584','585','586','587','588','589','590','591','592','593','594','595','596','597','598','599','600','601','602','615','634','635','636','637','638','639','775','776','777','778','779','780','781','782','783','784','785','786','788','789','826','831','832','833','834','835','836','855','865','990','991','992','1013','1017','1047','1049','1123','1126','1134','1136','1138','1140','1141','1143','1145') )AND g.brand_id=115 AND g.goods_id IN ('426','427','428','411','412','487','493') ORDER BY salenum DESC LIMIT 24 |