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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ')) ORDER BY I.Seq OFFSET 1920 ROWS FETCH NEXT 15 ROWS ONLY
55 inch 4K LED monitorUML-554-90 Monitor professionale per sala controllo dimensione 55 risoluzione 4K 3840x2160 169 107 miliardi di colori retroilluminazione 50000 ore luminanza 450 cdmq contrasto 40001 angolo visione orizzontaleverticale 178 Fedele riproduzione dei colori antiimag...Dettagli
28-Port 10/100/1000Mbps Gigabit Stackable SmartPro PoE SwitchDGS-1510-28P 28Port 101001000Mbps Gigabit Stackable SmartPro PoE Switch including 2 SFP ports and 2 x 10G SFP ports 24 x 101001000Mbps AutoNegotiating Ports 2 x MiniGBIC SFP ports 2 x 10G SFP ports Physical Stacking up to 6 units per stack Stacking Bandwidth ...Dettagli
CORNICE INOX A PARETEDS-KD-ACW2/S Cornice Acciaio Inox 304 per applicazione a parete 2 moduli Contiene Cornice Inox e base di montaggio...Dettagli