Akoestiek Belcellen Banken en fauteuils Bureaus Bureaustoelen Kasten Stoelen Tafels Turnkey-inrichting Projectstoffering Verlichting Overig

Filters:

Buitenmeubilair Hoekbank Hoge fauteuils Hoge banken Lage banken Lage fauteuils Modulaire banken Overlegunit Populaire banken Poef - Krukjes Restaurantbanken Ronde banken Vergaderbox Wachtbanken Zorgmeubilair


Luxe Lounge banken voor projecten

Onze collectie lounge banken bestaat uit vele merken. Van woninginrichting tot projectinrichting voor ieder budget een. De meeste modellen kunnen worden gemaakt in vele kleuren en leer en stoffen. 

Graag komen we met u in contact, neem hier contact met ons op voor al je vragen of bel direct 0031 (0)20-311 8396

 

Banken en fauteuils Hoekbank Hoge fauteuils Hoge banken Lage banken Lage fauteuils Modulaire banken Overlegunit Populaire banken Poef - Krukjes Restaurantbanken Ronde banken Wachtbanken Zorgmeubilair Buitenmeubilair Vergaderbox
Artifort 070 bank
1
                                    productid 998

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 998

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%998%' ORDER BY FilterPageID

                                    lagefauteuil laag

                                    Filterpos = 5
                                    Filterid = 2585
                                    pagefilterid = 1401

                                    productfilter = 1352, 1353, 1353, 1401, 1401, 1419, 1847, 1948, 1948, 2585,
Artifort 070

€ 2400
carolien meinema slogan
Artifort Apps fauteuil
2
                                    productid 988

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 988

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%988%' ORDER BY FilterPageID

                                    lagefauteuil laag

                                    Filterpos = 2
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401,
Artifort Apps

€ 1590
Artifort Big Island banken
3
                                    productid 991

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 991

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%991%' ORDER BY FilterPageID

                                    laag

                                    Filterpos = 2
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1294, 1401, 2794,
Artifort Big Island

€ 2840
Artifort Bras banken
4
                                    productid 996

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 996

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%996%' ORDER BY FilterPageID

                                    poef laag

                                    Filterpos = 2
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1392, 1401,
Artifort Bras

€ 2380
Artifort C683
5
                                    productid 999

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 999

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%999%' ORDER BY FilterPageID

                                    laag

                                    Filterpos = 3
                                    Filterid = 1822
                                    pagefilterid = 1401

                                    productfilter = 1256, 1388, 1401, 1666, 1822,
Artifort C683

€ 2120
Artifort C905 banken
6
                                    productid 1001

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1001

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1001%' ORDER BY FilterPageID

                                    lagefauteuil laag

                                    Filterpos = 2
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401,
Artifort C905

€ 2810
Artifort Chaise Longue banken
7
                                    productid 1002

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1002

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1002%' ORDER BY FilterPageID

                                    laag

                                    Filterpos = 1
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1401,
Artifort Chaise Longue

€ 3460
Artifort Diva banken
8
                                    productid 1005

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1005

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1005%' ORDER BY FilterPageID

                                    lagefauteuil laag

                                    Filterpos = 2
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401,
Artifort Diva

€ 2090
Artifort F416
9
                                    productid 2231

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2231

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2231%' ORDER BY FilterPageID

                                    

                                    Filterpos = 2
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401,
Artifort F416

€ 2200
Artifort Figura
10
                                    productid 1535

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1535

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1535%' ORDER BY FilterPageID

                                    lagefauteuil laag

                                    Filterpos = 2
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401, 2794,
Artifort Figura

€ 2430
Artifort Manhattan bank
11
                                    productid 1032

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1032

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1032%' ORDER BY FilterPageID

                                    poef laag modulair

                                    Filterpos = 2
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1392, 1401, 1847, 2789, 2794,
Artifort Manhattan

€ 4000
Artifort Mare
12
                                    productid 1033

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1033

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1033%' ORDER BY FilterPageID

                                    lagefauteuil poef laag

                                    Filterpos = 4
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1353, 1376, 1392, 1401, 2313, 2794,
Artifort Mare

