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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ' AND GRP = '01157 ')) ORDER BY I.Seq OFFSET 2565 ROWS FETCH NEXT 15 ROWS ONLY
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
Attacco di fissaggio per telecamera (F134.1mmx83.5mm)ACM243 Attacco di fissaggio per telecamera F1341mmx835mm...Dettagli