GAs linked from open CCIs

Fork of GAs linked from open CCIs by AntiCompositeNumber

This query is marked as a draft This query has been published by Sennecaster.

SQL

SELECT CONCAT("[[", fal.pl_title, "]]"), GROUP_CONCAT(CONCAT("[[WP:", cci.page_title, "]]") SEPARATOR ', ')
FROM page cci
JOIN pagelinks ccip ON ccip.pl_title = cci.page_title AND ccip.pl_namespace = cci.page_namespace
JOIN pagelinks fal ON cci.page_id = fal.pl_from
JOIN page fa ON fa.page_title = fal.pl_title AND fa.page_namespace = fal.pl_namespace
JOIN categorylinks ON fa.page_id = cl_from
WHERE
	cci.page_namespace = 4
    AND cci.page_title LIKE "Contributor_copyright_investigations/%"
    AND ccip.pl_from = (SELECT page_id FROM page WHERE page_namespace = 10 AND page_title = "CCIlist")
	AND cl_to = "Good_articles"
    AND fa.page_namespace = 0
GROUP BY fa.page_id

SQL

Checking query status...