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 1500 ROWS FETCH NEXT 15 ROWS ONLY
Wireless AC1900 Wave2 Nuclias Access Point (With 1 Year License) - UptoDBA-2520P Wireless AC1900 Wave2 Nuclias Access Point With 1 Year License Upto 1900Mbps Wireless LAN Indoor Access Point Supports 1x 101001000 Ethernet port Compatible with IEEE 80211abgnac Wave2 with MUMIMO and bandwidth 160MHz Concurrent 80211abgnac Wave2...Dettagli
Wireless AC1200 Dual-Band Gigabit VDSL/ADSL Modem Router with Outer Wi-FDSL-3788 Wireless AC1200 DualBand Gigabit VDSLADSL Modem Router with Outer WiFi Antennas Builtin ADSL2VDSL2 modem for connecting to your highspeed broadband Internet connection Four Gigabit Ethernet LAN ports to connect wired devices for highspeed online ac...Dettagli
Flush mountSHD-1198FW Polycarbonate Inceiling Flush Mount for Dome cameras Compatible with QND6070R6082R7080R8080R HCD6070R6080R7070R7080R White...Dettagli
Flush mountSHD-1408FW Polycarbonate Inceiling Flush Mount for Dome cameras Compatible with PND9080R XND60806080R6080RV6080V8080R8080V8080RVL6080RL6080RVL6080V HCV6070R60806080R7070R7080R White...Dettagli