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)) ORDER BY I.Seq OFFSET 17910 ROWS FETCH NEXT 15 ROWS ONLY
Thermal Network Bullet Camera, 5MP, 7 mm thermal lensBMH-THERMAL-7-V2 Thermal Network Bullet Camera, 5MP, 7 mm thermal lens ...Dettagli
Camera- H.265 S-Sight, Active Deterrence, Bullet, Hybrid light, 2.8mm Lens, check point embedded, 4MBMH-340ADSN-28 Camera- H.265 S-Sight, Active Deterrence, Bullet, Hybrid light, 2.8mm Lens, check point embedded, 4M ...Dettagli
Camera- H.265 Eye-Sight Active deterrence Series, Bullet Hybrid LED, motorized Lens 4M with PoEBMH-340ADN-MVF-V4 Camera- H.265 Eye-Sight Active deterrence Series, Bullet Hybrid LED, motorized Lens 4M with PoE ...Dettagli
H.265 All-In-One Stand Alone DVR - 5MP LiteHybrid 16CH + 8CH IP, 1U caseSH-16200A5N-5L(1U)-V2 H.265 All-In-One Stand Alone DVR - 5MP LiteHybrid 16CH + 8CH IP, 1U case ...Dettagli
4 in 1, 1CH Passive HD Video and Power Balun Set, 8MPPTR-102VP-HD-8 4 in 1, 1CH Passive HD Video and Power Balun Set, 8MP ...Dettagli
1 CH HD Passive Video Balun Set, 8MPPTR-101V-HD-8 1 CH HD Passive Video Balun Set, 8MP ...Dettagli
Bracket- Wall bracket and Junction box for Z4,Z5,Z6 PTZPR-WJB-Z Bracket- Wall bracket and Junction box for Z4,Z5,Z6 PTZ ...Dettagli
Bracket- Wall bracket for FEI-PR-WB50 Bracket- Wall bracket for FEI- ...Dettagli
Bracket- L shape bracket with PR-JB14IP66 for I6-/DI-VF/DAI-VF, IP66PR-WB14 Bracket- L shape bracket with PR-JB14IP66 for I6-/DI-VF/DAI-VF, IP66 ...Dettagli
Bracket- L shape bracket with PR-JB12IP66 for I4-/I2-/DI-Fix/DAI-Fix, IP66 PR-WB12 Bracket- L shape bracket with PR-JB12IP66 for I4-/I2-/DI-Fix/DAI-Fix, IP66 ...Dettagli
Bracket- Wall bracket for DI-VF, DI-Fix, DAI-Fix, DMA.GreyPR-WB-A-G Bracket- Wall bracket for DI-VF, DI-Fix, DAI-Fix, DMA.Grey ...Dettagli
Bracket- Wall braket for DI-VF, DI-Fix, DAI-Fix, DMAPR-WB-A Bracket- Wall braket for DI-VF, DI-Fix, DAI-Fix, DMA ...Dettagli
Bracket- Junction box for I6-/DI-VF, IP66,GreyPR-JB14IP66-G Bracket- Junction box for I6-/DI-VF, IP66,Grey ...Dettagli