Aici găsești punctajele de la jocul de șah de pe site.
|
Nume |
Niv |
Pct |
C |
R |
P |
A |
Pr |
error sql= SELECT * FROM ( SELECT * FROM top_sah where puncte>0 ORDER BY nivel DESC ) AS t1
GROUP BY nume ORDER BY nivel DESC, puncte desc -> Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't1.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by