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 315 ROWS FETCH NEXT 15 ROWS ONLY
Dispositivo di pulizia per connettori FC, SC e ST PZ 1FCC-250 Dispositivo di pulizia per connettori FC SC e ST PZ 1...Dettagli
Pannello cieco 2U, Nero RAL9005WPN-ABP-2-B Pannello cieco in metallo standard 19 da 2 unit per chiudere gli spazi non utilizzati nellarmadio Lutilizzo dei pannelli ciechi forza laria fresca a passare attraverso gli apparati attivi grazie allunit di ventilazione se installata nellarmadio Color...Dettagli
DINION BRACKET GRAY (5 PIECES) FOR DINION CAMERASMTC-G1001 Staffa leggera per installazione in interno a muro o a soffitto per telecamere serie Dinion colore grigio Confezione da 5 pz...Dettagli
Battery pack rack 2u 72Vdc 9Ah x Ups 3KVABTP-SWO7209/RK Dettagli
VARIO PSU - 24V, 20W, 1xO/P for 1x2 series VARIO illuminatorsPSU-VAR-20W-1 VARIO PSU 24V 20W 1xOP for 1x2 series VARIO illuminators Input Fuse Rating 1A Max Output 20W Output Fuse Rating 3A Dedicated PSU to power all VARIO and VARIO IP Illuminators Powers multiple illuminators from one PSU CAT5 connection for VARIO IP Fast...Dettagli
24-Port 10/100/1000Mbps Copper Gigabit Ethernet Switch Desktop/RackmountDGS-1024D 24Port 101001000Mbps Copper Gigabit Ethernet Switch DesktopRackmount Unmanaged Copper Gigabit Ethernet Switch 24 x 101001000Mbps AutoNegotiating Ports AutoNegotiation of MDIII MDIX Cross Over for Easy Expansion HalfFullDuplex IEEE 8023x Flow Co...Dettagli
Pannello cieco 1U, Nero RAL9005WPN-ABP-1-B Pannello cieco in metallo standard 19 da 1 unit per chiudere gli spazi non utilizzati nellarmadio Lutilizzo dei pannelli ciechi forza laria fresca a passare attraverso gli apparati attivi grazie allunit di ventilazione se installata nellarmadio Color...Dettagli
Wireless Controller 2000 128 AP Service Pack - Additional 128 access poiDWC-2000-AP128-LIC Wireless Controller 2000 128 AP Service Pack Additional 128 access points support for DWC2000 Compatible access point DWL2600AP DWL3600AP DWL6600AP DWL8600AP DWL8610AP...Dettagli
3 Year Same Business Day ( 9 x 5 x 4) SwapDAS-B-3YSBD 3 Year Same Business Day 9 x 5 x 4 Swap...Dettagli