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 2145 ROWS FETCH NEXT 15 ROWS ONLY
Remote Head Camera Ceiling HousingSBL-101C Polycarbonate Remote Head Camera Ceiling Housing white RAL9003 Compatible with SLAT2480 SLAT2480A SLAT4680 SLAT4680A...Dettagli
Weather CapSBV-253WCW Polycarbonate Weather Cap White RAL9003 Compatible with PNM9031RVPNM9022V...Dettagli
Skin cover in silverSBC-170C Skin cover in silver poly carbonate material weight 50g011lb compatible with TNV8011C...Dettagli
Skin cover in whiteSBC-170CW Skin cover in white poly carbonate material weight 50g011lb compatible with TNV8011C...Dettagli
Skin cover in blackSBC-170CB Skin cover in black poly carbonate material weight 50g011lb compatible with TNV8011C...Dettagli
Flush mountSHD-1600FPW Polycarbonate Inceiling Flush Mount for Dome cameras Compatible with PNV9080R XNF9010RV8010R8010RV XND60856085V XNV608561206120R8080R6080R6080 XNVL6080RL6080 White RAL9003...Dettagli
Hanging MountSBP-276HMW Adattatore supporto staffa in alluminio per telecamera multisensore PNM9084QZ Bianco...Dettagli
SWITCH 10/100 HI-POE DIN + UPLINK GIGABIT SFPDS-3T0306HP-E/HS Porte 4 Porta PoE 1 IEEE 8023afatbt Porte da 2 a 4 IEEE 8023afat Tipologia 10100 Poe Budget Porta 1 60 W da 2 a 4 30W Budget Totale 60 W Distanza PoE Extended Mode 300Mt Porta 3 Porta 4 Uplink 2 Tipologia Uplink SFP Tipo L2 Unmanaged Case Metallico ...Dettagli
Cavo Video HD 75Ohm doppia guaina HD8035 LSZH Bobina 500mHD8035DG-WR500 Cavo coassiale per videosorveglianza con doppia guaina Norme di riferimento CEI EN 50117 Formazione solo coax Diametro esterno mm630 Trasmissione segnale video analogico m 800 Trasmissione segnale video HDSDIm160 Bobina 500m...Dettagli
Capsula microfonica alta fedeltà HAP120 Capsula microfonica alta fedelt...Dettagli
SMART MANAGED GIGABITDS-3E1508-EI(O-STD)V2 Porte 8 Tipologia 101001000 Tipo L2 Smart Managed Case Metallico Banda 16 Gbps Funzionalit Network Topology Health Monitor Real time alarm push Link Aggregation Flow Control Client Management Port Statistics Temperatura Funzionamento 10 C A 55 C Alim...Dettagli