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 ' AND I.GRP = '01157 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ' AND GRP = '01157 ')) ORDER BY I.Seq OFFSET 2445 ROWS FETCH NEXT 15 ROWS ONLY
Clarius Plus IR 850nm SmallSECL-IR850-DC-S Small Clarius PLUS InfraRed Illuminator 850nm max distances 132m low power consumption 15W Builtin photocell IR onoff Telemetry input for camera daynight remote switching angle 10 30 60 95 degree IP66...Dettagli
Clarius Plus IR 850nm Medium SECL-IR850-DC-M Medium Clarius PLUS InfraRed Illuminator 850nm max distances 187m low power consumption 26W Builtin photocell IR onoff Telemetry input for camera daynight remote switching angle 10 30 60 95 degree IP66...Dettagli
Cable Tester RJ11/12/45 BNC e USBWPC-TST-002 Cable Tester RJ111245 BNC e USB Il tester remoto permette di controllare i cavi prima e dopo l’installazione grazie alla parte remota removibile Compatibile EIATIA 356A EIATIA 568 AB ATT 258A e Token Ring Usoc 468 Portata massima 200 metri per ogni c...Dettagli
Staffa pendente a soffitto biancaSBP-300CMW Dettagli
10/100/1000 Mbps to SFP Industrial Media Converter with -40 to 70 °C opeDIS-M100G-SW 101001000 Mbps to SFP Industrial Media Converter with 40 to 70 C operating range 100BASETX 1000BASET RJ45 copper port 100BASEFX 1000BASEX SFP port Use multimode SFP or singlemode SFP Switching Capacity 4 Gbps Fanless passive cooling design Wi...Dettagli
Adattatore supporto staffa per telecamere tipo D4 e V6SBP-122HM Adattatore supporto staffa per telecamere tipo D4 e V6 XNV6010 6020 8020R 8030R 8040R QNV 6010R 6020 R 6030R QND6070R 7080R ...Dettagli
Collare da palo piccolo per sup.par.,per tel.e per sc.stagna(DaØ 80 a Ø1ACM263 Collare da palo piccolo per supporto da parete per telecamera e per scatola stagna Diampali da 80 a 1501400mmx1304mmx450mm...Dettagli