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 2295 ROWS FETCH NEXT 15 ROWS ONLY
Stripper per rivestimento da 125/900 micron PZ 1JIC-375 Stripper per rivestimento da 125900 micron PZ 1...Dettagli
Staffa collo d'ocaSBP-300WM Staffa da muro a collo doca per Speed Dome serie SCP SNP versione outdoor con custodia modello SHP3700H SHP3701H per Vandal Dome serie SCVSNV con relativa piastra adattatrice mod SBP300HM1 SBP300HM2 SBP300HM3 colore avorio...Dettagli
PORTE: 24. POE: 24: IEEE 802.3af, IEEE802.3at. TIPOLOGIA: 10/100/1000. TDS-3E0526P-E/M PORTE 24 POE 24 IEEE 8023af IEEE8023at TIPOLOGIA 101001000 TIPO POE 30 W BUDGET TOTALE 225 W UPLINK 2 TIPOLOGIA UPLINK SFP TIPO L2 UNMANAGED CASE METALLICO BANDA 52 GBPS TEMPERATURA FUNZIONAMENTO 10 C a 55 C ALIMENTAZIONE 100240 VAC...Dettagli
24 SFP ports Layer 3 Stackable Managed Gigabit Switch with 2 x 10GBASE-TDGS-3130-30S/SI 24 SFP ports Layer 3 Stackable Managed Gigabit Switch with 2 x 10GBASET ports and 4 x SFP ports Managed Gigabit Ethernet Switch 24 x SFP ports 2 x 10GBASET ports 4 x 10G SFP ports 4 Stacking ports stacking cost 1 80Gbps stacking up to 9 unitsst...Dettagli