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 ' AND I.SBFAM = '011 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ')) ORDER BY I.Seq OFFSET 4545 ROWS FETCH NEXT 15 ROWS ONLY
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
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