来自其他两个表的条款排序

I have a table RecentChanges which holds reference to all actions done on my website. It contains the Type of the action done (e.g. edit, upload, etc.), a Revision ID foreign key (which references to the ID in the which holds refere