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
Quanticle
.
Toggle Highlighting
SQL
#DECLARE simp VARCHAR(256) SELECT CASE page_title WHEN 'Hamilton_College_(New_York)' THEN 'Hamilton_College' WHEN 'Grinnell,_Iowa' THEN 'Grinell_College' ELSE page_title END AS page_title, gt_lat, gt_lon FROM page JOIN geo_tags ON gt_page_id = page_id #CASE simp #when page_title = 'Hamilton_College_(New_York)' then 'Hamilton_College'; #when page_title = 'Grinnell, Iowa' then 'Grinnell_College'; #END CASE; WHERE page_title = 'Williams_College' OR page_title = 'Amherst_College' OR page_title = 'Swarthmore_College' OR page_title = 'Bowdoin_College' OR page_title = 'Middlebury_College' OR page_title = 'Wellesley_College' OR page_title = 'Carleton_College' OR page_title = 'Claremont_McKenna_College' OR page_title = 'Davidson_College' OR page_title = 'United_States_Naval_Academy' OR page_title = 'Haverford_College' OR page_title = 'Vassar_College' OR page_title = 'Hamilton_College_(New_York)' OR page_title = 'Harvey_Mudd_College' OR page_title = 'Smith_College' OR page_title = 'Washington_and_Lee_University' OR page_title = 'Wesleyan_University' OR page_title = 'Colby_College' OR page_title = 'Colgate_University' OR page_title = 'Grinnell,_Iowa' OR page_title = 'United_States_Military_Academy' OR page_title = 'Macalester_College' OR page_title = 'Oberlin_College' OR page_title = 'Bates_College' OR page_title = 'Bryn_Mawr_College' OR page_title = 'Colorado_College' OR page_title = 'Kenyon_College' AND gt_globe = 'earth' AND page_namespace = 0
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...