select * from gdc_cat_producten p, brandstof b, gdc_cat_niveaus n where braId=proBrandstof and p.parent=nivId and proVerkocht<>1 and p.parent=47 and p.publiceren=1 order by p.volgnummer,proId limit 0,100