wordpress如何在页面中获取最新评论文章

wordpress如何在文章页面右侧显示最新评论文章，下面web建站小编给大家详细介绍一下具体实现代码！

利用MYSQL语法实现功能：

$pop = $wpdb->get_results("SELECT DISTINCT comment_post_ID
  FROM $wpdb->comments
  WHERE comment_approved = 1
  AND comment_post_ID NOT IN
  (
    SELECT ID FROM $wpdb->posts
    WHERE post_type != 'post'
    OR post_status != 'publish'
    OR post_password != ''
  )
  ORDER BY comment_date_gmt DESC
  LIMIT 10"); 
?>
<ul>
<?php foreach($pop as $post) : ?>
  <li><a href="<?php echo get_permalink($post->comment_post_ID); ?>">
  <?php echo get_the_title($post->comment_post_ID); ?></a></li>
<?php endforeach; ?>
</ul>