wp_get_archives('type=postbypost') missing ORDER BY

[mattbta]

wp-includes/general-template.php function wp_get_archives() line 417/418 :

('alpha' == $type) ? $orderby = "post_title ASC " : $orderby = "post_date DESC ";
		$arcresults = $wpdb->get_results("SELECT * FROM $wpdb->posts $join $where $orderby $limit");

Should be:

('alpha' == $type) ? $orderby = "post_title ASC " : $orderby = "post_date DESC ";
		$arcresults = $wpdb->get_results("SELECT * FROM $wpdb->posts $join $where ORDER BY $orderby $limit");

+1

/me hides in shame for breaking it with his last patch

Notes that this is a dupe of #3951

Closing as dupe of earlier ticket which also has-patch

(In [5036]) Fix order by in wp_get_archives(). Props mattbta. fixes #3961