| 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 < 1713505553 AND g.promote_end_date > 1713505553 THEN g.promote_price WHEN g.real_promote_price != '' AND g.real_promote_start_date < 1713505553 AND g.real_promote_end_date > 1713505553 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 ('722','1327','733','1308','734','1320','1318','736','1460','737','739','1297','1301','1598','1313','1609','2115','1317','2218','2155','1268','1321','2159','1279','1332','1568','1285','735','1336','1288','1432','1292','1444','1298','1304','1309','2213','1600','1314','2216','2187','1270','1322','1276','1330','1280','1334','866','1286','1337','2132','2170','1290','1441','2135','1217','1293','2205','1299','1307','1312','2256','2151','1316','2217','1267','1615','1274','1323','2161','1277','1331','1628','1282','1335','1287','1291','2203','1443','1275','2153','1571') OR g.goods_id IN ('171','346','377','403','410','950','951','952','971','989','997','1020','1021','1062','1071','1073','1172','1173','1191','1322','1334','1335','1337','1338','1339','1340','1341','1342','1343','1345','1348','1349','1372','1408','1409','1501','1505','1567','1631','1662','1960','2023','2024','2025','2026','2244','2246','2248','2307','2436','2437','2438','2469','2535','2677','3092','3148','3149','3287','3288','3289','3290','3291','3292','3302','3305','3438','3688','3886','4037','4046','4066','4068','4071','4072','4084','4091','4125','4160','4161','4162','4163','4164','4165','4166','5058','5060','5062','5066','5071','5072','5073','5074','5075','5076','5077','5078','5079','5080','5081','5082','5083','5084','5085','5086','5087','5088','5089','5090','5136','5137','5138','5139','5140','5141','5142','5143','5144','5145','5152','5750','6326','7183','7587','7627','7628','7629','8192','8193','8194','8195','8213','8215','8217','8219','8221','8301','8320','8430','8433','8434','8948','8950','9037','9038','9039','9040','9041','9042','9043','9044','9179','9180','9181','9183','9184','9185','9187','9188','9189','9190','9192','9193','9196','9197','9199','9200','9201','9209','9296','9316','9381','9382','9383','9384','9403','9406','9407','9408','9409','9410','9411','9412','9414','9415','9418','9425','9426','9427','9428','9429','9430','9431','9432','9433','9434','9435','9436','9437','9438','9439','9440','9441','9442','9443','9445','9447','9448','9450','9451','9452','9453','9456','9457','9459','9462','9463','9464','9465','9466','9468','9469','9471','9472','9474','9492','9493','9494','9495','9496','9497','9498','9585','9587','9588','9590','9591','9592','9595','9623','9624','9625','9626','9667','9704','9705','9706','9707','9708','9724','10356','10358','10359','10362','10366','10583','11368','11369','11374','11380','11381','11385','11386','11390','11394','11395','11409','11410','11411','11412','11413','11415','11522','11524','11525','11527','11528','11531','11792','11793','11796','12837','12838','12839','12847','12848','12896','12897','12898','12899','12900','12901','12908','12909','12910','12911','15158','15160','15161','15277','15321','15462','15492','15578','15580','15585','15596','15600','15621','15626','15629','15636','15663','15776','15777','16094','16095','16112','16113','16115','16116','16117','16118','16155','16156','16164','16165','16166','16167','16168','16169','16170','16171','16172','16173','16174','16188','16191','16193','16194','16195','16201','16204','16232','16374','16375','16376','16377','17444','17449','17450','17452','17458','17462','17463') ) AND g.is_direct_pro = 1 ORDER BY g.is_identity_c desc, salenum DESC |