€ 2100
Artifort Mare los rugkussen
13
                                    productid 1817

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1817

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1817%' ORDER BY FilterPageID

                                    lagefauteuil laag poef

                                    Filterpos = 2
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401, 2794,
Artifort Mare losse rugkus...

€ 2300
Artifort Ondo banken
14
                                    productid 1043

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1043

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1043%' ORDER BY FilterPageID

                                    laag

                                    Filterpos = 1
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1401,
Artifort Ondo

€ 3065
Bla Station BOB
15
                                    productid 805

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 805

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%805%' ORDER BY FilterPageID

                                    lagefauteuil laag poef modulair

                                    Filterpos = 5
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1315, 1352, 1353, 1392, 1401, 1586, 1637, 1708, 1775, 1847, 2789, 2794,
Bla station BOB

€ 6000
Bla Station Dundra
16
                                    productid 877

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 877

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%877%' ORDER BY FilterPageID

                                    laag lagefauteuil treinbank

                                    Filterpos = 4
                                    Filterid = 2077
                                    pagefilterid = 1401

                                    productfilter = 1353, 1353, 1401, 1401, 1639, 1847, 1948, 2077,
Bla station Dundra

€ 800
Bla Station Park +
17
                                    productid 2318

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2318

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2318%' ORDER BY FilterPageID

                                    

                                    Filterpos = 2
                                    Filterid = 1847
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401, 1847,
Bla station Park +

€ 1900
Brunner A-Bench
18
                                    productid 2734

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2734

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2734%' ORDER BY FilterPageID

                                    

                                    Filterpos = 1
                                    Filterid = 2789
                                    pagefilterid = 1401

                                    productfilter = 1401, 1639, 1847, 1948, 2789,
Brunner A-Bench

€ 2090
BuzziSpace BuzziCee
19
                                    productid 2809

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2809

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2809%' ORDER BY FilterPageID

                                    

                                    Filterpos = 1
                                    Filterid = 2789
                                    pagefilterid = 1401

                                    productfilter = 1401, 1948, 2789,
BuzziSpace BuzziCee

€ 3500
Casala Bricks Configurations
20
                                    productid 445

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 445

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%445%' ORDER BY FilterPageID

                                    lagefauteuil hogebank laag hogefauteuil concentratie 

                                    Filterpos = 6
                                    Filterid = 1441
                                    pagefilterid = 1401

                                    productfilter = 1304, 1352, 1352, 1392, 1401, 1401, 1419, 1441,
Casala Bricks Configuratio...

€ 3000
Casala Capsule
21
                                    productid 1679

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1679

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1679%' ORDER BY FilterPageID

                                    hogefauteuil hogebank concentratie

                                    Filterpos = 3
                                    Filterid = 1419
                                    pagefilterid = 1401

                                    productfilter = 1352, 1353, 1401, 1419,
Casala Capsule

€ 4400
Casala Corals
22
                                    productid 1456

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1456

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1456%' ORDER BY FilterPageID

                                    concentratie laag lagefauteuil modulair

                                    Filterpos = 2
                                    Filterid = 2585
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401, 1847, 2585,
Casala Corals

€ 3000
Casala Diner Sofa
23
                                    productid 616

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 616

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%616%' ORDER BY FilterPageID

                                    laag treinbank

                                    Filterpos = 1
                                    Filterid = 1896
                                    pagefilterid = 1401

                                    productfilter = 1401, 1639, 1881, 1896,
Casala Diner Sofa

€ 1250
Djavan Casala
24
                                    productid 619

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 619

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%619%' ORDER BY FilterPageID

                                    laag

                                    Filterpos = 2
                                    Filterid = 2353
                                    pagefilterid = 1401

                                    productfilter = 1392, 1401, 1419, 1631, 2353,
Casala Djavan

€ 2900
Casala Gabo
25
                                    productid 1516

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1516

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1516%' ORDER BY FilterPageID

                                    hogebank hogefauteuil Concentratie laag

                                    Filterpos = 2
                                    Filterid = 1639
                                    pagefilterid = 1401

                                    productfilter = 1352, 1401, 1419, 1639,
