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 5775 ROWS FETCH NEXT 15 ROWS ONLY
Waterproof Back BoxSBV-180WW Waterproof Back Box for the white Vandal XCore and XPlus cameras
Compatible models include XNV6081R XNV8081R XNV6083R XNV8083R XNV8093R XNV9083R XNVC6083R XNVC7083R XNVC8083R XNVC9083R...Dettagli
Monitor Stand Compatible with SMT-4343, 3234, 3240SBM-4343 Monitor Stand Compatible with SMT4343 3234 3240...Dettagli
22" FHD MonitorSMT-2212 22 FHD LED Monitor Frameless Design Support up to 1920 x 1080 resolution Contrast ratio 30001 Viewing Angle HV 178178 Response Time 65ms Video Input HDMI and VGA...Dettagli
Clarius Plus IR 850nm SmallSECL-IR850-DC-S Small Clarius PLUS InfraRed Illuminator 850nm max distances 132m low power consumption 15W Builtin photocell IR onoff Telemetry input for camera daynight remote switching angle 10 30 60 95 degree IP66...Dettagli
Clarius Plus IR 850nm MediumĀ SECL-IR850-DC-M Medium Clarius PLUS InfraRed Illuminator 850nm max distances 187m low power consumption 26W Builtin photocell IR onoff Telemetry input for camera daynight remote switching angle 10 30 60 95 degree IP66...Dettagli