testuję takjei zapytanie w PhpMyAdmin:
SELECT SUM(pkt) AS points, riders.id FROM points LEFT JOIN riders ON id_zawodnika = riders.id WHERE `mecz`=129 AND points.klub=1 AND SUM(pkt)<9 LIMIT 1
I otrzymuje błąd:
#1111 - Invalid use of group function
SELECT SUM(pkt) AS points, riders.id FROM points LEFT JOIN riders ON id_zawodnika = riders.id WHERE `mecz`=129 AND points.klub=1 AND SUM(pkt)<9 LIMIT 1
#1111 - Invalid use of group function