diff options
| author | randomdan <randomdan@localhost> | 2010-07-17 16:06:31 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2010-07-17 16:06:31 +0000 |
| commit | 2eb571aa1b8ba52c9c317ec6fed28a611f2b62fc (patch) | |
| tree | 76b27b2f32f17d681aee38735a11c38d3cfdda05 | |
| parent | Add signup and email confirmation (diff) | |
| download | gentoobrowse-2eb571aa1b8ba52c9c317ec6fed28a611f2b62fc.tar.bz2 gentoobrowse-2eb571aa1b8ba52c9c317ec6fed28a611f2b62fc.tar.xz gentoobrowse-2eb571aa1b8ba52c9c317ec6fed28a611f2b62fc.zip | |
Tweak newebuilds SQL to be more efficient
| -rw-r--r-- | gentoobrowse/views/newebuilds.xml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/gentoobrowse/views/newebuilds.xml b/gentoobrowse/views/newebuilds.xml index 1476533..7e26b37 100644 --- a/gentoobrowse/views/newebuilds.xml +++ b/gentoobrowse/views/newebuilds.xml @@ -8,7 +8,7 @@ WHERE e.ebuildid = f.fileid AND e.packageid = p.packageid AND p.categoryid = c.categoryid - AND f.firstseen > (SELECT DISTINCT f.firstseen FROM files f ORDER BY f.firstseen DESC LIMIT 1 OFFSET 3) + AND f.firstseen IN (SELECT DISTINCT f.firstseen FROM files f ORDER BY f.firstseen DESC LIMIT 3) ORDER BY c.name, p.name, e.versioninst </sql> </project2:sqlview> |