SS
ну я не про то, зачем эти все танцы, если можно через ОРМ сделать два запроса?
select first_team_id as team_id
from iss_matches
where iss_matches.id in
(select distinct match_id
from iss_video_uploads
where iss_video_uploads.user_id = 1
and iss_video_uploads.match_id is not null)
UNION
select second_team_id as team_id
from iss_matches
where iss_matches.id in
(select distinct match_id
from iss_video_uploads
where iss_video_uploads.user_id = 1
and iss_video_uploads.match_id is not null)
