-- |
1 year ago |
USE commonswiki_p;
SELECT page_title, rev_timestamp, rev_len
FROM page
JOIN... |
1 year ago |
USE commonswiki_p;
SELECT page_title, rev_timestamp, rev_len
FROM page
JOIN... |
1 year ago |
USE commonswiki_p;
SELECT page_title, rev_timestamp, rev_len, comment
FROM... |
1 year ago |
USE commonswiki_p;
SELECT page_title, rev_timestamp, rev_len,... |
1 year ago |
USE commonswiki_p;
SELECT page_title, rev_timestamp, rev_user_text,... |
1 year ago |
USE commonswiki_p;
SELECT rc_title, rc_timestamp, rc_user, rc_size,... |
1 year ago |
USE commonswiki_p;
SELECT rc_title, rc_timestamp, rc_user, rc_size,... |
1 year ago |
USE commonswiki_p;
SELECT rc_title, rc_timestamp, rc_user_text, rc_size,... |
1 year ago |
SELECT COUNT(*) as undo_count
FROM revision
JOIN change_tag
ON rev_id =... |
1 year ago |
-- |
1 year ago |
SELECT actor_name as user,
COUNT(*) as total_revisions,
... |
1 year ago |
SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON... |
1 year ago |
SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON... |
1 year ago |
SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON... |
3 years ago |
SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON... |
3 years ago |