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
Dome IP AI 4 MP 8~32 mm WDR IR Starlight+ 12/24V/PoE+ NEMA 4XIPC-HDBW7442H-Z4-ATC- Dome IP AI 4 MP 8~32 mm WDR IR Starlight+ 12/24V/PoE+ NEMA 4X ...Dettagli
Dome IP AI 8 MP 2.7~12 mm WDR IR Starlight 12/24V/PoE+ NEMA 4XIPC-HDBW7842H-Z-ATC-S Dome IP AI 8 MP 2.7~12 mm WDR IR Starlight 12/24V/PoE+ NEMA 4X ...Dettagli
Bullet IP AI 4 MP 8~32 mm WDR IR Starlight+ 12/24V/PoE+ NEMA 4XIPC-HFW7442H-Z4-ATC-S Bullet IP AI 4 MP 8~32 mm WDR IR Starlight+ 12/24V/PoE+ NEMA 4X ...Dettagli
Bullet IP AI 8 MP 2.7~12 mm WDR IR Starlight 12/24V/PoE+ NEMA 4XIPC-HFW7842H-Z-ATC-S2 Bullet IP AI 8 MP 2.7~12 mm WDR IR Starlight 12/24V/PoE+ NEMA 4X ...Dettagli
EVS IP 320 ch 16 HDD ridondanteEVS5016S-R-V2 EVS IP 320 ch 16 HDD ridondante ...Dettagli
Bullet IP AI 180° 4x4 MP 4x2.8 mm IR Starlight 12/24/PoE+IPC-PFW81642-A180 Bullet IP AI 180° 4x4 MP 4x2.8 mm IR Starlight 12/24/PoE+ ...Dettagli
Bullet IP 5G AI 8 MP 2.7~12 mm WDR IR/LED Mic 12VIPC-HFW5842DK1-Z-5G Bullet IP 5G AI 8 MP 2.7~12 mm WDR IR/LED Mic 12V ...Dettagli
Server IP 1AI 128 ch 12 MP 8 HDD 240VIVSS7008C-1I Server IP 1AI 128 ch 12 MP 8 HDD 240V ...Dettagli