SELECT   rv.rev_id, ct.ct_rev_id, cmt.comment_text, ctd.ctd_name

FROM     revision rv, comment cmt, change_tag_def ctd, change_tag ct

WHERE    rv.rev_id > (SELECT max(ct_rev_id) - 20

                      FROM   change_tag )

AND      rv.rev_comment_id = cmt.comment_id

AND      rv.rev_id = ct.ct_rev_id

AND      ctd.ctd_id = ct.ct_tag_id

AND      cmt.comment_text IS NOT NULL

ORDER BY rev_id DESC

LIMIT 10

​