From Morose Cassowary, 5 Years ago, written in Plain Text.
Embed
  1. ### Start Device Groups ###
  2. SQL[SELECT * FROM device_groups ORDER BY name]
  3. SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'device_perf' && COLUMN_NAME = 'device_id']
  4. SQL[SELECT DISTINCT(device_perf.device_id) FROM device_perf WHERE  device_perf.device_id='4415' AND (device_perf.avg >= 120 ) LIMIT 1]
  5. SQL[ LIMIT 1]
  6. MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 1' at line 1 ( LIMIT 1)
  7. SQL[ LIMIT 1]
  8. MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 1' at line 1 ( LIMIT 1)
  9. SQL[ LIMIT 1]
  10. MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 1' at line 1 ( LIMIT 1)
  11.