| USE zhwiki_p;
SELECT *
FROM recentchanges
WHERE rc_type = 0 AND rc_timestamp... |
4 years ago |
| USE zhwiki_p;
SELECT *
FROM recentchanges
WHERE rc_type = 0
ORDER BY... |
4 years ago |
| USE zhwiki_p;
SELECT *
FROM recentchanges
ORDER BY rc_timestamp DESC
LIMIT 10 |
4 years ago |
| USE zhwiki_p;
SELECT rc_timestamp, rc_namespace, rc_title, actor_name
FROM... |
5 years ago |
| USE zhwiki_p;
SELECT rc_timestamp, rc_namespace, rc_title, actor_name
FROM... |
5 years ago |
| USE zhwiki_p;
SELECT rc_timestamp, rc_namespace, rc_title, user_name,... |
5 years ago |
| USE zhwiki_p;
SELECT rc_timestamp, rc_namespace, rc_title, user_name
FROM... |
5 years ago |
| USE zhwiki_p;
SELECT rc_namespace, rc_title, user_name
FROM (
SELECT *
FROM... |
5 years ago |
| USE zhwiki_p;
SELECT *
FROM recentchanges
WHERE rc_type IN (0, 1)
LIMIT 100 |
5 years ago |
| USE zhwiki_p;
SELECT *
FROM recentchanges
LIMIT 100 |
5 years ago |
