Changes between Version 2 and Version 3 of Internal/GoodJoin

Timestamp:

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

Author:

ssugrim

Comment:

—

Internal/GoodJoin

@@ -16 +16 @@
 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)
+WHERE 
+(devices.device_kind_id = 41 OR devices.device_kind_id = 32)
+AND locations.testbed_id = 1
 ORDER BY locations.x,locations.y
 }}}