Recent Posts across WP Network

global $wpdb;
                    $prefix = 'ZkUy_';
                    $limit = 3;
                    $sitesquery = '
                        SELECT blog_id
                        FROM '.$prefix.'blogs';
                    $sites = $wpdb->get_results( $sitesquery );
                    foreach( $sites as $site ) {

                        $posts_table = $prefix.$site->blog_id.'_posts';

                        $posts_table = esc_sql( $posts_table );
                        $blogs_table = esc_sql( $prefix . 'blogs' );

                        $postsquery = '
                            SELECT *
                            FROM '.$posts_table.'
                            WHERE post_type="post"
                            AND post_status="publish"
                            ORDER BY post_date DESC LIMIT 0, '.$limit;

                        $postsquery = $wpdb->prepare($postsquery);
                        $siteposts = $wpdb->get_results($postsquery);
                        foreach( $siteposts as $post ) : setup_postdata($post); ?>
                            <div id="post-<?php the_ID(); ?>" <?php post_class( array('row') ); ?>>
                                <div class="span1">
                                    <div class="timestamp">
                                        <span class="timestamp_year"><?php the_time('Y'); ?></span>
                                        <span class="timestamp_bottom">
                                            <span class="timestamp_month"><?php the_time('M'); ?></span>
                                            <span class="timestamp_day"><?php the_time('j'); ?></span>
                                        </span>
                                    </div>
                                    <div class="comments_number">
                                        <?php $commentNo = get_comments_number();
                                                if( $commentNo == 0 ) { ?>
                                                <a href="<?php comments_link(); ?>" class="comments_number_link">Discuss!</a>
                                                <?php } else { ?>
                                                <a href="<?php comments_link(); ?>" class="comments_number_bubble"><?php echo $commentNo; ?></a>
                                            <?php } ?>
                                    </div>
                                </div>
                                <div class="span7">
                                    <div class="post_content">
                                        <h2 class="post_title"><a href="<?php the_permalink(); ?>"><?php the_title(); ?></a></h2>
                                        <div class="postmeta_top">
                                            <span class="post_author">by <?php the_author_link(); ?></span> &bull; <span class="post_category">posted in <?php the_category(', '); ?></span>
                                        </div>
                                        <div class="post_entry">
                                            <?php the_post_thumbnail(); ?>
                                            <?php the_content(); ?>
                                        </div>
                                    </div><!-- .post_content -->
                                </div>
                            </div>
                        <?php endforeach; wp_reset_postdata();
                    }