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 105 ROWS FETCH NEXT 15 ROWS ONLY
55? FHD High Brightness LCD Display Unit (1.8mm)DHL550UDH-EG 55” FHD High Brightness LCD Display Unit 18mm...Dettagli
55" FHD High Brightness LCD Display Unit (3.5mm)DHL550UCM-ES 55 FHD High Brightness LCD Display Unit 35mm...Dettagli
49" FHD Stand Brightness LCD Display Unit (3.5mm)DHL490UCM-EG 49 FHD Stand Brightness LCD Display Unit 35mm...Dettagli
55" FHD High Brightness LCD Display Unit (3.5mm)DHL550UCH-ES 55 FHD High Brightness LCD Display Unit 35mm...Dettagli
UML-275-90 Monitor LED 4K, 27"UML-275-90 Monitor per sala controllo dimensione 27 risoluzione 4K 3840x2160 169 167 milioni di colori retroilluminazione 30000 ore luminanza 200 cdmc contrasto 10001 Fedele riproduzione dei colori antiimage retention ingressi HDMI DP Prevedere supporti accesso...Dettagli
Monitor LED 19", Risoluz. 1280x1024. Ingressi: VGA, HDMI e 2xBNC, DVI.SX-19G Monitor professionale LED da 19 risoluzione 1280x1024pixelluminosit 250cdm2 Ingressi VGA HDMI e 2xBNC DVI DisplayPort Ingresso audio 2 altoparlanti integrati Montaggio a parete standard VESA...Dettagli
Monitor 27", cabinet plastico, in VGA+HDMI+AUDIOLM27-B200 Monitor 27 cabinet plastico in VGAHDMIAUDIO...Dettagli
Monitor 23.8", cabinet plastico, in VGA+HDMI+AUDIOLM24-B200 Monitor 238 cabinet plastico in VGAHDMIAUDIO...Dettagli
43'' UHD LED MonitorLM43-F410 43 UHD LED Monitor...Dettagli
50'' UHD LED MonitorLM50-F410 50 UHD LED Monitor...Dettagli