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 645 ROWS FETCH NEXT 15 ROWS ONLY
Wall Mount with junction boxDS-1602ZJ-BOX-CORNER Dettagli
Access Point Wireless N300DAP-2020 Wireless N300 Access Point Compatible with IEEE 80211b80211g80211n 24GHz Standard Open source linux based software for Linux developers and enthusiasts 1 10100Mbps Fast Ethernet Interface for connecting to Wired Network 64128Bit Wired Equivalent ...Dettagli
Dual-Band PoE Access Point Wireless AC1300 Wave2DAP-2610 Wireless AC1300 Wave2 DualBand PoE Access Point Up to 1300Mbps Wireless LAN Indoor Access Point Compatible with IEEE 80211abgnac Wave2 Concurrent 80211abgnac Wave2 Wireless Connectivity Plenum rated housing Supports IEEE 80211 anac and bgn wirel...Dettagli
RJ45 Screw Terminal Adaptor (sold in pairs)NV-RJ45A RJ45 Screw Terminal Adaptor sold in pairs...Dettagli
Power Supp,220VAC 50Hz, 24VAC 50VA OutUPA-2450-50 Alimentatore 230VAC in 24VAC 50VA Out...Dettagli
Localization (Keyboard) Russia - RussianMHW-AWLCK-RU Tastiera Russia da prevedere per ogni server e workstation...Dettagli
Localization (Keyboard) Sweden - SwedishMHW-AWLCK-SE Tastiera Svezia da prevedere per ogni server e workstation...Dettagli
Localization (Keyboard) Germany - GermanMHW-AWLCK-DE Tastiera Germania da prevedere per ogni server e workstation...Dettagli
Localization (Keyboard) United Kingdom - UK EnglishMHW-AWLCK-UK Tastiera UK da prevedere per ogni server e workstation...Dettagli
Microfono capacitico amnidirezionale, alta sensibilità, copertura 70mq,DS-2FP2020 Microfono capacitico amnidirezionale alta sensibilit copertura 70mq impedenza di uscita 600ohm pre amplificato...Dettagli
Localization (Keyboard) Netherlands - DutchMHW-AWLCK-NL Tastiera Olanda da prevedere per ogni server e workstation...Dettagli