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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ')) ORDER BY I.Seq OFFSET 990 ROWS FETCH NEXT 15 ROWS ONLY
Cavo Patch Cat.5E F/UTP 3.0m BluWPC-PAT-5F030B Cavo patch Cat5e schermato A coppie twistate 4 x 2 x AWG267 a 100 Ohm 2 connettori RJ45 schermati 50 gold plated Cappuccio pressofuso e serracavo Protezione antipiega ed antistrappo Lunghezza 30m Colore blu...Dettagli
ROOF MOUNTLTC9230/01 Adattatore per installazione su tetto piano compatibile con NDAURMT...Dettagli
MOUNT, CEILING-J, FEED-THRU, FOR 938x SERIES, & 948x SERIES HOUSINGS.LTC9219/01 Staffa Jmount da soffitto per custodie seri UHOUHI passaggio cavi allinterno...Dettagli
MOUNT, FEED-THRU, 7-INCH, FOR 938x SERIES, & 948x SERIES HOUSINGS.LTC9215/00S Staffa da muro corta per custodie serie UHOUHI con passaggio cavi allinterno...Dettagli
Supporto da tavolo per DV-300DV-300BRK Supporto da tavolo per DV300...Dettagli
Piastra di Montaggio VUB per 1x alimentatori VARIOVUB-PLATE-PSU Dettagli
Piastra di Montaggio VUB per 3x illuminatori serie VARIO 8VUB-PLATE-3X8 Dettagli
Piastra di Montaggio VUB per 3x illuminatori serie VARIO 4VUB-PLATE-3X4 Dettagli
Piastra di Montaggio VUB per 3x illuminatori serie VARIO 2VUB-PLATE-3X2 Dettagli
Piastra di Montaggio VUB per 1x illuminatori serie VARIO 16VUB-PLATE-1X16 Dettagli
VARIO2 Extreme w8-1 standard packVAR2-XTR-W8-1 VARIO2 Extreme w81 standard pack 10x10 35x10 and 60x25 angles included WhiteLight 24 48V DC Max Distance 180m 591ft Input 24V ACDC Beam Shape Elliptical with HRT Hot Spot Reduction Technology Beam Angle System VARIO interchangeable lens system Consu...Dettagli
VARIO2 Extreme w16-1 standard packVAR2-XTR-W16-1 VARIO2 Extreme w161 standard pack 10x10 35x10 and 60x25 angles included WhiteLight 24 48V DC Max Distance 250m 820ft Input 24V ACDC Beam Shape Elliptical with HRT Hot Spot Reduction Technology Beam Angle System VARIO interchangeable lens system Cons...Dettagli