長野県、二次、電子カルテの病院・クリニック一覧
その他の検索条件:救急告示:二次
14件の病院が見つかりました。(1~10件を表示)
輝山会 輝山会記念病院
〒395-8558 長野県飯田市毛賀1707
- 病院の診療科目
- 腫瘍内・外、ペイン内・外、内視内・外、食道・胃・大腸・肛外、頸部・胸外、肝・胆・膵外、腎外(臓器移植)、人工透析外
| 経営体 | 医療法人 |
|---|---|
| 開設 | 1991/05/01 |
| 病床数 | 446床 |
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`='2043200001' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2020200019' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2030300002' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2032100001' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2020700001' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2020500004' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2035000001' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2020200013' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='4120300002' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='2020500007' 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`='20'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='20'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='41'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='20'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='41'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件を表示)
〒395-8558 長野県飯田市毛賀1707
| 経営体 | 医療法人 |
|---|---|
| 開設 | 1991/05/01 |
| 病床数 | 446床 |
14件の病院が見つかりました。(1~10件を表示)