diff options
| -rw-r--r-- | gentoobrowse-api/service/sql/portage/getTopTrackedPackages.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/gentoobrowse-api/service/sql/portage/getTopTrackedPackages.sql b/gentoobrowse-api/service/sql/portage/getTopTrackedPackages.sql index c328d73..16e711a 100644 --- a/gentoobrowse-api/service/sql/portage/getTopTrackedPackages.sql +++ b/gentoobrowse-api/service/sql/portage/getTopTrackedPackages.sql @@ -2,5 +2,5 @@ SELECT p.packageid, p.categoryid, p.name, p.description, p.summary, p.firstseen, FROM gentoobrowse.packages p, gentoobrowse.user_packages up WHERE p.packageid = up.packageid GROUP BY p.packageid -ORDER BY COUNT(*) DESC +ORDER BY COUNT(*) DESC, p.packageid LIMIT ? |