Топ 30 вопросов за 30 дней

MySQL Error!
MySQL error in file: \engine\modules\search.php at line 775
Error Number: 1054
The Error returned was:
Unknown column 'p.date' in 'where clause'
SQL query:

SELECT * FROM dle_post WHERE dle_post.approve = 1 AND p.date < '2026-02-16 08:20:32' AND ( title LIKE '%%' OR xfields LIKE '%new|%' OR xfields LIKE '%year|%' ) ORDER BY date DESC LIMIT 5

$sql_request = "$sql_find AND (
		title LIKE '%{$query}%'
		OR xfields LIKE '%genre|{$query}%'
		OR xfields LIKE '%year|{$query}%'
	) ORDER BY $order_by LIMIT $search_start,{$config['search_number']}";

$db->query("
	SELECT * FROM " . PREFIX . "_post 
	WHERE " . PREFIX . "_post.approve = 1 
	{$this_date}
	AND (
		title LIKE '%{$query}%'
		OR xfields LIKE '%new|{$query}%'
		OR xfields LIKE '%year|{$query}%'
	)
	ORDER BY date DESC
	LIMIT 5
");