Untitled query #80191

SQL

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_title = lt_title
INNER JOIN categorylinks ON categorylinks.cl_from = questionablepage.page_id
WHERE ccipage.page_namespace = 4
AND ccipage.page_title LIKE 'Contributor_copyright_investigations/%'
AND lt_namespace = 0
AND questionablepage.page_namespace = 0
AND categorylinks.cl_to = 'All_articles_lacking_sources'
LIMIT 5
SQL

Checking query status...
