diff options
-rw-r--r-- | web/lib/pkgfuncs.inc | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc index 7427947..c4a30d5 100644 --- a/web/lib/pkgfuncs.inc +++ b/web/lib/pkgfuncs.inc @@ -736,7 +736,7 @@ function pkg_search_page($SID="") { # $q = "SELECT Packages.*, IF(ISNULL(PackageID), 0, COUNT(*)) AS Votes "; # $q.= "FROM Packages LEFT JOIN PackageVotes "; # $q.= "ON Packages.ID = PackageVotes.PackageID "; - $q = "SELECT * FROM Packages LEFT JOIN Users "; + $q = "SELECT * FROM Users RIGHT JOIN Packages "; $q.= "ON (Users.ID = Packages.MaintainerUID) "; $q.= "WHERE DummyPkg != 1 "; $has_where = 1; |