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 4485 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
Workstation Lenovo certificata per software DahuaCENTER090-V2 Workstation Lenovo certificata per software Dahua ...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
Bullet IP AI Enforcement ANPR 3 MP C WDR IRITC352-AU3F-IRL8-C1 Bullet IP AI Enforcement ANPR 3 MP C WDR IR ...Dettagli