| SQL | SELECT g.goods_id, g.goods_name, g.goods_name_style, g.click_count, g.goods_number, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, g.promote_price, IF(g.promote_price != '' AND g.promote_start_date < 1714697322 AND g.promote_end_date > 1714697322, g.promote_price, shop_price) AS shop_p, g.goods_type, g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb, g.goods_img FROM `tea0768`.`ecs_goods` AS g LEFT JOIN `tea0768`.`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 ('386','504','505','507','506','508','509') OR g.goods_id IN ('354','356','357','358','359','360','361','362','363','364','365','366','367','368','523','524','525','557','559','585','587','588','589','600','601','602','603','609','625','626','630','631','632','633','634','635','636','637','638','639','640','641','642','644','645','648','649','654','661','662','679','680','681','682','683','694','695','696','697','698','699','702','705','706','707','708','711','712','713','715','716','719','721','732','733','734','738','741','748','749','755','756','757','758','763','765','766','767','768','769','770','773','774','775','776','777','785','786','787','791','792','795','829','830','831','852','853','854','855','856','858','859','860','861','862','865','873','874','876','877','878','882','902','903','905','908','915','917','927','936','937','958','960','976','977','979','980','986','993','1004','1009','1011','1028','1030','1032','1037','1038','1039','1040','1041','1042','1048','1053','1054','1059','1060','1064','1076','1077','1079','1080','1081','1116','1117','1127','1128','1129','1130','1131','1132','1133','1134','1143','1144','1150','1152','1154','1165','1178','1180','1181','1182','1183','1185','1186','1218','1219','1220','1221','1222','1223','1224','1227','1228','1229','1230','1233','1256') ) AND g.supplier_id=0AND g.brand_id=2 ORDER BY last_update DESC LIMIT 16 |