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 ' AND I.SBGRP = '01157122 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ' AND GRP = '01157 ' AND SBGRP = '01157122 ')) ORDER BY I.Seq OFFSET 180 ROWS FETCH NEXT 15 ROWS ONLY
Staffa da muro per speed dome SD8APFB306W Dettagli
Staffa di supporto per box cameraPFB120WS Dettagli
Adattatore Backbox, compatibilita' con XNV-6011SBV-116B Adattatore Backbox compatibilita con XNV6011...Dettagli
PoE SINGLE PORT MIDSPAN 15.4W AC INNPD-5001-POE Midspan singola porta 154W POE AC...Dettagli
Plastic/Aluminum Wall mount for outdoor domesSBP-137WMW1 PlasticAluminum Wall mount for outdoor domes Compatible with QNV6010R6020R6030R6070R7010R7020R7030R7080R XNP6040H XNV601060208020R8030R8040R HCV6080R6070R7010R7020R7030R7070R SNVL5083RL6083RSCV50825082R50835083R50856023R6083R White...Dettagli
Plastic/Aluminum Wall mount for outdoor domesSBP-137WM1 PlasticAluminum Wall mount for outdoor domes Compatible with QNV6010R6020R6030R6070R7010R7020R7030R7080R XNP6040H XNV601060208020R8030R8040R HCV6080R6070R7010R7020R7030R7070R SNVL5083RL6083RSCV50825082R50835083R50856023R6083R Ivory...Dettagli
Staffa da muro per telecamera TNU-6320SBU-500WM Staffa da muro per telecamera TNU6320...Dettagli
1-METER SERVICE/MONITOR CABLE FOR FLEXIDOME XT SERIES.S1460 Cavo coassiale per telecamera FlexiDome e Dinion IP 40005000...Dettagli
Scatola di giunzione stagna per VKD-x70PTPFA123 Scatola di giunzione stagna per VKDx70PT Dimensioni L134 x H134 x P51...Dettagli
PIPE 50CM FOR LTC 9543HAC-PIPE50 Tubo filettato di lunghezza 50cm per versione pendente soffitto...Dettagli
Hanging MountSBP-276HMW Adattatore supporto staffa in alluminio per telecamera multisensore PNM9084QZ Bianco...Dettagli
Staffa a muro per MiniDome tipo D5SBP-120WM Staffa a muro per MiniDome tipo D5 QND7080R 7030R7020R7010R6070R QND6030R6020R6010R XND60106020 SNDL6083RL6014RL6013R L6013 L6012L5083RL5013 SCD6083R6023R60215083R 508350825080...Dettagli
Base di giunzione per Dome antivandaloPFA13B Base di giunzione per dome antivandalo Dimensioni L122 x H335 x P0...Dettagli