SQL
AخA
select page_title, actor_name, rc_title, /*regexp_substr(rc_params, '(?<=s:5:"added";b:)\\d(?=;)') as added,*/ rc_timestamp from recentchanges_userindex
join page on rc_cur_id = page_id -- and page_namespace = 1
join actor_revision on actor_id = rc_actor -- and actor_name != 'AnomieBOT'
where rc_title like 'All_articles_proposed_for_deletion' -- 'All_article_disambiguation_pages' -- 'Disambiguation_pages_containing_one_non-primary_topic%' -- 'Candidates_for_technical_speedy_deletion' -- 'Pages_with_incorrectly_transcluded_templates' -- 'Disambiguation_pages_with_Chinese_character_titles'
and rc_namespace = 14 and rc_type = 6 and rc_params like '%s:5:"added";b:0;%'
and page_id in (
select cl_from from categorylinks
where cl_to in ("All_disambiguation_pages") and cl_type = 'page'
)
and page_id not in (
select cl_from from categorylinks
where cl_to in ("Articles_for_deletion") and cl_type = 'page'
)
order by rc_timestamp desc
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.