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 ' AND I.GRP = '01052 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '010 ' AND GRP = '01052 ')) ORDER BY I.Seq OFFSET 180 ROWS FETCH NEXT 15 ROWS ONLY
MIDSPAN, 95WNPD-9501A Midspan singola porta 95W High POE AC...Dettagli
Staffa per fissaggio a muro e paloMIKROTIKQMP Dettagli
PSU 100W, 100-240VAC In, 24VDC 4.2A OutPSU-IIR-100 Alimentatore da esterno IP67 100W 100240VAC In 24VDC 42A Out...Dettagli
Pinza per connettori BNCPINZABETA Pinza a compressione Compatibilit HD 4019EOC 4019 HD 8035EOC 8035 HD 14055EOC 14055...Dettagli
Scatola di giunzione in alluminio per telecamera (139.3mmx40.5mm)ACM206-B Scatola di giunzione in alluminio per telecamera 1393mmx405mm 1716mmx405mm con pressacavo...Dettagli
Ripiano x cabinet profondi 450mmPFC610-4D Dettagli
VARIO PSU - 24V, 20W, 1xO/P for 1x2 series VARIO illuminatorsPSU-VAR-20W-1 VARIO PSU 24V 20W 1xOP for 1x2 series VARIO illuminators Input Fuse Rating 1A Max Output 20W 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 Fast...Dettagli