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
Positioning system IP AI 2 MP 60x WDR IR Starlight 36VPTZ85260-HNF-PA Positioning system IP AI 2 MP 60x WDR IR Starlight 36V ...Dettagli
Server IP 4AI 128 ch 24 MP 12 HDD 240VIVSS7012-4M Server IP 4AI 128 ch 24 MP 12 HDD 240V ...Dettagli
EVS 512 ch IP 48 HDD single controller fibra ottica 10GEVS7148S-10G EVS 512 ch IP 48 HDD single controller fibra ottica 10G ...Dettagli
EVS 1024 ch IP 85 HDD single controllerEVS7285S EVS 1024 ch IP 85 HDD single controller ...Dettagli
Bullet IP AI 8 MP 8~32 mm WDR IR Starlight 12/24V/ePoE NEMA 4X heaterIPC-HFW5842H-Z4HE-ATC Bullet IP AI 8 MP 8~32 mm WDR IR Starlight 12/24V/ePoE NEMA 4X heater ...Dettagli
Dome IP AI 8 MP 8~32 mm WDR IR Starlight 12/24V/ePoE NEMA 4X heaterIPC-HDBW5842H-Z4HE-AT Dome IP AI 8 MP 8~32 mm WDR IR Starlight 12/24V/ePoE NEMA 4X heater ...Dettagli
Dome IP AI 4 MP 2.7~12 mm WDR IR Starlight+ 12/24V/PoE+IPC-HDBW7442H-Z-S2 Dome IP AI 4 MP 2.7~12 mm WDR IR Starlight+ 12/24V/PoE+ ...Dettagli
Bullet AI Access ANPR 4 MP 2.7~12 mm WDR IRITC415-PW6M-IZ-GN-C2 Bullet AI Access ANPR 4 MP 2.7~12 mm WDR IR ...Dettagli
Bullet IP AI Enforcement ANPR 3 MP C WDR IRITC352-AU3F-IRL8-C1 Bullet IP AI Enforcement ANPR 3 MP C WDR IR ...Dettagli
PTZ IP AI + panoramica 2 MP 25x/6 mm WDR IR/LED Starlight 36V/Hi-PoESDT5X225-2F-QA-0600 PTZ IP AI + panoramica 2 MP 25x/6 mm WDR IR/LED Starlight 36V/Hi-PoE ...Dettagli
PTZ IP AI + panoramica 4 MP 5x/6 mm WDR IR/LED Starlight+ 36V/Hi-PoESDT5X405-4F-QA-0600 PTZ IP AI + panoramica 4 MP 5x/6 mm WDR IR/LED Starlight+ 36V/Hi-PoE ...Dettagli
PTZ IP AI + panoramica 4 MP 25x (8~32 mm)/6 mm WDR IR/LED Starlight+ 36SDT5X425-4Z4-QA-0832 PTZ IP AI + panoramica 4 MP 25x (8~32 mm)/6 mm WDR IR/LED Starlight+ 36 ...Dettagli