Holloway of Ludlow
Free delivery on orders over 50
Basket
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.Catalogue1, Products_Data.Catalogue2, Products_Data.Catalogue3, Products_Data.Catalogue4, Products_Data.Catalogue5, 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.CatalogueOrder1 WHEN Products_Data.Catalogue2 IN () THEN Products_Data.CatalogueOrder2 WHEN Products_Data.Catalogue3 IN () THEN Products_Data.CatalogueOrder3 WHEN Products_Data.Catalogue4 IN () THEN Products_Data.CatalogueOrder4 WHEN Products_Data.Catalogue5 IN () THEN Products_Data.CatalogueOrder5 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.Catalogue1 IN () OR Products_Data.Catalogue2 IN () OR Products_Data.Catalogue3 IN () OR Products_Data.Catalogue4 IN () OR Products_Data.Catalogue5 IN () ) GROUP BY Products_Data.IntRef ORDER BY Products_Data.OrderWeighting DESC 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.CatalogueOrder1 WHEN Products_Data.Catalogue2 IN () THEN Pr' at line 1