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 1215 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
55? FHD Stand Brightness LCD Display Unit (0.88mm)LS550UEM-EG 55” FHD Stand Brightness LCD Display Unit 088mm...Dettagli
65? UHD High Brightness LCD Display Unit (3.5mm)LS650KCH-ES 65” UHD High Brightness LCD Display Unit 35mm...Dettagli
Cavo U/UTP cat 5e, LSZH verde, termoretratto da 100mBNUU5E-B-SF100 Cavo UUTP cat 5e LSZH verde termoretratto da 100m...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
Cavo U/UTP cat 6A LSZH blu, Bobina da 1000mBNUU6A-E-WR1000 Cavo UUTP cat 6A LSZH blu Bobina da 1000m...Dettagli