Re: Making query ONLY_FULL_GROUP_BY compatible

[Peter Brawley]

If `name` has dupes, there are matching description dupes too. How do you wish to handle that?

If there are no name dupes ...

select x.id_category, c.name, c.description
from category_table c
join (
  select id_category, max(name) as maxname 
  from category_table 
  where id_lang=1 
  group by id_category 
) x on c.name=x.maxname
order by c.name;