SELECT
main_contingent_options_relationship.contingent_id AS `main_contingent_options_relationship-contingent_id`,
contingent.file_number AS `contingent-file_number`,
contingent.date_of_receipt AS `contingent-date_of_receipt`,
contingent.first_name AS `contingent-first_name`,
contingent.last_name AS `contingent-last_name`,
contingent.patronomic AS `contingent-patronomic`,
institution.name AS `institution-name`,
contingent.year_of_grad AS `contingent-year_of_grad`,
award_of_completion.name AS `award_of_completion-name`,
contingent.orphan AS `contingent-orphan`,
group_disability.name AS `group_disability-name`,
country.name AS `country-name`,
city.name AS `city-name`,
street.name AS `street-name`,
address.home AS `address-home`,
address.room AS `address-room`,
contacts.city_phone1 AS `contacts-city_phone1`,
contacts.mobile_phone1 AS `contacts-mobile_phone1`,
contingent.village AS `contingent-village`,
contingent.hostel `contingent-hostel`,
contingent.exame_date AS `contingent-exame_date`,
contingent.total_points AS `contingent-total_points`,
contingent.prof_points AS `contingent.prof_points`,
contingent.agreement AS `contingent.agreement`
FROM main_contingent_options_relationship
INNER JOIN contingent
ON main_contingent_options_relationship.contingent_id = contingent.id
INNER JOIN `contingent-institution_relationship`
ON `contingent-institution_relationship`.contingent_id = contingent.id
INNER JOIN institution
ON `contingent-institution_relationship`.institution_id = institution.id
INNER JOIN `contingent-award_relationship`
ON `contingent-award_relationship`.contingent_id = contingent.id
INNER JOIN award_of_completion
ON `contingent-award_relationship`.award_id = award_of_completion.id
INNER JOIN `contingent-disability_relationship`
ON `contingent-disability_relationship`.contingent_id = contingent.id
INNER JOIN group_disability
ON `contingent-disability_relationship`.disability_id = group_disability.id
INNER JOIN `contingent-address_relationship`
ON `contingent-address_relationship`.contingent_id = contingent.id
INNER JOIN address
ON `contingent-address_relationship`.address_id = address.id
INNER JOIN city
ON address.city_id = city.id
INNER JOIN country
ON address.country_id = country.id
INNER JOIN street
ON address.street_id = street.id
INNER JOIN `contingent-contact_relationship`
ON `contingent-contact_relationship`.contingent_id = contingent.id
INNER JOIN contacts
ON `contingent-contact_relationship`.contact_id = contacts.id
WHERE main_contingent_options_relationship.ayear_id = 2
Жду ваших вариантов, а пока попробую сам.