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='茨城県') ) ) ;