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 600 ROWS FETCH NEXT 15 ROWS ONLY
156W Modular Redundant Power SupplyDPS-500A 156W Modular Redundant Power Supply for DGS300010TC DGS312048TC DGS342028TC DGS342028SC DGS342052T DGS362028TC DGS362028SC DGS362052T...Dettagli
1-Port Gigabit 30W PoE Splitter - 10/100/1000BASE-TDPE-301GS 1Port Gigabit 30W PoE Splitter 101001000BASET HalfFullDuplex 80233u3ab compliant 8023at and 8023af Supports up to 30 watts to powered device Dip Switch to setting output power 5VDC9VDC12VDC...Dettagli
Alimentatore, 16 uscite da 24Vac - 8APR816-24 Alimentatore 16 uscite da 24Vac 8A...Dettagli
Alimentatore fissaggio a rack, 1 uscite da 24VacPR801 Alimentatore fissaggio a rack 1 uscite da 24Vac...Dettagli
AUTODOME 5000 HD INCEIL TINTED BUBBLENEZ-A5-BUB-CTIP Cupola oscurata per AUTODOME IP 5000i incasso...Dettagli