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=44 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 | Audio Visual Alarms

Audio Visual Alarms

Audio Visual Alarms

Audio visual alarm with multiple inputs, logic control to activate depending on key indicators.

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