use nlwiki_p;
select r.rev_user, r.rev_user_text, page.page_namespace,... |
9 years ago |
use nlwiki_p;
select r.rev_user, page.page_namespace, count(r.rev_id) from... |
9 years ago |
use nlwiki_p;
select r.rev_user, page.page_namespace, count(r.rev_id) from... |
9 years ago |
use nlwiki_p;
select r.rev_user, page.page_namespace from revision as... |
9 years ago |
use nlwiki_p;
select r.rev_user, page.page_namespace, count(r.rev_id) from... |
9 years ago |
use nlwiki_p;
select r.rev_user, page.page_namespace, count(r.rev_id) from... |
9 years ago |
use nlwiki_p;
select * from revision as r
left join page on r.rev_page =... |
9 years ago |
use nlwiki_p;
select r.* from revision as r
where r.rev_user in (select... |
9 years ago |
use nlwiki_p;
select r.* from revision as r
where r.rev_user in (select... |
9 years ago |
use nlwiki_p;
select r.* from revision as r
where r.rev_user in (select... |
9 years ago |
use nlwiki_p;
select distinct rdk.rev_user from revision as rdk where... |
9 years ago |
use nlwiki_p;
select rdk.rev_user from revision as rdk where... |
9 years ago |
use nlwiki_p;
select rdk.rev_user from revision as rdk where... |
9 years ago |
use nlwiki_p;
select * from revision where rev_page=336336 order by... |
9 years ago |
use nlwiki_p;
select * from revision where rev_page=336336 limit 10; |
9 years ago |
use nlwiki_p;
select * from page where page_namespace=4 and page_title='De_kroeg'; |
9 years ago |
use nlwiki_p;
select * from page where page_namespace=6 and page_title='De_kroeg'; |
9 years ago |