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 2100 ROWS FETCH NEXT 15 ROWS ONLY
Stainless steel anti-corrosive silver moon gray 180.6 mm × 150 mm × 74DS-1705ZJ-DM35-Y3(OS) Stainless steel anticorrosive silver moon gray 1806 mm 150 mm 74 mm 498 g...Dettagli
Anti-corrosion SUS316L Stainless steel Silver moon grey 90 mm × 55 mm ×DS-1706ZJ-Y-AC(OS) Anticorrosion SUS316L Stainless steel Silver moon grey 90 mm 55 mm 60 mm 270 g...Dettagli
Anti-corrosion Silver moon grey SUS316L Stainless Steel 136 mm × 204.2 mDS-1697ZJ-X-AC(OS) Anticorrosion Silver moon grey SUS316L Stainless Steel 136 mm 2042 mm 353 mm 12 kg...Dettagli
anti-corrosive Stainless Steel Silver moon gray 228 mm × 140 mm × 412.5DS-1701ZJ-AC1(OS) anticorrosive Stainless Steel Silver moon gray 228 mm 140 mm 4125 mm 3800 g...Dettagli
anti-corrosive Stainless steel Silver moon gray 229 mm × 210 mm × 135 mmDS-1284ZJ-M-AC3(OS) anticorrosive Stainless steel Silver moon gray 229 mm 210 mm 135 mm 1981 g...Dettagli
Scatola di giunzione stagna per VKD-x50V e serie RPFA135 Scatola di giunzione stagna per serie R varifocale Dimensioni L90 x H32 x P0...Dettagli
Cavo U/UTP cat 5e, LSZH verde, Bobina da 305mBNUU5E-B-UW305 Cavo UUTP cat 5e LSZH verde Bobina da 305m...Dettagli
Switch a 5 porte PoE Fast EthernetDES-1005P 5Port 10100Mbps Fast Ethernet Desktop Switch with one PoE Port port 1 Compatible with 100BASETX IEEE 8023 8023u 8023az and IEEE 8023af 154W on Port 1 Connect Power Over Ethernet PoE devices and expand your Network Powered by DLink Green Technology...Dettagli
Staffa pendente per attacco di fissaggio telecam.(F128.8mmx767.00mm)ACM244 Staffa pendente per attacco di fissaggio telecamera F1288mmx76700mm...Dettagli
Adattatore Back box,Compatibile con QNV-6012R/6022R/6032RSBV-120GW Adattatore Back box Compatibile con QNV6012R6022R6032R QNV8010R8020R8030R Bianco...Dettagli
IP54 protection kit, 3 pcsNDA-8001-IP Kit di protezione IP54 per telecamere FLEXIDOME IP 8000i da interno 3 pezzi...Dettagli
White skin coverSBC-165W Cover bianca per TID600R...Dettagli
Tilt MountSBS-165TM Staffa montaggio per Intercom TID600R...Dettagli
Flush Mount with coverSHS-165F Accessorio per montaggio ad incasso per Intercom TID600R due colori inclusi grigio scuro e bianco...Dettagli