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> • <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();
}