MySQL Error!
MySQL error in file: /engine/cache/system/plugins/dd7cc994d613d6495f669dc673edbaba.php at line 99
Error Number: 1054
The Error returned was:
Unknown column 'f.xf_rand' in 'order clause'
SQL query:
SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason FROM dle_post p LEFT JOIN dle_post_extras e ON (p.id=e.news_id) LEFT JOIN dle_dle_filter_news f ON (p.id=f.newsId) JOIN (SELECT d.id FROM dle_post d LEFT JOIN dle_post_extras e ON (d.id=e.news_id) INNER JOIN (SELECT dle_post_extras_cats.news_id, GROUP_CONCAT(dle_post_extras_cats.cat_id) as ci FROM dle_post_extras_cats GROUP BY news_id HAVING (FIND_IN_SET('1', ci) > 0)) z ON (d.id=z.news_id) LEFT JOIN dle_dle_filter_news f ON (d.id=f.newsId) WHERE approve=1 AND date < '2024-10-04 10:25:42' ORDER BY f.`xf_rand` desc LIMIT 0,30) as l ON p.id=l.id ORDER BY f.`xf_rand` desc