Select Distinct
t1.id as id,
t1.name as name
From
`hapetek-new`.`courses` t0
Inner join `hapetek-new`.`schools` t1 on t1.id = t0.school
Where
(6 = -1 or exists(
select *
from `hapetek-new`.downloads s0
where s0.type = 6 and
– s0.active = 1 and
s0.course = t0.id
))
Order by
t1.name Asc