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>