Emulate history of [[Anarchism]]

SQL

SELECT timestamp(rev1.rev_timestamp), actor_name, rev1.rev_len, (CAST(rev1.rev_len AS SIGNED) - rev2.rev_len) 'diff', comment_text, group_concat( ctd_name SEPARATOR ', ' ) 'tags'
FROM page
JOIN revision rev1 on rev1.rev_page = page_id
JOIN revision rev2 on rev1.rev_parent_id = rev2.rev_id
JOIN actor on actor_id = rev1.rev_actor
JOIN comment on comment_id = rev1.rev_comment_id
JOIN change_tag on ct_rev_id = rev1.rev_id
JOIN change_tag_def on ct_tag_id = ctd_id
WHERE page_namespace = 0 AND page_title = 'Anarchism'
GROUP BY rev1.rev_id
ORDER BY rev1.rev_timestamp desc
LIMIT 30;
SQL

Checking query status...
