-- 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 page_title

FROM page

INNER JOIN categorylinks cat1 ON cat1.cl_from = page_id

INNER JOIN categorylinks cat2 ON cat2.cl_from = page_id

WHERE cat1.cl_to = "WikiProject_Biography_articles"

AND cat2.cl_to = "Stub-Class_football_articles"

AND page.page_namespace = 1

LIMIT 5