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 1710 ROWS FETCH NEXT 15 ROWS ONLY
HDD Specifico per Videosorveglianza 3,5" SATA Seagate Serie SkyHawk 2 TBSKYHAWK2TB HDD Specifico per Videosorveglianza 35 SATA Seagate Serie SkyHawk 2 TB...Dettagli
Staffa a parete per Camere serie PNM Multisensor - Lunghezza 417 mmSBP-390WM2 Staffa a parete per Camere serie PNM Multisensor Lunghezza 417 mm...Dettagli
Montaggio a pareteDS-2200ZJ-WA-140 Staffa da perete in alluminio acciaio inossidabile colore bianco dim 1821 mm 140 mm 233 mm Peso 8935 g ...Dettagli
Htr, Blr, SS,230VAC/35W, AC->DCUHO-HBGS-51 Custodia in alluminio grigio ad apertura laterale con viti antimanomissione vetrino ad alta risoluzione termostatato binario interno rimovibile in grado di alloggiare una telecamera fino a 91 x 81 x 262 mm custodia termostata e ventilata con range di...Dettagli
8-port 10/100Mbps Fast Ethernet Unmanaged Switch - Metal HousingDES-108 8port 10100Mbps Fast Ethernet Unmanaged Switch Metal Housing 8Port 100BaseTX AutoNegotiating NWAY 10100Mbps Switch HalfFullDuplex IEEE 8023x Flow Control AutoMDIMDIX For uplink Expansion via MDI Uplink Port Small Portable in Size Metal Housi...Dettagli