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 1200 ROWS FETCH NEXT 15 ROWS ONLY
5MP Corner CameraTNV-8011C 5MP Corner Camera ...Dettagli
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
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
IP SPEED DOME IP 25X WDR 120dB H.265+ SMART 2MPDS-2DE5225W-AE Speed Dome5 2MP 1920x1080 Zoom ottico 25x Digitale 16x sensore CMOS 128’’ Progressive Scan di tipo DayNight con filtro IR meccanico WDR 120 dB sensibilit colori 0005 lux F16 AGC on BN 0001 lux F16 AGC on BLC HLC 3DDNR EIS ottica varifocale 481200mm D...Dettagli