ContentTranslation cleanup edits

List edits made by Framabot (Framawiki's bot) against CX errors

Some available edit types:
-"espace superflu": unnecessary space
-"{{références}}": English wikipedia {{references}} template that was substed by CX
-"div inutile dans une ref": unnecessary <div> tag in reference
-"cite dans une référence": unnecessary <cite> tag in reference
-"catégorie non traduite": not translated category, that was usually added because an English wikipedia template was substed by CX
...

To see the edit, go to https://fr.wikipedia.org/w/index.php?diff=prev&oldid= and append rev_id value to that url.

SQL

use frwiki_p;

select page_title as title, replace(comment_text, 'Bot: nettoyage traduction: ', '') as comment, date(rev_timestamp) as date, rev_id
from revision_userindex
  INNER JOIN comment on rev_comment_id = comment_id
  INNER JOIN page ON rev_page = page_id
  INNER JOIN actor_revision ON rev_actor = actor_id
where actor_name = "Framabot"
  and page_namespace = 0
  and comment_text like 'Bot: nettoyage traduction%'
order by rev_timestamp desc
limit 10000;

SQL

Checking query status...