EGOroff ^info

<ul>
    <?php
    $result = $wpdb->get_results("SELECT comment_count,ID,post_title, post_date FROM $wpdb->posts WHERE post_date BETWEEN '2008-06-01' AND '2010-07-01' 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 }
    }
    ?>
    </ul>