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='熊本県') or (TMP05 = '動植物園入口駅' and PREF='熊本県') or (TMP05 = '健軍交番前駅' and PREF='熊本県') or (TMP05 = '健軍町駅' and PREF='熊本県') ) ) ;