Opdrachtgever:
Locatie:
De opdracht:
Interieurontwerper:
Een mooie symmetrie van kleur, vorm en materiaal.
In dit interieurontwerp vindt u een mooie mix tussen sjiek en stoer. Een stoere Arco Slim tafel, massief hout en voorzien van een stoere en toch klassieke look. De elegante velvet armstoelen "Kate" zijn van Dutchbone en ook ziet u in het ontwerp stoere Petfelt barkrukken van Halden genaamd "Racco".
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='Artinox' AND PROD.ModelMeinema='Medusa' GROUP BY PROD.ID ORDER BY PROD.ModelMeinema
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='Meinema' AND PROD.ModelMeinema='Alle 100 modellen ' GROUP BY PROD.ID ORDER BY PROD.ModelMeinema
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='Viso' AND PROD.ModelMeinema='Fort Knox' GROUP BY PROD.ID ORDER BY PROD.ModelMeinema
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='IVC' AND PROD.ModelMeinema='Select' GROUP BY PROD.ID ORDER BY PROD.ModelMeinema
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='Castelijn' AND PROD.ModelMeinema='Foliant' GROUP BY PROD.ID ORDER BY PROD.ModelMeinema
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='Light4' AND PROD.ModelMeinema='Ring' GROUP BY PROD.ID ORDER BY PROD.ModelMeinema
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='Cruso' AND PROD.ModelMeinema='Paddle Chair ' GROUP BY PROD.ID ORDER BY PROD.ModelMeinema
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='WoodUpp' AND PROD.ModelMeinema='Akupanel' GROUP BY PROD.ID ORDER BY PROD.ModelMeinema
