cakephp/cakephp — pull request #4591 by lorenzo (2014-09-12 16:08:01+00:00)
Title: 3.0 - Reimplement the subquery selection strategy

This rewrite addresses the problem of not being able to use limit and offset under some circumstances in Mysql. Previously data was fetched using a query similar to this:

```sql
select from comments where article_id in (select id from articles);
```
After this change queries will look like this:

```sql
select from comments inner join (select id from articles) articles where article_id = articles.id;
```

Fixes https://github.com/cakephp/cakephp/issues/4576