| -- denominator
select count(*) as denominator
from page
where
... |
3 years ago |
| select count(*)
from page
where
page_namespace = 0
and page_is_redirect... |
3 years ago |
| select count(*)
from page
where
page_namespace = 0
and page_is_redirect... |
3 years ago |
| select count(*)
from page
where
page_namespace = 0
and page_is_redirect... |
3 years ago |
| select count(*)
from page
where
page_namespace = 0
and page_is_redirect = 0 |
3 years ago |
| select count(*)
from page
where page_namepsace = 0
and page_is_redirect = 0 |
3 years ago |
| use fawiki_p;
select d.*
from
(
select
actor_name,
count(*) cnt
... |
4 years ago |
| use fawiki_p;
select d.*
from
(
select actor_name, count(*) cnt
from... |
4 years ago |
| use fawiki_p;
select actor_name, count(*)
from actor
join user_groups
on... |
4 years ago |
| use fawiki_p;
select actor_name, count(*)
from actor
join user_groups
on... |
4 years ago |
| use fawiki_p;
select actor_name, page_title
from actor
join user_groups
on... |
4 years ago |
| use fawiki_p;
select actor_name
from actor
join user_groups
on ug_user =... |
4 years ago |
| use fawiki_p;
select actor_name
from actor
join user_groups
on ug_user =... |
4 years ago |
| use fawiki_p;
select actor_name
from actor
join user_group
on ug_user =... |
4 years ago |
