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='岩手県') ) ) ;