MySQL error in file: /engine/cache/system/plugins/d8c19c9acba88f0df785c1363724ece0.php at line 83

Error Number: 1054

The Error returned was:
Unknown column 'p.id' in 'IN/ALL/ANY subquery'

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('31', ci) > 0 AND FIND_IN_SET('227', 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 p.id NOT IN (SELECT DISTINCT(dle_post_extras_cats.news_id) FROM dle_post_extras_cats WHERE cat_id IN (331)) AND allow_main=1 ORDER BY date desc LIMIT 0,30) as l ON p.id=l.id ORDER BY date desc