$days = 7; //To fetch posts published during the last 7 days

$today = date("Y-m-d H:i:s"); //Today's date

$daysago = date("Y-m-d H:i:s",strtotime(date('Y-m-j H:i:s')) - (7 * 24 * 60 * 60)); //Today - $days

$result = $wpdb->get_results("SELECT comment_count,ID,post_title,

post_date FROM $wpdb->posts WHERE post_date BETWEEN $daysago AND

$today ORDER BY comment_count DESC LIMIT 0 , 10");

foreach ($result as $topten) {

$postid = $topten->ID;

$title = $topten->post_title;

$commentcount = $topten->comment_count;

if ($commentcount != 0) {

?>

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

<?php }

}