Unlinked genes N-Z

SQL

SET STATEMENT max_statement_time = 120 FOR
SELECT Pg.page_title
FROM page Pg
WHERE Pg.page_namespace=0 AND Pg.page_title LIKE 'ADSL%_(gene)'
AND NOT EXISTS (
  SELECT 1
  FROM page Pb
  JOIN pagelinks ON pl_from=Pb.page_id AND pl_from_namespace=0 AND pl_namespace=0 AND pl_title=Pg.page_title)
  WHERE Pb.page_namespace=0 AND Pb.page_title=CONCAT(SUBSTR(Pg.page_title, 1, CHAR_LENGTH(Pg.page_title)-7),"")
AND NOT EXISTS (
  SELECT 1
  FROM page Pd
  JOIN pagelinks ON pl_from=Pd.page_id AND pl_from_namespace=0 AND pl_namespace=0 AND pl_title=Pg.page_title)
  WHERE Pd.page_namespace=0 AND Pd.page_title=CONCAT(SUBSTR(Pg.page_title, 1, CHAR_LENGTH(Pg.page_title)-7),"_(disambiguation)")
AND NOT EXISTS (
  SELECT 1
  FROM page Pbr
  JOIN redirect ON rd_from=Pbr.page_id AND rd_namespace=0
  JOIN pagelinks ON pl_from=Pbr.page_id AND pl_from_namespace=0 AND pl_namespace=0 AND pl_title=rd_title)
  WHERE Pbr.page_namespace=0 AND Pbr.page_title=CONCAT(SUBSTR(Pg.page_title, 1, CHAR_LENGTH(Pg.page_title)-7),"")
AND NOT EXISTS (
  SELECT 1
  FROM page Pdr
  JOIN redirect ON rd_from=Pdr.page_id AND rd_namespace=0
  JOIN pagelinks ON pl_from=Pdr.page_id AND pl_from_namespace=0 AND pl_namespace=0 AND pl_title=rd_title)
  WHERE Pdr.page_namespace=0 AND Pdr.page_title=CONCAT(SUBSTR(Pg.page_title, 1, CHAR_LENGTH(Pg.page_title)-7),"_(disambiguation)")
SQL

Checking query status...
