SQL
AخA
SELECT ccipage.page_title AS cci_title, questionablepage.page_title AS page_title
FROM page ccipage
INNER JOIN pagelinks ON ccipage.page_id = pl_from
INNER JOIN linktarget ON pl_target_id = lt_id
INNER JOIN page questionablepage ON questionablepage.page_titlte = lt_title
WHERE ccipage.page_namespace = 4
AND ccipage.page_title LIKE 'Contributor_copyright_investigations/%'
AND lt_namespace = 0
AND questionablepage.page_namespace = 0
LIMIT 5
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.