Bengali Wikipedia Section Translation edits

Fork of Bengali Wikipedia Content Translation edits by Amire80

This query is marked as a draft This query has been published by Amire80.

SQL

use bnwiki_p;

-- When appropriate, change 'contenttranslation' to 'sectiontranslation'
set @cx_edit_tag = (
  select
    ctd_id
  from
    change_tag_def
  where
    ctd_name = 'sectiontranslation'
);

select
	date_format(rev_timestamp, "%Y-%m-%d %H:%i:%s") as 'Time',
    rev_id as 'Revision ID',
    actor_name as 'Username',
    replace(page_title, '_', ' ') as 'Page title'
from
	revision,
    page,
    change_tag,
    actor
where
	-- if needed, add a condition for rev_timestamp
    page_id = rev_page and
    ct_rev_id = rev_id and
    ct_tag_id = @cx_edit_tag and
    rev_actor = actor_id 
order by
    rev_timestamp desc
limit
	50; -- Can be adjusted

SQL

Checking query status...