Как вывести новости в топ за отдельный промежуток времени по просмотрам из числа всех новостей?

ALTER TABLE `dle_post_extras` ADD `day_read` INT( 6 ) NOT NULL DEFAULT '0';

        if ($match[1] == "title" ) $news_msort = "ASC";

        if ($match[1] == "day_read" ){
            $sql_select = str_replace("e.news_read, ","e.news_read, e.day_read, ",$sql_select);
            $news_sort = $match[1]." DESC, news_read";
        }

e.editor, e.reason

e.editor, e.reason, e.day_read

news_read=news_read+1

news_read=news_read+1, day_read=day_read+1

    $db->query( "SELECT p.id, p.date, p.short_story, p.xfields, p.title, p.category, p.alt_name FROM " . PREFIX . "_post p LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) WHERE p.approve=1 AND p.date >= '$this_month' - INTERVAL 1 MONTH AND p.date < '$this_month' ORDER BY rating DESC, comm_num DESC, news_read DESC, date DESC LIMIT 0,{$config['top_number']}" );

    $db->query( "SELECT p.id, p.date, p.short_story, p.xfields, p.title, p.category, p.alt_name FROM " . PREFIX . "_post p LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) WHERE p.approve=1  AND (DATE_FORMAT(p.date, '%Y%m%d')<=CURDATE()){$not_add_to_top}ORDER BY day_read DESC, date DESC LIMIT 0,{$config['top_number']}" );

if( $cron == 2 ) {

    $db->query( "UPDATE " . PREFIX . "_post_extras SET day_read=0" );

{topnews}