-- Rationale for this query: there seem to be a lot of incorrect links of this type, probably caused by

-- mass creation at scale. Not sure whether this will turn out to be practical.

​

SELECT sourcetalkpage.page_id

FROM page talkpage

INNER JOIN categorylinks cat1 ON cat1.cl_from = talkpage.page_id

INNER JOIN categorylinks cat2 ON cat2.cl_from = talkpage.page_id

INNER JOIN pagelinks ON pagelinks.pl_title = talkpage.page_title

INNER JOIN page sourcemainpage ON sourcemainpage.page_id = pagelinks.pl_from

INNER JOIN page sourcetalkpage ON sourcetalkpage.page_title = sourcemainpage.page_title

WHERE cat1.cl_to = "WikiProject_Biography_articles"

AND cat2.cl_to = "Stub-Class_football_articles"

AND talkpage.page_namespace = 1

AND pagelinks.pl_namespace = 0

AND pagelinks.pl_from_namespace = 0

AND sourcetalkpage.page_namespace = 1

LIMIT 500