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 690 ROWS FETCH NEXT 15 ROWS ONLY
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 i8 lenti di ricambio - 120°H x 50°VVAR-I8-LENS-8030 VARIO i8 lenti di ricambio 120H x 50V...Dettagli
Staffa da Parete - Staffa a LWB1 Staffa da Parete Staffa a L...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
Supporto da tavolo per DV-300DV-300BRK Supporto da tavolo per DV300...Dettagli
VARIO PSU - 24V, 50W, 2xO/P for 2x4 series VARIO illuminatorsPSU-VAR-50W-2 VARIO PSU 24V 50W 2xOP for 2x4 series VARIO illuminators Input Fuse Rating 25A Max Output 50W Output Fuse Rating 3A Dedicated PSU to power all VARIO and VARIO IP Illuminators Powers multiple illuminators from one PSU CAT5 connection for VARIO IP Fas...Dettagli
IR Illuminator 940nm medium rangeIIR-50940-MR Illuminatore serie 5000 Medium Range MR luce invisibile a 940nm con lenti di diffusione intercambiabili e autopulenti per le seguenti coperture 135m 10 80m 20 65m 30 40m 60 30m 80 20m 95 con intensit IR regolabile dal 10 al 100 dotato di fotocellula ...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
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