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 45 ROWS FETCH NEXT 15 ROWS ONLY
Scatola stagna per staffa da parete/palo ,ACM202,ACM203 o PTZACM204 Scatola stagna per staffa da paretepalo ACM202 ACM203 o per speed dome...Dettagli
Pendant interface plate NDE-4/5000NDA-5030-PIP Piastra interfaccia pendente compatibile con serie FLEXIDOME 4000i e 5000i da esterno NDE4xxxNDE5xxx Tale piastra necessaria per linstallazione pendente in combinazione con gli accessori opzione 2 e 3 Elegante e robusto design antivandalo IK10 resis...Dettagli
Plastic/Aluminum Wall mount for outdoor domesSBP-137WMW1 PlasticAluminum Wall mount for outdoor domes Compatible with QNV6010R6020R6030R6070R7010R7020R7030R7080R XNP6040H XNV601060208020R8030R8040R HCV6080R6070R7010R7020R7030R7070R SNVL5083RL6083RSCV50825082R50835083R50856023R6083R White...Dettagli
MIDSPAN, 95WNPD-9501A Midspan singola porta 95W High POE AC...Dettagli
Attacco per speed dome SD3282D-GNPFA101 Adattatore per speed dome SD3282DGN con staffa PFB300S...Dettagli
Ripiano x cabinet profondi 450mmPFC610-4D Dettagli
Staffa pendente per PFA100/101/102PFB300C Supporto pendente per speed dome...Dettagli
Explosion-proof Camera Wall MountZAZ100W Explosionproof Camera Wall Mount...Dettagli
Scatola di giunzione in alluminio per telecamera (F161.0mmx38.0mm)ACM208 Scatola di giunzione in alluminio per telecamera F1610mmx380mm...Dettagli
DINION BRACKET GRAY (5 PIECES) FOR DINION CAMERASMTC-G1001 Staffa leggera per installazione in interno a muro o a soffitto per telecamere serie Dinion colore grigio Confezione da 5 pz...Dettagli