limits in subqueries break SQL (at least in current mysql)
I think this may be fixed. would have to test...