summaryrefslogtreecommitdiffstats
path: root/bin
diff options
context:
space:
mode:
Diffstat (limited to 'bin')
-rwxr-xr-xbin/reproducible_common.py4
1 files changed, 1 insertions, 3 deletions
diff --git a/bin/reproducible_common.py b/bin/reproducible_common.py
index 2eb7389b..368aed5e 100755
--- a/bin/reproducible_common.py
+++ b/bin/reproducible_common.py
@@ -568,9 +568,7 @@ def get_bugs():
"""
query = """
SELECT bugs.id, bugs.source, bugs.done, ARRAY_AGG(tags.tag)
- FROM bugs JOIN bugs_tags ON bugs.id = bugs_tags.id
- JOIN bugs_usertags ON bugs_tags.id = bugs_usertags.id
- JOIN sources ON bugs.source=sources.source
+ FROM bugs JOIN bugs_usertags ON bugs.id = bugs_usertags.id
LEFT JOIN (
SELECT id, tag FROM bugs_tags
WHERE tag='patch' OR tag='pending'