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 * from page_props where pp_page=4496757# and pp_propname="page_image"# and pp_value is NULL #pp_page in (109922,110198,4496757) and pp_propname="page_image"# and pp_value is NULL limit 20; p.page_id in (select cla.cl_from from categorylinks cla where pla.page_namespace=0 and 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")) */ select * 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 (select cla2.cl_from from categorylinks cla2 where cla2.cl_type="category" and cla2.cl_to="County_seats_of_the_United_States"/* "County_seats_in_Alabama", "Borough_seats_in_Alaska", "County_seats_in_Arizona", "County_seats_in_Arkansas", "County_seats_in_Georgia_(U.S._state)" */) ) 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...