blank1 - Quarry

SQL

/*select pl.pl_title#šeit vēl pielikt izveides datumu
#p.page_id
from pagelinks pl
#join page p on p.page_title=pl.pl_title and pl.pl_namespace=p.page_namespace
where pl.pl_from=47274942 and pl.pl_namespace=0
	and pl.pl_title not
limit 15;


*/
select p.page_title, (select rev_timestamp
						from revision
						where rev_parent_id=0 and rev_page=p.page_id) as creation
from page p
where p.page_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# and cla.tl_from_
             								   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 in (select p2.page_title from templatelinks tl
  											join page p2 on tl.tl_from=p2.page_id and p2.page_namespace=1
											where tl.tl_title="WikiProject_Jewish_Women"
  											and tl.tl_namespace=10 and tl.tl_from_namespace=1)*/
                  and p.page_title not in (select pl.pl_title#šeit vēl pielikt izveides datumu
										#p.page_id
										from pagelinks pl
										#join page p on p.page_title=pl.pl_title and pl.pl_namespace=p.page_namespace
										where pl.pl_from=47274942 and pl.pl_namespace=0)
                  and (select rev_timestamp
						from revision
						where rev_parent_id=0 and rev_page=p.page_id)>20150711000000
                        limit 50;
SQL

Checking query status...
