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 ' AND I.SBGRP = '01157119 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ' AND GRP = '01157 ' AND SBGRP = '01157119 ')) ORDER BY I.Seq OFFSET 135 ROWS FETCH NEXT 15 ROWS ONLY
49'' Floor Standing Digital SignageLDV49-SAI200C 49 Floor Standing Digital Signage...Dettagli
32 inch FHD LED monitorUML-324-90 Monitor professionale per sala controllo dimensione 32 risoluzione 1080p 1920x1080 169 167 milioni di colori retroilluminazione 50000 ore luminanza 500 cdmq contrasto 30001 angolo visione orizzontaleverticale 178 Fedele riproduzione dei colori antiim...Dettagli
Monitor professionale LED 19", risoluzione SXGA,X-19E-B Monitor professionale LED da 19 risoluzione 1280x1024pixelluminosit 250cdm2 Ingressi VGA DVI HDMI e DisplayPort Ingresso audio 2 altoparlanti integrati Montaggio a parete standard VESA Alimentazione 220Vac...Dettagli
Monitor professionale a LED 22" touch a 10 punti, risoluzione Full HDTM-22 Monitor professionale a LED da 22 touch a 10 punti risoluzione Full HD 1920x1080pixels Elevato contrasto 10001 luminosit 220cdm2 Tecnologia Projected Capacitive Touch capacit touch a 10 punti compatibile con Microsoft Windows 7 e 8 Ingressi VGA HDMI ...Dettagli