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 = '01153 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ' AND GRP = '01153 ')) ORDER BY I.Seq OFFSET 300 ROWS FETCH NEXT 15 ROWS ONLY
Bullet IP AI Full-color TiOC 5 MP 2.7~13.5 mm IR/LED micIPC-HFW3549T1-ZAS-PV Telecamera bullet IP AI WizSense TiOC 20 Fullcolor con Smart Dual Illuminator e deterrenza attiva da internoesterno IP67 sensore CMOS progressivo 128 risoluzione 5 MP a 20fps AI coding H265 ICR ottica motorizzata 27135 mm ƒ10 luminosit 0003 lux ƒ12 p...Dettagli
"Bullet IP 4K con sensore 1/2.5"" Sony Starvis Progressive CMOS, H.265 / H"IPT4704G3MZ+ Bullet IP 4K con sensore 125 Sony Starvis Progressive CMOS H265 H264 obiettivo autofocus 27135 mm WDR 120dB BLC 3D NR ROI audio allarmi reset Oggetto abbandonatorimosso ingressouscita area attraversamento linea conteggio attraversamenti riconoscimen...Dettagli
Bullet IP 2MP, ottica 5.3-64mm, IR 150 m, WDR, Starlight, 12Vdc/PoEIPC-HFW5241E-Z12E Bullet IP 2MP ottica 5364mm IR 150 m WDR Starlight 12VdcPoE...Dettagli
8MP AI IR Panoramic Outdoor Vandal DomePNM-C9022RV 8MP AI IR Panoramic Outdoor Vandal Dome ...Dettagli