select * from (
select page_title, count(*) as user_edits,... |
3 years ago |
select sub.page_title, ip_edits, sum(user_edits) + ip_edits as... |
3 years ago |
select sub.page_title, ip_edits, sum(user_edits) + ip_edits as... |
3 years ago |
select sub.page_title, sum(user_edits) + ip_edits as "num_revisions",... |
3 years ago |
select sub.page_title, sum(user_edits) as "num_revisions", count(*) as... |
3 years ago |
select sub.page_title, sub.num_revisions, count(*) as "num_editors" from (
... |
3 years ago |
select sub.page_title, count(*) as "num_editors" from (
select page_title,... |
3 years ago |
select page_title, count(*) as "num_editors" from (
select page_title,... |
3 years ago |
select page_title as "Title", count(*) as "Number of editors" from... |
3 years ago |
select page_title as "Title", count(*) as "Number of editors" from... |
3 years ago |
select page_title, count(*) from page
join revision on rev_page =... |
3 years ago |
select * from page
where page_namespace = 108
and page_is_redirect = 0 |
3 years ago |
select * from page
where page_namespace = 108
where page_is_redirect = 0 |
3 years ago |
select * from page
where page_namespace = 108 |
3 years ago |