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 1830 ROWS FETCH NEXT 15 ROWS ONLY
STRIPPER PER CAVI DATI U/UTP E F/UTP PZ 1HT350 STRIPPER PER CAVI DATI UUTP E FUTP PZ 1...Dettagli
IR Illuminator 850nm extra rangeIIR-50850-XR Illuminatore serie 5000 Extra Range XR luce semiinvisibile a 850nm con lenti di diffusione intercambiabili e autopulenti per le seguenti coperture 308m 10 210m 20 154m 30 98m 60 70m 80 49m 95 con intensit IR regolabile dal 10 al 100 dotato di fotocel...Dettagli
Tilt mount 20-deg, 148mmNDA-5080-TM Accessorio per installazione inclinata 20 delle telecamere FLEXIDOME IP 4000i5000i da interno ed esterno e FLEXIDOME panoramic 5100i...Dettagli
Flush mountSHD-2510FPW Custodia controsoffitto in alluminio per telecamere multisensore Compatibile con PNM9084QZ PNM8082VT Bianca...Dettagli
2.4mm Lens/Imager right angle body for PNM-9000QB (8.0m cable)SLA-T2480VA Modulo camera 128 2MP CMOS con ottica fissa da 24mm per PNM9000QB FoV H 138 V 73 045Lux WDR 120dB Electrical DayNight...Dettagli
4.6mm Lens/Imager straight body for PNM-9000QB (8.0m cable)SLA-T4680A Modulo camera 128 2MP CMOS con ottica fissa da 46mm per PNM9000QB FoV H 73 V 39 006Lux WDR 120dB Electrical DayNight...Dettagli
4.6mm Lens/Imager right angle body for PNM-9000QB (8.0m cable)SLA-T4680VA Modulo camera 128 2MP CMOS con ottica fissa da 46mm per PNM9000QB FoV H 73 V 39 006Lux WDR 120dB Electrical DayNight...Dettagli
2.4mm Lens/Imager straight body for PNM-9000QB (8.0m cable)SLA-T2480A Modulo camera 128 2MP CMOS con ottica fissa da 24mm per PNM9000QB FoV H 138 V 73 045Lux WDR 120dB Electrical DayNight...Dettagli