Is it possible to bypass the limitation in mysql?

Question

MySQL

SELECT `data` FROM `table` WHERE `id` 
IN (SELECT `data2` FROM `table2` ORDER BY `user` DESC LIMIT 0,20)

Error: #1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
I realized that he doesn't like LIMIT in a subquery, can I get around this by changing the subquery or do I have to split it into 2 queries?

Answer 1

Can be bypassed