Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank, sum(GREATEST(likes,0)) as likes, sum(GREATEST(dislikes,0)) as dislikes, su' at line 1
Whole query: select creatorid, creator, sum(_rankPlay) as rank, sum(GREATEST(likes,0)) as likes, sum(GREATEST(dislikes,0)) as dislikes, sum(GREATEST(nlikes,0)) as nlikes, count(*) as adventures, sum(reported > -1) as rep, sum(completed) as completed, sum(plays) as plays from adventures where bypass = 0 and reported < 0 and reported > -10 and (creatorid not in ('3SPROCKETS', '76561198005976731')) group by creatorid order by rank desc, plays desc limit 100