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='長野県') ) ) ;