SELECT count(*) as total, l.nome, l.seo, m.grupo FROM store_categories_lang as l, store_categories as m WHERE m.id = l.intid AND l.idioma = 3 AND m.id = '167'
In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'siorto_db.l.nome'; this is incompatible with sql_mode=only_full_group_by