| 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 < 1714248003 AND g.promote_end_date > 1714248003 THEN g.promote_price WHEN g.real_promote_price != '' AND g.real_promote_start_date < 1714248003 AND g.real_promote_end_date > 1714248003 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 ('691') OR g.goods_id IN ('1500','2754','10918','10920') ) AND g.is_direct_pro = 1 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 |