wiki:Internal/GoodJoin

Version 1 (modified by ssugrim, 13 years ago) ( diff )

—

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
Note: See TracWiki for help on using the wiki.