##use enwiki_p
select * from revision o
where o.rev_page in (27712)
limit 50
|
5 years ago |
##use enwiki_p
select * from revision o left join revision r on o.rev_id =... |
5 years ago |
use enwiki_p;
select * from page WHERE page_title IN ('Sugar' ,'Salt') |
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 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 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 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 count(distinct(rev_user))
from revision o
where... |
5 years ago |
##use enwiki_p
select count(*)
from revision o
where o.rev_page in... |
5 years ago |
##use enwiki_p
select count(*)
from revision o
where o.rev_page in... |
5 years ago |
##use enwiki_p
select *
from revision o
where o.rev_page in (27712)
##and... |
5 years ago |
##use enwiki_p
select *
from revision o
where o.rev_page in (27712)
and... |
5 years ago |
##use enwiki_p
select *
from revision o
where o.rev_page in (27712)
and... |
5 years ago |
##use enwiki_p
select *
from revision o
where o.rev_page in (27712)
and... |
5 years ago |
##use enwiki_p
select *
from revision o
where o.rev_page in (27712)
and... |
5 years ago |
##use enwiki_p
select *
from revision o
where o.rev_page in (27712)
and... |
5 years ago |
##use enwiki_p
select *
from revision o
where o.rev_page in (27712)
and... |
5 years ago |
##use enwiki_p
select *
from revision o
where o.rev_page in (27712)
and... |
5 years ago |
##use enwiki_p
select *
from revision o
where o.rev_page in (27712)
and... |
5 years ago |
##use enwiki_p
select *
from revision o /*left join revision r on o.rev_id... |
5 years ago |
##use enwiki_p
select rev_deleted, count(rev_id)
from revision o /*left... |
5 years ago |
##use enwiki_p
select *
from revision o /*left join revision r on o.rev_id... |
5 years ago |
##use enwiki_p
select count(*)
from revision o /*left join revision r on... |
5 years ago |
##use enwiki_p
select o.*
from revision o /*left join revision r on... |
5 years ago |
use enwiki_p
select o.*
from revision o /*left join revision r on o.rev_id... |
5 years ago |
##use enwiki_p
select o.*, r.rev_deleted as rev from revision o left join... |
5 years ago |
##use enwiki_p
select o.*, r.rev_deleted as rev from revision o left join... |
5 years ago |
##use enwiki_p
select o.*, r.rev_deleted as rev from revision o left join... |
5 years ago |
##use enwiki_p
select o.*, p.rev_deleted as rev from revision o left join... |
5 years ago |
##use enwiki_p
select o.*, p.rev_deleted as rev from revision
where... |
5 years ago |
##use enwiki_p
select count(*) from revision
where rev_page in (27712)
limit 50
|
5 years ago |
##use enwiki_p
select * from revision
where rev_page in (27712, 1605200)
limit 50
|
5 years ago |
##use enwiki_p
select * from page
where page_title in ("Sugar", "Salt")
limit 50 |
5 years ago |
##use enwiki_p
select * from page
where page_title like "%Sugar%"
limit 50 |
5 years ago |
##use enwiki_p
select * from page
where page_title like "%Sugar%"
limit 50 |
5 years ago |
##use enwiki_p
select * from page
where page_title like "%Sugar%"
limit 20 |
5 years ago |
##use enwiki_p
select * from page
where page_title = "Sugar"
limit 20 |
5 years ago |
##use enwiki_p
select * from page
where page_title = "Sugar"
limit 20 |
5 years ago |
##use enwiki_p
select * from page
where page_title like "%Sugar%"
limit 20 |
5 years ago |
##use enwiki_p
select * from page
limit 20 |
5 years ago |
use enwiki_p |
5 years ago |