I am getting empty results when I change the LIMIT clause from LIMIT 0,11 to LIMIT 0,12. It also seems to happen when I add extra columns. For example a LIMIT 0,20 works when I have fewer columns.
No errors are presented. Just seems to give an empty result set.
Pasting the same query into phpmyadmin works fine and returns the entire result set.