Singh not listed (draft)

SQL

use enwiki_p;
SELECT page_title
FROM (
  SELECT DISTINCT page_title
  FROM page
  WHERE (
    page_title LIKE "%Singh"
  )
  AND page_title NOT LIKE "%(disambiguation)" ) AS allpeople LEFT JOIN (
  SELECT DISTINCT pl_title 
  FROM pagelinks JOIN page ON page_id = pl_from
  WHERE (
    page_title LIKE "List_of_people_with%"
    OR page_title LIKE "%(disambiguation)"
  )
  AND (
    pl_title LIKE "%Singh"
  )
  AND pl_title NOT LIKE "%(disambiguation)" ) AS dislinks ON allpeople.page_title = dislinks.pl_title
WHERE dislinks.pl_title IS NULL
AND allpeople.page_is_redirect = 0
AND allpeople.page_namespace = 0
SQL

Checking query status...
