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 = '010 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '010 ')) ORDER BY I.Seq OFFSET 1605 ROWS FETCH NEXT 15 ROWS ONLY
Cavo F/UTP cat 5e, LSZH verde, termoretratto da 100mBNFU5E-C-SF100 Cavo FUTP cat 5e LSZH verde termoretratto da 100m...Dettagli
4MP Wisenet HD+ Outdoor DomeHCV-7010RA Minidome da esterno 4MP WiseNet HD CMOS PS QHD 2560 x 1440 25fps over coax BNC AHD CVBS per installazione DWDR ottica fissa 28mm 20m IR range ICR distmax 500m motion detec Coax Ctrl IP66 IK1012 Vdc...Dettagli
Flexidome AN 4000, 960H, TDN, 4.3x, da internoVDN-276-10 Flexidome AN 4000 da interno Ultra High Resolution CCD 13 960H 720 TVL True DayNight Digital WDR obiettivo varifocale 2812 mm sensibilit 012007 Lux F12 50 IRE 2DNR BLC e HLC 4 zone di privacy mirror regolazione triassiale menu OSD alimentazione 12VDC...Dettagli
Bullet CVI 5MP 3.6mm WDR LED F-col. Mic 12V 16:9HAC-HFW1509TLM-A-LED- Bullet CVI 5MP 36mm WDR LED Fcol Mic 12V 169...Dettagli