Untitled query #28910

SQL

use lvwiki_p;
select orig.page_title, (select m2.ll_title from langlinks m2 where m2.ll_from=orig.page_id and m2.ll_lang="en")
from revision
join page orig on orig.page_id=rev_page and orig.page_is_redirect=0 and orig.page_namespace=0
where rev_timestamp>20040800000000/*20180530181512 20180527084118 20180525142023 20180523184815 20180517183650 20180504095931 20180504090552 20180320000000
		20180406073037 20180414213650 20180423155813 20180426164212*/ and rev_parent_id=0
and exists (select * from templatelinks t where orig.page_id = t.tl_from AND t.tl_namespace = 10 AND t.tl_title='Albuma_infokaste')
SQL

Checking query status...
