Connected to the database successfully!
SQL Query: SELECT
esp8266id,
airq_sensor_id,
firmware,
sensor_name,
SUM(total_measurements) as total_measurements,
SUM(missing_measurements) as missing_measurements,
ROUND((SUM(missing_measurements) / SUM(total_measurements) * 100, 2) as missing_percentage,
MAX(timestamp) as last_timestamp
FROM airq_missed_data GROUP BY esp8266id, airq_sensor_id, firmware, sensor_name ORDER BY missing_percentage DESC
Fatal error: Uncaught mysqli_sql_exception: 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 'FROM airq_missed_data GROUP BY esp8266id, airq_sensor_id, firmware, sensor_na...' at line 10 in /home/sensors/public_html/missed/view_missed_data.php:86
Stack trace:
#0 /home/sensors/public_html/missed/view_missed_data.php(86): mysqli->query()
#1 {main}
thrown in /home/sensors/public_html/missed/view_missed_data.php on line 86