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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ')) ORDER BY I.Seq OFFSET 1050 ROWS FETCH NEXT 15 ROWS ONLY
12V 3A PSU Accessory Black (Interchangeable Euro/ UK plug)PSM-12V-38-B 12V 3A PSU Accessory Black Interchangeable Euro UK plug SMPS Wall Mount Removable Type AC in 100V240V ES Level Vl DC output 12V3A DC cable length11M UL2468 DC plug 38x135x95mm Itype Suitable for the following DIR880L DIR868L DSL3590L DIR860L DSL3580L...Dettagli
Sistema di centralizzazione mobile embeddizatoDSS4004M Dettagli
Capsula microfonica alta fedeltà HAP100 Capsula microfonica alta fedelt...Dettagli