Project design in sweden

 SELECT SITE.Title AS PPTitle, PROD.MerkMeinema AS PPMerk, PROD.ModelMeinema AS PPModel, PROD.TekstMeinema AS PPTekst, PROD.PrijsMeinema AS PPPrijs, PROD.VoorraadMeinema AS PPVoorraad, PROD.BestellenMeinema AS PPBestellen, BEST.FileFilename AS PPPlaatje, SITE.URLSegment AS PPLink, COUNT(AFBE.ImageID) AS PPafbeeldingen FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID AND PLAA.SortOrder=0 JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID JOIN ProductPage_PlaatjeMeinema AS AFBE ON PROD.ID = AFBE.ProductPageID WHERE PROD.MerkMeinema='Halden' AND PROD.ModelMeinema='Simple' GROUP BY PROD.ID ORDER BY PROD.ModelMeinema