| SELECT * -- min(rc_this_oldid)
FROM recentchanges
WHERE rc_timestamp >... |
2 years ago |
| SELECT min(rc_this_oldid)
FROM recentchanges
WHERE rc_timestamp >... |
2 years ago |
| SELECT min(rc_this_oldid)
FROM recentchanges
WHERE rc_timestamp > '20210515000000'
|
2 years ago |
| SELECT *
FROM recentchanges
WHERE rc_timestamp > '20210515000000'
LIMIT 10 |
2 years ago |
| SELECT *
FROM recentchanges
LIMIT 10 |
2 years ago |
| SELECT *
FROM recent_changes
LIMIT 10 |
2 years ago |
| use arwiki_p;
select
page_len_category,
count(*) as freq
from (
... |
5 years ago |
| use fawiki_p;
select count(*) total_pages, sum(page_is_redirect)... |
5 years ago |
| use fawiki_p;
select count(*) total_pages, sum(page_is_redirect) redirects
from page; |
5 years ago |
