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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ')) ORDER BY I.Seq OFFSET 4035 ROWS FETCH NEXT 15 ROWS ONLY
BET-UTP5EFR-SC200 Cavo dati resistente al fuocoUTP5EFR-SC200 UTP5EFRSC200 DATAFIRE CAVI DATI FUTP5E RESISTENTI AL FUOCO PH120 Norme di riferimento CEI EN 50289416 PH120 CEI UNEL 36762 UNI 97952013 Scatola 200m...Dettagli
Presa Keystone Jack RJ45 colore Nero per U/UTP 5EKJUU5E(N) Presa Keystone Jack RJ45 colore Nero per UUTP 5E...Dettagli
Presa Keystone Jack RJ45 colore Nero per U/UTP 6KJUU6(N) Presa Keystone Jack RJ45 colore Nero per UUTP 6...Dettagli
Presa Keystone Jack RJ45 colore Nero per U/UTP 6AKJUU6A(N) Presa Keystone Jack RJ45 colore Nero per UUTP 6A...Dettagli
Fixed dome 2MP HDR 3.4-10.2mm NDV-5702-A FLEXIDOME starlight 5100i interno 1080p60 Intelligent Video Analytics Pro Building Pack licenze aggiuntive opzionali IVA Pro Perimeter Pack e IVA Pro Traffic Pack True DayNight sensore CMOS 128 progressive scan gamma dinamica 144 dB HDR 105 dB misura...Dettagli
MONITOR PROFESSIONALE LED 65", RISOLUZIONE 4KQM-65 MONITOR PROFESSIONALE LED 65 RISOLUZIONE 4K...Dettagli
Cavo Patch Cat.5E U-UTP 1.0m VerdeWPC-PAT-5U010G Cavo patch Cat5e A coppie twistate non schermate 4 x 2 x AWG267 a 100 Ohm 2 connettori RJ45 50 gold plated Cappuccio pressofuso e serracavo Protezione antipiega ed antistrappo Lunghezza 10m Colore verde...Dettagli
Attacco di fissaggio per telecamera (F166.0mmx83.5mm)ACM249 Attacco di fissaggio per telecamera F1660mmx835mm...Dettagli
Base staffa pareteSBP-300B Base per montaggio da parete...Dettagli
Distributore video 8in/16out HDTVI/AHD/HDCVI/CVBSCD816HD Distributore video 8in16out HDTVIAHDHDCVICVBS...Dettagli
Back BoxSBO-147BA Cover Aluminum Top cover – Polycarbonate Back Box White RAL9003 Compatible with XNOC6083RVC7083RVC8083RVC9083RV...Dettagli
Weather CapSBV-161WCW Polycarbonate Weather Cap WhiteRAL9003 Compatible with XNVC6083RC7083RC8083RC9083R...Dettagli