How to select fields of a contained association?
<p>I would like to execute the following query where I'd like to read only the necessary fields from associated.<br>
I used a dot notation in <code>select()</code> below to better explain what I want.<br>
Basically the <code>select()</code> seems to concern <code>Users</code> only. Is it possible to specify the fields of <code>Sites</code>?</p>

<pre><code>$orders = $this-&gt;Orders-&gt;find()
    -&gt;contain([
        'Sites.Users'=&gt; function ($q) {
            return $q
                -&gt;select([
                    'Sites.id',
                    'Sites.user_id',
                    'Users.id',
                    'Users.name',
                    'Users.owner_id',
                    'Users.firstname',
                    'Users.lastname'
                ])
                -&gt;autoFields(false);
        },
    ])
    -&gt;first();
</code></pre>