What version of MySQL are you using? It probably doesn't like the sub-query syntax that's being used.

Try disabling modules, one by one, until the error message goes away. I'd start with the contrib modules because I can't find that query in any code on my test site.