A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and ru.gender = 'M' AND r.date <= NOW() group by runner_id order by sum(w' at line 10

select lastName,firstName,sum(wavaPoints) as total, ru.gender,runner_id, conv(sum( IF( wavaPoints = 50, 68719476736, IF( wavaPoints = 49, 4294967296, IF( wavaPoints = 48, 268435456, IF( wavaPoints = 47, 16777216, IF( wavaPoints = 46, 1048576, IF( wavaPoints = 45, 65536, IF( wavaPoints = 44, 4096, IF( wavaPoints = 43, 256, IF( wavaPoints = 42, 16, IF( wavaPoints = 41, 1, 0))))))))))),10,16) as countback , group_concat(r.title ORDER BY r.date SEPARATOR '|') as raceNames, group_concat(r.id ORDER BY r.date SEPARATOR '|') as raceIds, group_concat(wavaPoints ORDER BY r.date SEPARATOR '|') as racePts, group_concat(wavaTime ORDER BY r.date SEPARATOR '|') as raceTimes from runnerraces rr join races r on r.id = rr.race_id AND r.hasChild = 0 join runners ru on rr.runner_id = ru.id where season_id = and ru.gender = 'M' AND r.date <= NOW() group by runner_id order by sum(wavaPoints) desc, countback desc, r.date

Filename: controllers/Racedata.php

Line Number: 87