Good articles about anthology films

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

Pages in both [[Category:Good articles]] and a category whose name includes "nthology film".

For [[Wikipedia:Help desk#plot summary for a film mainly composed of unrelated skits]] circa 1 September 2023.

SQL

SELECT REPLACE(page_title, '_', ' ') AS pagename,
       GROUP_CONCAT(CONCAT('Category:', REPLACE(anth.cl_to, '_', ' ')) SEPARATOR ' || ') AS 'Anthology film categories'
FROM page
JOIN categorylinks AS ga ON ga.cl_from = page_id
JOIN categorylinks AS anth ON anth.cl_from = page_id
WHERE ga.cl_to = 'Good_articles'
  AND anth.cl_to LIKE '%nthology\_film%'
GROUP BY page_title;

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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...