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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ')) ORDER BY I.Seq OFFSET 4305 ROWS FETCH NEXT 15 ROWS ONLY
SPEED DOME IP 32X WDR 120dB H.265+ SMART IR 150MT 4MPDS-2DE5432IW-AE Speed Dome5 4MP 2560x1440 IR 150mt Zoom ottico 32x Digitale 16x sensore CMOS 125’’ Progressive Scan di tipo DayNight con filtro IR meccanico WDR 120 dB sensibilit colori 0005 lux F16 AGC on BN 0001 lux F16 AGC on 0 Lux con IR BLC HLC 3DDNR EIS ottica...Dettagli
DIVAR IP Workstation Expansion (1)MBV-XWST-DIP Licenza espansione n 1 Workstation postazione operatoren per DIVAR IP 30007000 e DIVAR IP 500060007000 Allinone...Dettagli
TURRET IP ACUSENSE OTTICA FISSA H.265+ 4KDS-2CD3386G2-ISU(2.8) TURRET IP ACUSENSE OTTICA FISSA H265 4K...Dettagli
Anti-corrosion Silver moon grey SUS316L 126 mm × 222 mm × 328 mm 2307gDS-1697ZJ-Y3(OS) Anticorrosion Silver moon grey SUS316L 126 mm 222 mm 328 mm 2307g...Dettagli
anti-corrosion SUS316L Stainless steel Silver moon grey 136 mm × 136 mmDS-1696ZJ-X-AC(OS) anticorrosion SUS316L Stainless steel Silver moon grey 136 mm 136 mm 306 mm 11 kg...Dettagli
Anti-corrosion SUS316L Stainless steel Silver moon grey 170 mm × 170 mmDS-2701ZJ-AC(OS) Anticorrosion SUS316L Stainless steel Silver moon grey 170 mm 170 mm 10 mm 360 g...Dettagli
Anti-corrosion SUS316L Stainless steel Silver moon grey 90 mm × 55 mm ×DS-1706ZJ-Y-AC(OS) Anticorrosion SUS316L Stainless steel Silver moon grey 90 mm 55 mm 60 mm 270 g...Dettagli
anti-corrosive Stainless Steel Silver moon gray 202 mm × 175.8 mm × 309.DS-1703ZJ-AC3(OS) anticorrosive Stainless Steel Silver moon gray 202 mm 1758 mm 3099 mm 3330 g...Dettagli
Stainless steel anti-corrosive silver moon gray 140 mm × 200 mm × 278DS-1704ZJ-Y-AC(OS) Stainless steel anticorrosive silver moon gray 140 mm 200 mm 278 mm 2158 g...Dettagli
BULLET IP MOTORIZZATA H.265+ 4MP NEMA 4 X CON RISCALDATOREIDS-2CD7A45G0-IZHSY(4 BULLET IP MOTORIZZATA H265 4MP NEMA 4 X CON RISCALDATORE...Dettagli
BULLET IP MOTORIZZATA H.265+ 4MP NEMA 4 XIDS-2CD7A45G0-IZSY(4. BULLET IP MOTORIZZATA H265 4MP NEMA 4 X...Dettagli
ANTIDEFLAGRANTE SPEED DOME IP ZOOM OTTICO 20X 2MPDS-2DF4220-DX(S6/316L Dettagli
ANTIDEFLAGRANTE BULLET IP MOTORIZZATA 2MP ZOOM 36X INOX 316LDS-2DB4236I-CWX(T5/31 Dettagli