there are few SQLs which is incompatible with LIMIT clause so that it returns Syntax error.
One of user executed
SELECT athlete, score FROM history
ORDER BY score FOR ORDERBY_NUM() BETWEEN 3 AND 5;
However CWM put LIMIT 100 in the end of query thereore the user encountered -493 syntax error.
Please follow CM/CQB's pagination.