岩手県、HCUの病院・クリニック一覧
その他の検索条件:熊本県
14件の病院が見つかりました。(1~10件を表示)
国家公務員共済組合連合会 熊本中央病院
〒862-0965 熊本県熊本市南区田井島1-5-1
- 病院の診療科目
- 休診中(神内、精、皮)
| 経営体 | 国家公務員共済組合連合会 |
|---|---|
| 開設 | 1951/04/01 |
| 病床数 | 361床 |
14件の病院が見つかりました。(1~10件を表示)
SELECT `id`,`name` FROM `line_master` WHERE `flag`='1'AND`delete_flag`='0' ORDER BY `display_num` ASC MySQL server has gone awaySELECT `id`,`name`,`line_id` FROM `station_master` WHERE `flag`='1'AND`delete_flag`='0' ORDER BY `station_sort` 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 `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='320700001' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='320900005' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1821000001' 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`='4320800007' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='320100025' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1820200004' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1820200005' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='4310400006' 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`='18'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`='18'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件を表示)
〒862-0965 熊本県熊本市南区田井島1-5-1
| 経営体 | 国家公務員共済組合連合会 |
|---|---|
| 開設 | 1951/04/01 |
| 病床数 | 361床 |
14件の病院が見つかりました。(1~10件を表示)