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