Untitled query #33020

This query is marked as a draft This query has been published by Cabayi.

SQL

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

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...