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 405 ROWS FETCH NEXT 15 ROWS ONLY
Pannello prese rack 19"PR-RCK-PWR Pannello prese rack 19...Dettagli
IR Illuminator 940nm medium range IP PoENIR-50940-MRP Illuminatore IP serie 5000 Medium Range MR luce invisibile a 940nm con lenti di diffusione intercambiabili e autopulenti per le seguenti coperture 135m 10 80m 20 65m 30 40m 60 30m 80 20m 95 accesso tramite interfaccia web intensit IR regolabile dal 1...Dettagli
Piastra adattatore per montaggio dell'alimentatore al paloPBC-PSU-ADAP Piastra adattatore per conosentire il montaggio dellalimentatore al palo...Dettagli