| 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 < 1713537413 AND g.promote_end_date > 1713537413 THEN g.promote_price WHEN g.real_promote_price != '' AND g.real_promote_start_date < 1713537413 AND g.real_promote_end_date > 1713537413 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 ('653','654','661','662','663','666','667','668','847','669','670','671','848','672','673','849','1490','655','676','2176','677','678','679','680','681','2179','2149','2171','2177','2150','2178','656','682','839','686','687','689','688','1482','1485','1508','2269','2272','1480','1483','2147','1486','1489','1498','1509','1557','1481','1484','1487','1538','657','690','691','692','693','694','850','696','695','658','697','698','700','701','702','2277','659','703','704','705','706','707','708','709','2117','1503','660','710','711','712','713','714','715','716','717','718','719','720','1233','1236','1239','1245','1234','1237','1240','1246','1235','1238','1244','2133','2134','2219','2318','2282','2215','728','782','780','776','786','778','781','729','823','783','824','793','825','826','790','827','828','787','829','784','794','830','791','831','832','788','785','833','835','795','836','792','789','837','838','834','840','856','868','869','873','874','875','872','881','876','880','877','882','1488','1492','2157','1618','2259','2158','1572','2212','2260','1621','1573','2194') OR g.goods_id IN ('85','86','92','93','101','110','111','112','113','115','116','117','118','121','125','127','129','130','132','133','136','157','158','161','192','202','248','259','267','274','279','280','281','286','289','290','292','297','298','299','302','303','304','307','310','311','312','313','314','315','329','332','333','338','368','369','371','401','413','414','424','425','443','445','446','447','448','449','451','452','487','654','655','656','657','702','704','708','709','716','717','718','719','720','721','723','764','769','774','776','823','824','825','840','903','904','958','979','980','1028','1029','1061','1072','1139','1171','1177','1182','1185','1186','1187','1189','1226','1228','1229','1230','1231','1232','1233','1234','1235','1236','1237','1238','1241','1242','1243','1244','1245','1246','1247','1248','1249','1250','1251','1252','1253','1255','1260','1268','1270','1273','1285','1286','1288','1290','1292','1299','1300','1301','1303','1304','1305','1308','1310','1312','1314','1315','1316','1317','1318','1320','1321','1329','1330','1333','1336','1367','1371','1425','1433','1437','1441','1445','1446','1452','1460','1461','1476','1482','1491','1492','1493','1494','1500','1550','1559','1603','1606','1607','1608','1609','1629','1676','1677','1678','1819','1820','1821','1865','1866','1867','1868','1877','1878','1879','1880','1884','1913','1946','1947','1949','1950','1952','1953','1954','1959','2077','2080','2115','2192','2194','2195','2196','2197','2199','2234','2317','2649','2650','2678','2679','2719','2720','2721','2732','2735','2736','2739','2741','2742','2744','2754','2756','2866','3095','3100','3144','3152','3288','4161','4259','4371','4425','4426','4436','4437','4438','4439','4450','4451','4453','4478','4480','4529','4531','4553','4554','4556','4557','4558','4559','4560','4561','4975','4979','5028','5029','5331','5368','5432','5434','5564','5568','5578','5763','5772','5984','6052','6461','6672','6674','6808','6851','7458','7460','7464','7465','7551','7603','7676','7827','7828','7829','7830','7831','7832','7833','7834','7835','7836','7853','7854','7855','7856','7857','7858','8592','8593','8595','8606','8607','8763','8772','8776','8842','8843','8844','8848','8849','8850','8851','8852','8853','8855','8858','8859','8860','8862','8865','8869','8875','8876','8877','10193','10774','10777','10779','10780','10781','10782','10783','10784','10785','10786','10787','10788','10789','10790','10791','10792','10793','10794','10795','10796','10797','10798','10799','10800','10801','10802','10803','10804','10805','10806','10807','10808','10810','10811','10812','10813','10814','10815','10816','10817','10818','10819','10820','10821','10824','10828','10830','10831','10832','10833','10836','10837','10838','10840','10841','10842','10843','10844','10845','10846','10847','10849','10850','10851','10852','10853','10854','10855','10856','10857','10858','10859','10860','10861','10862','10863','10864','10865','10866','10867','10868','10869','10870','10871','10872','10873','10874','10876','10877','10878','10879','10880','10881','10882','10883','10884','10885','10886','10887','10888','10889','10890','10891','10892','10894','10897','10899','10901','10903','10904','10905','10906','10908','10910','10911','10912','10914','10915','10916','10917','10918','10919','10920','10921','10923','10924','10925','10926','10927','10928','10929','10930','10931','10932','10933','10934','10939','10945','10953','10956','10957','10959','10960','10961','10965','10967','10969','10970','10971','10973','10978','10980','10983','10985','10987','10988','10990','10991','10993','10994','10996','10997','11000','11001','11002','11003','11004','11005','11006','11007','11009','11010','11012','11014','11016','11017','11018','11021','11022','11023','11024','11025','11026','11027','11028','11029','11030','11031','11032','11033','11034','11035','11036','11037','11039','11040','11041','11042','11043','11044','11045','11046','11047','11048','11049','11050','11051','11052','11053','11054','11055','11056','11057','11058','11059','11060','11061','11062','11063','11064','11065','11066','11067','11068','11069','11070','11071','11072','11073','11074','11075','11076','11078','11080','11082','11083','11084','11087','11088','11090','11091','11093','11094','11095','11097','11098','11100','11101','11102','11103','11104','11106','11107','11108','11109','11110','11111','11112','11113','11114','11115','11116','11117','11118','11119','11120','11121','11122','11123','11124','11125','11126','11127','11132','11136','11137','11138','11139','11145','11162','11166','11167','11169','11174','11176','11180','11181','11182','11183','11184','11189','11192','11194','11195','11196','11197','11198','11199','11200','11202','11203','11206','11207','11208','11209','11210','11211','11212','11213','11214','11215','11216','11217','11218','11219','11220','11221','11222','11223','11224','11225','11226','11227','11228','11229','11230','11231','11232','11233','11234','11235','11236','11237','11238','11239','11240','11241','11242','11243','11244','11245','11246','11247','11248','11249','11250','11251','11252','11254','11255','11256','11258','11259','11260','11261','11262','11263','11264','11265','11266','11267','11268','11270','11271','11272','11274','11275','11276','11277','11279','11280','11281','11282','11283','11284','11286','11288','11289','11290','11291','11293','11294','11296','11297','11298','11299','11301','11302','11303','11304','11305','11306','11307','11308','11309','11310','11311','11312','11313','11314','11315','11316','11317','11318','11320','11321','11322','11323','11328','11329','11330','11331','11332','11333','11334','11335','11336','11337','11338','11339','11340','11341','11342','11343','11344','11345','11346','11347','11348','11349','11350','11351','11353','11354','11355','11356','11357','11358','11359','11360','11361','11362','11363','11364','11365','11367','11372','11375','11379','11382','11384','11400','12863','16119','16120','16121','16123','16796','17147','17170','17460','17461','31558','31559','31560','31561','31562','33189','33190','36549','37484') )AND g.brand_id=307 AND g.is_direct_pro = 1 ORDER BY g.is_identity_c desc, salenum DESC |