Fork of GAs linked from open CCIs by AntiCompositeNumber
This query is marked as a draft This query has been published by Sennecaster.

SQL

AخA
 
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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...