Casala Gabo

€ 2200
Casala Kylian
26
                                    productid 650

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 650

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%650%' ORDER BY FilterPageID

                                    lagefauteuil laag

                                    Filterpos = 6
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1278, 1353, 1376, 1388, 1392, 1401, 1901, 2794,
Casala Kylian

€ 2980
Casala Stream
27
                                    productid 623

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 623

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%623%' ORDER BY FilterPageID

                                    hogebank laag modulair

                                    Filterpos = 4
                                    Filterid = 2077
                                    pagefilterid = 1401

                                    productfilter = 1245, 1305, 1352, 1401, 1586, 1775, 1847, 2077,
Casala Stream

€ 1900
Casala treinbank
28
                                    productid 617

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 617

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%617%' ORDER BY FilterPageID

                                    hogebank laag treinbank

                                    Filterpos = 2
                                    Filterid = 1639
                                    pagefilterid = 1401

                                    productfilter = 1352, 1401, 1632, 1639,
Casala Treinbank

€ 1100
De Vorm Arnhem Sofa
29
                                    productid 1423

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1423

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1423%' ORDER BY FilterPageID

                                    hogebank laag lagefauteuil hogefauteuil

                                    Filterpos = 3
                                    Filterid = 1419
                                    pagefilterid = 1401

                                    productfilter = 1352, 1353, 1401, 1419,
De Vorm Arnhem Sofa

€ 2800
DUM Beech Private
30
                                    productid 2183

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2183

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2183%' ORDER BY FilterPageID

                                    

                                    Filterpos = 3
                                    Filterid = 1639
                                    pagefilterid = 1401

                                    productfilter = 1352, 1353, 1401, 1419, 1639,
Dum Beech Private

€ 4500
Dutchbone Houda
31
                                    productid 2487

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2487

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2487%' ORDER BY FilterPageID

                                    

                                    Filterpos = 3
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1353, 1392, 1401,
Dutchbone Houda

€ 1000
Dutchbone Kate
32
                                    productid 2489

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2489

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2489%' ORDER BY FilterPageID

                                    

                                    Filterpos = 2
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401,
Dutchbone Kate

€ 840
Dynamobel Ginza
33
                                    productid 556

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 556

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%556%' ORDER BY FilterPageID

                                    laag wachtbank

                                    Filterpos = 1
                                    Filterid = 2077
                                    pagefilterid = 1401

                                    productfilter = 1401, 1836, 1948, 2077,
Dynamobel Ginza

€ 1200
Fermob Bellevie
34
                                    productid 2435

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2435

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2435%' ORDER BY FilterPageID

                                    

                                    Filterpos = 4
                                    Filterid = 2181
                                    pagefilterid = 1401

                                    productfilter = 1353, 1376, 1392, 1401, 2181,
Fermob Bellevie

€ 2500
Gelderland 430
35
                                    productid 753

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 753

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%753%' ORDER BY FilterPageID

                                    laag

                                    Filterpos = 2
                                    Filterid = 2061
                                    pagefilterid = 1401

                                    productfilter = 1388, 1401, 1402, 1610, 1611, 1826, 2061,
Gelderland 430

€ 2300
Gelderland 4800
36
                                    productid 1743

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1743

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1743%' ORDER BY FilterPageID

                                    laag lagefauteuil

                                    Filterpos = 2
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401, 2313, 2794,
Gelderland 4800

€ 1100
Gelderland 7840 Pillow
37
                                    productid 1588

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1588

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1588%' ORDER BY FilterPageID

                                    lagefauteuil laag hogebank hogefauteuil

                                    Filterpos = 3
                                    Filterid = 1419
                                    pagefilterid = 1401

                                    productfilter = 1352, 1353, 1401, 1419,
Gelderland 7840 Pillow

€ 2000
Gelderland Endless
38
                                    productid 1956

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1956

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1956%' ORDER BY FilterPageID

                                    laag modulaire

                                    Filterpos = 2
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401, 1847, 2794,
Gelderland Endless

