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 5070 ROWS FETCH NEXT 15 ROWS ONLY
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
Positioning system IP 2 MP 45x WDR IR Starlight 24V/Hi-PoEpresa nella pPTZ19245U-IRB-N-B Positioning system IP 2 MP 45x WDR IR Starlight 24V/Hi-PoEpresa nella p ...Dettagli
PTZ IP AI 4 MP 48x WDR IR Starlight 36V/Hi-PoESD8C448PA-HNF PTZ IP AI 4 MP 48x WDR IR Starlight 36V/Hi-PoE ...Dettagli
Positioning system IP AI 8 MP 48x WDR IR Starlight 36VPTZ85848-HNF-PA Positioning system IP AI 8 MP 48x WDR IR Starlight 36V ...Dettagli
EVS IP 320 ch 24 HDD single controllerEVS5124S EVS IP 320 ch 24 HDD single controller ...Dettagli