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=74 and p.publiceren=1 order by p.volgnummer,proId limit 0,100