Mercurial > hg > fapweb

changeset 412:3e38433fcace

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Show only competitions that have entries.
author Matti Hamalainen <ccr@tnsp.org>
date Thu, 05 Dec 2013 17:38:57 +0200
parents 2aa58de08d6d
children 9eb46567f0aa
files admajax.php
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/admajax.php	Thu Dec 05 17:36:43 2013 +0200
+++ b/admajax.php	Thu Dec 05 17:38:57 2013 +0200
@@ -659,7 +659,7 @@
         $sql =
           "SELECT compos.*, ".
           "(SELECT COUNT(*) FROM entries WHERE compo_id=compos.id) AS nentries ".
-          "FROM compos ".
+          "FROM compos WHERE nentries > 0 ".
           "ORDER BY id DESC";
 
         $currCompoID = stGetDisplayVar("compoID");