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 = '010 ' AND I.GRP = '01052 ' AND I.SBGRP = '01052106 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '010 ' AND GRP = '01052 ' AND SBGRP = '01052106 ')) ORDER BY I.Seq OFFSET 30 ROWS FETCH NEXT 15 ROWS ONLY
MONITOR MOUNT, WALL, BASIC, FOR LCD MONITORS 20" AND SMALLER, EXCEPT MONUMM-LW-20B Accessorio per linstallazione a muro di monitor serie UML fino a 26...Dettagli
LCD / LED Rack Mount Bracket, support the monitors from 8 inch to 19 incUMM-LCDUB-RM Accessorio per installazione a Rack di Monitor LCD serie UML fino a 19...Dettagli
Monitor 27", cabinet plastico, in VGA+HDMI+AUDIOLM27-B200 Monitor 27 cabinet plastico in VGAHDMIAUDIO...Dettagli
Monitor 27" con VGA/HDMI/Audio e staffaLM27-F211 Monitor 27 con VGAHDMIAudio e staffa...Dettagli
24" Tecnologia: LED Backlight Risoluzione: Full-HD 1920 x 1080 Input HDMDS-D5024FC 24 Tecnologia LED Backlight Risoluzione FullHD 1920 x 1080 Input HDMIVGABNCAUDIO Output BNC AUDIO Speaker Integrati Angolo di visione 170180 3D Comb Filter 3D Noise Reduction 3D Deinterlace Compatibilit con staffe VESA Case Plastico...Dettagli
Monitor professionale LED 17", risoluzione SXGAX-17E-B Monitor professionale LED da 17 risoluzione 1280x1024pixelluminosit 250cdm2 Ingressi VGA DVI HDMI e DisplayPort Ingresso audio 2 altoparlanti integrati Montaggio a parete standard VESA Alimentazione 220Vac...Dettagli