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 1230 ROWS FETCH NEXT 15 ROWS ONLY
Copertura esterna per XNV-6081Z/8081Z, XNV-6081/6081R/8081RSBC-180B Copertura esterna di colore nero da applicare su camere mod XNV6081Z8081Z XNV60816081R8081R...Dettagli
Copertura esterna per XND-6081VZ/8081VZ, XND-6081V/6081RV/8081RVSBC-160B Copertura esterna di colore nero da applicare su camere mod XND6081VZ8081VZ XND6081V6081RV8081RV...Dettagli
Staffa a muro per MiniDomeSBP-120WMW Staffa a muro per MiniDome tipo LND6070R QND6072R6082R8080R LND6010R6020R6030R QND6012R6022R6032R8010R8020R8030R QND6011602180118021...Dettagli
INSTALLATION BOX, compatibilita' con SBP-300WMW, SBP-300WMW1SBP-300NBW INSTALLATION BOX compatibilita con SBP300WMW SBP300WMW1...Dettagli
Copertura domeSBV-120WCW Copertura dome LNV6010R6020R6030R QNV6012R6022R6032R8010R8020R8030R...Dettagli
Base Speed Dome SFP -Fibra ottica,Supporta modalita' single e multi modeSBP-303HF Base Speed Dome SFP Fibra ottica Supporta modalita single e multi mode compatibile con XNP6550RH6371RH6320H6250RH6320RH QNP6230H...Dettagli
PoE SINGLE PORT MIDSPAN 15.4W AC INNPD-5001-POE Midspan singola porta 154W POE AC...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
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