FEB24 pages linked from CCIs

SQL

SELECT ccipage.page_title AS cci_title, questionablepage.page_title AS page_title
FROM pagelinks toplinks
INNER JOIN linktarget toptarget ON toplinks.pl_target_id = toptarget.lt_id
INNER JOIN page ccipage ON ccipage.page_title = toplinks.pl_title
INNER JOIN pagelinks finallinks ON ccipage.page_id = finallinks.pl_from
INNER JOIN linktarget finaltarget ON finallinks.pl_target_id = finaltarget.lt_id
INNER JOIN page questionablepage ON questionablepage.page_title = finaltarget.lt_title
INNER JOIN categorylinks ON categorylinks.cl_from = questionablepage.page_id
WHERE toplinks.pl_from = 24705288
AND toptarget.lt_namespace = 4
AND toplinks.pl_title LIKE 'Contributor_copyright_investigations/%'
AND ccipage.page_namespace = 4
AND finaltarget.lt_namespace = 0
AND questionablepage.page_namespace = 0
AND categorylinks.cl_to = 'All_articles_lacking_sources'
ORDER BY cci_title
SQL

Checking query status...