€ 2000
Gelderland Woody
39
                                    productid 1955

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1955

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1955%' ORDER BY FilterPageID

                                    lagefauteuil laag poef

                                    Filterpos = 3
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1353, 1392, 1401,
Gelderland Woody

€ 1400
Kastel Kendo
40
                                    productid 526

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 526

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%526%' ORDER BY FilterPageID

                                    hogebank lagefauteuil poef laag hogefauteuil

                                    Filterpos = 7
                                    Filterid = 2132
                                    pagefilterid = 1401

                                    productfilter = 1281, 1282, 1282, 1352, 1353, 1392, 1401, 1419, 2077, 2132,
Kastel Kendo

€ 1200
Kastel Klasse
41
                                    productid 436

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 436

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%436%' ORDER BY FilterPageID

                                    lagefauteuil laag

                                    Filterpos = 7
                                    Filterid = 1833
                                    pagefilterid = 1401

                                    productfilter = 1270, 1276, 1305, 1315, 1338, 1353, 1401, 1408, 1426, 1592, 1775, 1833,
Kastel Klasse

€ 850
Kastel Kontex
42
                                    productid 2211

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2211

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2211%' ORDER BY FilterPageID

                                    

                                    Filterpos = 3
                                    Filterid = 2585
                                    pagefilterid = 1401

                                    productfilter = 1352, 1353, 1401, 1419, 2585,
Kastel Kontex

€ 1800
Kusch + Co 7900 Creva Soft
43
                                    productid 1998

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1998

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1998%' ORDER BY FilterPageID

                                    laag hogebank poef hogefauteuil salon 

                                    Filterpos = 3
                                    Filterid = 2585
                                    pagefilterid = 1401

                                    productfilter = 1352, 1353, 1401, 1419, 1948, 2585,
Kusch + co 7900 Creva Soft

€ 2800
Kusch en Co Palato
44
                                    productid 2284

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2284

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2284%' ORDER BY FilterPageID

                                    

                                    Filterpos = 2
                                    Filterid = 2270
                                    pagefilterid = 1401

                                    productfilter = 1315, 1401, 1775, 1916, 2270,
Kusch + co Palato 3700

€ 485
Kusch en Co Vega
45
                                    productid 2835

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2835

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2835%' ORDER BY FilterPageID

                                    

                                    Filterpos = 2
                                    Filterid = 2270
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401, 2270,
Kusch + co Vega

€ 1726
Lammhults Area
46
                                    productid 2502

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2502

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2502%' ORDER BY FilterPageID

                                    

                                    Filterpos = 3
                                    Filterid = 1847
                                    pagefilterid = 1401

                                    productfilter = 1352, 1353, 1401, 1419, 1847,
Lammhults Area

€ 1250
Lande Buggy
47
                                    productid 2790

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2790

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2790%' ORDER BY FilterPageID

                                    

                                    Filterpos = 1
                                    Filterid = 2181
                                    pagefilterid = 1401

                                    productfilter = 1401, 1639, 1948, 2181,
Lande Buggy

€ 845
Lande Talks
48
                                    productid 1786

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1786

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1786%' ORDER BY FilterPageID

                                    laag lagefauteuil modulair

                                    Filterpos = 2
                                    Filterid = 2789
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401, 1847, 1948, 2789,
Lande Talks

€ 1370
Markant Hybrid
49
                                    productid 1963

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1963

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1963%' ORDER BY FilterPageID

                                    hogebank laag treinbank concentratie

                                    Filterpos = 2
                                    Filterid = 2585
                                    pagefilterid = 1401

                                    productfilter = 1352, 1401, 1639, 1847, 2313, 2585,
Markant Hybrid

€ 2500
Balmoral bank
50
                                    productid 2614

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2614

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2614%' ORDER BY FilterPageID

                                    

                                    Filterpos = 2
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401,
Meinema Balmoral

