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 = '010 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '010 ')) ORDER BY I.Seq OFFSET 345 ROWS FETCH NEXT 15 ROWS ONLY
VARIO PSU - 24V, 100W, 2xO/P for 2x8 series VARIO illuminatorsPSU-VAR-100W-2 VARIO PSU 24V 100W 2xOP for 2x8 series VARIO illuminators Input Fuse Rating 25A Max Output 100W Output Fuse Rating 5A Dedicated PSU to power all VARIO and VARIO IP Illuminators Powers multiple illuminators from one PSU CAT5 connection for VARIO IP F...Dettagli
VARIO i4 lenti di ricambio - 80°H x 30°VVAR-I4-LENS-8030 VARIO i4 lenti di ricambio 80H x 30V...Dettagli
VARIO i8 lenti di ricambio - 120°H x 50°VVAR-I8-LENS-8030 VARIO i8 lenti di ricambio 120H x 50V...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
VARIO2 hy4-1 standard packVAR2-HY4-1 VARIO2 hy41 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 hy16-1 standard packVAR2-HY16-1 VARIO2 hy161 standard pack 10x10 35x10 and 60x25 angles included 24V DC black 850nm WhiteLightCombined InfraRed WhiteLight Illumination Switch easily and automatically between IR WL PLATINUM Elite twincore SMT LED Technology Hotspot Reduction Tech...Dettagli
"Adattatore BNC a ""T"""NV-BNCT Adattatore BNC a T...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
ROOF MOUNTLTC9230/01 Adattatore per installazione su tetto piano compatibile con NDAURMT...Dettagli
VARIO PSU - 24V, 150W, 3xO/P for 3x8 series VARIO illuminatorsPSU-VAR-150W-3 VARIO PSU 24V 150W 3xOP for 3x8 series VARIO illuminators Input Fuse Rating 25A Max Output 150W Output Fuse Rating 5A Dedicated PSU to power all VARIO and VARIO IP Illuminators Powers multiple illuminators from one PSU CAT5 connection for VARIO IP F...Dettagli