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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ')) ORDER BY I.Seq OFFSET 2040 ROWS FETCH NEXT 15 ROWS ONLY
Accoppiatore Duplex SC/SC, Multimodale OM2WPC-FA2-SC0201 Accoppiatore Duplex SCSC Multimodale OM2 Ferrula in zirconio ceramica Custodia in tecnopolimero Colore grigio...Dettagli
4MP IR BulletQNO-7012R Wisenet Q network IR da esterno antivandalo bullet camera 4MP 20fpsottica fissa da 28mm 110 triplo codec H265H264MJPEG con WiseStream Multiple streaming 120dB WDR True Day Night ICR IR da 20m Motion detection Tampering Defocus detection Hallway View...Dettagli
Soft ceiling support for in-ceilingNDA-8000-SP Supporto per soffitti sospesi Flexidome IP 8000i...Dettagli
Tinted BubbleNDA-8000-TBL Cupola oscurata Flexidome IP 8000i...Dettagli
Staffa di fissaggio a parete per telec. DOME (160.0mmx120.0mmx74.0mm)ACM254 Staffa di fissaggio a parete per telecamera DOME 1600mmx1200mmx740mm...Dettagli