€ 1995
Cave bank
51
                                    productid 437

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 437

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%437%' ORDER BY FilterPageID

                                    hogebank lagefauteuil hogefauteuil treinbank laag

                                    Filterpos = 7
                                    Filterid = 2350
                                    pagefilterid = 1401

                                    productfilter = 1313, 1313, 1314, 1314, 1352, 1353, 1401, 1419, 1592, 1639, 1708, 1916, 2097, 2313, 2350,
Meinema Cave

€ 1350
Falkor
52
                                    productid 2846

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2846

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2846%' ORDER BY FilterPageID

                                    

                                    Filterpos = 2
                                    Filterid = 1639
                                    pagefilterid = 1401

                                    productfilter = 1315, 1401, 1639,
Meinema Falkor

€ 1000
Life terrasbank
53
                                    productid 1934

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1934

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1934%' ORDER BY FilterPageID

                                    laag treinbank

                                    Filterpos = 1
                                    Filterid = 2181
                                    pagefilterid = 1401

                                    productfilter = 1401, 1639, 2181,
Meinema Life

€ 1750
Madrid
54
                                    productid 2091

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2091

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2091%' ORDER BY FilterPageID

                                    laag lagefauteuil poef treinbank 4-poot

                                    Filterpos = 3
                                    Filterid = 1639
                                    pagefilterid = 1401

                                    productfilter = 1353, 1392, 1401, 1639,
Meinema Madrid

€ 800
Modular bank
55
                                    productid 2096

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2096

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2096%' ORDER BY FilterPageID

                                    hogebank poef laag lagefauteuil modulair

                                    Filterpos = 4
                                    Filterid = 2585
                                    pagefilterid = 1401

                                    productfilter = 1352, 1353, 1392, 1401, 1847, 2585,
Meinema Modular

€ 800
Ribbel bank
56
                                    productid 1594

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1594

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1594%' ORDER BY FilterPageID

                                    laag treinbank modulair

                                    Filterpos = 2
                                    Filterid = 1847
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401, 1639, 1847,
Meinema Ribbel

€ 670
Soho bank
57
                                    productid 467

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 467

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%467%' ORDER BY FilterPageID

                                    laag treinbank modulair

                                    Filterpos = 4
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1278, 1314, 1337, 1401, 1592, 1639, 1774, 1822, 1832, 1847, 2097, 2270, 2313, 2794,
Meinema Soho bank

€ 500
Sonar
58
                                    productid 2338

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2338

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2338%' ORDER BY FilterPageID

                                    

                                    Filterpos = 1
                                    Filterid = 1639
                                    pagefilterid = 1401

                                    productfilter = 1401, 1639,
Meinema Sonar

€ 1100
Stripes
59
                                    productid 2626

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2626

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2626%' ORDER BY FilterPageID

                                    

                                    Filterpos = 3
                                    Filterid = 2077
                                    pagefilterid = 1401

                                    productfilter = 1353, 1392, 1401, 1639, 2077,
Meinema Stripes

€ 350
Varso bank
60
                                    productid 440

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 440

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%440%' ORDER BY FilterPageID

                                    laag modulair

                                    Filterpos = 2
                                    Filterid = 1847
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401, 1847,
Meinema Varso

€ 1500
Milani People
61
                                    productid 450

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 450

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%450%' ORDER BY FilterPageID

                                    

                                    Filterpos = 4
                                    Filterid = 2585
                                    pagefilterid = 1401

                                    productfilter = 1352, 1353, 1401, 1401, 1419, 1804, 2585,
Milani People

€ 6000
Montis Axel
62
                                    productid 439

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 439

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%439%' ORDER BY FilterPageID

                                    lagefauteuil laag

                                    Filterpos = 2
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401, 1610, 1802, 1804, 2313, 2794,
Montis Axel bank

€ 2300
Muuto Connect
63
                                    productid 1799

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1799

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1799%' ORDER BY FilterPageID

                                    laag modulair

                                    Filterpos = 1
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1401, 1847, 2794,
Muuto Connect

€ 1190
Muuto Oslo
64
                                    productid 1729

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1729

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1729%' ORDER BY FilterPageID

                                    laag lagefauteuil poef treinbank

                                    Filterpos = 2
                                    Filterid = 1948
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401, 1948,
Muuto Oslo

