USE enwiki_p;
SELECT
year,
SUM(CASE WHEN page_title = "Sugar" THEN... |
5 years ago |
USE enwiki_p;
SELECT
year,
SUM(CASE WHEN page_title = "Sugar" THEN... |
5 years ago |
USE enwiki_p;
SELECT
year,
SUM(CASE WHEN page_title = "Sugar" THEN... |
5 years ago |
USE enwiki_p;
SELECT
year,
CASE WHEN page_title = "Sugar" THEN count... |
5 years ago |
USE enwiki_p;
SELECT
year,
CASE WHEN page_title = "Sugar" THEN count... |
5 years ago |
use enwiki_p;
SELECT
page_title,
EXTRACT(year FROM rev_timestamp) AS... |
5 years ago |
use enwiki_p;
select rev_page, case when rev_user = 0 then "non" else... |
5 years ago |
use enwiki_p;
select case when rev_user = 0 then "non" else "user" end as... |
5 years ago |
use enwiki_p;
select case when rev_user = 0 then "non" else "user" end as... |
5 years ago |
use enwiki_p;
select case when rev_user = 0 then "non" else then "user" end... |
5 years ago |
use enwiki_p;
select *
from revision o
where o.rev_page in (1605200)
and... |
5 years ago |
use enwiki_p;
select *
from revision o
where o.rev_page in (1605200)
and... |
5 years ago |
use enwiki_p;
select *
from revision o
where o.rev_page in (1605200)
and... |
5 years ago |
use enwiki_p;
select *
from revision o
where o.rev_page in (1605200)
and... |
5 years ago |
use enwiki_p;
select count(distinct(rev_user)) from revision o
where... |
5 years ago |
use enwiki_p;
select count(distinct(rev_user)) from revision o
where... |
5 years ago |
use enwiki_p;
select count(distinct(rev_user)) from revision o
where... |
5 years ago |
use enwiki_p;
select rev_minor_edit, count(*) from revision o
where... |
5 years ago |
use enwiki_p;
select rev_minor_edit, count(*) from revision o
where... |
5 years ago |
use enwiki_p;
select rev_minor_edit, count(*) from revision o
where... |
5 years ago |
use enwiki_p;
select rev_minor_edit, count(*) from revision o
where... |
5 years ago |
use enwiki_p;
select * from revision o
where o.rev_page in (27712)
order... |
5 years ago |
use enwiki_p;
select * from revision o
where o.rev_page in (27712)
limit 100 |
5 years ago |
use enwiki_p;
select * from revision o
where o.rev_page in (27712)
limit 50 |
5 years ago |