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 2505 ROWS FETCH NEXT 15 ROWS ONLY
HDD SPECIFICO PER VIDEOSORVEGLIANZA 2TBST2000VX0172TB HDD SPECIFICO PER VIDEOSORVEGLIANZA 2TB ...Dettagli
24W Ultra slim design with 17.5mm (1SU) width DC output voltage adjustaDIS-H30-24 24W Ultra slim design with 175mm 1SU width DC output voltage adjusta...Dettagli
Cavo Patch Cat.6 U-UTP 5.0m RossoWPC-PAT-6U050R Cavo patch Cat6 a coppie twistate non schermato 4 x 2 x AWG267 a 100 Ohm 2 connettori RJ45 Cappuccio pressofuso e serracavo Protezione antipiega ed antistrappo Lunghezza 50m Colore rosso...Dettagli