Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
select * from (select * from zzrh_tag where catid=3 order by listorder desc ) t group by letter order by listorder desc limit 20