€ 2350
Muuto Outline Series
65
                                    productid 1719

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1719

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1719%' ORDER BY FilterPageID

                                    hogebank lagefauteuil laag poef

                                    Filterpos = 5
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1304, 1352, 1353, 1392, 1401, 2794,
Muuto Outline

€ 2600
Narbutas Arcipelago
66
                                    productid 1869

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1869

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1869%' ORDER BY FilterPageID

                                    modulair hogebank hogefauteuil laag

                                    Filterpos = 2
                                    Filterid = 2789
                                    pagefilterid = 1401

                                    productfilter = 1352, 1401, 1419, 1847, 2585, 2789,
Narbutas Arcipelago

€ 1800
Narbutas Twist & Sit fauteuil
67
                                    productid 1926

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1926

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1926%' ORDER BY FilterPageID

                                    hogefauteuil

                                    Filterpos = 3
                                    Filterid = 1419
                                    pagefilterid = 1401

                                    productfilter = 1352, 1353, 1401, 1419,
Narbutas Twist and Sit

€ 1000
Narbutas Twist and Sit soft
68
                                    productid 2836

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2836

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2836%' ORDER BY FilterPageID

                                    

                                    Filterpos = 4
                                    Filterid = 1419
                                    pagefilterid = 1401

                                    productfilter = 1304, 1352, 1353, 1401, 1419,
Narbutas Twist and Sit Sof...

€ 3000
Offecct Airberg
69
                                    productid 1877

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1877

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1877%' ORDER BY FilterPageID

                                    lagefauteuil laag

                                    Filterpos = 2
                                    Filterid = 2077
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401, 1847, 1948, 2077,
Offecct Airberg

€ 3900
Offecct Lucy
70
                                    productid 1874

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1874

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1874%' ORDER BY FilterPageID

                                    modulair poef laag 

                                    Filterpos = 2
                                    Filterid = 1948
                                    pagefilterid = 1401

                                    productfilter = 1392, 1401, 1847, 1948,
Offecct Lucy

€ 2400
Offecct Maki
71
                                    productid 2159

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2159

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2159%' ORDER BY FilterPageID

                                    modulair fauteuil laag 

                                    Filterpos = 2
                                    Filterid = 2789
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401, 1847, 1948, 2789,
Offecct Maki

€ 2300
Quinti Deep Lounge
72
                                    productid 2367

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2367

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2367%' ORDER BY FilterPageID

                                    

                                    Filterpos = 2
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401,
Quinti Deep Lounge

€ 1100
Quinti Loft X
73
                                    productid 2452

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2452

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2452%' ORDER BY FilterPageID

                                    

                                    Filterpos = 4
                                    Filterid = 2585
                                    pagefilterid = 1401

                                    productfilter = 1352, 1353, 1392, 1401, 1419, 1948, 2585,
Quinti Loft X

€ 1800
Quinti New York
74
                                    productid 2784

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2784

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2784%' ORDER BY FilterPageID

                                    

                                    Filterpos = 3
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1353, 1392, 1401, 2794,
Quinti New York

€ 2520
Quinti Vogue
75
                                    productid 2818

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2818

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2818%' ORDER BY FilterPageID

                                    

                                    Filterpos = 3
                                    Filterid = 1847
                                    pagefilterid = 1401

                                    productfilter = 1353, 1392, 1401, 1639, 1847,
Quinti Vogue

€ 1875
Softline Basel
76
                                    productid 743

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 743

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%743%' ORDER BY FilterPageID

                                    lagefauteuil laag

                                    Filterpos = 6
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1278, 1353, 1353, 1388, 1401, 1401, 1774, 1822, 1901, 2313, 2794,
Softline Basel

€ 1560
Softline Cabala
77
                                    productid 1685

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1685

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1685%' ORDER BY FilterPageID

                                    laag lagefauteuil modulair

                                    Filterpos = 2
                                    Filterid = 1948
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401, 1847, 1948,
Softline Cabala

