Emulate history of [[Anarchism]]

SQL

SELECT timestamp(rev1.rev_timestamp) 'date', actor_name, rev1.rev_len,
     (CAST(rev1.rev_len AS SIGNED) - CAST(rev2.rev_len as signed)) 'diff',
     rev1.rev_minor_edit 'minor', rev1.rev_deleted, 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...
