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 30 ROWS FETCH NEXT 15 ROWS ONLY
VARIO2 i4-3 Adaptive Illumination a triplo pannello, incluso standard paVAR2-I4-3 VARIO2 i43 Adaptive Illumination a triplo pannello incluso standard pack lenti con angoli 10x10 35x10 e 60x25 1224V cacc nero 850nm...Dettagli
VARIO2 i4-2 Adaptive Illumination a doppio pannello, incluso standard paVAR2-I4-2 VARIO2 i42 Adaptive Illumination a doppio pannello incluso standard pack lenti con angoli 10x10 35x10 e 60x25 1224V cacc nero 850nm...Dettagli
VARIO2 w8-3 Adaptive Illumination a triplo pannello, incluso standard paVAR2-W8-3 VARIO2 w83 Adaptive Illumination a triplo pannello incluso standard pack lenti con angoli 10x10 35x10 e 60x25 1224V cacc argento Luce Visibile...Dettagli
VARIO2 w8-2 Adaptive Illumination a doppio pannello, incluso standard paVAR2-W8-2 VARIO2 w82 Adaptive Illumination a doppio pannello incluso standard pack lenti con angoli 10x10 35x10 e 60x25 1224V cacc argento Luce Visibile...Dettagli
VARIO2 w8-1 incluso standard pack lenti con angoli 10°x10°, 35°x10° e 60VAR2-W8-1 VARIO2 w81 incluso standard pack lenti con angoli 10x10 35x10 e 60x25 1224V cacc argento Luce Visibile...Dettagli
VARIO2 w4-3 Adaptive Illumination a triplo pannello, incluso standard paVAR2-W4-3 VARIO2 w43 Adaptive Illumination a triplo pannello incluso standard pack lenti con angoli 10x10 35x10 e 60x25 1224V cacc argento Luce Visibile...Dettagli
VARIO2 w4-2 Adaptive Illumination a doppio pannello, incluso standard paVAR2-W4-2 VARIO2 w42 Adaptive Illumination a doppio pannello incluso standard pack lenti con angoli 10x10 35x10 e 60x25 1224V cacc argento Luce Visibile...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