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