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 90 ROWS FETCH NEXT 15 ROWS ONLY
65'' Outdoor Wall-mounted Digital SignageLDH65-EAO200H 65 Outdoor Wallmounted Digital Signage...Dettagli
55'' Outdoor Wall-mounted Digital SignageLDH55-EAO200H 55 Outdoor Wallmounted Digital Signage...Dettagli
49'' Indoor Wall-mounted Digital SignageLDH49-TAI200 49 Indoor Wallmounted Digital Signage...Dettagli
43'' Outdoor Floor-standing Digital SignageLDV43-EAO200 43 Outdoor Floorstanding Digital Signage...Dettagli
43'' Outdoor Wall-mounted Digital SignageLDH43-EAO200H 43 Outdoor Wallmounted Digital Signage...Dettagli
55'' Outdoor Floor-standing Digital SignageLDV55-EAO200 55 Outdoor Floorstanding Digital Signage...Dettagli
Staffa montaggio a Tavolo per DS-K1T671TM-3XF e DS-K1TA70MI-T, PESO 2,2kDS-DM0701BL Staffa montaggio a Tavolo per DSK1T671TM3XF e DSK1TA70MIT PESO 22kg DIMENSIONI 192mm195mm353 mm...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