Sort subtable query result - Cakephp 4

[d_php]

I am trying to sort the subquery (joined table) result by using order by id DESC. I am unable to implement this.

I used the following query to sort Table2 in DESC order by id, which is not correct.

$result = $this->Table->find('all', ['contain' => ['Table2' => ['order' => ['id' => 'desc']]]])->where(['col1' => $col1, 'col2' => $col2])->order(["col3" => 'desc'])->toArray();

 

Is there any other way available?

[Barand]

What is the actual SQL query that is generated by those incantations?

PS What RDBMS are you using?

Edited October 26, 2021 by Barand

[ginerjm]

Not sure I have the full picture from your posted text, but I certainly don't know what your query is supposed to look like.  From your text, your reference to a 'sub-query' might mean one of the tables in your total query which is joined to the main table and that you want that one table 'sorted'.  Why?  It is not the result.  It is only a source of data that will comprise the final result and THAT can already be sorted.  

So - what is the real problem?