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 1170 ROWS FETCH NEXT 15 ROWS ONLY
Explosion Proof Stainless Steel Bullet Camera with Built-in Wiper and IRTNO-6322ER Explosion Proof Stainless Steel Bullet Camera with Built-in Wiper and IR ...Dettagli
Explosion Proof Stainless Steel Positioning Bullet Camera with Built-inTNU-6322E Explosion Proof Stainless Steel Positioning Bullet Camera with Built-in ...Dettagli
Explosion Proof Stainless Steel Positioning Bullet Camera with Built-inTNU-6322ER Explosion Proof Stainless Steel Positioning Bullet Camera with Built-in ...Dettagli
2MP IR Vandal DomeQNV-6022R1 2MP IR Vandal Dome ...Dettagli
15MP IR Panoramic Outdoor Vandal DomePNM-9031RV 15MP IR Panoramic Outdoor Vandal Dome ...Dettagli
Speed dome IP 2Mp 20x, IP66, ICR, IK10SD50225U-HNI Speed dome IP Star Light da esternointerno IP67 IK10 termoventilata sensore CMOS progressivo 128” STARVIS™ risoluzione 2Mp con 50Fps compressione H265H264MJPEG ottica motorizzata 48120mm zoom ottico 25X 16X digitale luminosit 0005Lux ƒ16 porta LAN 1...Dettagli
FLEXIDOME IP 8000i indoor 2MP HDR 3-9mm PTRZNDV-8502-R FLEXIDOME IP starlight 8000i interno 1080p60 Intelligent Video Analytics VCA double resolution True DayNight sensore CMOS 128 progressive scan gamma dinamica 146 dB HDR 108 dB misurato secondo IEC 626745 in modalit Extended Dynamic Mode max 30FPS mov...Dettagli