--- old\modules\aggregator.module Thu Dec 29 05:46:40 2005 +++ new\modules\aggregator.module Sun Jan 01 22:15:40 2006 @@ -1021,7 +1021,7 @@ * Menu callback; displays all the feeds used by the aggregator. */ function aggregator_page_sources() { - $result = db_query('SELECT f.fid, f.title, f.description, f.image, MAX(i.timestamp) AS last FROM {aggregator_feed} f LEFT JOIN {aggregator_item} i ON f.fid = i.fid GROUP BY f.fid, f.title, f.description, f.image'); + $result = db_query('SELECT f.fid, f.title, f.description, f.image, MAX(i.timestamp) AS last FROM {aggregator_feed} f LEFT JOIN {aggregator_item} i ON f.fid = i.fid GROUP BY f.fid, f.title, f.description, f.image ORDER BY last DESC, f.title'); $output = "
\n"; while ($feed = db_fetch_object($result)) { $output .= '

'. check_plain($feed->title) ."

\n";