€ 1400
Softline Elle
78
                                    productid 747

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 747

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%747%' ORDER BY FilterPageID

                                    laag lagefauteuil modulair

                                    Filterpos = 4
                                    Filterid = 2585
                                    pagefilterid = 1401

                                    productfilter = 1305, 1315, 1353, 1401, 1775, 1847, 2585,
Softline Elle

€ 900
Softline Fluid
79
                                    productid 744

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 744

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%744%' ORDER BY FilterPageID

                                    poef laag

                                    Filterpos = 4
                                    Filterid = 2181
                                    pagefilterid = 1401

                                    productfilter = 1353, 1392, 1392, 1401, 2181,
Softline Fluid outdoor

€ 350
Softline Jason Sofabed
80
                                    productid 694

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 694

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%694%' ORDER BY FilterPageID

                                    laag

                                    Filterpos = 1
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1401,
Softline Jason Sofabed

€ 2050
Softline Loft sofa
81
                                    productid 947

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 947

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%947%' ORDER BY FilterPageID

                                    laag modulair

                                    Filterpos = 1
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1401, 1847, 2181, 2794,
Softline Loft

€ 300
Softline Lotus
82
                                    productid 931

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 931

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%931%' ORDER BY FilterPageID

                                    laag modulair

                                    Filterpos = 1
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1401, 1847, 2794,
Softline Lotus

€ 550
Softline Lounge sofa
83
                                    productid 948

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 948

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%948%' ORDER BY FilterPageID

                                    laag

                                    Filterpos = 1
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1401,
Softline Lounge

€ 1400
Softline Lubi
84
                                    productid 746

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 746

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%746%' ORDER BY FilterPageID

                                    laag

                                    Filterpos = 4
                                    Filterid = 1948
                                    pagefilterid = 1401

                                    productfilter = 1315, 1353, 1401, 1401, 1775, 1948,
Softline Lubi

€ 740
Softline Meghan
85
                                    productid 2727

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2727

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2727%' ORDER BY FilterPageID

                                    

                                    Filterpos = 1
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1401,
Softline Meghan

€ 2210
Softline Nevada sofa
86
                                    productid 949

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 949

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%949%' ORDER BY FilterPageID

                                    laag

                                    Filterpos = 1
                                    Filterid = 1847
                                    pagefilterid = 1401

                                    productfilter = 1401, 1847,
Softline Nevada

€ 850
Softline Noa
87
                                    productid 938

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 938

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%938%' ORDER BY FilterPageID

                                    laag modulair

                                    Filterpos = 1
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1401, 1847, 2794,
Softline Noa

€ 800
Softline Ohio
88
                                    productid 952

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 952

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%952%' ORDER BY FilterPageID

                                    laag poef modulaire

                                    Filterpos = 2
                                    Filterid = 1847
                                    pagefilterid = 1401

                                    productfilter = 1392, 1401, 1402, 1847,
Softline Ohio

€ 600
Softline Opera Chair and Sofa
89
                                    productid 933

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 933

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%933%' ORDER BY FilterPageID

                                    hogefauteuil lagefauteuil laag hogebank modulair

                                    Filterpos = 5
                                    Filterid = 1847
                                    pagefilterid = 1401

                                    productfilter = 1281, 1352, 1353, 1392, 1401, 1419, 1847,
Softline Opera

€ 1150
Softline Orlando Wood
90
                                    productid 1899

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1899

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1899%' ORDER BY FilterPageID

                                    lagefauteuil laag treinbank

                                    Filterpos = 2
                                    Filterid = 1948
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401, 1948,
Softline Orlando Wood

€ 700
Softline Passion modular sofa
91
                                    productid 950

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 950

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%950%' ORDER BY FilterPageID

                                    laag modulair

                                    Filterpos = 4
                                    Filterid = 2794
                                    pagefilterid = 1401

                                    productfilter = 1276, 1337, 1338, 1401, 1446, 1822, 1832, 1833, 1847, 2084, 2157, 2794,
Softline Passion

