select * from revision r
where rev_page in (select page_id from page p... |
3 years ago |
select * from page p
where p.page_title in (select pl_title from pagelinks... |
3 years ago |
select * from page p
where p.page_title in (select pl_title from pagelinks... |
3 years ago |
select * from page p
where p.page_title in (select pl_title from pagelinks... |
3 years ago |
select * from page p
where p.page_title in (select pl_title from pagelinks... |
3 years ago |
select * from page p
join pagelinks pl on p.page_title = pl.pl_title
where... |
3 years ago |
select * from page p
join pagelinks pl on p.page_id = pl.pl_from
where... |
3 years ago |
select * from pagelinks
where pl_from = 990505 and pl_namespace = 0; |
3 years ago |
select * from pagelinks
where pl_from = 990505; |
3 years ago |
select * from page
where page_title = "Mental_health"
and page_namespace = 0; |
3 years ago |
select * from page
where page_title = "Mental_health"; |
3 years ago |