<?php get_header(); ?>
<div class="row">
	<div class="col-md-12">

		<?php
		if ( have_posts() ) :
		    while (have_posts()) : the_post();
			?>
				<div class="col-md-7">
					<div class="news-img">
						<?php
						if (has_post_thumbnail())
						{
							the_post_thumbnail('full');
						}
						?>
					</div>
			        <div class="bsav-detail-new">
				        <a class="wp-green-color" href="<?php the_permalink() ?>" style="text-decoration:none">
							<h2 class="news-title"><?php the_title() ?></h2>
						</a>
						<div><h5 class="text-muted"><?php the_time('d F Y') ?></h5></div><br>
						<div class="text-muted"><strong><?php the_excerpt() ?></strong></div><br>
			        	<?php the_content() ?>
			        </div><br><br>

			    </div>
				<?php
			endwhile;
		endif;
		?>

		<?php
		global $wpdb;
		$table = $wpdb->prefix . "posts";
        $query = "SELECT *
        			 FROM bsav_posts
        			 WHERE post_type = 'noticies'
        			 AND post_status = 'publish'
        			 AND DATE_FORMAT(post_date,'%Y') = ".get_the_time('Y')."
        			 ORDER BY post_date DESC";
		$relatedPosts = $wpdb->get_results($query, OBJECT);
		if ( $relatedPosts )
		{
		?>
		<div class="col-md-5 news-sidebar">
		<?php
			foreach ( $relatedPosts as $post )
			{
				setup_postdata( $post );
				?>
					<h4 class="news-title-sidebar">
						<span class="text-muted news-date-sidebar"><?php the_time('Y m d') ?> - </span>
						<a class="wp-green-color" href="<?php the_permalink(); ?>" rel="bookmark" title="Permalink: <?php the_title(); ?>">
							<?php the_title(); ?>
						</a>
					</h4>
				<?php
			}
		?>
		</div>
		<?php
		}
        ?>


	</div>

</div>

<?php get_footer(); ?>