引数=SELECT * FROM F_shop inner join prefecture On F_shop.F_shop_prefecture = prefecture.id Left join Fshop_GRP ON Fshop_GRP.Fgrp_id = F_shop.F_GRP_num Where F_shop_region <> 3 AND F_shop_region <> 4 AND F_shop_region <> 5 AND F_shop_region <> 6 AND F_shop_region <> 7 AND F_shop_region <> 8 AND F_shop_region <> 10 And F_GRP_num <> 4 And ( F_GRP_num < 11 or F_GRP_num > 16 ) And F_GRP_flag = 1 Order by F_GRP_num Asc,F_shop_prefecture Asc