<?php
/**
 * Template Name: Most Popular
 *
 * List Biography of those whose birthday is today
 *
 * @link https://codex.wordpress.org/Template_Hierarchy
 *
 * @package bio
 */
?>
<?php
$title = 'Most Popular';
$year_week= date("YW");
$querystr = "
                SELECT wp.* ,wv.count
                FROM wp_posts wp 
                LEFT JOIN wp_post_views wv ON wv.id = wp.ID
                WHERE wv.type = 1
                AND wv.period= '$year_week'
                AND wp.post_status = 'publish'
                AND wp.post_type = 'post'
                AND wp.post_date < NOW()
                ORDER BY wv.count DESC
                LIMIT 40
             ";
$loop = new WP_Query($querystr);
$rank = 1;
?>
<?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, 'rank'=>$rank++));?>
                        <?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();?>