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 3915 ROWS FETCH NEXT 15 ROWS ONLY
Stainless steel anti-corrosive silver moon gray 180.6 mm × 150 mm × 74DS-1705ZJ-DM35-Y3(OS) Stainless steel anticorrosive silver moon gray 1806 mm 150 mm 74 mm 498 g...Dettagli
Anti-corrosion Silver moon grey SUS316L Stainless Steel 136 mm × 204.2 mDS-1697ZJ-X-AC(OS) Anticorrosion Silver moon grey SUS316L Stainless Steel 136 mm 2042 mm 353 mm 12 kg...Dettagli
anti-corrosive Stainless steel Silver moon gray 229 mm × 210 mm × 135 mmDS-1284ZJ-M-AC3(OS) anticorrosive Stainless steel Silver moon gray 229 mm 210 mm 135 mm 1981 g...Dettagli
anti-corrosion Stainless steel Silver moon grey 160 mm × 160 mm × 331 mmDS-1696ZJ-Y3(OS) anticorrosion Stainless steel Silver moon grey 160 mm 160 mm 331 mm 1892g...Dettagli
Anti-corrosion Silver moon grey SUS316L 126 mm × 222 mm × 328 mm 2307gDS-1697ZJ-Y3(OS) Anticorrosion Silver moon grey SUS316L 126 mm 222 mm 328 mm 2307g...Dettagli
anti-corrosion SUS316L Stainless steel Silver moon grey 136 mm × 136 mmDS-1696ZJ-X-AC(OS) anticorrosion SUS316L Stainless steel Silver moon grey 136 mm 136 mm 306 mm 11 kg...Dettagli
Anti-corrosion SUS316L Stainless steel Silver moon grey 170 mm × 170 mmDS-2701ZJ-AC(OS) Anticorrosion SUS316L Stainless steel Silver moon grey 170 mm 170 mm 10 mm 360 g...Dettagli
Anti-corrosion SUS316L Stainless steel Silver moon grey 90 mm × 55 mm ×DS-1706ZJ-Y-AC(OS) Anticorrosion SUS316L Stainless steel Silver moon grey 90 mm 55 mm 60 mm 270 g...Dettagli
Scatola di giunzione stagna per VKD-x50V e serie RPFA135 Scatola di giunzione stagna per serie R varifocale Dimensioni L90 x H32 x P0...Dettagli
TERMICA BULLET IP OTTICA FISSA 384 x 288FUNZIONI SMARTDS-2TD2137-35/P RISOLUZIONE E FRAME RATE 384x288 50fps SENSORE TERMICO Ossido di Vanadio senza raffreddamento DISTANZA PIXEL 17m RISPOSTA SPETTRALE 8m14m SENSIBILITA TERMICA NETD meno di 35 mk RANGE TEMPERATURA 20C 150C 8C OTTICA 35mm FUNZIONI SMART Line Crossing D...Dettagli
Switch a 5 porte PoE Fast EthernetDES-1005P 5Port 10100Mbps Fast Ethernet Desktop Switch with one PoE Port port 1 Compatible with 100BASETX IEEE 8023 8023u 8023az and IEEE 8023af 154W on Port 1 Connect Power Over Ethernet PoE devices and expand your Network Powered by DLink Green Technology...Dettagli
SPEED DOME IP AUTO-TRACKING 8" 42X WDR 120dB SMART 2MPDS-2DF8242IX-AEL RISOLUZIONE 2MP 1920x1080 FRAME RATE 25FPS 1920x1080 SENSORE 118 progressive scan CMOS SENSIBILTA Color 0002 Lux F15 AGC ON BW 00002 Lux F15 AGC ON 0 lux con IR Darkfighter DAYNIGHT ICR OTTICA 57 mm a 2394 mm Zoom Ottico 42X ottico 16x digitale COMP...Dettagli
PTZ thermal VGA-9mm 2MP 30x 30Hz, blackMIC-9502-Z30BVF9 MIC IP Starlight 9000i fusion colore nero 9mm VGA 30Hz telecamera HD 1080p60 213 Mega pixel da esterno DayNight zoom ottico 30x e zoom digitale 12x 360x sensore CMOS 128 scansione progressiva Wide Dynamic Range 120 dB IEC 62676 Part 5 sensibilit 000...Dettagli
PTZ thermal VGA-9mm 2MP 30x 9Hz, blackMIC-9502-Z30BVS9 MIC IP Starlight 9000i fusion colore nero 9mm VGA 9Hz telecamera HD 1080p60 213 Mega pixel da esterno DayNight zoom ottico 30x e zoom digitale 12x 360x sensore CMOS 128 scansione progressiva Wide Dynamic Range 120 dB IEC 62676 Part 5 sensibilit 0007...Dettagli