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_is_redirect=0 and p.page_title in (select lde.ll_title from dewiki_p.langlinks lde where lde.ll_from 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) and p.page_id not in (select distinct cla.cl_from from categorylinks cla where 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 p.page_id not in (select tl.tl_from from templatelinks tl where tl.tl_title in ("WikiProject_Jewish_Women","WikiProject_Women's_sport") and tl.tl_namespace=10 and tl.tl_from_namespace=1) limit 50000; /* dewiki raksti, kas ir enwiki select lde.ll_title from dewiki_p.langlinks lde #join dewiki_p.page pde on pde.page_id=lde.ll_from where lde.ll_from 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 */
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...