Replicas browser and optimizer
Bengali Wikipedia Content Translation edits
This query is marked as a draft
This query has been published
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
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in