disambig script [dev version]

use lvwiki_p;
select *
from page
join categorylinks on page_id=cl_from and cl_to="Nozīmju_atdalīšana"
join pagelinks on pl_title = page_title and pl_namespace=0
where page_namespace=0
limit 100

-----
5486 - ir saites
---
use lvwiki_p;
select distinct page_title, 
from page
join categorylinks on page_id=cl_from and cl_to="Nozīmju_atdalīšana"
join pagelinks on pl_title = page_title and pl_namespace=0
where page_namespace=0
--------
use lvwiki_p;
select distinct page_title, (select GROUP_CONCAT(DISTINCT rd_title SEPARATOR '|') from redirect where rd_from=page_id) as redirects
from page
join categorylinks on page_id=cl_from and cl_to="Nozīmju_atdalīšana"
join pagelinks on pl_title = page_title and pl_namespace=0
where page_namespace=0 and page_title='1956._gada_olimpiskās_spēles'

SQL

use lvwiki_p;
select distinct page_title, (select GROUP_CONCAT(DISTINCT rd_title SEPARATOR '|') as target from redirect where rd_from=page_id)
from page
join categorylinks on page_id=cl_from and cl_to="Nozīmju_atdalīšana"
join pagelinks on pl_title = page_title and pl_namespace=0
where page_namespace=0

SQL

Checking query status...