€ 700
Softline Planet sofa
92
                                    productid 953

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 953

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%953%' ORDER BY FilterPageID

                                    poef laag modulair

                                    Filterpos = 3
                                    Filterid = 1847
                                    pagefilterid = 1401

                                    productfilter = 1376, 1392, 1401, 1434, 1847,
Softline Planet

€ 800
Softline Scope
93
                                    productid 745

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 745

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%745%' ORDER BY FilterPageID

                                    lagefauteuil laag

                                    Filterpos = 4
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1245, 1353, 1353, 1401,
Softline Scope

€ 850
Softline Sleep
94
                                    productid 1968

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1968

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1968%' ORDER BY FilterPageID

                                    laag

                                    Filterpos = 1
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1401,
Softline Sleep

€ 1100
Softline Venus sofa
95
                                    productid 945

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 945

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%945%' ORDER BY FilterPageID

                                    laag

                                    Filterpos = 1
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1401,
Softline Venus

€ 2100
Softline Wood Sofa
96
                                    productid 2746

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2746

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2746%' ORDER BY FilterPageID

                                    

                                    Filterpos = 1
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1401,
Softline Wood Sofa

€ 2260
Walter Knoll 375
97
                                    productid 1507

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1507

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1507%' ORDER BY FilterPageID

                                    lagefauteuil poef laag

                                    Filterpos = 3
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1353, 1392, 1401,
Walter Knoll 375

€ 1500
Walter Knoll Jaan
98
                                    productid 1503

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1503

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1503%' ORDER BY FilterPageID

                                    lagefauteuil laag modulair

                                    Filterpos = 2
                                    Filterid = 1847
                                    pagefilterid = 1401

                                    productfilter = 1353, 1401, 1847,
Walter Knoll Jaan

Op aanvraag
Wilkhahn Insit
99
                                    productid 1843

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 1843

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%1843%' ORDER BY FilterPageID

                                    laag poef treinbank modulair

                                    Filterpos = 2
                                    Filterid = 2789
                                    pagefilterid = 1401

                                    productfilter = 1392, 1401, 1639, 1847, 1948, 2789,
Wilkhahn Insit

€ 3200
Zuiver Summer
100
                                    productid 2475

                                    SELECT SITE.ID AS PPID, 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, PROD.FilterMeinema AS PPFilter, PROD.Subprijs AS PPSubprijs, FILP.ID AS PPsubFilter, PROD.SubcatPrijs AS PPSubcatprijs, 'laag' AS PPKey, FILP.Filter AS PPalter FROM ProductPage_Live AS PROD JOIN ProductPage_PlaatjeMeinema AS PLAA ON PROD.ID = PLAA.ProductPageID JOIN File AS BEST ON PLAA.ImageID = BEST.ID JOIN SiteTree_Live AS SITE ON PROD.ID = SITE.ID LEFT JOIN ProductPage_Filter2 AS FILT ON PROD.ID = FILT.ProductPageID LEFT JOIN FilterPage_Live AS FILP ON FILT.FilterPageID = FILP.ID WHERE FILP.Filter LIKE BINARY '%laag%' AND PLAA.SortOrder=0 AND WeergaveOverzicht = 0 GROUP BY PPTitle ORDER BY PROD.MerkMeinema, PROD.ModelMeinema 

                                    SELECT File.FileFilename AS altimage FROM ProductPage_PlaatjeMeinema JOIN File ON ProductPage_PlaatjeMeinema.ImageID = File.ID WHERE ProductPageID = 2475

                                    SELECT *,  ROW_NUMBER() OVER (ORDER BY (FilterPageID)) AS number FROM ProductPage_Filter2 WHERE ProductPageID LIKE '%2475%' ORDER BY FilterPageID

                                    

                                    Filterpos = 3
                                    Filterid = 1401
                                    pagefilterid = 1401

                                    productfilter = 1353, 1392, 1401,
Zuiver Summer

€ 1400
cindy meinema slogan 
WILT U MEER INFORMATIE ONTVANGEN OF KUNNEN WIJ U ADVISEREN?
Wij staan voor u klaar om u te helpen, neem hier contact met ons op!
Kantoor projectinrichting Skoon 8 - Oostzaan