SELECT count(ID) as CNT FROM DAT_HAISYA WHERE ENABLE='ENABLE:公開中' AND PREF='埼玉県' AND ( ( (TMP05 = '羽生駅' and PREF='埼玉県') or (TMP05 = '西羽生駅' and PREF='埼玉県') or (TMP05 = '新郷駅' and PREF='埼玉県') or (TMP05 = '武州荒木駅' and PREF='埼玉県') or (TMP05 = '東行田駅' and PREF='埼玉県') or (TMP05 = '行田市駅' and PREF='埼玉県') or (TMP05 = '持田駅' and PREF='埼玉県') or (TMP05 = 'ソシオ流通センター駅' and PREF='埼玉県') or (TMP05 = '熊谷駅' and PREF='埼玉県') or (TMP05 = '上熊谷駅' and PREF='埼玉県') or (TMP05 = '石原駅' and PREF='埼玉県') or (TMP05 = 'ひろせ野鳥の森駅' and PREF='埼玉県') or (TMP05 = '大麻生駅' and PREF='埼玉県') or (TMP05 = '明戸駅' and PREF='埼玉県') or (TMP05 = '武川駅' and PREF='埼玉県') or (TMP05 = '永田駅' and PREF='埼玉県') or (TMP05 = 'ふかや花園駅' and PREF='埼玉県') or (TMP05 = '小前田駅' and PREF='埼玉県') or (TMP05 = '桜沢駅' and PREF='埼玉県') or (TMP05 = '寄居駅' and PREF='埼玉県') or (TMP05 = '波久礼駅' and PREF='埼玉県') or (TMP05 = '樋口駅' and PREF='埼玉県') or (TMP05 = '野上駅' and PREF='埼玉県') or (TMP05 = '長瀞駅' and PREF='埼玉県') or (TMP05 = '上長瀞駅' and PREF='埼玉県') or (TMP05 = '親鼻駅' and PREF='埼玉県') or (TMP05 = '皆野駅' and PREF='埼玉県') or (TMP05 = '和銅黒谷駅' and PREF='埼玉県') or (TMP05 = '大野原駅' and PREF='埼玉県') or (TMP05 = '秩父駅' and PREF='埼玉県') or (TMP05 = '御花畑駅' and PREF='埼玉県') or (TMP05 = '影森駅' and PREF='埼玉県') or (TMP05 = '浦山口駅' and PREF='埼玉県') or (TMP05 = '武州中川駅' and PREF='埼玉県') or (TMP05 = '武州日野駅' and PREF='埼玉県') or (TMP05 = '白久駅' and PREF='埼玉県') or (TMP05 = '三峰口駅' and PREF='埼玉県') ) ) ;