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 4980 ROWS FETCH NEXT 15 ROWS ONLY
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
4K IR Outdoor Vandal FisheyeXNF-9013RV 4K IR Outdoor Vandal Fisheye ...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