Changes between Initial Version and Version 1 of Internal/GoodJoin

Timestamp:

Jun 20, 2011, 3:32:48 PM (13 years ago)

Author:

ssugrim

Comment:

—

Internal/GoodJoin

@@ +1 @@
+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
+}}}