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