Changes between Version 2 and Version 3 of Internal/GoodJoin


Ignore:
Timestamp:
06/21/11 16:15:10 (8 years ago)
Author:
ssugrim
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Internal/GoodJoin

    v2 v3  
    1616LEFT JOIN devices ON nodes.motherboard_id = devices.motherboard_id
    1717LEFT JOIN device_kinds on devices.device_kind_id = device_kinds.id
    18 WHERE (devices.device_kind_id = 41 OR devices.device_kind_id = 32)
     18WHERE
     19(devices.device_kind_id = 41 OR devices.device_kind_id = 32)
     20AND locations.testbed_id = 1
    1921ORDER BY locations.x,locations.y
    2022}}}