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 1215 ROWS FETCH NEXT 15 ROWS ONLY
Copertura esterna per XND-6081VZ/8081VZ, XND-6081V/6081RV/8081RVSBC-160B Copertura esterna di colore nero da applicare su camere mod XND6081VZ8081VZ XND6081V6081RV8081RV...Dettagli
Cavo Video HD 75Ohm C4 5mm Bobina 500mHD8035-WR500 Cavo coassiale per videosorveglianza Norme di riferimento CEI EN 50117 Formazione solo coax Diametro esterno mm500 Trasmissione segnale video analogico m 800 Trasmissione segnale video HDSDIm160 Bobina 500m...Dettagli
IR Illuminator 940nm short rangeIIR-50940-SR Illuminatore serie 5000 Smal Range SR luce invisibile a 940nm con lenti di diffusione intercambiabili e autopulenti per le seguenti coperture 95m 10 57m 20 46m 30 28m 60 21m 80 14m 95 con intensit IR regolabile dal 10 al 100 dotato di fotocellula per...Dettagli
Custodia controsoffitto per telecamere Dome e PTZSHP-1680FW Custodia controsoffitto per telecamere Dome e PTZ Compatibile con XNP6120H XNV61206120R6085 XND60856085V Bianca...Dettagli
Staffa da muro per telecamera TNU-6320SBU-500WM Staffa da muro per telecamera TNU6320...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