<div id="footer"> 
  <!--recent comments start --> 
  <div class="footer-recent-posts"> 
 <h4>Son Yazılar</h4> 
      <?php query_posts('showposts=5'); ?> 
    <ul> 
    <?php while (have_posts()) : the_post(); ?> 
    <li> 
    <strong><a href="<?php the_permalink() ?>" rel="bookmark" title="<?php _e('Permanent link to'); ?> <?php the_title(); ?>"><?php the_title(); ?></a></strong><br /> 
    <small><?php the_time('m-d-Y') ?></small> 
    </li> 
    <?php endwhile;?> 
    </ul> 
  </div> 
  <!--recent comments start --> 
 
  <!--recent comments start --> 
  <div class="footer-recent-comments"> 
    <?php include (TEMPLATEPATH . '/simple_recent_comments.php'); /* recent comments plugin by: www.g-loaded.eu */?> 
    <?php if (function_exists('src_simple_recent_comments')) { src_simple_recent_comments(5, 60, ' 
   <h4>Son Yorumlar</h4>', ''); } ?> 
  </ul> 
  </div> 
  <!--recent comments end --> 
 
<div class="footer-recent-posts"> 
 <h4>En Çok Yorumlananlar</h4> 
      <?php query_posts('showposts=5'); ?> 
    <ul> 
    <?php  
$result = $wpdb->get_results("SELECT comment_count,ID,post_title FROM $wpdb->posts ORDER BY comment_count DESC LIMIT 0 , 5");  
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); ?>" title="<?php echo $title ?>"><?php echo $title ?> &raquo; <span></a></li>  
<?php } } ?>  
    </li> 
    <?php endwhile;?> 
    </ul> 
  </div> 
 
 
  <hr class="clear" /> 
  </div><!--/footer --> 
</div><!--/page -->