FEB24 pages linked from CCIs

SQL

SELECT questionablepage.page_title, ccipage.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
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
LIMIT 5
SQL

Checking query status...
