Basket
Home > Product categories > Clearance > Top Sale Lighting & Furniture Pieces
There has been an issue with the website, please try again in a few minutes.
Error in executing SELECT Products_Data.IntRef, Products_Data.PageUrl, Products_Data.ProductName, Products_Data.DiscountVal, Products_Data.POA, Products_Data.Catalogue1, Products_Data.Catalogue2, Products_Data.Catalogue3, Products_Data.Catalogue4, Products_Data.Catalogue5, Products_Data.Catalogue6, Products_Data.Catalogue7, Products_Data.Catalogue8, Products_Data.Catalogue9, Products_Data.Catalogue10, Manufacturer_Data.DiscountVal AS ManDiscountVal,(SELECT MIN(Products_Price_Matrix.Price) FROM Products_Price_Matrix WHERE Products_Price_Matrix.GroupId = '1' AND Products_Price_Matrix.ProductLink = Products_Data.IntRef) AS MinPrice,(SELECT MAX(Products_Price_Matrix.Price) FROM Products_Price_Matrix WHERE Products_Price_Matrix.GroupId = '1' AND Products_Price_Matrix.ProductLink = Products_Data.IntRef) AS MaxPrice,(SELECT MIN(Products_Price_Matrix.Price - (Products_Price_Matrix.Price / 100 * Products_Data.DiscountVal)) FROM Products_Price_Matrix WHERE Products_Price_Matrix.GroupId = '1' AND Products_Price_Matrix.ProductLink = Products_Data.IntRef) AS MinProdPrice,(SELECT MIN(Products_Price_Matrix.Price - (Products_Price_Matrix.Price / 100 * Manufacturer_Data.DiscountVal)) FROM Products_Price_Matrix WHERE Products_Price_Matrix.GroupId = '1' AND Products_Price_Matrix.ProductLink = Products_Data.IntRef) AS MinManPrice,(SELECT group_concat(Products_Filter_Matrix.FilterId) FROM Products_Filter_Matrix WHERE Products_Filter_Matrix.ProductLink = Products_Data.IntRef) AS TestFilter,(SELECT COUNT(DISTINCT Products_Filter_Matrix.IntRef) FROM Products_Filter_Matrix LEFT JOIN Filter_Data ON Filter_Data.IntRef = Products_Filter_Matrix.FilterId WHERE Products_Filter_Matrix.ProductLink = Products_Data.IntRef AND Filter_Data.Type = '2') AS ColourCount,CASE WHEN Products_Data.Catalogue1 IN () THEN Products_Data.CatalogueSubOrder1 WHEN Products_Data.Catalogue2 IN () THEN Products_Data.CatalogueSubOrder2 WHEN Products_Data.Catalogue3 IN () THEN Products_Data.CatalogueSubOrder3 WHEN Products_Data.Catalogue4 IN () THEN Products_Data.CatalogueSubOrder4 WHEN Products_Data.Catalogue5 IN () THEN Products_Data.CatalogueSubOrder5 WHEN Products_Data.Catalogue6 IN () THEN Products_Data.CatalogueSubOrder6 WHEN Products_Data.Catalogue7 IN () THEN Products_Data.CatalogueSubOrder7 WHEN Products_Data.Catalogue8 IN () THEN Products_Data.CatalogueSubOrder8 WHEN Products_Data.Catalogue9 IN () THEN Products_Data.CatalogueSubOrder9 WHEN Products_Data.Catalogue10 IN () THEN Products_Data.CatalogueSubOrder10 END AS Zorder FROM Products_Data LEFT JOIN Manufacturer_Data ON Manufacturer_Data.ManufacturerName = Products_Data.Manufacturer WHERE Products_Data.Viewable = '1' AND Products_Data.WebsiteRef < '3' AND (Products_Data.Catalogue1 IN () OR Products_Data.Catalogue2 IN () OR Products_Data.Catalogue3 IN () OR Products_Data.Catalogue4 IN () OR Products_Data.Catalogue5 IN () OR Products_Data.Catalogue6 IN () OR Products_Data.Catalogue7 IN () OR Products_Data.Catalogue8 IN () OR Products_Data.Catalogue9 IN () OR Products_Data.Catalogue10 IN () ) GROUP BY Products_Data.IntRef ORDER BY Zorder stmt
There has been an issue with the website, please try again in a few minutes.
error:1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') THEN Products_Data.CatalogueSubOrder1 WHEN Products_Data.Catalogue2 IN () THEN' at line 1