HOW to get round MAX_JOIN_SIZE with cakephp v3.x
<p>I am getting this the following MAX_JOIN_SIZE error when I deploy my cakephp v3 app to shared hosting:</p>

<pre><code>    Error: SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
</code></pre>

<p>This seems like a common problem, but can anyone tell me how to get round this when using cakephp v3.x?  I have tried putting the following code in app/src/Model/AppModel.php:</p>

<pre><code>    function beforeFind()   {
        $this-&gt;query('SET SQL_BIG_SELECTS=1');
    }
</code></pre>

<p>but this doesn't seem to have any effect.</p>