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 ' AND I.GRP = '01157 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ' AND GRP = '01157 ')) ORDER BY I.Seq OFFSET 2430 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
Wall Mount BracketSBP-300BW1 Staffa montaggio Alluminio Bianca peso 700g154lb compatibile con TNO7180RLP...Dettagli
Back BoxSBV-140BW Back Box alluminio bianca peso 390g086lb compatibile con QNVC8083RC9083R QNVC8011RC8012C9011R QND601121 QND801121 QND6012R22R72R82R QND7012R22R82R QNE8011R21R...Dettagli
ControllerSPC-2001 Controller 3Axis 12 bottoni USB Joystick Controller per NVRs WAVE SSM e Wisenet Viewer...Dettagli
32" UHD MonitorSMT-3240 32 UHD LED Monitor 4K UHD 3840 x 2160 HDMI DP 169 aspect ratio Contrast ratio 1000 1 Response time 14ms Panel life 30000 hrs Audio connector VESA DPM Compatible 100x100mm 400x200mm...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