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
   FULL OUTER JOIN ( 
    SELECT DISTINCT reds.rd_title  /* 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 AS reds 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.rd_title
/*  ) AS whole */
SQL

Checking query status...
