diff options
Diffstat (limited to 'Bugzilla/Bug.pm')
-rwxr-xr-x | Bugzilla/Bug.pm | 16 |
1 files changed, 10 insertions, 6 deletions
diff --git a/Bugzilla/Bug.pm b/Bugzilla/Bug.pm index 39864d252..675c2ec15 100755 --- a/Bugzilla/Bug.pm +++ b/Bugzilla/Bug.pm @@ -163,12 +163,16 @@ sub initBug { reporter_accessible, cclist_accessible, estimated_time, remaining_time, " . $dbh->sql_date_format('deadline', '%Y-%m-%d') . " - FROM bugs LEFT JOIN votes using(bug_id), - classifications, products, components - WHERE bugs.bug_id = ? - AND classifications.id = products.classification_id - AND products.id = bugs.product_id - AND components.id = bugs.component_id " . + FROM bugs + LEFT JOIN votes + USING (bug_id) + INNER JOIN components + ON components.id = bugs.component_id + INNER JOIN products + ON products.id = bugs.product_id + INNER JOIN classifications + ON classifications.id = products.classification_id + WHERE bugs.bug_id = ? " . $dbh->sql_group_by('bugs.bug_id', 'alias, products.classification_id, classifications.name, bugs.product_id, products.name, version, rep_platform, op_sys, bug_status, resolution, priority, |