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 5025 ROWS FETCH NEXT 15 ROWS ONLY
Server IP AI 128 ch 24 MP 12 HDD 240VIVSS7012 Server IP AI 128 ch 24 MP 12 HDD 240V ...Dettagli
Positioning system IP AI 4 MP 48x WDR IR Starlight 36VPTZ85448-HNF-PA Positioning system IP AI 4 MP 48x WDR IR Starlight 36V ...Dettagli
PTZ IP AI WizMind 4G mobile portatile 2 MP 31x WDR IR Starlight+PTZ4M231-HNR-XA-GHW PTZ IP AI WizMind 4G mobile portatile 2 MP 31x WDR IR Starlight+ ...Dettagli
Bullet IP AI Enforcement ANPR 9 MP C WDR IRITC952-AU3F-IRL8-C1 Bullet IP AI Enforcement ANPR 9 MP C WDR IR ...Dettagli
Servizio migrazione dati DSSSFDATAMIGRA1D Licenza DSS per servizio migrazione dati 1 giorno...Dettagli
PTZ IP AI + panoramica 4 MP 24x/4 mm WDR IR/LED Starlight+ 36VSDT7C424-4F-ZBZJ-APV- PTZ IP AI + panoramica 4 MP 24x/4 mm WDR IR/LED Starlight+ 36V ...Dettagli
Bullet IP AI 180° 4x8 MP 4x2.8 mm IR Starlight 12/24/PoE+IPC-PFW83242-A180-S2 Bullet IP AI 180° 4x8 MP 4x2.8 mm IR Starlight 12/24/PoE+ ...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
Dual IP AI 4 MP 2x2.8 mm WDR IR Starlight Mic 12V/PoEIPC-HDW8441X-3D Dual IP AI 4 MP 2x2.8 mm WDR IR Starlight Mic 12V/PoE ...Dettagli