Singh disambiguations listed (draft)

SQL

USE enwiki_p;
/* SELECT whole.* */ /* whole.page_title */
/* FROM ( */
  SELECT *
  FROM ( 
    SELECT DISTINCT links.page_title
    FROM page AS sources
     JOIN pagelinks ON sources.page_id = pl_from
     JOIN page AS links ON pl_title = links.page_title
    WHERE sources.page_namespace = 0
     AND sources.page_title = "List_of_people_with_surname_Singh"
     AND links.page_title LIKE "%disambiguation)"
     AND links.page_is_redirect = 0
  ) AS directs
   OUTER JOIN ( 
    SELECT DISTINCT targets.page_title
    FROM page AS sources2
     JOIN pagelinks ON sources2.page_id = pl_from
     JOIN page AS links2 ON pl_title = links2.page_title
     JOIN redirect ON links2.page_id = rd_from 
     JOIN page AS targets ON reds.rd_title = targets.page_title
    WHERE sources2.page_namespace = 0
     AND sources2.page_title = "List_of_people_with_surname_Singh"
     AND links2.page_title LIKE "%disambiguation)"
     AND links2.page_is_redirect = 1
   ) AS indirects
  ON directs.page_title = indirects.targets.page_title
/*  ) AS whole */
SQL

Checking query status...
