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 900 ROWS FETCH NEXT 15 ROWS ONLY
DVR ACUSENSE 16CH/4CH DEEP LEARNING 3MP + 1*HDD 1TB VIDEOIDS-7216HQHI-M1/S DVR Hybrid 16 CH selfadaptive HDTVI 3MP AHD 4MPHD CVI 4MPIPCVBS accetta fino a 2 telecamere IP a 6MP fino a 24 Canali risoluzione analogica TVI fino a 3MP15Fps compressione video H265H265H264H264 uscita video HDMI VGA CVBS audio IN 1ch4ch con cavo ...Dettagli
IR Illuminator 940nm short rangeIIR-50940-SR Illuminatore serie 5000 Smal Range SR luce invisibile a 940nm con lenti di diffusione intercambiabili e autopulenti per le seguenti coperture 95m 10 57m 20 46m 30 28m 60 21m 80 14m 95 con intensit IR regolabile dal 10 al 100 dotato di fotocellula per...Dettagli
Adattatore da palo IPC-HFW8241X-3D + serie AIPFA154 Adattatore da palo IPCHFW8241X3D serie AI...Dettagli
HD+ Bullet 2MP, AHD/TVI/CVI/CVBS, lente 3.2-10mm 24VAC/12VDC, IP66/IK10HCO-6080 Wisenet HD Bullet camera da esterno 2MP Full HD1080p 30fps AHDTVICVICVBS lente varifocal motorizzata 31X 3210mm 120 dB true WDR Day Night ICR 24VAC12VDC IP66IK10...Dettagli
Minidome 2MP, AHD/TVI/CVI/CVBS, lente 3.2-10mm, 24VAC/12VDC, IP66/IK10HCV-6080 Wisenet HD Minidome Antivandalica da esterno da 2MP Full HD1080p 30fps AHDTVICVICVBS lente varifocale motorizzata 31X 3210mm 120 dB true WDR Day Night ICR 24VAC12VDC IP66IK10...Dettagli