Error!

MySQL Error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rodpub_beta.heaps.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL Statement: SELECT contents.title, heaps.id FROM heaps JOIN heap_contents on heap_contents.heap_id='8835' join contents on contents.id = heap_contents.content_id WHERE heap_type_id = 19 AND heaps.published = 1 AND heaps.publish_date>CURDATE() group by contents.id ORDER BY heap_contents.priority desc 日本人的色道