Changes between Version 1 and Version 2 of Internal/GoodJoin

Timestamp:

Jun 21, 2011, 4:13:07 PM (13 years ago)

Author:

ssugrim

Comment:

—

Internal/GoodJoin

@@ -8 +8 @@
 ORDER BY `check_in`.`time`  DESC
 }}}
+
+X,Y coordinates of a specific device:
+{{{
+SELECT locations.x,locations.y,nodes.motherboard_id,device_kinds.description
+FROM nodes
+LEFT JOIN locations ON nodes.location_id = locations.id
+LEFT JOIN devices ON nodes.motherboard_id = devices.motherboard_id
+LEFT JOIN device_kinds on devices.device_kind_id = device_kinds.id
+WHERE (devices.device_kind_id = 41 OR devices.device_kind_id = 32)
+ORDER BY locations.x,locations.y
+}}}