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
Cavo Allarme schermato LSZH Blu 2x0.22+2x0.50+T+S Termoretratto BB500mSIC-EL22-WR500 Cavo per impianto antintrusione con guaina in LSZH Norme di riferimento CEI UNEL 36762 Formazione 2x0222x050TS mmq Diametro esterno mm 420 Materiale Guaina Duraflam LSZH BB500m...Dettagli
24-Port 10/100/1000Mbps Desktop, Gigabit, PoE + 2GE Combo SwitchDGS-1026MP 24Port 101001000Mbps Desktop Gigabit PoE 2GE Combo Switch 2 x Combo 101001000BASETSFP Port 19U 1U Rackmount Chassis Total PoE Power Budget 370W PoE up to 30W per 101001000 Port Auto MDIMDIX crossover for all ports 52Gbps Switching Capacity Ra...Dettagli
VARIO2 i4 PoE, incluso standard pack lenti con angoli 10°x10°, 35°x10° eVAR2-POE-I4-1 VARIO2 i4 PoE incluso standard pack lenti con angoli 10x10 35x10 e 60x25 PoE nero 850nm...Dettagli
Cavo F/UTP cat 5e, LSZH blu, Bobina da 305mBNFU5E-E-UW305 Cavo FUTP cat 5e LSZH blu Bobina da 305m...Dettagli
10/100 CASE METALLICO - SOHODS-3E0105-O Switch 5 10100M RJ45 ports Desktop Steel Case Unmanaged Switch...Dettagli
10/100 CASE METALLICO - SOHODS-3E0108-O Switch 8 10100M RJ45 ports Desktop Steel Case Unmanaged Switch...Dettagli