Mainspace pages with maintenance tags

Including section maintenance tags as well, not only article tags.

Some maintenance templates will only be on an article's talk page.

https://en.wikipedia.org/wiki/Category:Cleanup_templates
https://en.wikipedia.org/wiki/Wikipedia:Template_index/Maintenance
https://en.wikipedia.org/wiki/Category:Article_message_templates
https://en.wikipedia.org/wiki/Category:Wikipedia_maintenance_templates

Possibly do not include inline maintenance templates.

SQL

SELECT CONCAT('https://en.wikipedia.org/wiki/', p2.page_title) AS 'Article', GROUP_CONCAT(lt.lt_title SEPARATOR ', ') AS 'Tags'
FROM categorylinks cl
INNER JOIN page p ON cl.cl_from = p.page_id AND p.page_namespace = 10
INNER JOIN linktarget lt ON p.page_title = lt.lt_title AND p.page_namespace = lt.lt_namespace
INNER JOIN templatelinks tl ON lt.lt_id = tl.tl_target_id
INNER JOIN page p2 ON p2.page_id = tl.tl_from AND p2.page_namespace = 0
WHERE cl.cl_to IN ('Cleanup_templates', 'Citation_and_verifiability_maintenance_templates')
GROUP BY p2.page_id

SQL

Checking query status...