https://bugzilla.wikimedia.org/show_bug.cgi?id=46716
--- Comment #20 from Nemo <[email protected]> --- Let's see how much previous translation admin time we're wasting by requiring basically every single "mark for translation" action to be done twice, with a dummy edit in between. This catches many such edits (but possibly not the majority), with nearly no false positives, by looking for common edit summaries: SELECT count(rev_id) FROM revision JOIN logging ON rev_page = log_page AND log_type = 'pagetranslation' WHERE rev_comment RLIKE '.*(null|dummy|trigger|propagate|46716).*'; +---------------+ | count(rev_id) | +---------------+ | 5489 | +---------------+ 1 row in set (9.32 sec) MariaDB [metawiki_p]> ---- +---------------+ | count(rev_id) | +---------------+ | 959 | +---------------+ 1 row in set (4.17 sec) MariaDB [mediawikiwiki_p]> ---- +---------------+ | count(rev_id) | +---------------+ | 284 | +---------------+ 1 row in set (2.40 sec) MariaDB [commonswiki_p]> ---- Not amusing. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
