| 1 | SELECT `School`.`id`, `School`.`name`, `School`.`district_id`, `School`.`city`, `School`.`address`, `School`.`latitude`, `School`.`longitude`, `School`.`phone`, `School`.`email`, `School`.`notes`, `School`.`is_center`, `School`.`center_id`, `School`.`capacity`, `School`.`arondated`, `School`.`student_count`, `School`.`teacher_count`, `School`.`room_count`, `School`.`capacity_ok`, `School`.`created`, `School`.`modified`, `District`.`id`, `District`.`name`, `District`.`abbreviation`, `District`.`country`, `District`.`new_id`, `District`.`name_en`, `District`.`student_count`, `District`.`user_count`, `District`.`school_count`, `District`.`teacher_count`, `District`.`grade2_count`, `District`.`grade3_count`, `District`.`grade4_count`, `District`.`grade5_count`, `District`.`grade6_count`, `District`.`grade7_count`, `District`.`grade8_count`, `District`.`TOTAL_2016` FROM `luminamath_2026_simulare`.`schools` AS `School` LEFT JOIN `luminamath_2026_simulare`.`districts` AS `District` ON (`School`.`district_id` = `District`.`id`) WHERE `School`.`district_id` = 9 AND `School`.`is_center` = 1 ORDER BY `School`.`id` ASC | | 1 | 1 | 61 |