<?
if($tags = wp_get_post_tags($id)){
   foreach ($tags  as $key => $value){
       $terms[] = $value->term_id;
   }
   $terms = (',',$terms);
$query =
"SELECT SQL_CALC_FOUND_ROWS  $wpdb->posts.*
FROM $wpdb->posts
INNER JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id)
INNER JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
INNER JOIN $wpdb->terms ON ($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id)
WHERE 1=1
AND $wpdb->posts.ID NOT IN ($id)
AND $wpdb->term_taxonomy.taxonomy = 'post_tag'
AND $wpdb->terms.term_id IN ($terms)
AND $wpdb->posts.post_type = 'post'
AND ($wpdb->posts.post_status = 'publish' OR $wpdb->posts.post_status = 'private')
GROUP BY $wpdb->posts.ID
ORDER BY $wpdb->posts.post_date DESC
LIMIT 0, 6";
   $related_post = $wpdb->get_results($query);
   if(($related_post)){
?>
        <br />
        <div id='related_post'>
        <h3>Похожие объявления:</h3>
        <ul class="ul-list box">
<?
    foreach ($related_post as $key=>$rl_post) {
?>
            <li style="margin-bottom: 10px">
                <a href="<?=get_permalink($rl_post->ID); ?>" rel="bookmark" title="Permanent Link to <?=$rl_post->post_title?>"><?=$rl_post->post_title?></a>
                 <br /><span class="postdata"><?=mysql2date('F jS, Y',$rl_post->post_date) ?> </span>
            </li>
<? } ?>
        </ul>
        </div>
<?
   }
}
?>