| 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 < 1714419569 AND g.promote_end_date > 1714419569 THEN g.promote_price WHEN g.real_promote_price != '' AND g.real_promote_start_date < 1714419569 AND g.real_promote_end_date > 1714419569 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 ('791') OR g.goods_id IN ('279','414','424','425','443','445','446','447','448','449','451','452','717','718','769','1608','2735','2744','4259','6052','6461','6851','7465','8595','8844','10774','10777','10782','10803','10808','10832','10837','10847','10869','10874','10905','10911','10921','10957','10959','10961','10967','10969','10971','10990','10994','10997','11002','11006','11007','11016','11017','11031','11032','11033','11093','11103','11117','11167','11169','11176','11180','11181','11183','11184','11194','11196','11197','11208','11213','11220','11223','11224','11291','11298','11307','11346','11351','11360','11372') ) AND g.is_direct_pro = 1 AND g.goods_id IN ('2745','2744','2743','2733','3096','3098','4624','6023','6026','6031','6052','6055','6058','6071','6084','6810','6833','6838','6839','6850','6851','6995','7465','7461','7458','7511','7514','7515','8595','8596','8597','8598','8599','8600','8601','8603','8604','8873','8874','10774','10786','10796','10815','10817','10818','10832','10852','10862','10881','10883','10884','10905','10926','10945','10957','10959','10961','11006','11007','11029','11035','11036','11070','11071','11082','11093','11100','11101','11108','11144','11147','11162','11167','11169','11176','11183','11184','11239','11241','11240','11248','11249','11252','11291','11305','11311','11314','11315','11319','11329','11339','11358','11362','11364','17459') ORDER BY g.is_identity_c desc, salenum DESC |