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 105 ROWS FETCH NEXT 15 ROWS ONLY
TLC 1080p Fissa 3.6 mm 12V IR 30 mHAC-HFW1200T-S5 TLC 1080p Fissa 36 mm 12V IR 30 m...Dettagli
TLC 1080p Fissa 3.6 mm 12V IR 20 mHAC-HFW1200R-S5 TLC 1080p Fissa 36 mm 12V IR 20 m...Dettagli
Dome 1080p fissa 2.8 mm 12V IR 50 m MicrofonoHAC-HDW1200EM-A-S5 Dome 1080p fissa 28 mm 12V IR 50 m Microfono...Dettagli
Dome 1080p Varifocale 2.7~12 mm 12V IR 30 mHAC-HDBW1200R-Z-S5 Dome 1080p Varifocale 2712 mm 12V IR 30 m...Dettagli
DOME 2K Fissa 1.18mm 12V WDR \IK10 antivandaloHAC-EW2501 DOME 2K Fissa 118mm 12V WDR IK10 antivandalo...Dettagli
"SPEED DOME 25X 4"" WDR 120Db 2MP"DS-2AE4225T-D 4 2MP 1920x1080 sensore 128 a scansione progressiva illuminazione minima a colori 0005 Lux F16 AGC ON BN 0001 Lux F16 AGC ON WDR 120db 3DDNR 8 zone di privacy mask programmabili filtro meccanico zoom ottico 48120mm 25X Pan 360 Tilt 5 a 90 velocit ...Dettagli
4MP Wisenet HD+ BulletHCO-7020RA Bullet camera 4MP WiseNet HD CMOS PS QHD 2560 x 1440 25fps over coax BNC AHD CVBS per installazione DWDR ottica fissa 4mm 25m IR range ICR distmax 500m motion detec Coax Ctrl IP66 IK10 12 Vdc...Dettagli
Dome 5MP Fissa 2.8 mm 12V IR 30 mHAC-HDW1500TLMQ-S2 Dome 5MP Fissa 28 mm 12V IR 30 m...Dettagli
5MP Starlight HDCVI IR Bullet CameraHAC-HFW2501E-A-S2 Dettagli
Dome 5MP Varifocale 2.7~12 mm 12V IR 30 mHAC-HDBW1500R-Z-S2 Dome 5MP Varifocale 2712 mm 12V IR 30 m...Dettagli
BULLET OTTICA FISSA 4 in 1 WDR 120dB EXIR 2.0 5MPDS-2CE16H8T-IT5F(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 80m sensore 5MP Progressive Scan CMOS sensibilit 0003 Lux F12 con AGC attivo 0 Lux con...Dettagli
Dome 1080p Fissa 2.8 mm 12V IR 30 mHAC-HDBW1200E-S5 Dome 1080p Fissa 28 mm 12V IR 30 m...Dettagli