Fork of Offensive usernames by Cabayi
This query is marked as a draft This query has been published by Cabayi.

SQL

​x
 
select   rv.rev_id, cmt.comment_text, ctd.ctd_name
from     revision rv, comment cmt, change_tag ct, change_tag_def ctd
where    rv.rev_comment_id = cmt.comment_id
and      rv.rev_id IN (
       SELECT ct_rev_id
       FROM change_tag
       ORDER BY ct_rev_id desc
       LIMIT 10 )
AND      ct.ct_rev_id = rv.rev_id
and      ctd.ctd_id = ct.ct_tag_id
​
​
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
All SQL code is licensed under CC0 License.

Checking query status...