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 3225 ROWS FETCH NEXT 15 ROWS ONLY
4K 30X AI IR Wiper PTZXNP-C9303RW 8MP 30x AI PTZ Camera with builtin wiper...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