From 08594266f7b528813ba4b47715cf2d307de0e08f Mon Sep 17 00:00:00 2001 From: Holger Levsen Date: Sun, 13 Sep 2015 12:02:04 +0200 Subject: reproducible: fixup query --- bin/reproducible_html_live_status.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'bin') diff --git a/bin/reproducible_html_live_status.py b/bin/reproducible_html_live_status.py index e3faa5b9..b60de0f4 100755 --- a/bin/reproducible_html_live_status.py +++ b/bin/reproducible_html_live_status.py @@ -61,7 +61,7 @@ def generate_live_status_table(arch): query = 'SELECT s.id, s.suite, s.architecture, s.name, s.version, ' + \ 'p.date_build_started, r.status, r.build_duration, p.builder ' + \ 'FROM sources AS s JOIN schedule AS p ON p.package_id=s.id LEFT JOIN results AS r ON s.id=r.package_id ' + \ - 'WHERE (p.date_build_started != "" OR p.notify != "") AND s.architecture="{arch}" ' + \ + 'WHERE p.date_build_started != "" AND s.architecture="{arch}" ' + \ 'ORDER BY p.date_build_started DESC' html = '' rows = query_db(query.format(arch=arch)) -- cgit v1.2.3-70-g09d2