This is the original report: https://www.mediawiki.org/wiki/Topic:T0di3reb139m62qu
One example is "Dr. Kucho!" in the English Wikipedia. This revision was created by CX, and should have been in pt.wikipedia, but it appears in en.wikipedia. The revision tags appear correct: {"from":"en","to":"pt"} (run select * from change_tag where change_tag.ct_rev_id = 758536335; in the enwiki database), but how is it possible to have "to":"pt" in any Wikipedia other than pt?
I found 62 total instances in the English Wikipedia (select * from change_tag where ct_tag = 'contenttranslation' and ct_params not like '%"to":"en"%';), so this is not totally esoteric:
mysql:wikiadmin@db1089 [enwiki]> select * from change_tag where ct_tag = 'contenttranslation' and ct_params not like '%"to":"en"%'; +-----------+-----------+-----------+--------------------+-----------------------------+ | ct_rc_id | ct_log_id | ct_rev_id | ct_tag | ct_params | +-----------+-----------+-----------+--------------------+-----------------------------+ | 757576423 | NULL | 677163407 | contenttranslation | {"from":"en","to":"fa"} | | 757641069 | NULL | 677218942 | contenttranslation | {"from":"en","to":"pt"} | | 759049796 | NULL | 678414993 | contenttranslation | {"from":"en","to":"de"} | | 759640134 | NULL | 678904083 | contenttranslation | {"from":"en","to":"zh"} | | 773981023 | NULL | 690146422 | contenttranslation | {"from":"en","to":"eo"} | | 774010472 | NULL | 690172078 | contenttranslation | {"from":"en","to":"es"} | | 774011600 | NULL | 690173040 | contenttranslation | {"from":"en","to":"es"} | | 774012199 | NULL | 690173553 | contenttranslation | {"from":"en","to":"es"} | | 774012503 | NULL | 690173791 | contenttranslation | {"from":"en","to":"es"} | | 774017040 | NULL | 690177299 | contenttranslation | {"from":"en","to":"es"} | | 774017134 | NULL | 690177364 | contenttranslation | {"from":"en","to":"es"} | | 774903508 | NULL | 690838686 | contenttranslation | {"from":"en","to":"it"} | | 775452654 | NULL | 691253359 | contenttranslation | {"from":"en","to":"zh"} | | 778639761 | NULL | 693544079 | contenttranslation | {"from":"eo","to":"fr"} | | 778857069 | NULL | 693696564 | contenttranslation | {"from":"eo","to":"fr"} | | 780500518 | NULL | 694721653 | contenttranslation | {"from":"en","to":"pt"} | | 781672055 | NULL | 695512931 | contenttranslation | {"from":"en","to":"pt"} | | 786358382 | NULL | 698681273 | contenttranslation | {"from":"en","to":"pt"} | | 787015300 | NULL | 699117024 | contenttranslation | {"from":"en","to":"it"} | | 790139419 | NULL | 701208315 | contenttranslation | {"from":"en","to":"id"} | | 795566308 | NULL | 704057341 | contenttranslation | {"from":"en","to":"ta"} | | 801628382 | NULL | 707287237 | contenttranslation | {"from":"en","to":"pt"} | | 805054540 | NULL | 709213435 | contenttranslation | {"from":"en","to":"ru"} | | 805056343 | NULL | 709214537 | contenttranslation | {"from":"en","to":"ru"} | | 807581773 | NULL | 710582766 | contenttranslation | {"from":"en","to":"pt"} | | 809272240 | NULL | 711547351 | contenttranslation | {"from":"en","to":"zh"} | | 809273029 | NULL | 711547815 | contenttranslation | {"from":"en","to":"zh"} | | 814967862 | NULL | 714796704 | contenttranslation | {"from":"en","to":"fr"} | | 814967904 | NULL | 714796735 | contenttranslation | {"from":"en","to":"fr"} | | 814968387 | NULL | 714797046 | contenttranslation | {"from":"en","to":"fr"} | | 815803061 | NULL | 715259970 | contenttranslation | {"from":"en","to":"pt"} | | 815906799 | NULL | 715321689 | contenttranslation | {"from":"en","to":"fa"} | | 817059447 | NULL | 715968444 | contenttranslation | {"from":"en","to":"zh"} | | 817805061 | NULL | 716322208 | contenttranslation | {"from":"en","to":"pt"} | | 818308404 | NULL | 716612415 | contenttranslation | {"from":"en","to":"pt"} | | 824645421 | NULL | 719765530 | contenttranslation | {"from":"en","to":"pa"} | | 829205751 | NULL | 722203663 | contenttranslation | {"from":"en","to":"simple"} | | 830798899 | NULL | 723035021 | contenttranslation | {"from":"en","to":"ta"} | | 835268919 | NULL | 725431268 | contenttranslation | {"from":"en","to":"bn"} | | 835269320 | NULL | 725431488 | contenttranslation | {"from":"en","to":"bn"} | | 836999840 | NULL | 726371307 | contenttranslation | {"from":"en","to":"pt"} | | 837701048 | NULL | 726776516 | contenttranslation | {"from":"en","to":"ko"} | | 838151632 | NULL | 727033418 | contenttranslation | {"from":"pt","to":"ca"} | | 839794574 | NULL | 727860892 | contenttranslation | {"from":"de","to":"cs"} | | 841446268 | NULL | 728714530 | contenttranslation | {"from":"en","to":"zh"} | | 843290522 | NULL | 729766412 | contenttranslation | {"from":"en","to":"uk"} | | 844205482 | NULL | 730303777 | contenttranslation | {"from":"en","to":"jv"} | | 845564166 | NULL | 731058743 | contenttranslation | {"from":"en","to":"zh"} | | 845725471 | NULL | 731143074 | contenttranslation | {"from":"en","to":"th"} | | 846221381 | NULL | 731417488 | contenttranslation | {"from":"en","to":"jv"} | | 846221812 | NULL | 731417760 | contenttranslation | {"from":"en","to":"jv"} | | 846225757 | NULL | 731419770 | contenttranslation | {"from":"en","to":"jv"} | | 848930931 | NULL | 732966339 | contenttranslation | {"from":"en","to":"ur"} | | 851907192 | NULL | 734571980 | contenttranslation | {"from":"en","to":"ur"} | | 853102614 | NULL | 735219005 | contenttranslation | {"from":"en","to":"da"} | | 853178017 | NULL | 735265334 | contenttranslation | {"from":"en","to":"da"} | | 855169546 | NULL | 736061011 | contenttranslation | {"from":"en","to":"ar"} | | 856128034 | NULL | 736599553 | contenttranslation | {"from":"en","to":"ur"} | | 864963860 | NULL | 741264669 | contenttranslation | {"from":"en","to":"ur"} | | 879065168 | NULL | 748305847 | contenttranslation | {"from":"en","to":"el"} | | 890316159 | NULL | 754242746 | contenttranslation | {"from":"en","to":"es"} | | 898934041 | NULL | 758536335 | contenttranslation | {"from":"en","to":"pt"} | +-----------+-----------+-----------+--------------------+-----------------------------+ 62 rows in set (0.04 sec)
Note that in some of those neither "from" nor "to" equals "en".
Also, to check the dates I ran the following:
mysql:wikiadmin@db1089 [enwiki]> select ct_rev_id, ct_params, rev_timestamp from change_tag, revision where ct_tag = 'contenttranslation' and ct_params not like '%"to":"en"%' and ct_rev_id = rev_id; +-----------+-----------------------------+----------------+ | ct_rev_id | ct_params | rev_timestamp | +-----------+-----------------------------+----------------+ | 690146422 | {"from":"en","to":"eo"} | 20151111160352 | | 690838686 | {"from":"en","to":"it"} | 20151116003037 | | 691253359 | {"from":"en","to":"zh"} | 20151118170631 | | 693544079 | {"from":"eo","to":"fr"} | 20151203063649 | | 707287237 | {"from":"en","to":"pt"} | 20160227233701 | | 709213435 | {"from":"en","to":"ru"} | 20160309190947 | | 710582766 | {"from":"en","to":"pt"} | 20160317205101 | | 711547351 | {"from":"en","to":"zh"} | 20160323153451 | | 715259970 | {"from":"en","to":"pt"} | 20160414174656 | | 715968444 | {"from":"en","to":"zh"} | 20160419012929 | | 716322208 | {"from":"en","to":"pt"} | 20160421034413 | | 716612415 | {"from":"en","to":"pt"} | 20160422185704 | | 719765530 | {"from":"en","to":"pa"} | 20160511170819 | | 722203663 | {"from":"en","to":"simple"} | 20160526161659 | | 725431268 | {"from":"en","to":"bn"} | 20160615162536 | | 725431488 | {"from":"en","to":"bn"} | 20160615162712 | | 726776516 | {"from":"en","to":"ko"} | 20160624090358 | | 727033418 | {"from":"pt","to":"ca"} | 20160626053711 | | 730303777 | {"from":"en","to":"jv"} | 20160718042951 | | 731143074 | {"from":"en","to":"th"} | 20160723075832 | | 732966339 | {"from":"en","to":"ur"} | 20160804131419 | | 734571980 | {"from":"en","to":"ur"} | 20160815070606 | | 735219005 | {"from":"en","to":"da"} | 20160819091428 | | 735265334 | {"from":"en","to":"da"} | 20160819160714 | | 736061011 | {"from":"en","to":"ar"} | 20160824221331 | | 736599553 | {"from":"en","to":"ur"} | 20160828161021 | | 741264669 | {"from":"en","to":"ur"} | 20160926115833 | | 754242746 | {"from":"en","to":"es"} | 20161211163811 | | 758536335 | {"from":"en","to":"pt"} | 20170106011655 | +-----------+-----------------------------+----------------+ 29 rows in set (0.05 sec)
There are much less results here, and I guess that those that appear in the first query belong to deleted pages.