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 1830 ROWS FETCH NEXT 15 ROWS ONLY
60W Ultra slim design with 17.5mm (1SU) width DC output voltage adjustabDIS-H60-24 60W Ultra slim design with 175mm 1SU width DC output voltage adjustab...Dettagli
Accoppiatore Duplex LC/LC, Multimodale OM2WPC-FA2-LC0201 Accoppiatore Duplex LCLC Multimodale OM2 Ferrula in zirconio ceramica Custodia in tecnopolimero Colore grigio...Dettagli
IP Fisheye Camera 6MP, ICR, 360°, CMOS, IR 15m, PoE, 12V, IP66, IK10XNF-8010RV Wisenet X con DSP Wisenet 5 network da esterno antivandalo fisheye sensore da 6MP CMOS 2048x2048 30fpsottica fissa da 16mm 192 triplo codec H265H264MJPEG con WiseStream II technology 120dB WDR USB port per una facile installazione advanced video cla...Dettagli
12TB HDD DIVAR IP all-in-oneDIP-AIO12-HDD 12TB HDD DIVAR IP allinone...Dettagli
8TB HDD DIVAR IP all-in-oneDIP-AIO8-HDD 8TB HDD DIVAR IP allinone...Dettagli
Cavo F/UTP cat 6, LSZH blu, termoretratto da 100mBNFU6-E-SF100 Cavo FUTP cat 6 LSZH blu termoretratto da 100m...Dettagli
Cavo U/UTP cat 6A, LSZH verde, Bobina da 1000mBNUU6A-C-WR1000 Cavo UUTP cat 6A LSZH verde Bobina da 1000m...Dettagli
Cavo U/UTP cat 6A, LSZH verde, Bobina da 500mBNUU6A-C-WR500 Cavo UUTP cat 6A LSZH verde Bobina da 500m...Dettagli
Cavo per sistemi IP e PoE ad alte prestazioni,Armato,termoretratto 100 mHDIP3220ARM-SF100 Cavo per sistemi IP e PoE ad alte prestazioni Armato termoretratto 100 m...Dettagli
Cavo per sistemi IP e PoE ad alte prestazioni, Armato, Bobina 1000 mHDIP3220ARM-WR1000 Cavo per sistemi IP e PoE ad alte prestazioni Armato Bobina 1000 m...Dettagli