При использовании поиска на сайте выдаёт:
MySQL Error!
------------------------
The Error returned was:
Column 'rating' in field list is ambiguous
Error Number:
1052
Код:
SELECT SQL_CALC_FOUND_ROWS id, autor, dle_post.date AS newsdate, dle_post.date AS date, short_story AS story, dle_post.xfields AS xfields, title, descr, keywords, category, alt_name, comm_num AS comm_in_news, allow_comm, rating, news_read, editdate, editor, reason, view_edit, tags, '' AS output_comms FROM dle_post LEFT JOIN dle_post_extras ON (dle_post.id=dle_post_extras.news_id) WHERE dle_post.approve=1 AND dle_post.date < '2012-10-15 21:26:29' AND (short_story LIKE '%интерны%' OR full_story LIKE '%интерны%' OR xfields LIKE '%интерны%' OR title LIKE '%интерны%') ORDER BY date desc LIMIT 0,11
Из за чего это?
Что делать?