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 ' AND I.GRP = '01050 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '010 ' AND GRP = '01050 ')) ORDER BY I.Seq OFFSET 105 ROWS FETCH NEXT 15 ROWS ONLY
4MP Wisenet HD+ Indoor DomeHCD-7070RA Minidome da interno 4MP WiseNet HD CMOS PS QHD 2560 x 1440 25fps over coax BNC AHD CVBS per installazione DWDR Varifocal 32 10mm manuale 30m IR range ICR distmax 500m motion detec Coax Ctrl Dual Voltage 12 Vdc 24 Vac...Dettagli
4MP Wisenet HD+ Indoor DomeHCD-7010RA Minidome da interno 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 12 Vdc...Dettagli
4MP Wisenet HD+ BoxHCB-7000A Box camera 4MP WiseNet HD CMOS PS QHD 2560 x 1440 25fps over coax BNC AHD CVBS per installazione DWDR CCS mount ICR distmax 500m motion detec Coax Ctrl Dual Voltage 12 Vdc 24 Vac...Dettagli