SELECT
  DISTINCT(RevisionContent.parent_record_id), RevisionContent.id
FROM revisions_content AS RevisionContent
WHERE RevisionContent.module_id=3
ORDER BY RevisionContent.revision DESC