Filter posts showing in Footer

I have checked the theme’s function clearly selects only posts that are published, however it’s doing it in an old-fashioned way. Try opening the file functions.php and for the function list_most_commented change the line:

$posts = $wpdb->get_results("SELECT comment_count,ID,post_title,post_status FROM $wpdb->posts WHERE post_status='publish' ORDER BY comment_count DESC LIMIT 0 , 6");

with:

$posts = get_posts( array(
	'numberposts'     => 6,
	'orderby'         => 'post_date'
) );

• This reply was modified 12 years, 6 months ago by Daniel Tara.

Sorry I made a type, here’s the correct code:

$posts = get_posts( array(
	'numberposts'     => 6,
	'orderby'         => 'comment_count'
) );