Wordpress Show Popular Posts Based on Comment Count

WordPress Show Popular Posts Based on Comment Count

Itâ€™s nice to be able to list all of your most popular posts based on the number of comments.

<h2>Popular Posts</h2>
<ul>
	<?php 
	global $wpdb;
	$result = $wpdb->get_results("SELECT comment_count,ID,post_title FROM $wpdb->posts ORDER BY comment_count DESC LIMIT 0 , 10");
	foreach ($result as $post) {
		setup_postdata($post);
		$postid = $post->ID;
		$title = $post->post_title;
		$commentcount = $post->comment_count;
		if ($commentcount != 0) { ?>
			<li><a href="<?php echo get_permalink($postid); ?>" title="<?php echo $title ?>">
				<?php echo $title ?></a> {<?php echo $commentcount ?>}</li>
		<?php 
		} 
	} 
	?>
</ul>

<h2>Popular Posts</h2>

<ul>

<?php

global $wpdb;

$result = $wpdb->get_results("SELECT comment_count,ID,post_title FROM $wpdb->posts ORDER BY comment_count DESC LIMIT 0 , 10");

foreach ($result as $post) {

setup_postdata($post);

$postid = $post->ID;

$title = $post->post_title;

$commentcount = $post->comment_count;

if ($commentcount != 0) { ?>

<li><a href="<?php echo get_permalink($postid); ?>" title="<?php echo $title ?>">

<?php echo $title ?></a> {<?php echo $commentcount ?>}</li>

<?php

}

</ul>