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 4740 ROWS FETCH NEXT 15 ROWS ONLY
Adatt. Per Staffa ControsoffittoDS1642ZJ Adatt Per Staffa Controsoffitto...Dettagli
Telec. Minidome 2Mpx Col. Antivand.DS2CD7153E-4 Telec Minidome 2Mpx Col Antivand...Dettagli
Staffa Da Soffitto X Speed Dome 4"DS1653ZJ Staffa Da Soffitto X Speed Dome 4...Dettagli
Fixed dome 8MP HDR 3.4-10.2mm NDV-5704-A FLEXIDOME starlight 5100i interno 8MP30FPS Intelligent Video Analytics Pro Building Pack licenze aggiuntive opzionali IVA Pro Perimeter Pack e IVA Pro Traffic Pack True DayNight sensore CMOS 127 progressive scan gamma dinamica 120 dB HDR 105 dB misur...Dettagli
Bullet 8MP HDR 10.5-47mm CPP14 IP67 NBE-7704-ALT DINION 7000i IR starlight X 8MPX Intelligent Video Analytics Pro Building Pack e IVA PRO Perimeter Pack licenze aggiuntive opzionali IVA Pro Traffic Pack True DayNight sensore CMOS 118 progressive scan gamma dinamica 144 dB HDR 108 dB misurato second...Dettagli
Fixed dome 8MP HDR 3.4-10.2mm IP66 NDE-5704-A FLEXIDOME starlight 5100i interno 8MP30FPS Intelligent Video Analytics Pro Building Pack licenze aggiuntive opzionali IVA Pro Perimeter Pack e IVA Pro Traffic Pack True DayNight sensore CMOS 127 progressive scan gamma dinamica 120 dB HDR 105 dB misur...Dettagli
Bullet 4MP HDR X 10.5-47mm CPP14 IP67 NBE-7703-ALXT DINION 7000i IR starlight X 4MPX Intelligent Video Analytics Pro Building Pack e IVA PRO Perimeter Pack licenze aggiuntive opzionali IVA Pro Traffic Pack True DayNight sensore CMOS 118 progressive scan gamma dinamica 144 dB HDR X 108 dB misurato seco...Dettagli