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 945 ROWS FETCH NEXT 15 ROWS ONLY
Upgrade a Enterprise pacchetto da 8 licenzeDGF-UP-STEN1108-V7 Dettagli
Upgrade a Enterprise pacchetto da 16 licenzeDGF-UP-STEN1116-V7 Dettagli
Upgrade a Professional BaseDGF-UP-STPR1008-V7 Dettagli
Media Converter 1 x RJ45 1000BASE-T / 1 x fibra ottica 1000BASE-LX (SC)DMC-810SC 1000BaseT to 1000BaseLX Singlemode Media Converter with SC Fiber Connector UTP to Singlemode Fiber Media Converter SC Fiber connector Distance up to 10km Includes Power Supply for standalone use...Dettagli
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
Wall mount with junction boxDS-1273ZJ-160B Dettagli