Gets the locations of the most recent checkin
{{{
SELECT check_in.time, locations.x,locations.y,testbeds.node_domain 
FROM check_in 
LEFT JOIN locations ON check_in.id = locations.id 
LEFT JOIN testbeds ON locations.testbed_id = testbeds.id 
WHERE 1 
ORDER BY `check_in`.`time`  DESC
}}}