Order by max date

Submitted by Derick Ng on 16 January 2010 - 12:35pm

Hello,

How would I go about ordering threads by max date in the comments table?

I have the relationships
User hasMany Forum
User hasMany Comment
Forum hasMany Comment

After having a go with containable my array looks like:

{{{
Array
(
[0] => Array
(
[Forum] => Array
(
[id] => 1
[user_id] => 2