SELECT g.goods_id, g.goods_number,g.diqu, g.goods_name, g.provider_name, g.goods_name_style, g.supplier_id, 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, g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img , g.original_img, g.birthday, g.biaoqian FROM `shoptest`.`ecs_goods` AS g LEFT JOIN `shoptest`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '1' WHERE g.goods_id IN ('789','794','803','842','861','999','1063','1109','1178','1180','1261','1262','1312','1313','1314','1333','1345','1346','1356','1361','792','1255','1187','1067','853','860','797','1260','1275','1272','1190','1310','1007','1373','1279','790','1192','1308','1396','1393','1389','1394','1392','858','1359','1257','1331','1263','1069','1357','1360','1397','1179','1274') and find_in_set('石景山', diqu) and g.is_on_sale=1 order by sort_zhuanti ascSELECT g.goods_id, g.goods_number,g.diqu, g.goods_name, g.provider_name, g.goods_name_style, g.supplier_id, 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, g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img , g.original_img, g.birthday, g.biaoqian FROM `shoptest`.`ecs_goods` AS g LEFT JOIN `shoptest`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '1' WHERE g.goods_id IN ('789','794','803','842','861','999','1063','1109','1178','1180','1261','1262','1312','1313','1314','1333','1345','1346','1356','1361','792','1255','1187','1067','853','860','797','1260','1275','1272','1190','1310','1007','1373','1279','790','1192','1308','1396','1393','1389','1394','1392','858','1359','1257','1331','1263','1069','1357','1360','1397','1179','1274') and find_in_set('石景山', diqu) and g.is_on_sale=1 order by sort_zhuanti asc
SELECT g.goods_id, g.goods_number,g.diqu, g.goods_name, g.provider_name, g.goods_name_style, g.supplier_id, 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, g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img , g.original_img, g.birthday, g.biaoqian FROM `shoptest`.`ecs_goods` AS g LEFT JOIN `shoptest`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '1' WHERE g.goods_id IN ('789','794','803','842','861','999','1063','1109','1178','1180','1261','1262','1312','1313','1314','1333','1345','1346','1356','1361','792','1255','1187','1067','853','860','797','1260','1275','1272','1190','1310','1007','1373','1279','790','1192','1308','1396','1393','1389','1394','1392','858','1359','1257','1331','1263','1069','1357','1360','1397','1179','1274') and find_in_set('石景山', diqu) and g.is_on_sale=1 order by sort_zhuanti ascSELECT g.goods_id, g.goods_number,g.diqu, g.goods_name, g.provider_name, g.goods_name_style, g.supplier_id, 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, g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img , g.original_img, g.birthday, g.biaoqian FROM `shoptest`.`ecs_goods` AS g LEFT JOIN `shoptest`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '1' WHERE g.goods_id IN ('789','794','803','842','861','999','1063','1109','1178','1180','1261','1262','1312','1313','1314','1333','1345','1346','1356','1361','792','1255','1187','1067','853','860','797','1260','1275','1272','1190','1310','1007','1373','1279','790','1192','1308','1396','1393','1389','1394','1392','858','1359','1257','1331','1263','1069','1357','1360','1397','1179','1274') and find_in_set('石景山', diqu) and g.is_on_sale=1 order by sort_zhuanti asc
SELECT g.goods_id, g.goods_number,g.diqu, g.goods_name, g.provider_name, g.goods_name_style, g.supplier_id, 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, g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img , g.original_img, g.birthday, g.biaoqian FROM `shoptest`.`ecs_goods` AS g LEFT JOIN `shoptest`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '1' WHERE g.goods_id IN ('789','794','803','842','861','999','1063','1109','1178','1180','1261','1262','1312','1313','1314','1333','1345','1346','1356','1361','792','1255','1187','1067','853','860','797','1260','1275','1272','1190','1310','1007','1373','1279','790','1192','1308','1396','1393','1389','1394','1392','858','1359','1257','1331','1263','1069','1357','1360','1397','1179','1274') and find_in_set('石景山', diqu) and g.is_on_sale=1 order by sort_zhuanti ascSELECT g.goods_id, g.goods_number,g.diqu, g.goods_name, g.provider_name, g.goods_name_style, g.supplier_id, 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, g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img , g.original_img, g.birthday, g.biaoqian FROM `shoptest`.`ecs_goods` AS g LEFT JOIN `shoptest`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '1' WHERE g.goods_id IN ('789','794','803','842','861','999','1063','1109','1178','1180','1261','1262','1312','1313','1314','1333','1345','1346','1356','1361','792','1255','1187','1067','853','860','797','1260','1275','1272','1190','1310','1007','1373','1279','790','1192','1308','1396','1393','1389','1394','1392','858','1359','1257','1331','1263','1069','1357','1360','1397','1179','1274') and find_in_set('石景山', diqu) and g.is_on_sale=1 order by sort_zhuanti asc
