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 2130 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
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
Remote Head Camera Ceiling HousingSBL-101C Polycarbonate Remote Head Camera Ceiling Housing white RAL9003 Compatible with SLAT2480 SLAT2480A SLAT4680 SLAT4680A...Dettagli