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 = '01 ' AND I.SBFAM = '011 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ')) ORDER BY I.Seq OFFSET 2100 ROWS FETCH NEXT 15 ROWS ONLY
24-Ports PoE 10/100/1000Mbps with 4 x SFP ports - 24 x PoE 10/100/1000MbDGS-1210-28P 24Ports PoE 101001000Mbps with 4 x SFP ports 24 x PoE 101001000Mbps AutoNegotiating Ports 4 x SFP ports Port 14 8023at up to 30W Port 524 8023af up to 154W Switching Capacity 56 Gbps Advance power saving features Fanless design HalfFullDuplex...Dettagli
8MP AI IR Panoramic Outdoor Vandal DomePNM-C9022RV 8MP AI IR Panoramic Outdoor Vandal Dome ...Dettagli
Monitor 75" per meetboardIFP-7502 Monitor 75 per meetboard...Dettagli
Illuminatore IR per TNU-6320/KEU - 200m - 25 gradi - IP67SPI-50 Illuminatore IR per TNU6320KEU 200m 25 gradi IP67...Dettagli
Copertura esterna per XNV-6081Z/8081Z, XNV-6081/6081R/8081RSBC-180B Copertura esterna di colore nero da applicare su camere mod XNV6081Z8081Z XNV60816081R8081R...Dettagli
Copertura esterna per XND-6081VZ/8081VZ, XND-6081V/6081RV/8081RVSBC-160B Copertura esterna di colore nero da applicare su camere mod XND6081VZ8081VZ XND6081V6081RV8081RV...Dettagli
Staffa a muro per MiniDomeSBP-120WMW Staffa a muro per MiniDome tipo LND6070R QND6072R6082R8080R LND6010R6020R6030R QND6012R6022R6032R8010R8020R8030R QND6011602180118021...Dettagli
INSTALLATION BOX, compatibilita' con SBP-300WMW, SBP-300WMW1SBP-300NBW INSTALLATION BOX compatibilita con SBP300WMW SBP300WMW1...Dettagli
Copertura domeSBV-120WCW Copertura dome LNV6010R6020R6030R QNV6012R6022R6032R8010R8020R8030R...Dettagli
Adattatore supporto staffa per telecamere XNV-8081Z/6081Z/6081R/6081SBP-187HM Adattatore supporto staffa per telecamere XNV8081Z6081Z6081R6081...Dettagli
Housing and Mount for PVM camera TNB-6030SBP-300NM Housing and Mount for PVM camera TNB6030...Dettagli