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
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
INSTALLATION TOOL FOR TC9311PM3, LTC 9213 & LTC 9225 POLE MOUNT ADAPTERSTC9311PM3T Tendireggia per modello TC9311PM3 per collari LTC 9213 e LTC 9225...Dettagli
Adattatore supporto staffa per telecamere tipo D6SBP-300HM8 Adattatore supporto staffa per telecamere tipo D6 PND9080RPXND6080XND8080SCD6081PSND5083PSND5084PSND5084RPSND6083PSND6084PSND6084RP ...Dettagli