select c.Club_Resp as cClub_Resp from clubs_resp c join Equipes e on c.Nr=e.Club_Resp where ( e.Nr=44 and e.cp_no<>'' and e.Aktiv='1') order by c.Nr_club asc, e.cp_no asc