SELECT um.areaid, um.unitid, um.name, um.yomi, um.tel, um.hp, um.address_city, um.address_town, um.address_other, um.catids, um.localid,us.flg_appeal, case when um.address_city ~ '足立区$' then '010' when um.address_city ~ '荒川区$' then '020' when um.address_city ~ '板橋区$' then '030' when um.address_city ~ '江戸川区$' then '040' when um.address_city ~ '大田区$' then '050' when um.address_city ~ '葛飾区$' then '060' when um.address_city ~ '北区$' then '070' when um.address_city ~ '江東区$' then '080' when um.address_city ~ '品川区$' then '090' when um.address_city ~ '渋谷区$' then '100' when um.address_city ~ '新宿区$' then '110' when um.address_city ~ '杉並区$' then '120' when um.address_city ~ '墨田区$' then '130' when um.address_city ~ '世田谷区$' then '140' when um.address_city ~ '台東区$' then '150' when um.address_city ~ '中央区$' then '160' when um.address_city ~ '千代田区$' then '170' when um.address_city ~ '豊島区$' then '180' when um.address_city ~ '中野区$' then '190' when um.address_city ~ '練馬区$' then '200' when um.address_city ~ '文京区$' then '210' when um.address_city ~ '港区$' then '220' when um.address_city ~ '目黒区$' then '230' when um.address_city ~ '昭島市$' then '240' when um.address_city ~ 'あきる野市$' then '250' when um.address_city ~ '稲城市$' then '260' when um.address_city ~ '青梅市$' then '270' when um.address_city ~ '清瀬市$' then '280' when um.address_city ~ '国立市$' then '290' when um.address_city ~ '小金井市$' then '300' when um.address_city ~ '国分寺市$' then '310' when um.address_city ~ '小平市$' then '320' when um.address_city ~ '狛江市$' then '330' when um.address_city ~ '立川市$' then '340' when um.address_city ~ '多摩市$' then '350' when um.address_city ~ '調布市$' then '360' when um.address_city ~ '西東京市$' then '370' when um.address_city ~ '八王子市$' then '380' when um.address_city ~ '羽村市$' then '390' when um.address_city ~ '東久留米市$' then '400' when um.address_city ~ '東村山市$' then '410' when um.address_city ~ '東大和市$' then '420' when um.address_city ~ '日野市$' then '430' when um.address_city ~ '府中市$' then '440' when um.address_city ~ '福生市$' then '450' when um.address_city ~ '町田市$' then '460' when um.address_city ~ '三鷹市$' then '470' when um.address_city ~ '武蔵野市$' then '480' when um.address_city ~ '武蔵村山市$' then '490' when um.address_city ~ '奥多摩町$' then '500' when um.address_city ~ '日の出町$' then '510' when um.address_city ~ '桧原村$' then '520' when um.address_city ~ '瑞穂町$' then '530' when um.address_city ~ '青ヶ島村$' then '540' when um.address_city ~ '大島町$' then '550' when um.address_city ~ '小笠原村$' then '560' when um.address_city ~ '神津島村$' then '570' when um.address_city ~ '利島村$' then '580' when um.address_city ~ '新島村$' then '590' when um.address_city ~ '八丈町$' then '600' when um.address_city ~ '御蔵島村$' then '610' when um.address_city ~ '三宅島$' then '620' when um.address_city ~ '^埼玉県' then '700' when um.address_city ~ '^千葉県' then '710' when um.address_city ~ '^神奈川県' then '720' else '999' end as order_city, case when um.yomi != '' then um.yomi else 'ん' end as order_yomi FROM unit_main um INNER JOIN unit_site us ON (us.areaid=um.areaid AND us.unitid=um.unitid) WHERE us.siteid = 'yohfuku' AND us.day_of_quit is null AND us.flg_admit = TRUE AND um.online = TRUE AND catids ~ 'rf' ORDER BY order_city, um.localid, order_yomi LIMIT 20 OFFSET 20 Set-Cookie: sid=9d162211ac82102a096b70f68ffab484; domain=www.yohfuku.or.jp; path=/; expires=Sat, 26-Apr-2025 19:11:04 GMT Date: Fri, 26 Apr 2024 19:11:04 GMT Content-Type: text/html; charset=euc
店 名 | 住 所 | 電話番号 | ハンド メイド |
マシン メイド |
リフォ ーム |
---|---|---|---|---|---|
(株)テーラーマツダ | 新宿区新宿6-16-22 | 03-3352-0008 | ○ | - | ○ |
中島洋服店 | 新宿区新宿5-2-16 | 03-3351-7939 | ○ | - | ○ |
紳士服大萬 | 杉並区桃井3-1-16 | 03-3399-2430 | ○ | ○ | ○ |
テーラーツクダ | 杉並区荻窪5-16-19 | 03-3391-1083 | ○ | ○ | ○ |
(有)テーラー中山 | 杉並区天沼3-6-22 | 03-3398-6157 | ○ | ○ | ○ |
増田洋服店 | 杉並区阿佐谷南3-5-3 | 03-3391-6575 | ○ | ○ | ○ |
榎本洋服店 | 墨田区東向島1-32-14 | 03-3614-2929 | ○ | - | ○ |
地元で洋服一筋 50年 錦糸テーラー | 墨田区錦糸4-12-4 | 03-3623-6577 | ○ | ○ | ○ |
テーラー国島 | 墨田区菊川2-5-9クニシマビル2F | 03-3631-7608 | ○ | ○ | ○ |
(株)フジセ | 墨田区吾妻橋2-2-4 | 03-3625-0690 | ○ | ○ | ○ |
エムスリー栗原 | 世田谷区等々力3-32-7 | 03-3701-6433 | ○ | ○ | ○ |
形吉屋洋服店 | 世田谷区野沢1-29-20 | 03-3487-5273 | ○ | ○ | ○ |
(有)蟹澤洋服店 | 世田谷区世田谷1-25-13 | 03-3429-6700 | ○ | ○ | ○ |
(有)上川テーラー | 世田谷区経堂5-29-3 | 03-3420-5605 | ○ | - | ○ |
小暮洋服店 | 世田谷区松原2-22-15 | 03-3321-4940 | ○ | - | ○ |
タナカ洋服店 | 世田谷区大原2-19-5 | 03-3321-5712 | ○ | - | ○ |
テーラーフジヤ | 世田谷区宮坂2-18-1 | 03-3420-4561 | ○ | ○ | ○ |
ニュースコッチ | 世田谷区宮坂2-1-9 モンタニュ109-101 | 03-3428-3710 | ○ | - | ○ |
(株)壹番館洋服店 | 中央区銀座5-3-12 | 03-3571-0021 | ○ | - | ○ |
(株)弘潤社 | 中央区銀座西1-2銀座インズ3 | 03-3561-0527 | - | ○ | ○ |