DB Error: unknown errorselect DISTINCT DATE_FORMAT(nw.date,'%Y') as year from fsp_news as nw inner join fsp_items as nl on nw.id = nl.item_id where nl.parent_id = '218' and is_published = 1 and status = 0 and nw.date ORDER by date DESC [nativecode=3065 ** Expression #1 of ORDER BY clause is not in SELECT list, references column 'host1028_1.nw.date' which is not in SELECT list; this is incompatible with DISTINCT]