SELECT I.Description, I.DescriptionHTML, I.Code, I.PackPiecesNr, I.Id, (SELECT TOP 1 II.FileName FROM Media II WHERE II.EntityId = I.Id AND II.Type = 'IMAGE' AND II.EntityName = 'Item' ORDER BY Seq) AS Image, Trolese_WebSite.dbo.getSEOUrlByContentId(I.Code,'IT',NULL,NULL,I.LevelCode,0) AS SEOURL, COUNT(*) OVER() AS totResults FROM Item I WHERE I.LevelCode = 'ITEM' AND I.State IN (50,60) AND I.FAM IS NOT NULL AND I.Enabled = 1 AND I.Visible = 1 AND I.Deleted <> 1 AND I.State IN ('50','60') AND ((1=1 AND I.FAM = '02 ' AND I.SBFAM = '071 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '02 ' AND SBFAM = '071 ')) ORDER BY I.Seq OFFSET 0 ROWS FETCH NEXT 15 ROWS ONLY
Centrale 8 ingressi espan. a 32. Cloud tramite ip/gprs/3g- videoverificaX824V Centrale 8 ingressi espandibile a 32 telegestibile via cloud tramite ip e gprs3gapp con videoverifica...Dettagli
Modulo 4G , per telegestione via Cloud+APP - per SerieX V e XR800 VX4W Modulo 4G per telegestione via CloudAPP per SerieX V e XR800 V...Dettagli
Tastiera lcd blu con 2 linee in/out programmabiliK-LCDBLUE Tastiera lcd blu con 2 linee inout programmabili...Dettagli
Sensore serie ProLine, con antimask, dual tech con resistenze EOLDT1AM sensore serie ProLine con antimascheramento dual tech con resistenze EOL integrate pet immune 15kg...Dettagli
Sirena autoalimentata col. bianco- lamp. bianco doppio piezoBLADE02-WW-DP Sirena autoalimentata doppio piezo colore bianco lampegg a led bianco alta luminosit a scorrimento e riporto stato impiantoallarme...Dettagli