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 ' AND I.SBGRP = '01052110 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '010 ' AND GRP = '01052 ' AND SBGRP = '01052110 ')) ORDER BY I.Seq OFFSET 105 ROWS FETCH NEXT 15 ROWS ONLY
Adattatore fissaggio per speed dome no DahuaPFA116 Dettagli
Corrosion-proof Power BoxPFA140A Box di gunzione anticorrosione...Dettagli
Heavy-duty Pole Mount BracketPFA153 Heavyduty Pole Mount Bracket...Dettagli
Staffa da parete per telecamere serie PTZ1APFB730W Dettagli
Base di giunzione NEMA4X per SD60230U-HNI-SLPFA120-SL Base di giunzione NEMA4X per SD60230UHNISL...Dettagli
Adattatore fissaggio per speed domePFA114 Dettagli
Corrosion-proof Heavy-duty Pole Mount BracketPFA153A Corrosionproof Heavyduty Pole Mount Bracket...Dettagli
Explosion-proof Camera Wall MountZAZ100W Explosionproof Camera Wall Mount...Dettagli
PoE SINGLE PORT MIDSPAN 15.4W AC INNPD-5001-POE Midspan singola porta 154W POE AC...Dettagli
PIPE 50CM FOR LTC 9543HAC-PIPE50 Tubo filettato di lunghezza 50cm per versione pendente soffitto...Dettagli
Hanging MountSBP-300HMW8 Aluminum Hanging Mount for PND9080R XND6080VRV XND8080RV White...Dettagli
Dome Back boxSBV-158GW Back Box for Outdoor Vandal Domes Compatible with PNV9080R XNV6080R XNV8080R XNV6120R XNV6085 XNVL6080R SNV5084RSNV6084R SNV7084R SNV8081R SNV8080 White...Dettagli
Staffa da parete per telecamere serie PTZ19PFB731W Dettagli
Flush Mount BracketNDA-FMT-DOME Accessorio per installazione ad incasso delle telecamere Flexidome IP 4000 e Flexidome IP 5000...Dettagli