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_namespace=0 and p.page_id>47208283 and p.page_id in (select pp.page_id from pagelinks pl2 join page pp on pp.page_title=pl2.pl_title and pl2.pl_namespace=pp.page_namespace where pl2.pl_from in (37800330,37800340) and pl2.pl_namespace=0) and p.page_title in (select distinct pla.page_title from categorylinks cla join page pla on cla.cl_from=pla.page_id where pla.page_namespace=1 and cla.cl_type="page" and cla.cl_to in ("WikiProject_Feminism_articles", "WikiProject_Women_articles", "WikiProject_Women_artists_article", "WikiProject_Women's_health_articles", "WikiProject_Women's_History_articles", "WikiProject_Women_scientists_articles", "WikiProject_Women_writers_articles") and pla.page_title=p.page_title) and p.page_title not in (select pl.pl_title from pagelinks pl where pl.pl_from=47274942 and pl.pl_namespace=0) limit 5000; */ select lde.ll_title from dewiki_p.langlinks lde #join dewiki_p.page pde on pde.page_id=lde.ll_from where lde.ll_title in (select plade.page_id from dewiki_p.categorylinks clade join dewiki_p.page plade on clade.cl_from=plade.page_id where plade.page_namespace=0 and clade.cl_type="page" and clade.cl_to="Frau") and lde.ll_from in (select mde.ll_from from dewiki_p.langlinks mde where mde.ll_lang="en") and lde.ll_lang="en" group by lde.ll_from limit 15;
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...