WP:Women tagging (enwiki)

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

SQL

select p.page_title
from page p
where p.page_namespace=0 and p.page_is_redirect=0
		and p.page_id in (select p2.page_id from pagelinks pl
						join page p2 on p2.page_title=pl.pl_title and pl.pl_namespace=p2.page_namespace
						where pl.pl_from=37800389 and pl.pl_namespace=0)
			and p.page_title not in (select distinct pla.page_title
                							from categorylinks cla
											join page pla on cla.cl_from=pla.page_id
             								   where cla.cl_type="page"
                                     				and pla.page_namespace=1
     										   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_title not in (select pla2.page_title from templatelinks tl
											join page pla2 on pla2.page_namespace=1 and tl.tl_from=pla2.page_id
											where tl.tl_namespace=10 and tl.tl_from_namespace=1 and
                       			           tl.tl_title in ("WikiProject_Jewish_Women","WikiProject_Women's_sport")
                                 )*/
                        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
*/

SQL

Checking query status...