') `g/m³`
FROM locations
JOIN (
SELECT location_id, sensor_id, first_log_id, meaning_id FROM meanings
WHERE $last_log_id >= first_log_id AND $last_log_id < next_log_id
) ms USING(location_id)
$join_sensor
LEFT JOIN (
SELECT MAX(log_id) log_id, sensor_id
FROM log
WHERE log_id > $late_log_id
GROUP BY sensor_id
) AS maxes ON maxes.sensor_id = ms.sensor_id AND log_id >= first_log_id
LEFT JOIN log USING (log_id)
ORDER BY location_order
EOQ
);
/*
$weer = db_query(<<', TIMESTAMPDIFF(SECOND, log_timestamp, NOW()), 's'), '-') age, location_name locatie,
CONCAT('
') `g/m³`
FROM locations
LEFT JOIN (
SELECT MAX(log_id) log_id, location_id
FROM log
LEFT JOIN meanings ON meanings.sensor_id = log.sensor_id
AND log.log_id >= first_log_id
AND log.log_id < next_log_id
WHERE log_id > $late_log_id
GROUP BY location_id
) AS bla USING (location_id)
LEFT JOIN log USING (log_id)
$join_sensor
ORDER BY location_order
EOQ
);
*/
$orphans = db_query(<<', IFNULL(FORMAT(log_temperature,1), '-'), '') `℃` ,
CONCAT('
') `g/m³`,
(
SELECT CONCAT('')
FROM locations
LEFT JOIN (
SELECT MAX(log_id) log_id, location_id
FROM log
LEFT JOIN meanings ON meanings.sensor_id = log.sensor_id
AND log.log_id >= first_log_id
AND log.log_id < next_log_id
WHERE log_id > $late_log_id
GROUP BY location_id
) AS bla2 USING (location_id)
WHERE log_id IS NULL
) location
FROM (
SELECT MAX(log_id) log_id, log.sensor_id
FROM log
LEFT JOIN meanings ON meanings.sensor_id = log.sensor_id
AND log.log_id >= first_log_id
AND log.log_id < next_log_id
WHERE log_id > $late_log_id AND location_id IS NULL
GROUP BY sensor_id
) AS bla
LEFT JOIN log USING (log_id, sensor_id)
JOIN sensors USING (sensor_id)
EOQ
);
?>
Weerstation