<?php
/**
 * Template Name: Trending
 *
 * List Biography of those whose birthday is today
 *
 * @link https://codex.wordpress.org/Template_Hierarchy
 *
 * @package bio
 */
?>
<?php
$title = 'Trending';
$year_month= date("YM");
$querystr = "
                SELECT wp.* ,wv.count
                FROM wp_posts wp 
                LEFT JOIN wp_post_views wv ON wv.id = wp.ID
                WHERE wv.type = 2
                AND wv.period= '$year_month'
                AND wp.post_status = 'publish'
                AND wp.post_type = 'post'
                AND wp.post_date < NOW()
                ORDER BY wv.count DESC
                LIMIT 100
             ";
$loop = new WP_Query($querystr);

?>
<?php get_header(); ?>
    <div class="page-wrapper">
        <div class="list-page archive-page">
            <div class="container people-list todays-birthdays">
                <div class="row list-title-sub">
                    <div class="col-xs-12 text-center">
                        <h3 class="page-title"><?php echo $title;?></h3>
                    </div>
                </div>
                <div class="row">
                    <?php if ( $loop->have_posts() ) : ?>
                        <?php while ( $loop->have_posts() ) : $loop->the_post();?>
                            <?php hm_get_template_part('parts/content-single',array('show_category'=>true));?>
                        <?php endwhile;
                           wp_reset_postdata();
                        ?>
                    <?php else:?>
                    <div class="alert text-center">
                        No data found !!!
                    </div>
                    <?php endif;?>
                </div>
            </div>
        </div>
    </div>

<?php get_footer();?>