岩手県、健康管理センターの病院・クリニック一覧
その他の検索条件:熊本県
14件の病院が見つかりました。(1~10件を表示)
独立行政法人地域医療機能推進機構 天草中央総合病院
〒863-0033 熊本県天草市東町101
- 病院の診療科目
- 休診中(小、泌)
| 経営体 | 全国社会保険協会連合会 |
|---|---|
| 開設 | 1946/11/01 |
| 病床数 | 174床 |
14件の病院が見つかりました。(1~10件を表示)
SELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='4321500002' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='4321500004' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='3344500003' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='4336900001' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='321100005' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='4310100016' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='4320400001' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='4321200001' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='4321400004' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='3320200012' MySQL server has gone awaySELECT `id`,`type`,`value` FROM `facility_item_master` WHERE `flag`='1'AND`search_flag`='1'AND`delete_flag`='0' ORDER BY `display_num` DESC MySQL server has gone awaySELECT `id`,`type`,`value` FROM `facility_item_master` WHERE `flag`='1'AND`search_flag`='1'AND`delete_flag`='0' ORDER BY `display_num` DESC MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='3'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='3'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='33'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='43'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='3'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='33'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='43'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT `id`,`type`,`value` FROM `facility_item_master` WHERE `flag`='1'AND`search_flag`='1'AND`delete_flag`='0' ORDER BY `display_num` DESC MySQL server has gone away
14件の病院が見つかりました。(1~10件を表示)
〒863-0033 熊本県天草市東町101
| 経営体 | 全国社会保険協会連合会 |
|---|---|
| 開設 | 1946/11/01 |
| 病床数 | 174床 |
14件の病院が見つかりました。(1~10件を表示)