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 REPLACE(p.page_title, '_', ' '), iw.iwl_title
from  iwlinks iw
join wbc_entity_usage wb on wb.eu_entity_id=iw.iwl_title
join page p on wb.eu_page_id=p.page_id
where iwl_from=58532
group by iw.iwl_title;

SQL

Checking query status...