SQL
AخA
USE enwiki_p;
SELECT alldises.page_title
FROM (
SELECT page_title
FROM page JOIN templatelinks ON tl_from = page_id
WHERE tl_title LIKE "%isambiguation"
AND (
page_title LIKE "%Singh"
OR page_title LIKE "%Singh_(%)"
)
) AS alldises LEFT JOIN (
SELECT pl_title
FROM page JOIN pagelinks ON page_id = pl_from
WHERE page_title LIKE "List_of_people_with_surname_Singh"
) AS listed ON alldises.page_title = listed.pl_title
WHERE listed.pl_title IS NULL
LIMIT 5
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.