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 3150 ROWS FETCH NEXT 15 ROWS ONLY
10" IP PVM Monitor (Black)SMT-1030PV 10 IP PVM Monitor Black...Dettagli
Alimentatore 55Vdc 60w. Da usare con NV-EC-04 e NV-FLXLKNV-PS55-60W Alimentatore 55Vdc 60w Da usare con NVEC04 e NVFLXLK...Dettagli
Cavo U/UTP cat 5e, LSZH verde, Bobina da 500mBNUU5E-B-WR500 Cavo UUTP cat 5e LSZH verde Bobina da 500m...Dettagli
FISHEYE D-WDR H.264+ SMART 12MPDS-2CD63C2F-IVS(2) FishEye 12MP 4000x3072pixel a 20fps di tipo DayNight con filtro IR meccanico illuminatori IR integrati sino a 15mt sensore CMOS a scansione progressiva 117” sensibilit Colori 001 Lux F12 BN 004 lux F24 AGC ON DWDR 3DDNR BLC ottica fissa 2mm Algoritm...Dettagli
8-port 10/100Mbps Fast Ethernet Unmanaged Switch - Metal HousingDES-108 8port 10100Mbps Fast Ethernet Unmanaged Switch Metal Housing 8Port 100BaseTX AutoNegotiating NWAY 10100Mbps Switch HalfFullDuplex IEEE 8023x Flow Control AutoMDIMDIX For uplink Expansion via MDI Uplink Port Small Portable in Size Metal Housi...Dettagli