| SELECT COUNT(*)
FROM revision
LEFT JOIN page ON rev_page = page_id
... |
1 year ago |
| SELECT COUNT(*)
FROM user
|
1 year ago |
| SELECT COUNT(*)
FROM user
WHERE user_editcount = 0
|
1 year ago |
| SELECT actor_id, actor_user
FROM actor
WHERE actor_user IS NOT NULL
|
1 year ago |
| SELECT COUNT(*)
FROM user
|
1 year ago |
| SELECT COUNT(*)
FROM revision AS rev1
WHERE EXISTS
(SELECT rev_id FROM... |
1 year ago |
| SELECT COUNT(*)
FROM page
WHERE page_namespace = 0
/*
WHERE rev_timestamp >=... |
1 year ago |
| SELECT COUNT(*)
FROM actor
/*
WHERE rev_timestamp >= 20220601000000
AND... |
1 year ago |
| SELECT COUNT(*)
FROM page
/*
WHERE rev_timestamp >= 20220601000000
AND... |
1 year ago |
| SELECT COUNT(*)
FROM revision
WHERE rev_timestamp >= 20220601000000
AND... |
1 year ago |
| SELECT COUNT(*)
FROM revision |
1 year ago |
| SELECT COUNT(*) |
1 year ago |
| SELECT *
FROM revision
WHERE rev_timestamp >= 20220601000000
AND... |
1 year ago |
| SELECT * # COUNT(*)
FROM revision_actor_temp
# WHERE rev_actor = 60065
LIMIT 10 |
1 year ago |
| USE zhwiktionary_p;
SELECT * # COUNT(*)
FROM revision_actor_temp
# WHERE... |
4 years ago |
| USE zhwiktionary_p;
SELECT * # COUNT(*)
FROM revision
# WHERE rev_actor =... |
4 years ago |
