wordpress调用指定时间内评论数最多的文章

//显示热评文章
function hot_comment_viewed($number, $days){
    global $wpdb;
    $sql = "SELECT ID , post_title , comment_count
           FROM $wpdb->posts
           WHERE post_type = 'post' AND post_status = 'publish' AND TO_DAYS(now()) - TO_DAYS(post_date) < $days
           ORDER BY comment_count DESC LIMIT 0 , $number ";
    $posts = $wpdb->get_results($sql);
    $i = 1;
    $output = "";
    foreach ($posts as $post){
        $output .= "\n<li><span class='li-icon li-icon-$i'>$i</span><a href= \"".get_permalink($post->ID)."\" rel=\"bookmark\" title=\"".$post->post_title." (".$post->comment_count."条评论)\" >".$post->post_title."</a></li>";
        $i++;
    }
    echo $output;
}

<div id="hot_comment_widget">
    <ul>
        <?php hot_comment_viewed(8, 600); ?>
        <?php wp_reset_query(); ?>
    </ul>
</div>