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 ' AND I.SBGRP = '01157120 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ' AND GRP = '01157 ' AND SBGRP = '01157120 ')) ORDER BY I.Seq OFFSET 15 ROWS FETCH NEXT 15 ROWS ONLY
VARIO i4 lenti di ricambio - 80°H x 30°VVAR-I4-LENS-8030 VARIO i4 lenti di ricambio 80H x 30V...Dettagli
VARIO i16 lenti di ricambio - 80°H x 30°VVAR-I16-LENS-8030 VARIO i16 lenti di ricambio 80H x 30V...Dettagli
VARIO i16 lenti di ricambio - 120°H x 50°VVAR-I16-LENS-12050 VARIO i16 lenti di ricambio 120H x 50V...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
VARIO2 Extreme i8-1 standard packVAR2-XTR-I8-1 VARIO2 Extreme i81 standard pack 10x10 35x10 and 60x25 angles included 850nm 24 48V DCMax Distance 350m 1148ft Beam Shape Elliptical with HRT Hot Spot Reduction Technology Beam Angle System VARIO interchangeable lens system Consumption 46W LED Type ...Dettagli
VARIO2 Extreme i16-1 standard packVAR2-XTR-I16-1 VARIO2 Extreme i161 standard pack 10x10 35x10 and 60x25 angles included 850nm 24 48V DC Max Distance 500m 1640ft Beam Shape Elliptical with HRT Hot Spot Reduction Technology Beam Angle System VARIO interchangeable lens system Consumption 100W LED Ty...Dettagli
VARIO w4 lenti di ricambio - 120°H x 50°VVAR-W4-LENS-12050 VARIO w4 lenti di ricambio 120H x 50V...Dettagli
VARIO2 hy8-1 standard packVAR2-HY8-1 VARIO2 hy81 standard pack 10x10 35x10 and 60x25 angles included 24V DC black 850nm WhiteLight Combined InfraRed WhiteLight Illumination Switch easily and automatically between IR WL PLATINUM Elite SMT LED Technology Hotspot Reduction Technology HR...Dettagli
VARIO2 hy6-1 standard packVAR2-HY6-1 VARIO2 hy61 standard pack 10x10 35x10 and 60x25 angles included 24V DC black 850nm WhiteLight Combined InfraRed WhiteLight Illumination Switch easily and automatically between IR WL PLATINUM Elite SMT LED Technology Hotspot Reduction Technology HR...Dettagli