All revisions with tag

SQL

select rev_timestamp, concat("[[", page_title, "]]") as title, comment_text from 
	(select ct_rev_id from change_tag where ct_tag_id=25) table1 
    INNER JOIN (select rev_page, rev_timestamp, rev_comment_id, rev_id from revision) rev on table1.ct_rev_id = rev.rev_id 
    INNER JOIN (select page_id, page_title from page where page_namespace = 0) table2 on rev.rev_page = table2.page_id
    INNER JOIN (select comment_text, comment_id from comment) table3 on table3.comment_id = rev.rev_comment_id
    ORDER BY rev_timestamp DESC
    LIMIT 100
SQL

Checking query status...
