use enwiki_p;
select concat(p.page_id,',') from page p
where page_title in... |
8 years ago |
use enwiki_p;
select p.page_id from page p
where page_title in... |
8 years ago |
blank query |
8 years ago |
use lvwiki_p;
select p.page_title as "ciems", cl2.cl_to as "pagasts",... |
8 years ago |
use lvwiki_p;
select page_title as "ciems", cl2.cl_to as "pagasts", (SELECT ... |
8 years ago |
use lvwiki_p;
select page_title as "ciems", cl2.cl_to as "pagasts"
from... |
8 years ago |
use lvwiki_p;
select *
from categorylinks cl
join page on... |
8 years ago |
use lvw3iki_p;
select *
from categorylinks cl
join page on... |
8 years ago |
use lvwiki_p;
select *
from categorylinks cl
join page on... |
8 years ago |
use lvwiki_p;
select *
from categorylinks
join page on page_id=cl_from
join... |
8 years ago |
use lvwiki_p;
select page_title, (select cl2.cl_to
from categorylinks... |
8 years ago |
use lvwiki_p;
select page_title, (select cl2.cl_to
from categorylinks... |
8 years ago |
use lvwiki_p;
select page_title
from categorylinks
join page on... |
8 years ago |
blank query |
8 years ago |
select p.page_title#, (select rev_timestamp
# from... |
9 years ago |
select pp.page_id, pp.page_title from pagelinks pl2
join page pp on... |
9 years ago |
/*select *
from revision
where rev_parent_id=0
... |
9 years ago |
/*select *
from revision
where rev_parent_id=0
... |
9 years ago |
select *
from revision
where rev_parent_id=0
... |
9 years ago |
select *
from revision
where rev_parent_id=0
... |
9 years ago |
select *
from revision
where rev_parent_id=0
... |
9 years ago |
select distinct concat('[[',pla.page_title,']]')
from... |
9 years ago |
select distinct concat('[[',pla.page_title,']]')
from... |
9 years ago |
/*select distinct concat('[[',pla.page_title,']]')
... |
9 years ago |
select distinct concat('[[',pla.page_title,']]')
from... |
9 years ago |