Top Kommentatoren, falsches Ergebnis

function top_commentators_jahr() {
 global $wpdb;
 $topcommentator_query="SELECT comment_author, SUBSTRING_INDEX(comment_author_url, '/', 3) as top_commentator, COUNT(*) as top_num FROM $wpdb->comments
  WHERE comment_approved='1'
  AND comment_date >= CURDATE() - INTERVAL 365 DAY
  AND comment_author_url NOT LIKE 'http://themenfreund.de%'
  GROUP BY top_commentator
  Order by top_num DESC, comment_date ASC
  LIMIT 3";
 $topcommentator_result = $wpdb->get_results($topcommentator_query);
 if ( !empty($topcommentator_result) ) {
  echo '<ul>';
  foreach ($topcommentator_result as $comment) :
   $co_nam = $comment->comment_author;
   $co_aut = $comment->top_commentator;
   $co_aut = str_ireplace("http://", "", $co_aut);
   echo '<li><a href="'.$comment->top_commentator.'/" target="_blank">'.$co_nam.'</a> ('.$comment->top_num.') </li>';
  endforeach;
  echo '</ul>';
 }
}

function top_commentators_jahr() {
 global $wpdb;
 $topcommentator_query="SELECT comment_author, comment_type, SUBSTRING_INDEX(comment_author_url, '/', 3) as top_commentator, COUNT(*) as top_num FROM $wpdb->comments
  WHERE comment_approved='1' 
  AND comment_author_url NOT LIKE 'http://themenfreund.de%'
  AND comment_type NOT LIKE 'pingback' OR 'trackback'
  AND comment_date >= CURDATE() - INTERVAL 365 DAY
  GROUP BY top_commentator
  Order by top_num DESC, comment_date ASC
  LIMIT 3";
 $topcommentator_result = $wpdb->get_results($topcommentator_query);
 if ( !empty($topcommentator_result) ) {
  echo '<ul>';
  foreach ($topcommentator_result as $comment) :
   $co_aut = $comment->top_commentator;
   $co_aut = str_ireplace("http://", "", $co_aut);
   echo '<li><a href="'.$comment->top_commentator.'/" target="_blank">'.$comment->comment_author.'</a> ('.$comment->top_num.') </li>';
  endforeach;
  echo '</ul>';
 }
}