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 5055 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
Road AI 3MP Alta velocità Global Shutter CameraTNO-7180RLP Road AI 3MP Alta velocità Global Shutter Camera ...Dettagli
55'' FHD Videowall DisplayLH55VMBUBGBXEN 55 FHD LED Samsung Videowall Display 1080p 1920x1080 Super Thin Bezel Bezel to Bezel 35mm 500nit 169 aspect ratio Contrast ratio 40001 Response time 8ms DVID 2xHDMI VGA Display Port VESA Compatible 600x400mm...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