SELECT COUNT(*) FROM `facility` WHERE `delete_flag`='0'AND`flag`='1' AND ((pref = "27" OR pref = "38") AND (address LIKE "%守口市%")) AND EXISTS(SELECT "X" FROM facility_item_relation WHERE facility_item_relation.facility_id = facility.id AND facility_item_relation.item_id = "59") MySQL server has gone awaySELECT * FROM `facility` WHERE `delete_flag`='0'AND`flag`='1' AND ((pref = "27" OR pref = "38") AND (address LIKE "%守口市%")) AND EXISTS(SELECT "X" FROM facility_item_relation WHERE facility_item_relation.facility_id = facility.id AND facility_item_relation.item_id = "59")ORDER BY `updated_at` DESC LIMIT 10 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`='821'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 `pref_id`='27'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='27'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='38'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='27'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='38'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 大阪府、守口市、在宅(居宅)介護支援センターの病院・クリニック一覧 | 看護師の転職選びならナースリンク