MisterSynergy added a comment.
In T263730#6490727 <https://phabricator.wikimedia.org/T263730#6490727>, @Lucas_Werkmeister_WMDE wrote: > In other words, potentially affected is any item that was edited on 10 September between 11:06 and 15:58 (UTC) and then deleted before 7 October 13:27, if I’m not mistaken. MariaDB [wikidatawiki_p]> SELECT DISTINCT wbit_item_id, log_title, log_timestamp FROM wbt_item_terms JOIN logging ON wbit_item_id=SUBSTRING(log_title, 2) WHERE log_type='delete' AND log_action='delete' AND log_namespace=0 AND log_title NOT IN (SELECT page_title FROM page WHERE page_namespace=0) ORDER BY log_timestamp ASC; +--------------+-----------+----------------+ | wbit_item_id | log_title | log_timestamp | +--------------+-----------+----------------+ | 1798871 | Q1798871 | 20190908075346 | | 67206532 | Q67206532 | 20190910183620 | | 67206284 | Q67206284 | 20190910183629 | | 67205707 | Q67205707 | 20190910183639 | | 67205787 | Q67205787 | 20190910183649 | | 67205329 | Q67205329 | 20190910183659 | | 16376239 | Q16376239 | 20190910183709 | | 12865809 | Q12865809 | 20190910183719 | | 25667640 | Q25667640 | 20190910183731 | | 25667272 | Q25667272 | 20190910183740 | | 25664811 | Q25664811 | 20190910183750 | | 3546228 | Q3546228 | 20190910183800 | | 65175512 | Q65175512 | 20190910183810 | | 65051610 | Q65051610 | 20190910183820 | | 67205948 | Q67205948 | 20190910183830 | | 9307721 | Q9307721 | 20190910183840 | ... (skip plenty of rows here) ... | 30686328 | Q30686328 | 20191103185910 | | 25333226 | Q25333226 | 20191103194317 | | 8877061 | Q8877061 | 20191103194339 | | 60975079 | Q60975079 | 20191103194433 | | 8443133 | Q8443133 | 20191103194539 | | 70013783 | Q70013783 | 20191107163208 | | 74670014 | Q74670014 | 20191113061939 | | 74065265 | Q74065265 | 20191115121708 | | 74672773 | Q74672773 | 20191125085852 | | 74688761 | Q74688761 | 20191125090312 | | 74693264 | Q74693264 | 20191125090707 | | 74670082 | Q74670082 | 20191125093548 | | 74669422 | Q74669422 | 20191125093827 | | 74668425 | Q74668425 | 20191125185307 | | 74674299 | Q74674299 | 20191125234049 | | 74691179 | Q74691179 | 20191126080348 | | 74483053 | Q74483053 | 20191126101239 | | 74675327 | Q74675327 | 20191127111732 | | 74453398 | Q74453398 | 20191205123011 | | 74613482 | Q74613482 | 20191206010632 | | 74692551 | Q74692551 | 20191223084428 | | 87589401 | Q87589401 | 20200313152209 | +--------------+-----------+----------------+ 9594 rows in set (17 min 42.76 sec) Except for one entry, the problem starts indeed on the afternoon of 2019-10-09 (item deletion timestamp). However, there are plenty of entries until ~2019-11-03 in the evening (deletion time), and only 17 entries from a later deletion time. TASK DETAIL https://phabricator.wikimedia.org/T263730 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: MisterSynergy Cc: MisterSynergy, Addshore, Aklapper, Lucas_Werkmeister_WMDE, Akuckartz, darthmon_wmde, Nandana, lucamauri, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
