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 = '02 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '02 ')) ORDER BY I.Seq OFFSET 5655 ROWS FETCH NEXT 15 ROWS ONLY
Camera Indoor WiFi 2MP IR 10m. Micro SD slot, Two way Audio. 1080P. Analytics. DesktopVESTA-292 Camera Indoor WiFi 2MP IR 10m. Micro SD slot, Two way Audio. 1080P. Analytics. Desktop ...Dettagli
Camera Outdoor WiFi 2MP IR 30m. Micro SD slot, Ethernet. 1080P. Analytics. Bullet. White lightVESTA-293 Camera Outdoor WiFi 2MP IR 30m. Micro SD slot, Ethernet. 1080P. Analytics. Bullet. White light ...Dettagli
Wireless Water sensing Cable 120 cm for VESTA-026VESTA-300 Wireless Water sensing Cable 120 cm for VESTA-026 ...Dettagli
Bus Expansion Mudule 4 Wired Outputs. With Box and backup battery. Grade 3 CertifiedVESTA-305 Bus Expansion Mudule 4 Wired Outputs. With Box and backup battery. Grade 3 Certified ...Dettagli
Wireless Keypad with Bluetooth, Siren and Prox ReaderVESTA-307 Wireless Keypad with Bluetooth, Siren and Prox Reader ...Dettagli
Wireless Smoke and Thermal Detector. Built in Siren and PIR. One goes all goes. Easy Clean. False AlVESTA-336 Wireless Smoke and Thermal Detector. Built in Siren and PIR. One goes all goes. Easy Clean. False Al ...Dettagli
AC Adaptor for VESTA-207N SirenVESTA-337 AC Adaptor for VESTA-207N Siren ...Dettagli
Bus Wiegand 26 Interface. Wireless or Bus connection. 240 Users per partitionVESTA-344 Bus Wiegand 26 Interface. Wireless or Bus connection. 240 Users per partition ...Dettagli
Wireless HD Outdoor PIRCam. 10m. Antimasking. Pet Immune. 7m IR Illumination.VESTA-347N-720P Wireless HD Outdoor PIRCam. 10m. Antimasking. Pet Immune. 7m IR Illumination. ...Dettagli
Wireless Double Technology (PIR/MW) Indoor Detector. 9m. MW at 24GHz. 2,5m height. Pet ImmuneVESTA-352 Wireless Double Technology (PIR/MW) Indoor Detector. 9m. MW at 24GHz. 2,5m height. Pet Immune ...Dettagli
Bus 7 inch Touchscreen keypad. WiFi for Cameras. Microphone and SpeakerVESTA-354 Bus 7 inch Touchscreen keypad. WiFi for Cameras. Microphone and Speaker ...Dettagli
Bus Indoor PIRCamVESTA-355 Bus Indoor PIRCam ...Dettagli