Someone

<?php

$today = current_time('mysql', 1);

 

if ( $recentposts = $wpdb->get_results("SELECT ID, post_title FROM $wpdb->posts WHERE post_status = 'publish' AND post_date_gmt < '$today' ORDER BY post_date DESC LIMIT 10")):

?>
<li>
<h2><?php _e("Recent Posts"); ?></h2>

<ul>

<?php

foreach ($recentposts as $post) {

        if ($post->post_title == '')

                $post->post_title = sprintf(__('Post #%s'), $post->ID);

        echo "<li><a href='?p=$post->ID'>";

        the_title();

        echo '</a></li>';

}

?>

</ul>
</li>


<?php endif; ?>