I have two tables: #Favorites# content_type_id (INT) object_id (INT) ^unique together^ #ChangeLog# content_type_id (INT) object_id (INT) change_time (DATETIME) I want to select all from favorites, and join them with changelog, order the changelog descending, and then group it.