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 = '010 ' AND I.GRP = '01050 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '010 ' AND GRP = '01050 ')) ORDER BY I.Seq OFFSET 75 ROWS FETCH NEXT 15 ROWS ONLY
BULLET OTTICA FISSA POC WDR 120dB TVI+CVBS 2MPDS-2CE16D8T-ITE(3.6) Bullet Turbo HDTVI POC 2MP di tipo DayNight con filtro IR meccanico WDR 120dB in contenitore per esterno IP67 illuminatore EXIR 20 integrato sino a 20m sensore 2MP Progressive Scan CMOS sensibilit 0005 Lux F12 con AGC attivo 0 Lux con IR ottica fissa...Dettagli
Bullet CVI 2MP 3.6mm WDR LED Full-color Mic 12VHAC-HFW1239TLM-A-LED- Bullet CVI 2MP 36mm WDR LED Fullcolor Mic 12V...Dettagli
Dome HDCVI 4K, 4 out, 2.7-13.5mm, IR 60 metri, WDR, 12VdcHAC-HDW1801T-Z-A Dome HDCVI 4K 4 out 27135mm IR 60 metri WDR 12Vdc...Dettagli
BULLET OTTICA FISSA 4 in 1 WDR 120dB EXIR 2.0 5MPDS-2CE16H8T-ITF(3.6) Bullet Turbo HDTVI 5MP 4 in 1 TVICVIAHDCVBS di tipo DayNight con filtro IR meccanico WDR130dB in contenitore per esterno IP67 illuminatore EXIR 20 integrato sino a 30m sensore 5MP Progressive Scan CMOS sensibilit 0003 Lux F12 con AGC attivo 0 Lux con...Dettagli
Minidome da interno 2MP,(AHD / TVI / CVI / CVBS) Ottica 4mm,12 VdcHCD-6020R Minidome da interno 2MP WiseNet HD CMOS PS FullHD over coax 1920x1080 30fps BNCAHD TVI CVI CVBS Selezionabile WDR120dB Ottica fissa da 4mm 20m IR range ICR DeFog distmax 500m motion detec Coax Ctrl 12 Vdc...Dettagli
Box camera 2MP, WiseNet HD+, CMOS, WDR, D/NHCB-6001 Box camera 2MP WiseNet HD CMOS PS FullHD over coax 1920x1080 30fps BNCAHD TVI CVI CVBS Selezionabile WDR120dB CCS mount Simple Focus ICR DeFog distmax 500m motion detec Coax Ctrl Dual Voltage 12 Vdc 24 Vac...Dettagli
Bullet 2MP,(AHD / TVI / CVI / CVBS Selezionabile)Ottica 4mm,IP 66, 12VdcHCO-6020R Bullet Camera 2MP WiseNet HD CMOS PS FullHD over coax 1920x1080 30fps BNCAHD TVI CVI CVBS Selezionabile WDR120dB Ottica fissa da 4mm 30m IR range ICR DeFog distmax 500m motion detection Coax Ctrl IP 66 12 Vdc...Dettagli
Minidome da esterno 2MP, CMOS, WDR, 3.2 ~ 10mm motorizzato, IR 30m, ICRHCV-6080R Minidome da esterno 2MP WiseNet HD CMOS PS FullHD over coax 1920x1080 30fps BNCAHD TVI CVI CVBS Selezionabile WDR120dB Varifocal 32 10mm motorizzato 30m IR range ICR DeFog distmax 500m motion detec Coax Ctrl IP 66 IK 10 Dual Voltage 12 Vdc 24 Va...Dettagli
HD+ Bullet 2MP, AHD/TVI/CVI/CVBS, lente 3.2-10mm 24VAC/12VDC, IP66/IK10HCO-6080 Wisenet HD Bullet camera da esterno 2MP Full HD1080p 30fps AHDTVICVICVBS lente varifocal motorizzata 31X 3210mm 120 dB true WDR Day Night ICR 24VAC12VDC IP66IK10...Dettagli
Minidome 2MP, AHD/TVI/CVI/CVBS, lente 3.2-10mm, 24VAC/12VDC, IP66/IK10HCV-6080 Wisenet HD Minidome Antivandalica da esterno da 2MP Full HD1080p 30fps AHDTVICVICVBS lente varifocale motorizzata 31X 3210mm 120 dB true WDR Day Night ICR 24VAC12VDC IP66IK10...Dettagli
Full camera 2.8-12 led IR, 700TVLEL-F1642W Full camera 2812 led IR 700TVL...Dettagli
Dome camera 3.6 mm, 24 led IR, 700TVL, col. BiancoEL-TC1100FW Dome camera 36 mm 24 led IR 700TVL col Bianco...Dettagli