<?php 

$author_id = $post->post_author; 
$tp = $wpdb->prefix;
$yazar_sorgu = (array)$wpdb->get_results("SELECT ID, post_title, post_date FROM {$tp}posts, {$tp}term_relationships, {$tp}term_taxonomy    WHERE post_author = {$author_id} AND {$tp}term_relationships.object_id = {$tp}posts.ID AND {$tp}term_relationships.term_taxonomy_id = {$tp}term_taxonomy.term_taxonomy_id AND post_status = 'publish' AND post_date < NOW() AND post_type = 'post' GROUP BY ID LIMIT 10");

    if (count($yazar_sorgu) > 0) {

        $yazdir = NULL;

        $yazdir .= "<ul>";

        foreach ($yazar_sorgu as $apost) {

            $yazdir .= '<li><a href="' . get_permalink($apost->ID) . '">' . $apost->post_title . '</a></li>';

        }

        $yazdir .= "</ul>";

    }
    
    echo $yazdir;

?>