再说友情链接 [评论统计页面]

<?php
// https://codingforspeed.com
  global $wpdb;
  $query = "
    select 
      `comment_author`, 
      `comment_author_url`,
      count(1) as `cnt` 
    from
      `wp_comments`
    where
      `comment_approved` = 1      
    group by 
      `comment_author`
    order by
      `cnt` desc
    limit 10 
  ";
  
  $result = $wpdb->get_results($query);
  if ($result) {
    echo "<table width='100%' style='border:0'>";
    echo "<tr><b><td>作者</td><td>评论数目</td></b></tr>";
    foreach ($result as $author) {
      echo "<tr>";
      $a = esc_sql($author->comment_author);
      $query = "
        select 
          `comment_post_id`,
          `comment_id`
        from
          `wp_comments`
        where
          `comment_approved` = 1 and
          `comment_author` = '$a'
        order by
          `comment_date` desc
        limit 1      
      ";
      $latest = $wpdb->get_row($query);
      echo "<td><a href='$author->comment_author_url' target='_blank' title='$author->comment_author'>".$author->comment_author."</a></td>";
      echo "<td><a title='$author->comment_author' href='/archives/$latest->comment_post_id/#comment-$latest->comment_id'>".$author->cnt."</a></td>";      
      echo "</tr>";
    }
    echo "</table>";
  } 
?>