[gnrx]

Hello.
Thank for your reply and help.

I run the exact command from phpmyadmin:

SELECT champ_gid AS GID, champ_mid AS MID, champ_name AS name, COUNT(champ_mid) AS total FROM games_champs GROUP BY MID ORDER BY total DESC LIMIT 3

In phpmyadmin-SQL-Execute queries.
This is the result:

Error
consulta SQL: Documentaci?n

SELECT champ_gid AS GID, champ_mid AS MID, champ_name AS name, COUNT(champ_mid) AS total FROM games_champs GROUP BY MID ORDER BY total DESC LIMIT 3

MySQL ha dicho: Documentaci?n

#1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'MYUSER_MYDB.games_champs.champ_gid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

After this, continue the issue.
And yes, by phpmyadmin, can browse the table games_champs.

Regards!!