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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ')) ORDER BY I.Seq OFFSET 4395 ROWS FETCH NEXT 15 ROWS ONLY
Dome 6MP HDR 3.9-10mm PTRZ IP67 IRNDE-8703-RL FLEXIDOME 8100i IR starlight 6MPp30 IVA Pro Building e IVA Pro Perimeter True DayNight sensore CMOS 118 progressive scan gamma dinamica 120 dB HDR PTRZ movimento motorizzato ai fini dellinstallazione ed obiettivo PIris motorizzato 3910mm con automati...Dettagli
EASY IP 4.0 COLORVU, BULLET IP OTTICA MOTORIZZATA, 4MPDS-2CD2647G2-LZS(3.6- EASY IP 40 COLORVU BULLET IP OTTICA MOTORIZZATA 4MP...Dettagli
Bullet IP AI 4 MP 2.7~12 mm WDR IR Starlight 12V/ePoE heaterIPC-HFW5442H-ZHE Bullet IP AI 4 MP 2.7~12 mm WDR IR Starlight 12V/ePoE heater ...Dettagli
Bullet IP AI 4 MP 2.7~12 mm WDR IR Starlight 12V/ePoE anticorrosione heaIPC-HFW5442H-ZH-SL Bullet IP AI 4 MP 2.7~12 mm WDR IR Starlight 12V/ePoE anticorrosione hea ...Dettagli
Box IP AI 8 MP C/CS WDR Starlight Mic 12/24V/PoE+IPC-HF7842F-Z-S2 Box IP AI 8 MP C/CS WDR Starlight Mic 12/24V/PoE+ ...Dettagli
Dome IP AI 8 MP 2.7~12 mm WDR IR Starlight 12/24V/ePoE heaterIPC-HDBW5842H-ZHE-S2 Dome IP AI 8 MP 2.7~12 mm WDR IR Starlight 12/24V/ePoE heater ...Dettagli
Bullet IP AI 8 MP 2.7~12 mm WDR IR Starlight 12/24V/ePoE heaterIPC-HFW5842H-ZHE-S2 Bullet IP AI 8 MP 2.7~12 mm WDR IR Starlight 12/24V/ePoE heater ...Dettagli
Dome IP AI 8 MP 2.7~12 mm WDR IR Starlight 12/24V/ePoE NEMA 4X heaterIPC-HDBW5842H-ZHE-ATC Dome IP AI 8 MP 2.7~12 mm WDR IR Starlight 12/24V/ePoE NEMA 4X heater ...Dettagli
Bullet IP AI 8 MP 2.7~12 mm WDR IR Starlight 12/24V/ePoE NEMA 4X heaterIPC-HFW5842H-ZHE-ATC- Bullet IP AI 8 MP 2.7~12 mm WDR IR Starlight 12/24V/ePoE NEMA 4X heater ...Dettagli
Bullet IP AI 4 MP 2.7~12 mm WDR IR Starlight+ 12/24V/PoE+IPC-HFW7442H-Z-S2 Bullet IP AI 4 MP 2.7~12 mm WDR IR Starlight+ 12/24V/PoE+ ...Dettagli
Dome IP AI 4 MP 8~32 mm WDR IR Starlight+ 12/24V/PoE+IPC-HDBW7442H-Z4-S2 Dome IP AI 4 MP 8~32 mm WDR IR Starlight+ 12/24V/PoE+ ...Dettagli