| SQL | SELECT g.goods_id,g.cat_id, g.goods_name, g.goods_name_style, g.click_count, g.goods_number, g.market_price,g.consignor_id, g.is_new, g.is_best, g.is_hot, g.is_limit, g.is_shipping, g.shop_price AS org_price, g.mappoint,g.is_act_field,g.is_seckill_act_field, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price,g.is_promote,g.is_real_promote, g.promote_price,g.real_promote_price, CASE WHEN g.promote_price != '' AND g.promote_start_date < 1714076468 AND g.promote_end_date > 1714076468 THEN g.promote_price WHEN g.real_promote_price != '' AND g.real_promote_start_date < 1714076468 AND g.real_promote_end_date > 1714076468 THEN g.real_promote_price ELSE shop_price END AS shop_p, g.goods_type, g.promote_start_date, g.promote_end_date,g.real_promote_start_date, g.real_promote_end_date, g.goods_brief, g.goods_thumb, g.goods_img, g.supplier_id FROM `haoduobaduo`.`ecs_goods` AS g LEFT JOIN `haoduobaduo`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('2355') OR g.goods_id IN ('101','192','294','314','328','340','389','971','1050','1061','1171','1172','1186','1187','1194','1195','1196','1224','1227','1243','1301','1302','1303','1308','1309','1310','1311','1335','1341','1342','1343','1372','1493','1501','1605','1628','1634','1635','1636','1643','1662','1825','1869','1930','1932','1940','2057','2058','2060','2072','2195','2317','2535','2561','2756','2852','2972','3015','3016','3025','3026','3096','3119','3121','3291','3292','3299','3636','3639','3686','3688','3781','3782','3788','3792','3794','3883','3886','3896','4191','4193','4194','4195','4197','4198','4199','4200','4216','4219','4220','4221','4222','4262','4314','4320','4331','4338','4563','4571','4614','4617','4729','4732','4733','4756','4764','4876','5058','5063','5064','5066','5069','5070','5072','5074','5076','5078','5081','5083','5086','5199','5218','5538','5887','5900','5904','5907','5912','6046','6051','6478','6513','6668','6671','6675','6679','6681','6685','6686','6688','6714','6715','6717','6724','6726','6728','6809','6817','6818','6821','6822','6837','6841','6842','6844','6846','6855','6858','6859','6861','6895','7049','7052','7058','7059','7089','7090','7092','7093','7094','7095','7097','7098','7099','7100','7101','7102','7103','7104','7105','7142','7143','7144','7145','7146','7147','7148','7149','7150','7152','7153','7154','7182','7184','7185','7187','7190','7191','7194','7202','7203','7204','7205','7206','7207','7208','7209','7210','7211','7212','7215','7219','7221','7222','7223','7245','7247','7248','7249','7251','7252','7253','7254','7255','7511','7514','7515','7542','7578','7580','7658','7661','7667','7668','7669','7671','7674','7675','7698','7724','7725','7726','7727','7728','7729','7735','7737','7754','7779','7793','7794','7795','7796','7797','7798','7799','7800','7801','7802','7833','7834','7835','7836','8168','8169','8170','8173','8174','8175','8176','8177','8180','8181','8182','8183','8468','8646','8647','8658','8669','8686','8688','8856','9070','9076','9077','9082','9085','9086','9087','9218','9219','9220','9513','9568','9572','10108','10109','10132','10136','10137','10138','10141','10143','10145','10147','10150','10152','10153','10154','10155','10157','10159','10160','10163','10164','10166','10169','10172','10175','10178','10181','10183','10185','10186','10187','10188','10189','10190','10191','10192','10194','10195','10196','10197','10198','10199','10200','10201','10202','10203','10204','10205','10206','10207','10208','10209','10210','10211','10212','10213','10214','10215','10216','10229','10230','12915','12916','12917','12918','15150','15151','15152','15153','15154','15155','15156','15169','15186','15187','15188','15189','15191') ) AND g.is_direct_pro = 1 ORDER BY g.is_identity_c desc, salenum DESC |