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 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

Checking query status...