SQL
AخA
select concat("Module:",page_title),page_len from page join revision on rev_id=page_latest where page_namespace=828
and not /**/ exists (select 1 from templatelinks where tl_namespace=page_namespace and tl_title=page_title and tl_from != page_id
and tl_from_namespace != 2 and tl_from_namespace != 10)
and page_title like "%andbox%"
and page_title not like "%/sandbox"
and page_title not like "Sandbox/%"
and page_title not like "%testcases%"
and page_title not like "User:%"
and rev_timestamp < "20200401010101"
and page_is_redirect=0
and page_content_model!="wikitext"
order by page_title;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.