Untitled query #9948

SQL

select #p.page_id, page_title, pp_value

SELECT concat('<Replacement><Find>',page_title,'</Find><Replace>',pp_value,
              '</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 p.page_title=pl.pl_title and pl.pl_namespace=p.page_namespace
						join page_props pp on pp.pp_page=p.page_id AND pp_propname = 'wikibase_item'
						where pl.pl_from=37800330 and pl.pl_namespace=0
SQL

Checking query status...
