Untitled query #10303

SQL

select concat('<Replacement><Find>',pde.page_title,'</Find><Replace>',lde.ll_title,
              '</Replace><Comment /><IsRegex>false</IsRegex><Enabled>true</Enabled><Minor>true</Minor><BeforeOrAfter>false</BeforeOrAfter><RegularExpressionOptions>IgnoreCase</RegularExpressionOptions></Replacement>')



from enwiki_p.langlinks lde
join enwiki_p.page pde on pde.page_id=lde.ll_from
where lde.ll_from in (select p.page_id from enwiki_p.pagelinks pl
						join enwiki_p.page p on p.page_title=pl.pl_title and pl.pl_namespace=p.page_namespace
						where pl.pl_from=49241072 and pl.pl_namespace=0)
and lde.ll_from in (select mde.ll_from from enwiki_p.langlinks mde where mde.ll_lang="lv")
and lde.ll_lang="lv"
group by lde.ll_from
SQL

Checking query status...
