| 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 < 1714240744 AND g.promote_end_date > 1714240744 THEN g.promote_price WHEN g.real_promote_price != '' AND g.real_promote_start_date < 1714240744 AND g.real_promote_end_date > 1714240744 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 ('676') OR g.goods_id IN ('1255','10830','10890') ) AND g.is_direct_pro = 1 AND g.goods_id IN ('1420','1021','2535','5977','5988','5991','5993','5996','5998','5999','6209','6248','6543','6740','6742','7050','7053','7055','7119','7120','7234','7235','7236','7237','7726','7727','7728','7729','7754','7774','7776','7777','7778','7779','7780','7781','7782','7783','7784','7785','7786','7787','7788','7789','8888','8937','8938','8939','8940','8941','8942','8943','8944','8945','8946','8947','8949','8951','8952','8953','8954','8955','9267','9268','9269','9272','9409','9720','10098','10099','10100','10101','10102','10103','10104','10105','10106','10107','10108','10109','10571','10585','10586','16052','16051','16050','16048','16044','16055','16056','16402','16717','16719','16720','16721','16722','16723','16724','16725','16726','16727','16728','16729','16730','16731','16732','16733','16734','16735','16736','16738','16739','16740','16741','16742','16744','16746','16747','16748','16749','16750','16752','16753','16754','16756','16757','16760','16761','16762','16773','16775','16776','16960','16961','16962','16963','16964','16965','16968','16970','16971','16973','16975','16977','16978','16979','16981','17284','17291','17292','17293','17294','17358','17400','17398','17395','17393','17392','17387','17379','17371','17369','17365','17362','17360','17359','17403','17405','17407','17427','17428','17429','17432','17433','17434','17435','17437','17441','17442','17463','17995','17994','17993','17996','17997','17998','17999','18000','18001','18002','18003','18004','18005','18006','18007','18008','18009','18010','18011','18012','18039','18040','18041','18042','18043','18044','18045','18046','18047','18048','18049','18050','18053','18054','18055','18056','18057','18059','18060','18061','18062','18063','18064','18065','18067','18068','18069','18070','18071','18072','18073','18366','18368','18369','18370','18371','18372','18373','18374','18376','18377','18379','18380','18381','18383','18385','18386','18388','18390','18392','18393','18394','18396','18397','18400','18402','18403','18405','18406','18407','18408','18409','18410','18411','18412','18413','18414','18415','18416','18417','18418','18419','18420','18452') ORDER BY g.is_identity_c desc, salenum DESC |