SELECT a.idUser, a.status, c.geboortedatum, c.plaats, g.regio, f.landen, h.geslacht, c.nickname, d.gezicht, d.neus, d.ogen, d.neus, d.mond, d.haren, e.foto1, e.snapshot
FROM tblusers AS a LEFT JOIN tblnaw AS c USING(idUser), 
tblusers AS aa LEFT JOIN tblcompositie AS d USING(idUser), 
tblusers AS aaa LEFT JOIN tblpresentatie AS e USING(idUser), 
tblnaw AS cc LEFT JOIN pulllanden AS f USING(idLand), 
tblnaw AS ccc LEFT JOIN pullregio AS g USING(idRegio), 
tblnaw AS cccc LEFT JOIN pullgeslacht AS h USING(idGeslacht) 				
WHERE c.idGeslacht = 2
AND cc.idGeslacht = 2
AND ccc.idGeslacht = 2

AND c.idZoekGeslacht = 1
AND cc.idZoekGeslacht = 1
AND ccc.idZoekGeslacht = 1

AND a.emailbevestiging = 1
AND aa.emailbevestiging = 1
AND aaa.emailbevestiging = 1

GROUP BY idUser