Помогите с запросом

В engine.php

// ################ Новости на главной #################

if ($year == '' and $month == '' and $day == '') {

if ($cstart) {

$cstart = $cstart - 1;

$cstart = $cstart * $config['news_number'];

}

$url_page = substr ( $config['http_home_url'], 0, strlen ( $config['http_home_url'] ) - 1 );

$user_query = "";

if (isset ( $view_template ) and $view_template == "rss") {

$sql_select = "SELECT id, autor, date, short_story, full_story, xfields, artist, title, category, alt_name, comm_num, allow_comm, allow_rate, fixed, rating, vote_num, news_read, votes, flag, editdate, editor, reason, view_edit, tags FROM " . PREFIX . "_post WHERE {$stop_list}approve=1";

if ($config['rss_mtype']) {

$sql_select .= " AND allow_main=1";

}

$sql_select .= $where_date . " ORDER BY " . $config['news_sort'] . " " . $config['news_msort'] . " LIMIT 0," . $config['rss_number'];

} else {

if (isset ( $_SESSION['dle_sort_main'] )) $news_sort_by = $_SESSION['dle_sort_main'];

if (isset ( $_SESSION['dle_direction_main'] )) $news_direction_by = $_SESSION['dle_direction_main'];

$sql_select = "SELECT id, autor, date, short_story, SUBSTRING(full_story, 1, 15) as full_story, xfields, artist, title, category, alt_name, comm_num, allow_comm, allow_rate, fixed, rating, vote_num, news_read, votes, flag, editdate, editor, reason, view_edit, tags FROM " . PREFIX . "_post WHERE {$stop_list}approve=1 AND date >= '$this_week' - INTERVAL 1 WEEK AND date < '$this_week' AND allow_main=1" . $where_date . " ORDER BY " . $fixed . $news_sort_by . " " . $news_direction_by . " LIMIT " . $cstart . "," . $config['news_number'];

$sql_count = "SELECT COUNT(*) as count FROM " . PREFIX . "_post WHERE {$stop_list}approve=1 AND date >= '$this_week' - INTERVAL 1 WEEK AND date < '$this_week' AND allow_main=1" . $where_date;

}

}

поставил так только оно не показывает песни за неделю что делать??? на дле 9,3 работало на 9,4 не работает