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 75 ROWS FETCH NEXT 15 ROWS ONLY
21.5?? Indoor Public View MonitorLFH22-LAI200 215’’ Indoor Public View Monitor...Dettagli
43'' Wall Mounted Digital SignageLDH43-SAI200 43 Wall Mounted Digital Signage...Dettagli
55'' Wall Mounted Digital SignageLDH55-SAI200 55 Wall Mounted Digital Signage...Dettagli
49'' Wall Mounted Digital SignageLDH49-SAI200 49 Wall Mounted Digital Signage...Dettagli
Monitor 75" per meetboardIFP-7502 Monitor 75 per meetboard...Dettagli
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
43" Tecnologia: LED Backlight Risoluzione: Full HD 1920 x 1080 Input HDMDS-D5043FL-B 43 Tecnologia LED Backlight Risoluzione Full HD 1920 x 1080 Input HDMIVGADVIBNCUSB Output BNCAudio Angolo di visione 178178 3D Comb Filter 3D Noise Reduction 3D Deinterlace Compatibilita con staffe VESA Case Metallico...Dettagli
50" Tecnologia: LED Backlight Risoluzione: 4k 3840 x 2160 Input 2*HDMI/VDS-D5050UC 50 Tecnologia LED Backlight Risoluzione 4k 3840 x 2160 Input 2HDMIVGALANRS232 USBAV input Output Audio SPDIF Angolo di visione 178178 3D Comb Filter 3D Noise Reduction 3D Deinterlace Compatibilita con staffe VESA Case Plastico...Dettagli
55" Tecnologia: LED Backlight Risoluzione: 4k 3840 x 2160 Input HDMI/VGADS-D5055UC 55 Tecnologia LED Backlight Risoluzione 4k 3840 x 2160 Input HDMIVGALANRS232 USBAudio Output Audio Angolo di visione 178178 3D Comb Filter 3D Noise Reduction 3D Deinterlace Compatibilita con staffe VESA Case Plastico...Dettagli