岩手県、心療内科の病院・クリニック一覧
21件の病院が見つかりました。(1~10件を表示)
新潟大学医歯学総合病院
〒951-8520 新潟県新潟市中央区旭町通1番町754
- 病院の診療科目
- 予防・保存系歯、摂食機能・補綴系歯
| 経営体 | 国立大学法人 |
|---|---|
| 開設 | 2004/04/01 |
| 病床数 | 825床 |
21件の病院が見つかりました。(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`='1520400002' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1520600003' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1522200007' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1510300007' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1510300019' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1510500003' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1510200001' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1510700001' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='320100030' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1538500001' 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`='15'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`='15'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
21件の病院が見つかりました。(1~10件を表示)
〒951-8520 新潟県新潟市中央区旭町通1番町754
| 経営体 | 国立大学法人 |
|---|---|
| 開設 | 2004/04/01 |
| 病床数 | 825床 |
21件の病院が見つかりました。(1~10件を表示)