SQL
AخA
use enwiki_p;
SELECT targets.page_title
FROM page AS targets LEFT JOIN (SELECT * FROM pagelinks JOIN page ON pl_from = page_id) AS sources ON targets.page_id = sources.pl_title
WHERE (
targets.page_title LIKE "%Singh"
OR targets.page_title LIKE "%Singh (%)"
)
AND targets.page_title NOT LIKE "%Singh (disambiguation)"
AND sources.page_title NOT LIKE "%Singh (disambiguation)"
AND sources.page_title NOT LIKE "List of people%"
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.