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 not in (select pp.pp_page from page_props pp where 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 20;# 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...