{%
	$categoryCounter = 0;

	$categoriesRotatorQuery = $db->query("select * from categories where id in (select category_id from articles) order by `order` ASC");
	while($categoriesRotator = $categoriesRotatorQuery -> fetchArray(SQLITE3_ASSOC)){
	$categoryCounter++;
%}


<div class="politics-news">
	<div class="section-title">
		<h2>{{ $categoriesRotator['name'] }}</h2>
	</div>

	<div class="row">

		{%
			$categoryArticlesQuery = $db->query("select articles.id, articles.category_id, articles.slug as slug, articles.title as title, articles.excerpt as excerpt, articles.image as image, articles.created as created, authors.name as authorname, authors.linkedin as linkedin, authors.slug as authorslug, categories.name as category_name, categories.slug as category_slug from articles, authors, categories where articles.author_id = authors.id and articles.category_id = categories.id and categories.id = " . $categoriesRotator['id'] . " ORDER BY articles.created DESC limit 0,3");
			
			while($categoryArticle = $categoryArticlesQuery -> fetchArray(SQLITE3_ASSOC)){
			if($categoryCounter % 2 == 1) {
		%}

		<div class="col-lg-4 col-md-6">
			<div class="single-politics-news">
				<div class="politics-news-image">
					<a href="{{ $basehost }}/{{ $categoryArticle['category_slug'] }}/{{ $categoryArticle['slug'] }}.html">
						<img src="{{ $basehost }}/data/images/thumb-500-{{ $categoryArticle["image"] }}" alt="image">
					</a>
				</div>

				<div class="politics-news-content">
					<span>{{ $categoryArticle['category_name'] }}</span>
					<h3>
						<a href="{{ $basehost }}/{{ $categoryArticle['category_slug'] }}/{{ $categoryArticle['slug'] }}.html">{{ $categoryArticle['title'] }}</a>
					</h3>
					<p><a href="{{ $basehost }}/author/{{ $categoryArticle['authorslug'] }}/">{{ $categoryArticle['authorname'] }}</a> / {{ date("d F, Y", strtotime($categoryArticle['created'])) }}</p>
				</div>
			</div>
		</div>

		{%
			} else {
		%}

		<div class="col-lg-4 col-md-6">
			<div class="single-business-news">
				<div class="business-news-image">
					<a href="{{ $basehost }}/{{ $categoryArticle['category_slug'] }}/{{ $categoryArticle['slug'] }}.html">
						<img src="{{ $basehost }}/data/images/thumb-610-{{ $categoryArticle["image"] }}" alt="image">
					</a>
				</div>

				<div class="business-news-content">
					<span>{{ $categoryArticle['category_name'] }}</span>
					<h3>
						<a href="{{ $basehost }}/{{ $categoryArticle['category_slug'] }}/{{ $categoryArticle['slug'] }}.html">{{ $categoryArticle['title'] }}</a>
					</h3>
					<p><a href="{{ $basehost }}/author/{{ $categoryArticle['authorslug'] }}/">{{ $categoryArticle['authorname'] }}</a> / {{ date("d F, Y", strtotime($categoryArticle['created'])) }}</p>
				</div>
			</div>
		</div>

		{%
			}		
		%}

		{%
			}
		%}

	</div>
</div>


{%
	}
%}