WordPress添加访客排行榜实现最新评论自动排第一

function getvisitors() {

 global $wpdb;

 // $query="select * from `wp_comments` where `comment_approved`=1 group by `comment_author_url` order by comment_ID DESC limit 0,12";

 $query="select MAX(`comment_ID`) comment_ID ,`comment_author_url`,`comment_author` from wp_comments 

where `comment_author_url`<>'' and `comment_author_url` not like '%zouaw%' and `comment_approved`='1' 

group by `comment_author_url` order by `comment_ID` DESC limit 0,23;";

 $sql = $wpdb -> get_results($query, ARRAY_A);

 //print_r($sql);

foreach($sql as $vales){

 echo "<li><img src='https://www.chukuangren.com/wp-content/uploads/2019/01/timg-1.gif'><a target='_blank' rel="nofollow noopener noreferrer">".$vales["comment_author"]."</a></li>";

 }

}

<div class="vistor">

<style> 

.vistor{width:100%;margin-bottom:20px;height:auto!important;background:#fff;border:1px solid #f5f9ff;text-align:center;color:#096cb2;

border:1px solid #eaeaea;border-radius:4px;}

.vistor p{padding-top:4px;font-size:17px;}

.vistor ul{margin-top:10px;margin-bottom:10px;font-size:13px;padding-bottom:40px;}

.vistor ul li{list-style:none;float:left;margin-left:0px;margin-bottom:10px;width:16.6%;overflow:hidden;height:20px;text-align:left;}

.vistor ul li img{width:20px;height:20px;margin-left:2px;margin-right:2px;}

/*@media (max-width:820px) {.vistor{display:none}}*/

@media (max-width:820px) {

 .vistor ul li{width:25%;font-size:9px;} 

 .vistor p{padding-top:4px;font-size:15px;}

 }

</style>

<p><a href="/visitor-html" target="_blank" rel="noopener noreferrer">[访客榜单]-</a>每评论一次你就会自动排第一位</p>

<ul>

<li><img src='/wp-content/uploads/2019/01/timg-1.gif'><a target='_blank' rel="nofollow noopener noreferrer" href="">阿里云主机</a></li>

<?php 

 getvisitors();

?>

</ul>

<div style="clear: both;display:block"> </div>

</div>