use enwiki_p;
select count(r.rev_page)
from page as p
INNER JOIN revision... |
5 years ago |
use enwiki_p;
select count(r.*)
from page as p
INNER JOIN revision as r
ON... |
5 years ago |
use enwiki_p;
select page_id,
page_title,
rp.revc as... |
5 years ago |
use enwiki_p;
select page_id,
page_title,
rp.revc as... |
5 years ago |
use enwiki_p;
select page_id,
page_title,
rp.revc as revision_count
FROM... |
5 years ago |
use enwiki_p;
select rev_page, count(*) as revision_count
from revision... |
5 years ago |
use enwiki_p;
select * from page where
page_id in (27712,1605200); |
5 years ago |