SELECT DISTINCT CAT_ID, P_ID, P_VersionDisplayType, P_OrderVersionsBy, P_StrapLine1, cast(P_Desc1 as nvarchar(4000)) as P_Desc1, P_Name1, P_Type FROM (tblCactuShop1Categories c INNER JOIN tblCactuShop1ProductCategoryLink pcl ON c.CAT_ID = pcl.PCAT_CategoryID) INNER JOIN tblCactuShop1Products ON pcl.PCAT_ProductID = tblCactuShop1Products.P_ID WHERE P_Name1 <> '' AND P_Live = 'y' AND CAT_Live = 'y' AND CAT_ID=11 GROUP BY CAT_ID, P_ID, P_VersionDisplayType, P_OrderVersionsBy, P_StrapLine1, cast(P_Desc1 as nvarchar(4000)) , P_Name1, P_Type ORDER BY P_Name1 Products | 415v DOL - Accessories

415v DOL - Accessories

415v DOL - Accessories

415vv Starter Panel Accessories - Level modules, Remote Control modules, Alarm Modules, Panel meters, plugs & sockets

More Information


Geoquip Water Solutions Limited    Privacy    Sitemap
tel: +44(0)1473 462046    fax: +44(0)1473 462146   email: info@geoquipservices.co.uk
Address: Unit 7 Sovereign Centre, Farthing Road Industrial Estate, Ipswich, Suffolk, IP1 5AP, United Kingdom