From 2eb571aa1b8ba52c9c317ec6fed28a611f2b62fc Mon Sep 17 00:00:00 2001
From: randomdan <randomdan@localhost>
Date: Sat, 17 Jul 2010 16:06:31 +0000
Subject: Tweak newebuilds SQL to be more efficient

---
 gentoobrowse/views/newebuilds.xml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

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 &gt; (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>
-- 
cgit v1.2.3