#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

​

select page_title, pp_value

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

                        and page_title like "%national_football_team"