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
Timwi
.
Find all page titles of people born 1900 or later
Toggle Highlighting
SQL
select page_title from page where page_namespace=0 and page_id in ( select cl_from from categorylinks where cl_to in ('1900_births','1901_births','1902_births','1903_births','1904_births','1905_births','1906_births','1907_births','1908_births','1909_births','1910_births','1911_births','1912_births','1913_births','1914_births','1915_births','1916_births','1917_births','1918_births','1919_births','1920_births','1921_births','1922_births','1923_births','1924_births','1925_births','1926_births','1927_births','1928_births','1929_births','1930_births','1931_births','1932_births','1933_births','1934_births','1935_births','1936_births','1937_births','1938_births','1939_births','1940_births','1941_births','1942_births','1943_births','1944_births','1945_births','1946_births','1947_births','1948_births','1949_births','1950_births','1951_births','1952_births','1953_births','1954_births','1955_births','1956_births','1957_births','1958_births','1959_births','1960_births','1961_births','1962_births','1963_births','1964_births','1965_births','1966_births','1967_births','1968_births','1969_births','1970_births','1971_births','1972_births','1973_births','1974_births','1975_births','1976_births','1977_births','1978_births','1979_births','1980_births','1981_births','1982_births','1983_births','1984_births','1985_births','1986_births','1987_births','1988_births','1989_births','1990_births','1991_births','1992_births','1993_births','1994_births','1995_births','1996_births','1997_births','1998_births','1999_births','2000_births','2001_births','2002_births','2003_births','2004_births','2005_births','2006_births','2007_births','2008_births','2009_births','2010_births','2011_births','2012_births','2013_births','2014_births','2015_births','2016_births','2017_births','2018_births','2019_births') )
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...