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 = '127'
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