| describe recentchanges |
3 years ago |
| SHOW INDEX IN recentchanges |
3 years ago |
| SELECT
rc_actor,
DAYOFWEEK(rc_timestamp) AS day,
... |
3 years ago |
| SELECT
rc_actor,
COUNT(*) AS total,
SUM(
CASE
WHEN... |
3 years ago |
| select count(*) from page where page_namespace = 0 and page_is_redirect = 0 |
3 years ago |
| select sum(*) from page where page_namespace = 0 and page_is_redirect = 0 |
3 years ago |
| select * from site_stats |
3 years ago |
| select distinct(ug_group) from user_groups |
3 years ago |
| select * from user_groups |
3 years ago |
