wpDataTables Automatic ‘LIMIT 10’ Syntax Error

I’m creating a data table via SQL query and am getting the following error:

‘MySQL said: 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 ‘LIMIT 10′ at line 91’

However, I’m not including a LIMIT function anywhere in my query – it looks like the limit is being automatically added. Below is the end of the SQL script that wpDataTables returns to me as part of the error

‘; LIMIT 10’

How can i stop wp from adding this limit to my query that causes a syntax error