Have you printed the complete SQL statement before you try to run it? Most likely the concatenation of your SQL goes wrong somewhere.

My suggestion is to copy the request that Datatables makes from the browser and run your script from the command line with the request parameters. Alternatively, re-run the request, and have your script call die with the SQL statement if you don't have access to your log files.