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