SELECT DISTINCT a.content_cws,image,lengte,breedte,hoogte,zijaanzicht_cws AS zijaanzicht,container_id,naam,c.url AS containerurl,prijs,afvalstroom_id FROM tbl_prijs AS p JOIN tbl_afvalstroom AS a ON a.id=afvalstroom_id JOIN tbl_container AS c on c.id = p.container_id WHERE afvalstroom_id = ( SELECT  id FROM tbl_afvalstroom WHERE url = 'bouwafval' AND company_id = 2 ) ORDER BY c.positie ASC