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 765 ROWS FETCH NEXT 15 ROWS ONLY
Switch Unmanaged 16 porte 10/100Mbps Fast EthernetDES-1016D 16Port 10100Mbps Fast Ethernet Unmanaged Switch DesktopRackmount 16Port 100BaseTX AutoNegotiating NWAY 10100Mbps Switch HalfFullDuplex IEEE 8023x Flow Control AutoMDIMDIX For uplink Desktop Size Rackmount Kit for Installation in 19 Rack supplie...Dettagli
Switch Unmanaged 8 porte 10/100Mbps PoE Fast EthernetDES-1008PA 8Port 10100Mbps Fast Ethernet Unmanaged Desktop Switch with 4 PoE Ports 8port 10100 Desktop Switch with 4 PoE Ports 8Port 100BaseTX AutoNegotiating 10100Mbps IEEE 8023af standard compliant Includes 4 PoE ports Ports 14 Auto MDIMDIX PoE output u...Dettagli
10 Gigabit Stackable Managed Switch, 20x10G SFP+, 4 ComboDXS-3400-24SC 20Port 10G SFP and 4port 10GBASETSFP Combo Port Layer 3 Stackable Managed Switch Fast performance with up to 480 Gbps switching capacity 48K MAC address table Front Back airflow direction Two slots for ACDC hotswappable power modules support 11 power...Dettagli
Staffa di fissaggio a soffitto per CITY610PFB600W Dettagli
DINION BRACKET SILVER (5 PIECES) FOR DINIONXF CAMERASMTC-S1001 Staffa leggera per installazione in interno a muro o a soffitto per telecamere serie DinionXF colore argento Confezione da 5 pz...Dettagli