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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ' AND GRP = '01157 ')) ORDER BY I.Seq OFFSET 420 ROWS FETCH NEXT 15 ROWS ONLY
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
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, 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
Supporto da tavolo per DV-300DV-300BRK Supporto da tavolo per DV300...Dettagli
Ingresso linea di riserva Ups 10-100KVAEXD-LR10 Ingresso linea di riserva Ups 10100KVA...Dettagli
Kit collegamento Ups 10-100KVA in parallelo da prev. in ogni UpsEXD-KP10 Kit collegamento Ups 10100KVA in parallelo da prevedere per ogni Ups...Dettagli
Carica batterie maggiorato da 20a x Ups 30-80KVAEXD-BC960 Carica batterie maggiorato da 20a x Ups 3080KVA...Dettagli
Carica batterie maggiorato da 10a x Ups 10-20KVAEXD-BC480 Carica batterie maggiorato da 10a x Ups 1020KVA...Dettagli