Redirect fixing

use lvwiki_p;
SELECT concat('<Replacement><Find>',pl.pl_title,'</Find><Replace>',r.rd_title,
              '</Replace><Comment /><IsRegex>false</IsRegex><Enabled>true</Enabled><Minor>true</Minor><BeforeOrAfter>false</BeforeOrAfter><RegularExpressionOptions>IgnoreCase</RegularExpressionOptions></Replacement>')#pl.pl_namespace, pl.pl_title, count(pl.pl_from), pl.pl_from_namespace
from pagelinks pl
join page p on pl.pl_title=p.page_title #and  p.page_namespace=10
join redirect r on p.page_id=r.rd_from
where #pl.pl_namespace=10
#and pl.pl_from_namespace=2
#and 
/*pl.pl_from_namespace=0 and  - svarīgi arī veidnēs izvākt*/ pl.pl_from=236690

SQL

use enwiki_p;
SELECT pl.pl_title, r.rd_title #pl.pl_namespace, pl.pl_title, count(pl.pl_from), pl.pl_from_namespace
from pagelinks pl
join page p on pl.pl_title=p.page_title and /*p.page_is_redirect=1 and*/ p.page_namespace=10
join redirect r on p.page_id=r.rd_from
where pl.pl_namespace=10
#and pl.pl_from_namespace=2
and /*pl.pl_from_namespace=0 and  - svarīgi arī veidnēs izvākt*/ pl.pl_from=36589035

SQL

Checking query status...