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 1050 ROWS FETCH NEXT 15 ROWS ONLY
Wireless AC Dual Band Unified Service Router - 4 x 10/100/1000Mbps LANDSR-1000AC Wireless AC Dual Band Unified Service Router 4 x 101001000Mbps LAN ports 2 x 101001000Mbps WAN ports Second WAN port can be configured as DMZ port 130Mbps plaintext firewall throughput 70Mbps 3DESAES VPN throughput Concurrent session 100000 VPN...Dettagli
AUTODOME 4000 HD INCEIL TINTED BUBBLENEZ-A4-BUB-CTIP Cupola oscurata per AUTODOME IP 4000i incasso...Dettagli
Micro Adattatore USB Wireless N 150DWA-121 Wireless N 150 Micro USB Adapter Compatible with IEEE 80211b80211g80211n 24GHz Standard High performance antenna design with ultra slim profile Autosenses Adjusts Speed to conditions for Maximum Performance IEEE 8021x and WPA2 WPA Legacy WEP I...Dettagli
Alimentatore 55Vdc 110w. Da usare con NV-EC-04NV-PS55-110W Alimentatore 55Vdc 110w Da usare con NVEC04...Dettagli
Adattatore da USB 2.0 a Ethernet/Fast Ethernet 10/100MbpsDUB-E100 USB 20 10100Mbps Fast Ethernet Adapter 5 Metre USB TypeA receptacle to TypeB receptacle cable Highspeed USB 20 Certified Backward compatible with USB 11 devices...Dettagli
4 Port Superspeed USB 3.0 HubDUB-1340 4 Port Superspeed USB 30 Hub Up to 48Gbps data rate Connect up to 127 devices by cascading multiple hubs 4 downstream USB TypeA female ports 1 upstream USB Type MicroB female port Standards USB 30 201110 OHCI EHCI Power External Power adapter 5...Dettagli