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 120 ROWS FETCH NEXT 15 ROWS ONLY
46" FHD Stand Brightness LCD Display Unit (3.5mm)DHL460UCM-ES 46 FHD Stand Brightness LCD Display Unit 35mm...Dettagli
46" FHD Stand Brightness LCD Display Unit (5.5mm)DHL460UTS-E 46 FHD Stand Brightness LCD Display Unit 55mm...Dettagli
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
55" FHD High Brightness LCD Display Unit (3.5mm)DHL550UCH-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
UML-275-90 Monitor LED 4K, 27UML-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
10" IP PVM Monitor (Black)SMT-1030PV 10 IP PVM Monitor Black...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
Staffa con snodo per monitorPMK-01 Staffa con snodo per monitor design funzionale montaggio a parete inclinazione orizzontale 180 rispetto al posizionamento centrale inclinazione verticale 180 rispetto al posizionamento centrale rotazione display 270 Compatibile con standard VES...Dettagli
Monitor 23.8", cabinet plastico, in VGA+HDMI+AUDIOLM24-B200 Monitor 238 cabinet plastico in VGAHDMIAUDIO...Dettagli
43'' Floor Standing Digital SignageLDV43-SAI200C 43 Floor Standing Digital Signage...Dettagli
55'' Outdoor Floor-standing Digital SignageLDV55-EAO200AHD 55 Outdoor Floorstanding Digital Signage...Dettagli
49'' Floor Standing Touch Digital SignageLDV49-VAI200T 49 Floor Standing Touch Digital Signage...Dettagli
65? UHD High Brightness LCD Display Unit (3.5mm)LS650KCM-EF 65” UHD High Brightness LCD Display Unit 35mm...Dettagli