、田原市、津市の病院・クリニック一覧
その他の検索条件:岐阜県 三重県
27件の病院が見つかりました。(1~10件を表示)
三重県立小児心療センター あすなろ学園
〒514-0818 三重県津市城山1-12-3
- 病院の診療科目
- 児童精、小(入院児のみ)、歯(入院児のみ)
| 経営体 | 県 |
|---|---|
| 開設 | 1985/04/01 |
| 病床数 | 80床 |
27件の病院が見つかりました。(1~10件を表示)
SELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2420100007' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2420100017' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2420100024' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2122100001' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2420100022' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2420100006' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2420100030' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2420100012' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2420100001' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2420100002' 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 `id`='708'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `id`='721'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 awaySELECT * FROM `city_master` WHERE `flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='5'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='21'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='24'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='5'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='21'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='24'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
27件の病院が見つかりました。(1~10件を表示)
〒514-0818 三重県津市城山1-12-3
| 経営体 | 県 |
|---|---|
| 開設 | 1985/04/01 |
| 病床数 | 80床 |
27件の病院が見つかりました。(1~10件を表示)