SQL语法，我做错了什么？

I have the following syntax, and all runs fine except for "LIMIT". All the results of the database display when only 9 results should. I have the "0, 9" coming from variables so they will change on each paginated link (ex. 0, 9; 10, 18; 19, 27; etc.). I checked and rechecked my syntax and I don't understand why all the results would show. Below is the exact query I'm testing.I have the following syntax, and all runs fine