🇻
Всем привет!
Подскажите, как мне передать в подзапрос applications.id (вместо 1624 )
`SELECT
applications.id,
applications.special_id,
SubQuery.discipline_id,
SubQuery.v_exam_name_result
FROM applications
LEFT OUTER JOIN users
ON applications.user_id = users.user_id
LEFT OUTER JOIN applications_dissertations
ON applications_dissertations.application_id = applications.id
LEFT OUTER JOIN (SELECT
specialtie_to_disciplines.discipline_id,
specialtie_to_disciplines.special_id,
specialtie_to_disciplines.v_exam_name_result
FROM specialtie_to_disciplines
LEFT OUTER JOIN applications
ON specialtie_to_disciplines.special_id = applications.special_id
WHERE specialtie_to_disciplines.v_exam_name_result > 0
AND applications.id = 1624
AND (specialtie_to_disciplines.s_to_discipline_v IS NULL
OR specialtie_to_disciplines.s_to_discipline_v = applications.a_to_discipline_v)) SubQuery
ON applications.special_id = SubQuery.special_id
WHERE applications.status > 0
AND applications_dissertations.ds_rating IS NULL
GROUP BY applications.id
ORDER BY applications.id DESC
LIMIT 10`
