<?php get_header(); ?>
    <div id="content">
        <?php  if ( is_multisite() ) {?>
            <h1 class="yellow-line">&middot; Upcoming Markets &middot;</h1>
                <div id="mp-product-grid">
                <div class="main">
                    <?php
                    $query = "SELECT blog_id, p.post_id, post_permalink, post_title, post_content, post_date FROM {$wpdb->base_prefix}mp_products p WHERE p.blog_public = 1";
                    $query .= " ORDER BY p.post_date";
                    $query .= " DESC";
                    $query .= " LIMIT 0 , 6";
                    $results = $wpdb->get_results( $query );
                    ?>
                    <ul class="grid">
                        <?php foreach ($results as $product) { ?>
                            <li>
                                <a href="<?php echo $product->post_permalink; ?>">
                                <img src ="<?php echo $product->post_thumbnail;?>"/>
                                    <div class="image-wrapper">
                                        <?php $blogdetails = get_blog_details( $blog[0] );
                                            $thumbcode = str_replace( $current_blog->domain . $current_blog->path, $blogdetails->domain . $blogdetails->path, get_the_post_thumbnail( $post_id, $size, $attrs ) );
                                            $image = wp_get_attachment_image_src( get_post_thumbnail_id( $post->ID ), 'single-post-thumbnail' ); ?>
                                        <img width="313" height="235" src="<?php echo $product-image; ?>" />
                                    </div>
                                    <label>
                                        <acronym title="<?php echo $product->post_title ?>">
                                            <?php echo substr( $product->post_title , 0, 1);  ?>
                                        </acronym>
                                    </label>
                                    <div class="info">
                                        <p class="location"></p>
                                            <h2><?php echo $product->post_title; ?></h2>
                                            <p><?php echo $product->post_content; ?></p>
                                            <p><?php echo $product->post_date; ?></p>
                                    </div>
                                </a>
                            </li>
                        <?php } ?>
                    </ul>
                </div>
            </div>
            <h1 class="yellow-line"> &middot; Most Hearted of the Hunted &middot;</h1>
            <div id="mp-product-grid">
                <div class="main">
                    <?php
                        $query = "SELECT blog_id, p.post_id, post_permalink, post_title, post_content, post_date FROM {$wpdb->base_prefix}mp_products p WHERE p.blog_public = 1";
                        $query .= " ORDER BY p.post_date";
                        $query .= " DESC";
                        $query .= " LIMIT 0 , 6";
                        $results = $wpdb->get_results( $query );
                    ?>
                    <ul class="grid">
                        <?php foreach ($results as $product) { ?>
                        <li>
                            <a href="<?php echo $product->post_permalink; ?>">
                                <div class="image-wrapper">
                                    <?php
                                        $blogdetails = get_blog_details( $blog[0] );
                                        $thumbcode = str_replace( $current_blog->domain . $current_blog->path, $blogdetails->domain . $blogdetails->path, get_the_post_thumbnail( $post_id, $size, $attrs ) );
                                        $image = wp_get_attachment_image_src( get_post_thumbnail_id( $post->ID ), 'single-post-thumbnail' ); ?>
                                        <img width="313" height="235" src="<?php echo $image; ?>" />
                                </div>
                                <label class="heart">
                                    <acronym title="<?php echo $product->post_title ?>">
                                        <?php echo substr( $product->post_title , 0, 1);  ?>
                                    </acronym>
                                </label>
                                <div class="info">
                                    <p class="location"></p>
                                    <h2><?php echo $product->post_title; ?></h2>
                                    <p><?php echo $product->post_content; ?></p>
                                    <p><?php echo $product->post_date; ?></p>
                                </div>
                            </a>
                        </li>
                        <?php } ?>
                    </ul>
                </div>
            </div>
        <?php } ?>
    </div>
<?php get_sidebar(); ?>
<?php get_footer() ?>