Revert "NH-3336 - Fix error "MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery" by wrapping queries with limits into subquery"

This reverts commit 24ee723edcca03a02bda7167796af50456d9a22d.