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 2100 ROWS FETCH NEXT 15 ROWS ONLY
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
32" Full HD LED MonitorLH32DCE2LGC/EN 32 LED Monitor 1080p 1920x1080 250nit 169 aspect ratio Contrast ratio 50001 Response time 8ms HDMI HDCP22 VGA...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
Monitor LCD 10" case metallicoLM10-H100 Monitor LCD 10 case metallico...Dettagli
Monitor professionale LED 46", FullHD, VGA, HDMI e DisplayPort, CVBSPN-46D2 Monitor professionale LED 46 FullHD VGA HDMI e DisplayPort CVBS Montaggio a parete standard VESA Alimentazione 220Vac...Dettagli
VARIO2 IP PoE hy4 Network Illuminator, 3 angle options included, 24V DCVAR2-IPPOE-HY4-1 VARIO2 IP PoE hy4 Network Illuminator 3 angle options included 24V DC or PoE power input black 850nm WhiteLight Dedicated IP Lighting for Network Cameras Combined InfraRed WhiteLight Illumination PLATINUM Elite SMT LED Technology Integrated Web Int...Dettagli
Ripetitore PoE. 1-ch input 100M, 2-ch output 100M. Portata 250 m in ExteDS-1H34-0102P Ripetitore PoE 1ch input 100M 2ch output 100M Portata 250 m in Extend Mode Trasmissione a cascata fino a 500 m...Dettagli