Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
INS Pirat
.
Toggle Highlighting
SQL
USE enwiki_p; SELECT FROM ( SELECT DISTINCT page_title FROM templatelinks JOIN page 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
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...