Invalid query: Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jayisgames.i.icon_basename' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Whole query: SELECT
e.entry_id AS id,
e.entry_blog_id AS blogId,
e.entry_title AS title,
e.entry_excerpt AS excerpt,
e.entry_authored_on AS authoredOn,
i.icon_basename AS iconBasename,
fi.fileinfo_url AS url,
r.ajaxrating_votesummary_vote_count AS voteCount,
IF(r.ajaxrating_votesummary_vote_count = 0,-1,IF(r.ajaxrating_votesummary_vote_count < 20,0,TRUNCATE((r.ajaxrating_votesummary_total_score / r.ajaxrating_votesummary_vote_count),2))) AS rating,
c.category_basename AS categoryName,
em.entry_meta_vchar_idx AS gamesFeatured
FROM mt_objecttag AS o
JOIN mt_tag AS t ON t.tag_id = o.objecttag_tag_id
JOIN mt_entry AS e ON e.entry_id = o.objecttag_object_id AND e.entry_blog_id = o.objecttag_blog_id
JOIN mt_placement AS p ON placement_entry_id = e.entry_id
LEFT JOIN mt_category AS c ON placement_category_id = category_id
LEFT JOIN icons AS i ON (e.entry_id = i.icon_id)
LEFT JOIN mt_fileinfo AS fi ON (fi.fileinfo_entry_id = e.entry_id)
LEFT JOIN mt_ajaxrating_votesummary AS r ON (e.entry_id = r.ajaxrating_votesummary_obj_id)
LEFT JOIN mt_entry_meta AS em ON (e.entry_id = em.entry_meta_entry_id AND entry_meta_type like 'field.games_featured')
WHERE
o.objecttag_blog_id = 1
AND o.objecttag_object_datasource = 'entry'
AND e.entry_status = 2
AND p.placement_is_primary = 1
AND t.tag_name IN ('free', 'indie', 'visualnovel')
AND fi.fileinfo_templatemap_id = 31
GROUP BY o.objecttag_object_id HAVING COUNT(DISTINCT t.tag_name) = 3
ORDER BY e.entry_authored_on DESC, rating DESC, r.ajaxrating_votesummary_vote_count DESC