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 5385 ROWS FETCH NEXT 15 ROWS ONLY
Camera IP Dome STARLIGHT IP67,IK10, 4Mp,H265+,mot.2.7~13.5mm, IR e Led bi.50mNDV417SMADI Camera IP Dome STARLIGHT risoluzione 4Mp con 25Fps antivandalo IK10 da internoesterno IP67 con analisi video integrata con sensore CMOS progressivo 129 H265H264 ICR meccanico ottica motorizzata 27135mm con regolazione su 3 assi luminosit 0005Lux 14 0...Dettagli
Camera IP PAN/TILT 4G,IP66,dopp.ott.3MP zoom ibr., pann.solare incorpor.NPT3024GSPDET Camera IP PANTILT 4G IP66 doppia ottica con zoom ibrido pannello solare incorporato e batteria al litio da 65Wh DETERRENZA ATTIVA risoluzione 3Mp3Mp con 15Fps con sensore CMOS progressivo 128 H265H264 ICR meccanico ottica fissa e ottica PANTILT da 36...Dettagli