Footballer stubs linked from non-football-related pages

SQL

-- 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_title, talkpage.page_title
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
AND sourcemainpage.page_is_redirect = 0
AND "WikiProject_Football_articles" NOT IN (
  SELECT cat3.cl_to FROM categorylinks cat3 WHERE cat3.cl_from = sourcetalkpage.page_id
)
AND "All_set_index_articles" NOT IN (
  SELECT cat4.cl_to FROM categorylinks cat4 WHERE cat4.cl_from = sourcemainpage.page_id
)
AND 'disambiguation' NOT IN (
  SELECT pp_propname FROM page_props WHERE page_props.pp_page = sourcemainpage.page_id
)
LIMIT 5000
SQL

Checking query status...
