| 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 < 1714767328 AND g.promote_end_date > 1714767328, 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 ('385','392','404','402','403','401','396','430','393','395','394','400','398','399','427','522') OR g.goods_id IN ('189','369','370','371','372','373','493','499','500','501','502','503','504','505','506','507','508','532','533','534','543','544','545','546','547','548','549','550','551','560','561','562','567','592','593','594','604','606','607','608','610','616','617','620','622','647','655','658','659','666','667','671','672','687','735','766','780','788','790','801','802','825','826','827','864','870','871','875','879','880','891','898','900','940','948','949','950','951','1007','1025','1049','1089','1090','1091','1092','1093','1094','1095','1096','1097','1098','1099','1100','1102','1107','1137','1142','1143','1166','1174','1188','1205','1206','1207','1208','1209','1210','1211','1212','1213','1214','1215','1216','1217','1231','1237','1241','1250') ) AND g.supplier_id=0AND g.brand_id=1 ORDER BY last_update DESC LIMIT 16 |