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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ')) ORDER BY I.Seq OFFSET 810 ROWS FETCH NEXT 15 ROWS ONLY
Wireless Controller 2000 32 AP Service Pack - Additional 32 access pointDWC-2000-AP32-LIC Wireless Controller 2000 32 AP Service Pack Additional 32 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-C-3YSBD 3 Year Same Business Day 9 x 5 x 4 Swap...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
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
EIA 19 IN RACK FOR CNFE2MC, 120-230VACC1-IN Kit per installazione a rack di media converter CNFE2MC max 14 moduli alimentazione 120230VAC...Dettagli
Staffa da parete per custodiaPFB601W Staffa di fissaggio su piano orizzontale per CITY610...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
Staffa di fissaggio a soffitto per CITY610PFB600W Dettagli
MEDIA CONVERTER BOARD WITH SFP SOCKETFE2MC-B Dettagli
MEDIA CONVERTER W/SFP SOCKET, 120-230VACCNFE2MC/IN Media converter SFP a ethernet 10100 Mbits acquistare modulo SFP separatamente alimentazione 120230VAC...Dettagli
Staffa da parete per custodia con passaggio caviPFB604W Staffa di fissaggio a muro con passaggio cavi per CITY610...Dettagli
GROUND LOOP ISOLATION TRANSFORMER.TC8235GIT Trasformatore video di isolamento 11...Dettagli