SELECT *
FROM revision
WHERE rev_deleted != 0
ORDER BY rev_timestamp DESC
LIMIT 100
|
2 years ago |
USE zhwiki_p;
SELECT *
FROM revision
WHERE rev_actor = 8447145
AND... |
3 years ago |
USE zhwiki_p;
SELECT *
FROM revision
WHERE rev_actor = 8447145
ORDER BY... |
3 years ago |
USE zhwiki_p;
SELECT *
FROM revision
WHERE rev_actor = 8447145
ORDER BY... |
3 years ago |
USE zhwiki_p;
SELECT *
FROM revision
WHERE rev_actor = 8447145
LIMIT 1
|
3 years ago |
USE zhwiki_p;
SELECT *
FROM revision
WHERE rev_actor = 8447145
LIMIT 100
|
3 years ago |
USE zhwiki_p;
SELECT *
FROM revision
WHERE rev_actor = 8447145
LIMIT 100
|
3 years ago |
USE zhwiki_p;
SELECT COUNT(*)
FROM revision
WHERE rev_actor = 8447145
LIMIT 100
|
3 years ago |