custom sql query

<?php

$querystr = "
    SELECT *
    FROM $wpdb->posts
";

$pageposts = $wpdb->get_results($querystr, OBJECT);

?>

<?php if ($pageposts): ?>
    <?php global $post; ?>
        <?php foreach ($pageposts as $post): ?>
            <?php setup_postdata($post); ?>
            <div class="post" id="post-<?php the_ID(); ?>">
                <h2><?php the_title(); ?></h2>
                <div><?php echo do_shortcode('[yasr_overall_rating size="small"]'); ?></div>
            </div>
        <?php endforeach; ?>
<?php endif; ?>