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
Edgars2007
.
WikiProject Anthroponymy WikiProject Feminism WikiProject Gender Studies WikiProject Jewish Women WikiProject LGBT studies WikiProject Women WikiProject Women artists WikiProject Women's Health WikiProject Women's History WikiProject Women scientists WikiProject Women's sport WikiProject Women writers
Toggle Highlighting
SQL
select p.page_title from page p where p.page_id in (select cla.cl_from from categorylinks cla where cla.cl_type="page" and cla.cl_to in ("County_seats_in_Alabama", "Borough_seats_in_Alaska", "County_seats_in_Arizona", "County_seats_in_Arkansas", "County_seats_in_California", "County_seats_in_Colorado", "County_seats_in_Delaware", "County_seats_in_Florida", #"Former_county_seats_in_the_United_States", "County_seats_in_Georgia_(U.S._state)", "County_seats_in_Hawaii", "County_seats_in_Idaho", "County_seats_in_Illinois", "County_seats_in_Indiana", "County_seats_in_Iowa", "County_seats_in_Kansas", "County_seats_in_Kentucky", "Parish_seats_in_Louisiana", "County_seats_in_Maine", "County_seats_in_Maryland", "County_seats_in_Massachusetts", "County_seats_in_Michigan", "County_seats_in_Minnesota", "County_seats_in_Mississippi", "County_seats_in_Missouri", "County_seats_in_Montana", "County_seats_in_Nebraska", "County_seats_in_Nevada", "County_seats_in_New_Hampshire", "County_seats_in_New_Jersey", "County_seats_in_New_Mexico", "County_seats_in_New_York", "County_seats_in_North_Carolina", "County_seats_in_North_Dakota", "County_seats_in_Ohio", "County_seats_in_Oklahoma", "County_seats_in_Oregon", "County_seats_in_Pennsylvania", "County_seats_in_Rhode_Island", "County_seats_in_South_Carolina", "County_seats_in_South_Dakota", "County_seats_in_Tennessee", "County_seats_in_Texas", "County_seats_in_Utah", "County_seats_in_Vermont", "County_seats_in_Virginia", "County_seats_in_Washington_(state)", "County_seats_in_West_Virginia", "County_seats_in_Wisconsin", "County_seats_in_Wyoming")) and p.page_id not in (select pp.pp_page from page_props pp where pp.pp_page=p.page_id and /*pp.pp_page in (select cla.cl_from from categorylinks cla where cla.cl_type="page" and cla.cl_to in ("County_seats_in_Alabama", "Borough_seats_in_Alaska", "County_seats_in_Arizona", "County_seats_in_Arkansas")) and*/ pp.pp_propname="page_image") limit 2000;# and pp_value is NULL #pp_page in (109922,110198,4496757) and pp_propname="page_image"# and pp_value is NULL
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...