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)) ORDER BY I.Seq OFFSET 11490 ROWS FETCH NEXT 15 ROWS ONLY
Impaq SC rivelatore di shock MeMS con contatto magnetico colore marroneC1IMPAQSCMA Dettagli
Staffa pendente per attacco di fissaggio telecam.(F128.8mmx767.00mm)ACM244 Staffa pendente per attacco di fissaggio telecamera F1288mmx76700mm...Dettagli
Switch unmanaged 8 porte Gigabit 4 PoE 60WPFS3008-8GT-60-V2 Dettagli
Switch unmanaged 8 porte Gigabit PoE 96WPFS3008-8GT-96-V2 Dettagli