SELECT rev_id, rev_timestamp
FROM revision
WHERE rev_timestamp <... |
1 year ago |
SELECT rev_id, rev_timestamp
FROM revision
WHERE rev_timestamp <... |
1 year ago |
SELECT rev_id, rev_timestamp
FROM revision
WHERE rev_timestamp <... |
1 year ago |
SELECT rev_id, rev_timestamp
FROM revision
WHERE rev_timestamp <... |
1 year ago |
SELECT rev_id, rev_timestamp, rev_actor, page_title, rev_len
FROM... |
1 year ago |
SELECT rev_id, rev_timestamp, rev_actor, page_title, rev_len
FROM... |
1 year ago |
SELECT *
FROM revision
LEFT JOIN page ON rev_page = page_id
WHERE... |
1 year ago |
SELECT COUNT(*)
FROM revision
LEFT JOIN page ON rev_page = page_id
WHERE... |
2 years ago |
SELECT COUNT(*)
FROM revision
LEFT JOIN page ON rev_page = page_id
WHERE... |
2 years ago |
SELECT COUNT(*)
FROM revision
LEFT JOIN page ON rev_page = page_id
WHERE... |
2 years ago |
SELECT rev_timestamp, rev_id
FROM revision
WHERE rev_timestamp <... |
2 years ago |
SELECT rev_timestamp, rev_id, rev_parent_id
FROM revision
WHERE rev_page =... |
2 years ago |
SELECT *
FROM revision
WHERE rev_page = 3818611 |
2 years ago |
SELECT *
FROM page
WHERE page_id IN (
SELECT DISTINCT rev_page
FROM... |
2 years ago |
SELECT rev_id, rev_page, rev_timestamp, rev_sha1, rev_actor, actor_user,... |
2 years ago |
SET @pages := (SELECT DISTINCT rev_page
FROM revision
LEFT JOIN page ON... |
2 years ago |
SELECT rev_id, rev_page, rev_timestamp, rev_sha1, rev_actor, actor_user,... |
2 years ago |
SELECT rev_id, rev_page, rev_timestamp, rev_sha1, rev_actor, actor_user,... |
2 years ago |
SELECT rev1.rev_id, rev1.rev_page, rev1.rev_timestamp, rev1.rev_sha1,... |
2 years ago |
SELECT rev1.rev_id, rev1.rev_page, rev1.rev_timestamp, rev1.rev_sha1,... |
2 years ago |
SELECT rev1.rev_id, rev1.rev_page, rev1.rev_timestamp, rev1.rev_sha1,... |
2 years ago |
SELECT rev1.rev_id, rev1.rev_page, rev1.rev_timestamp, rev1.rev_sha1,... |
2 years ago |
SELECT rev1.rev_id, rev1.rev_page, rev1.rev_timestamp, rev1.rev_sha1,... |
2 years ago |
SELECT rev_id, rev_page, rev_timestamp, rev_sha1, rev_actor
FROM... |
2 years ago |
SELECT rev_id, rev_page, rev_timestamp, rev_sha1 #, actor_id, actor_user,... |
2 years ago |
SELECT rev_id, rev_page, rev_timestamp, rev_sha1, actor_id, actor_user,... |
2 years ago |
SELECT *
FROM revision
LEFT JOIN actor ON rev_actor = actor_id
WHERE... |
2 years ago |
SELECT rev_id
FROM revision
LEFT JOIN actor ON rev_actor = actor_id
WHERE... |
2 years ago |
SELECT rev_id
FROM revision
LEFT JOIN actor ON rev_actor = actor_id
WHERE... |
2 years ago |
SELECT *
FROM revision
#LEFT JOIN actor ON rev_actor = actor_id
WHERE... |
2 years ago |
SELECT *
FROM revision
#LEFT JOIN actor ON rev_actor = actor_id
WHERE... |
2 years ago |
SELECT *
FROM revision
LEFT JOIN actor ON rev_actor = actor_id
WHERE... |
2 years ago |
SELECT *
FROM revision
LEFT JOIN actor ON rev_actor = actor_id
WHERE... |
2 years ago |
SELECT *
FROM revision
LEFT JOIN actor ON rev_actor = actor_id
WHERE... |
2 years ago |
SELECT *
FROM revision
LEFT JOIN actor ON rev_actor = actor_id
WHERE... |
2 years ago |
SELECT *
FROM revision
#LEFT JOIN actor ON rev_actor = actor_id
WHERE... |
2 years ago |
SELECT *
FROM revision
#LEFT JOIN actor ON rev_actor = actor_id
WHERE
#... |
3 years ago |
SELECT *
FROM revision
#LEFT JOIN actor ON rev_actor = actor_id
WHERE
#... |
3 years ago |
USE zhwiki_p;
SELECT *
FROM revision
#LEFT JOIN actor ON rev_actor =... |
4 years ago |
USE zhwiki_p;
SELECT *
FROM revision
#LEFT JOIN actor ON rev_actor =... |
4 years ago |
USE zhwiki_p;
SELECT *
FROM revision
#LEFT JOIN actor ON rev_actor =... |
4 years ago |
USE zhwiki_p;
SELECT *
FROM revision
#LEFT JOIN actor ON rev_actor =... |
4 years ago |
USE zhwiki_p;
SELECT *
FROM revision
LEFT JOIN actor ON rev_actor =... |
4 years ago |
USE zhwiki_p;
SELECT *
FROM revision
LEFT JOIN actor ON rev_actor =... |
4 years ago |
USE zhwiki_p;
SELECT *
FROM revision
WHERE rev_actor IS NULL
ORDER BY... |
4 years ago |
USE zhwiki_p;
SELECT *
FROM revision
#WHERE rev_actor = 127
ORDER BY... |
4 years ago |
USE zhwiki_p;
SELECT *
FROM revision
#WHERE rev_actor = 127
LIMIT 10
ORDER... |
4 years ago |
USE zhwiktionary_p;
SELECT COUNT(*)
FROM revision
WHERE rev_actor = 127
|
5 years ago |
USE zhwiktionary_p;
SELECT * # COUNT(*)
FROM revision
# WHERE rev_actor =... |
5 years ago |
USE zhwiktionary_p;
SELECT * # COUNT(*)
FROM revision
WHERE rev_actor =... |
5 years ago |
USE zhwiktionary_p;
SELECT COUNT(*)
FROM revision
WHERE rev_actor = 60065
|
5 years ago |
USE zhwiktionary_p;
SELECT COUNT(*)
FROM revision
WHERE rev_actor = 60065
|
5 years ago |
USE zhwiktionary_p;
SELECT *
FROM revision
WHERE rev_actor = 60065
LIMIT 10; |
5 years ago |
USE zhwiktionary_p;
SELECT *
FROM revision_actor_temp
LIMIT 100;
SELECT... |
5 years ago |
USE zhwiktionary_p;
SELECT *
FROM revision_actor_temp
WHERE revactor_actor =... |
5 years ago |
USE zhwiktionary_p;
SELECT *
FROM revision_actor_temp
WHERE revactor_actor =... |
5 years ago |
USE zhwiktionary_p;
SELECT *
FROM revision_actor_temp
WHERE revactor_actor =... |
5 years ago |
USE zhwiktionary_p;
SELECT *
FROM revision
ORDER BY rev_id DESC
LIMIT 100 |
5 years ago |
USE zhwiki_p;
SELECT *
FROM revision
ORDER BY rev_id DESC
LIMIT 100 |
5 years ago |