Untitled query #84695

SQL

SELECT DISTINCT linktarget.lt_title
FROM pagelinks
JOIN page AS source_page
ON pagelinks.pl_from = source_page.page_id
JOIN linktarget
ON pagelinks.pl_target_id = linktarget.lt_id
JOIN categorylinks
ON pagelinks.pl_from = categorylinks.cl_from
WHERE source_page.page_title = 'List_of_computer_scientists'
AND source_page.page_namespace = 0
AND linktarget.lt_namespace = 0
AND (
    categorylinks.cl_to LIKE '%Living_people%' OR
    categorylinks.cl_to LIKE '%20th-century_computer_scientists%' OR
    categorylinks.cl_to LIKE '%21st-century_computer_scientists%' OR
    categorylinks.cl_to LIKE '%American_computer_scientists%' OR
    categorylinks.cl_to LIKE '%British_computer_scientists%' OR
    categorylinks.cl_to LIKE '%Female_computer_scientists%'
)
LIMIT 20;
SQL

Checking query status...
