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 1095 ROWS FETCH NEXT 15 ROWS ONLY
VARIO i4 lenti di ricambio - 120°H x 50°VVAR-I4-LENS-12050 VARIO i4 lenti di ricambio 120H x 50V...Dettagli
Cavo Patch Cat.6 U-UTP 2.0m GialloWPC-PAT-6U020Y Cavo patch Cat6 a coppie twistate non schermato 4 x 2 x AWG267 a 100 Ohm 2 connettori RJ45 Cappuccio pressofuso e serracavo Protezione antipiega ed antistrappo Lunghezza 20m Colore giallo...Dettagli
5 Port 10/100M bps Desktop Switch - IEEE 802.3 10BASE-T - IEEE 802.3uGO-SW-5E 5 Port 10100M bps Desktop Switch IEEE 8023 10BASET IEEE 8023u 100BASETX compliance Support AutoNegotiation for each port Support HalfFullDuplex operations at 10100Mbps Support back pressure at HalfDuplex operation IEEE 8023x Flow Control suppor...Dettagli
5 Port Unmanaged Switch with 4 x 10/100/1000BaseT(X) ports (4 PoE) & 1 xDIS-100G-5PSW 5 Port Unmanaged Switch with 4 x 101001000BaseTX ports 4 PoE 1 x 1001000BaseSFP ports...Dettagli
Accoppiatore Duplex SC/SC, Multimodale OM2WPC-FA2-SC0201 Accoppiatore Duplex SCSC Multimodale OM2 Ferrula in zirconio ceramica Custodia in tecnopolimero Colore grigio...Dettagli