SELECT vk_cathedra id vk_cathedra faculty_id vk_cathedra title vk_facu

1
SELECT `vk_cathedra`.`id`, `vk_cathedra`.`faculty_id`, `vk_cathedra`.`title`, `vk_faculty`.`id`, `vk_faculty`.`institute_id`, `vk_faculty`.`title`, `vk_institute`.`id`, `vk_institute`.`city_id`, `vk_institute`.`title`, `vk_city`.`id`, `vk_city`.`region_id`, `vk_city`.`title`, `vk_region`.`id`, `vk_region`.`country_id`, `vk_region`.`title`, `vk_country`.`id`, `vk_country`.`title` FROM `vk_cathedra` INNER JOIN `vk_faculty` ON (`vk_cathedra`.`faculty_id` = `vk_faculty`.`id`) INNER JOIN `vk_institute` ON (`vk_faculty`.`institute_id` = `vk_institute`.`id`) INNER JOIN `vk_city` ON (`vk_institute`.`city_id` = `vk_city`.`id`) INNER JOIN `vk_region` ON (`vk_city`.`region_id` = `vk_region`.`id`) INNER JOIN `vk_country` ON (`vk_region`.`country_id` = `vk_country`.`id`) WHERE `vk_cathedra`.`id` = 1