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 1740 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
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
Custodia da esternoDS-4718HZ-K Supporto in lega di alluminio bianco Compresa di ventola e Riscaldatore 24 Vca 12 Vcc IP66 174x153x550 mm Peso 2500 g...Dettagli