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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '010 ')) ORDER BY I.Seq OFFSET 1260 ROWS FETCH NEXT 15 ROWS ONLY
55? FHD High Brightness LCD Display Unit (0.88mm)LS550UEH-EG 55” FHD High Brightness LCD Display Unit 088mm...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