SELECT vk_cathedra id vk_cathedra faculty_id vk_cathedra title vk_facu

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
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