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 435 ROWS FETCH NEXT 15 ROWS ONLY
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
VARIO2 IP PoE i8 Illuminatore di rete, incluso standard pack lentiVAR2-IPPOE-I8-1 VARIO2 IP PoE i8 Illuminatore di rete incluso standard pack lenti con angoli 10x10 35x10 e 60x25 alimentazione 24Vcc o PoE nero 850nm...Dettagli
VARIO2 IP PoE i6 Illuminatore di rete, incluso standard pack lentiVAR2-IPPOE-I6-1 VARIO2 IP PoE i6 Illuminatore di rete incluso standard pack lenti con angoli 10x10 35x10 e 60x25 alimentazione 24Vcc o PoE nero 850nm...Dettagli
VARIO2 IP PoE i4 Illuminatore di rete, incluso standard pack lentiVAR2-IPPOE-I4-1 VARIO2 IP PoE i4 Illuminatore di rete incluso standard pack lenti con angoli 10x10 35x10 e 60x25 alimentazione 24Vcc o PoE nero 850nm...Dettagli
VARIO2 IP PoE hy8 Network Illuminator, 3 angle options included, 24V DCVAR2-IPPOE-HY8-1 VARIO2 IP PoE hy8 Network Illuminator 3 angle options included 24V DC or PoE power input black 850nm WhiteLight Dedicated IP Lighting for Network Cameras Combined InfraRed WhiteLight Illumination PLATINUM Elite SMT LED Technology Integrated Web Int...Dettagli
VARIO2 IP PoE hy6 Network Illuminator, 3 angle options included, 24V DCVAR2-IPPOE-HY6-1 VARIO2 IP PoE hy6 Network Illuminator 3 angle options included 24V DC or PoE power input black 850nm WhiteLightDedicated IP Lighting for Network Cameras Combined InfraRed WhiteLight Illumination PLATINUM Elite SMT LED Technology Integrated Web Inte...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
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