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 managed Stackable 20 porte 10/100/1000 PoE + 4 combo + 4 SFP+DGS-3630-28PC/SI 20port GE PoE 370W Layer 3 Stackable Managed Gigabit Switch including 4port Combo 4port Combo 4 10GE SFP 80Gbps physical stacking bandwidth Switching Capacity 128 Gbps Packet Forwarding Rate 9524 Mpps Up to 9 units per stack with other DGS3630 se...Dettagli
Staffa da soffitto per custodiaPFB603W Staffa di fissaggio a muro con passaggio cavi per CITY600...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
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