Untitled query #28910

SQL

use lvwiki_p;
select rev_user_text, rev_timestamp, orig.page_title
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>20180810000000/*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='Filmas_infokaste')
SQL

Checking query status...
