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 5115 ROWS FETCH NEXT 15 ROWS ONLY
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
PTZ IP AI + panoramica 4 MP 25x (2.8~12 mm)/6 mm WDR IR/LED Starlight+SDT5X425-4Z4-QA-2812 PTZ IP AI + panoramica 4 MP 25x (2.8~12 mm)/6 mm WDR IR/LED Starlight+ ...Dettagli
EVS IP 320 ch 16 HDDEVS5016S-V2 EVS IP 320 ch 16 HDD ...Dettagli