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 ' AND I.SBFAM = '077 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '02 ' AND SBFAM = '077 ')) ORDER BY I.Seq OFFSET 0 ROWS FETCH NEXT 15 ROWS ONLY
Zigbee +Z-Wave USB Dongle for VESTA panelsVESTA-239 Zigbee +Z-Wave USB Dongle for VESTA panels ...Dettagli
Wireless Indoor PIR and Glassbreak. 12m. Pet Immune (Programmable). 8m sound rangeVESTA-382 Wireless Indoor PIR and Glassbreak. 12m. Pet Immune (Programmable). 8m sound range ...Dettagli
Wireless LCD Keypad with Siren and Prox ReaderVESTA-383 Wireless LCD Keypad with Siren and Prox Reader ...Dettagli
Bus Smoke DetectorVESTA-384 Bus Smoke Detector ...Dettagli
Hybrid SMA antenna (antenna &bracket) for GSM (2G, 3G, 4G). SMA connectorVESTA-275 Hybrid SMA antenna (antenna &bracket) for GSM (2G, 3G, 4G). SMA connector ...Dettagli
Hybrid SMA antenna (antenna magnetic) for GSM (2G, 3G, 4G). SMA connectorVESTA-276 Hybrid SMA antenna (antenna magnetic) for GSM (2G, 3G, 4G). SMA connector ...Dettagli
Z-Wave Universal IR Split air conditioning control. LCD display. Touch buttonsVESTA-288 Z-Wave Universal IR Split air conditioning control. LCD display. Touch buttons ...Dettagli
Camera Indoor WiFi 2MP IR 10m. Micro SD slot, Two way Audio. 1080P. Analytics. CompactVESTA-291 Camera Indoor WiFi 2MP IR 10m. Micro SD slot, Two way Audio. 1080P. Analytics. Compact ...Dettagli
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