[rich! @ etiviti]

I was looking at this the other day as I noticed a sort can be passed in – but it seems the sort is only applicable to the date_recorded on the parent activity item.

$activities = $wpdb->get_results( $wpdb->prepare( "{$select_sql} {$from_sql} {$where_sql} ORDER BY a.date_recorded {$sort} {$pag_sql}" ) );

(then which append_comments is called to add in the activity replies for each parent activity item)

Though that was a quick look – maybe Andy can chime in if there is a proper way.

I almost think there needs to be a date_modified col which is updated when activity item has a comment – with some option to sort on that and bring it to the top.