| 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 < 1715578922 AND g.promote_end_date > 1715578922 THEN g.promote_price WHEN g.real_promote_price != '' AND g.real_promote_start_date < 1715578922 AND g.real_promote_end_date > 1715578922 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') AND g.goods_id IN ('494','547','550','551','963','1072','1073','1087','1154','1172','1173','1184','1183','1191','1194','1196','1195','1225','1251','1240','1261','1262','1264','1272','1383','1384','1385','1386','1390','1391','1392','1393','1400','1404','1406','1409','1429','1430','1431','1456','1459','1477','1478','1479','1496','1497','1498','1499','1500','1501','1502','1503','1504','1505','1534','1535','1536','1537','1538','1539','1542','1543','1544','1545','1547','1548','1549','1550','1552','1553','1554','1555','1556','1557','1558','1559','1560','1573','1590','1603','1605','1618','1619','1620','1621','1622','971','1085','1011','1323','1372','1869','1870','1517','1516','1616','1960','1562','1563','1564','1566','1567','1375','346','2023','2024','2025','2026','2041','2043','2063','2192','2195','2307','3120','3121','3119','3122','3186','3187','3438','3860','3861','3863','3864','3865','3866','3867','3868','3869','3870','3871','3872','3873','3874','3875','3877','3881','3883','3885','3887','3890','3891','3893','4480','4553','4556','4557','4558','4560','4561','5061','5059','5069','5070','5538','5763','5772','6248','6549','7142','7143','7144','7145','7146','7551','7726','7728','7792','7793','7794','7795','7796','7797','7798','7799','7800','7801','7802','7810','7827','7829','9210','9212','9213','9214','9215','9216','9218','9219','9220','9417','9419','9717','9718','9720','9721','9722','10082','10083','10087','10088','10404','10440','10571','10574','10576','10585','10586','10840','10899','10918','11538','11540','11546','11549','11552','11554','11559','11561','11562','11563','11564','11568','11576','11590','11599','12945','12948','12953','15488','15493','15490','16402','17443','17444','18269','18270','18271','18786','37508','37529','37530','37531','37532','37533','37534','37535','37536','37537','38717') ORDER BY g.is_identity_c desc, salenum DESC |