get("Recently Updated"); ?>
query("SELECT COUNT(machines.machineid) as count FROM machines
LEFT OUTER JOIN events ON events.machineid = machines.machineid
WHERE date=(SELECT MAX(s2.date)
FROM events s2
WHERE machines.machineid = s2.machineid
)
AND events.date > NOW() - INTERVAL 1 week
LIMIT 100")->fetchAll();
echo $machines[0]["count"];
?>