[Pypi-checkins] r954 - trunk/pypi

[richard]

Author: richard
Date: Tue Aug 23 03:13:55 2011
New Revision: 954

Modified:
   trunk/pypi/store.py
Log:
better newest package SQL; thanks Andy Todd

Modified: trunk/pypi/store.py
==============================================================================
--- trunk/pypi/store.py	(original)
+++ trunk/pypi/store.py	Tue Aug 23 03:13:55 2011
@@ -885,11 +885,14 @@
         # is "small".
         statement = '''
             select j.name, r.version, j.submitted_date, r.summary
-              from (select name,version,submitted_date from journals
-                     where action='create' order by submitted_date desc %s) j,
-                   releases r
-             where j.name=r.name and r.version is not NULL
+              from releases r
+                   JOIN (SELECT name, max(submitted_Date) submitted_date
+                         FROM  journals GROUP BY name) j ON j.name = r.name
+             where r.version is not NULL
                and not r._pypi_hidden
+               and r.name in (SELECT name FROM journals
+                              WHERE  action='create'
+                              ORDER BY submitted_date DESC %s)
              order by j.submitted_date desc'''
         #print ' '.join((statement % limit).split())
         safe_execute(cursor, statement % limit)