使用者:Antigng/對Bluedeck編輯摘要的研究
最近互助客棧上一直有用戶懷疑User:Bluedeck帳戶可能被盜用,質疑者聲稱Bluedeck最近的編輯行為、編輯傾向和過去非常不一致,認為Bluedeck帳戶存在被盜的可能性。鑑於Bluedeck帳戶有一些防護措施,也有人質疑Bluedeck是把帳戶主動轉交給了另一位用戶。[1]
老實說,我對Bluedeck之前的編輯行為並不了解,所以我做了一個簡單的測試。我從tool labs上中文維基百科的鏡像資料庫查找出Bluedeck喜歡使用的各種編輯摘要,再看Bluedeck做出帶有這些摘要的編輯的時間範圍。如果這些時間範圍的併集不能覆蓋Bluedeck帳號活躍的時間段,那麼Bluedeck帳戶變更使用者的可能性就比較大,反之,可能性就比較小。舉個例子,如果Bluedeck在2014年1月到2014年9月只使用「AAA、BBB、CCC」作編輯摘要,但是在2014年12月至2015年12月間只使用「蘋果、香蕉、李子」作編輯摘要,那麼一種可能的解釋就是Bluedeck帳戶的使用者發生了變化。
實驗結果
[編輯]MariaDB [zhwiki_p]> select rev_user , rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='diction' limit 5000; +----------+----------------+----------+----------+-------------+ | rev_user | rev_timestamp | rev_page | rev_id | rev_comment | +----------+----------------+----------+----------+-------------+ | 1351755 | 20140125001954 | 37966 | 29953425 | diction | | 1351755 | 20151206175457 | 104628 | 38221533 | diction | | 1351755 | 20141018133043 | 193815 | 33008684 | diction | | 1351755 | 20160214000535 | 2849559 | 39065908 | diction | | 1351755 | 20140701094708 | 3159765 | 31755904 | diction | | 1351755 | 20151016030353 | 3736446 | 37572048 | diction | | 1351755 | 20150108162744 | 3736447 | 33884024 | diction | | 1351755 | 20151008164438 | 3736601 | 37484903 | diction | | 1351755 | 20150914214421 | 3903191 | 37212995 | diction | | 1351755 | 20151008163626 | 3903191 | 37484813 | diction | | 1351755 | 20150208025525 | 4506433 | 34245406 | diction | | 1351755 | 20151008163842 | 5039810 | 37484834 | diction | | 1351755 | 20151008163923 | 5039810 | 37484839 | diction | | 1351755 | 20160216203417 | 5234992 | 39099015 | diction | +----------+----------------+----------+----------+-------------+ 14 rows in set (22.19 sec) MariaDB [zhwiki_p]> select rev_user , rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='UI' limit 5000; +----------+----------------+----------+----------+-------------+ | rev_user | rev_timestamp | rev_page | rev_id | rev_comment | +----------+----------------+----------+----------+-------------+ | 1351755 | 20140706030330 | 3779732 | 31800147 | UI | | 1351755 | 20150929154801 | 5165465 | 37393864 | UI | | 1351755 | 20160310021117 | 5260029 | 39330197 | UI | | 1351755 | 20160310022316 | 5260029 | 39330258 | UI | | 1351755 | 20160310022848 | 5260029 | 39330290 | UI | | 1351755 | 20160310023101 | 5260029 | 39330305 | UI | | 1351755 | 20160310023230 | 5260029 | 39330315 | UI | | 1351755 | 20160310023748 | 5260029 | 39330345 | UI | +----------+----------------+----------+----------+-------------+ 8 rows in set (21.03 sec) MariaDB [zhwiki_p]> select rev_user , rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='ui' limit 5000; +----------+----------------+----------+----------+-------------+ | rev_user | rev_timestamp | rev_page | rev_id | rev_comment | +----------+----------------+----------+----------+-------------+ | 1351755 | 20150825235156 | 3903191 | 36977711 | ui | | 1351755 | 20151002024030 | 5049964 | 37418080 | ui | +----------+----------------+----------+----------+-------------+ 2 rows in set (21.62 sec)
從上面兩個查詢結果可以看出,「diction」和「UI」兩個編輯摘要只有Bluedeck用過,而且從2014年1月一直用到2016年3月。
MariaDB [zhwiki_p]> select rev_user , rev_timestamp, rev_page, rev_comment from revision where rev_comment='routine' limit 5000; +----------+----------------+----------+-------------+ | rev_user | rev_timestamp | rev_page | rev_comment | +----------+----------------+----------+-------------+ | 1351755 | 20141005032950 | 3707240 | routine | | 1351755 | 20140905134130 | 3707260 | routine | | 1351755 | 20140629044743 | 3938658 | routine | | 1351755 | 20140630142311 | 3938663 | routine | | 1351755 | 20140630142355 | 3938664 | routine | | 1351755 | 20140705081026 | 3942503 | routine | | 1351755 | 20140706054136 | 3942505 | routine | | 1351755 | 20140707034314 | 3944262 | routine | | 1351755 | 20140709160516 | 3945748 | routine | | 1351755 | 20140804090658 | 3971854 | routine | | 1351755 | 20140805174557 | 3972347 | routine | | 1351755 | 20140807075618 | 3974932 | routine | | 1351755 | 20140810162216 | 3983594 | routine | | 1351755 | 20140812152436 | 3984905 | routine | | 1351755 | 20140813162132 | 3985184 | routine | | 1351755 | 20140816152407 | 3991390 | routine | | 1351755 | 20140825134537 | 4004201 | routine | | 1351755 | 20140831114109 | 4010042 | routine | | 1351755 | 20140901161303 | 4011175 | routine | | 1351755 | 20140902160543 | 4012081 | routine | | 1351755 | 20140903080504 | 4013120 | routine | | 1351755 | 20140904161940 | 4014966 | routine | | 1351755 | 20140905134125 | 4019952 | routine | | 1351755 | 20140907092728 | 4023298 | routine | | 1351755 | 20140908061105 | 4023613 | routine | | 1351755 | 20140909015559 | 4024707 | routine | | 1351755 | 20140629044749 | 4026864 | routine | | 1351755 | 20140912065725 | 4028197 | routine | | 1351755 | 20140912193820 | 4028198 | routine | | 1351755 | 20140630142325 | 4028472 | routine | | 1351755 | 20140915142643 | 4031268 | routine | | 1351755 | 20140916121706 | 4031861 | routine | | 1351755 | 20140918100401 | 4034942 | routine | | 1351755 | 20140705081018 | 4034951 | routine | | 1351755 | 20140919131201 | 4035311 | routine | | 1351755 | 20140706054125 | 4035621 | routine | | 1351755 | 20140710090429 | 4040250 | routine | | 1351755 | 20140922163642 | 4040768 | routine | | 1351755 | 20140924172959 | 4043549 | routine | | 1351755 | 20140925145203 | 4044324 | routine | | 1351755 | 20140926033632 | 4045573 | routine | | 1351755 | 20140927133218 | 4045578 | routine | | 1351755 | 20140928131524 | 4045838 | routine | | 1351755 | 20140930231721 | 4048535 | routine | | 1351755 | 20140717165737 | 4049050 | routine | | 1351755 | 20141001151542 | 4051094 | routine | | 1351755 | 20141002144042 | 4051097 | routine | | 1351755 | 20141004015443 | 4051144 | routine | | 1351755 | 20141005032927 | 4052645 | routine | | 1351755 | 20141005032958 | 4054769 | routine | | 1351755 | 20141005234911 | 4054947 | routine | | 1351755 | 20141007162128 | 4055479 | routine | | 1351755 | 20141008045019 | 4055482 | routine | | 1351755 | 20140723122319 | 4057486 | routine | | 1351755 | 20141010005925 | 4057734 | routine | | 1351755 | 20141014142947 | 4058029 | routine | | 1351755 | 20141010153228 | 4060267 | routine | | 1351755 | 20141011182733 | 4060557 | routine | | 1351755 | 20141013004538 | 4062090 | routine | | 1351755 | 20141013165859 | 4063659 | routine | | 1351755 | 20141016184830 | 4067524 | routine | | 1351755 | 20140910042237 | 4074859 | routine | | 1351755 | 20140804090703 | 4090583 | routine | | 1351755 | 20140804165445 | 4090595 | routine | | 1351755 | 20140921170936 | 4090680 | routine | | 1351755 | 20141018062524 | 4090699 | routine | | 1351755 | 20141019064041 | 4090717 | routine | | 1351755 | 20141020152409 | 4090724 | routine | | 1351755 | 20141022000515 | 4090726 | routine | | 1351755 | 20140805174605 | 4092097 | routine | | 1351755 | 20140807075546 | 4093274 | routine | | 1351755 | 20141022161013 | 4093292 | routine | | 1351755 | 20140809143634 | 4097489 | routine | | 1351755 | 20141023140802 | 4098979 | routine | | 1351755 | 20141024165942 | 4098985 | routine | | 1351755 | 20141024170041 | 4103128 | routine | | 1351755 | 20141027041942 | 4103923 | routine | | 1351755 | 20140810162201 | 4104431 | routine | | 1351755 | 20140812152447 | 4108241 | routine | | 1351755 | 20141027175941 | 4108802 | routine | | 1351755 | 20141028062143 | 4108818 | routine | | 1351755 | 20140813162140 | 4114542 | routine | | 1351755 | 20141030155019 | 4117027 | routine | | 1351755 | 20141031161357 | 4122300 | routine | | 1351755 | 20141101131948 | 4122320 | routine | | 1351755 | 20140816152418 | 4123110 | routine | | 1351755 | 20141103154730 | 4129822 | routine | | 1351755 | 20140820053238 | 4132032 | routine | | 1351755 | 20141104151746 | 4132565 | routine | | 1351755 | 20141106001544 | 4132578 | routine | | 1351755 | 20141106150604 | 4134223 | routine | | 1351755 | 20141108003253 | 4135560 | routine | | 1351755 | 20141109032137 | 4138217 | routine | | 1351755 | 20140825134602 | 4170559 | routine | | 1351755 | 20141112141206 | 4171128 | routine | | 1351755 | 20140831114134 | 4195100 | routine | | 1351755 | 20141118164517 | 4197858 | routine | | 1351755 | 20140901161321 | 4197924 | routine | | 1351755 | 20140902160536 | 4204649 | routine | | 1351755 | 20140903080511 | 4205424 | routine | | 1351755 | 20141119171913 | 4207696 | routine | | 1351755 | 20140904161930 | 4209108 | routine | | 1351755 | 20140907092749 | 4209231 | routine | | 1351755 | 20141121010644 | 4210937 | routine | | 1351755 | 20140908061114 | 4218150 | routine | | 1351755 | 20140909015607 | 4218707 | routine | | 1351755 | 20140910042243 | 4220371 | routine | | 1351755 | 20140912065716 | 4223149 | routine | | 1351755 | 20140912193829 | 4223161 | routine | | 1351755 | 20140915164105 | 4223171 | routine | | 1351755 | 20140916121729 | 4223177 | routine | | 1351755 | 20141208201202 | 4237647 | routine | | 1351755 | 20141208201247 | 4237647 | routine | | 1351755 | 20140918100408 | 4239374 | routine | | 1351755 | 20140919131154 | 4240131 | routine | | 1351755 | 20140921170912 | 4244688 | routine | | 1351755 | 20140922163655 | 4247566 | routine | | 1351755 | 20140924173053 | 4250806 | routine | | 1351755 | 20140925145209 | 4253984 | routine | | 1351755 | 20140926033030 | 4255989 | routine | | 1351755 | 20140927133229 | 4257467 | routine | | 1351755 | 20140928140456 | 4261882 | routine | | 1351755 | 20140930231728 | 4264252 | routine | | 1351755 | 20140930000602 | 4264328 | routine | | 1351755 | 20141001151512 | 4266042 | routine | | 1351755 | 20141002144049 | 4266051 | routine | | 1351755 | 20141004015411 | 4271508 | routine | | 1351755 | 20141005032921 | 4271765 | routine | | 1351755 | 20141005234857 | 4275300 | routine | | 1351755 | 20141007162138 | 4275303 | routine | | 1351755 | 20141008045029 | 4275316 | routine | | 1351755 | 20141010005901 | 4284644 | routine | | 1351755 | 20141010153313 | 4284647 | routine | | 1351755 | 20141011182742 | 4284649 | routine | | 1351755 | 20141013004553 | 4290710 | routine | | 1351755 | 20141014142908 | 4293526 | routine | | 1351755 | 20141014142927 | 4293534 | routine | | 1351755 | 20141016184845 | 4298229 | routine | | 1351755 | 20141018062529 | 4299904 | routine | | 1351755 | 20141019064030 | 4300183 | routine | | 1351755 | 20141020153022 | 4306490 | routine | | 1351755 | 20141022000504 | 4306494 | routine | | 1351755 | 20141023142305 | 4311843 | routine | | 1351755 | 20141027041936 | 4313990 | routine | | 1351755 | 20141027175934 | 4313993 | routine | | 1351755 | 20141028062136 | 4313995 | routine | | 1351755 | 20141029144321 | 4322714 | routine | | 1351755 | 20141030154830 | 4323255 | routine | | 1351755 | 20141031161405 | 4326770 | routine | | 1351755 | 20141103154718 | 4332759 | routine | | 1351755 | 20141104151804 | 4335035 | routine | | 1351755 | 20141106001534 | 4335043 | routine | | 1351755 | 20141106150617 | 4335045 | routine | | 1351755 | 20141108003245 | 4339929 | routine | | 1351755 | 20141109030247 | 4342155 | routine | | 1351755 | 20141112141232 | 4354262 | routine | | 1351755 | 20141118164444 | 4365612 | routine | | 1351755 | 20141119171923 | 4366179 | routine | | 1351755 | 20141121181412 | 4368603 | routine | | 1351755 | 20141122170102 | 4368607 | routine | | 1351755 | 20141125044929 | 4375480 | routine | | 1351755 | 20141127010758 | 4380903 | routine | | 1351755 | 20141127014440 | 4380910 | routine | | 1351755 | 20141127161827 | 4380915 | routine | | 1351755 | 20141130160843 | 4380928 | routine | | 1351755 | 20141202050902 | 4380933 | routine | | 1351755 | 20141208030858 | 4401538 | routine | | 1351755 | 20141208201010 | 4401700 | routine | | 1351755 | 20141208201103 | 4401702 | routine | | 1351755 | 20141211181140 | 4401711 | routine | | 1351755 | 20141212152259 | 4401712 | routine | | 1351755 | 20141213144604 | 4407950 | routine | | 1351755 | 20141214152818 | 4407952 | routine | | 1351755 | 20141215140513 | 4407958 | routine | | 1351755 | 20141218163506 | 4419662 | routine | | 1351755 | 20141219135101 | 4419671 | routine | | 1351755 | 20141221000905 | 4419675 | routine | | 1351755 | 20141221234334 | 4419682 | routine | | 1351755 | 20141222163859 | 4420321 | routine | | 1351755 | 20150114024608 | 4464405 | routine | | 1351755 | 20150202152225 | 4497894 | routine | | 1351755 | 20150224000543 | 4527943 | routine | +----------+----------------+----------+-------------+ 182 rows in set (26.13 sec) MariaDB [zhwiki_p]> select rev_user , rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='Routine' limit 5000; +----------+----------------+----------+----------+-------------+ | rev_user | rev_timestamp | rev_page | rev_id | rev_comment | +----------+----------------+----------+----------+-------------+ | 1351755 | 20140710090421 | 3945776 | 31844648 | Routine | | 1351755 | 20140711052819 | 3952033 | 31853124 | Routine | | 1351755 | 20140712054045 | 3952040 | 31864139 | Routine | | 1351755 | 20140719042939 | 3952487 | 31938385 | Routine | | 1351755 | 20140723122325 | 3959391 | 31986549 | Routine | | 1351755 | 20140730025849 | 3969003 | 32068379 | Routine | | 1351755 | 20140804165439 | 3971856 | 32142572 | Routine | | 1351755 | 20140808132841 | 3976343 | 32194161 | Routine | | 1351755 | 20140811091600 | 3984023 | 32228823 | Routine | | 1351755 | 20140814154037 | 3987893 | 32271453 | Routine | | 1351755 | 20140823001547 | 3999025 | 32367461 | Routine | | 1351755 | 20140830041806 | 4005731 | 32491098 | Routine | | 1351755 | 20140830041849 | 4009234 | 32491113 | Routine | | 1351755 | 20140719042953 | 4049059 | 31938386 | Routine | | 1351755 | 20140730025926 | 4067299 | 32068385 | Routine | | 1351755 | 20140914024420 | 4088155 | 32649531 | Routine | | 1351755 | 20140808132902 | 4097485 | 32194164 | Routine | | 1351755 | 20140811091942 | 4105346 | 32228862 | Routine | | 1351755 | 20140814154051 | 4115384 | 32271455 | Routine | | 1351755 | 20141102154949 | 4122323 | 33162154 | Routine | | 1351755 | 20140823001532 | 4135305 | 32367459 | Routine | | 1351755 | 20141110044618 | 4139558 | 33240816 | Routine | | 1351755 | 20141111224110 | 4144591 | 33258335 | Routine | | 1351755 | 20141114002221 | 4190134 | 33305186 | Routine | | 1351755 | 20140830041754 | 4192017 | 32491095 | Routine | | 1351755 | 20140914024411 | 4223168 | 32649530 | Routine | | 1351755 | 20141205172318 | 4233621 | 33517824 | Routine | | 1351755 | 20141101131954 | 4328786 | 33149128 | Routine | | 1351755 | 20141102154932 | 4332745 | 33162150 | Routine | | 1351755 | 20141110044633 | 4342158 | 33240819 | Routine | | 1351755 | 20141204083742 | 4395516 | 33503856 | Routine | | 1351755 | 20141205172225 | 4397011 | 33517818 | Routine | | 1351755 | 20141210175008 | 4401703 | 33568146 | Routine | | 1351755 | 20150202152220 | 4411106 | 34185025 | Routine | +----------+----------------+----------+----------+-------------+ 34 rows in set (21.21 sec) MariaDB [zhwiki_p]> select rev_user , rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='日常' limit 5000; +----------+----------------+----------+----------+-------------+ | rev_user | rev_timestamp | rev_page | rev_id | rev_comment | +----------+----------------+----------+----------+-------------+ | 1351755 | 20140430003449 | 3840527 | 31143483 | 日常 | | 1351755 | 20140430034040 | 3878071 | 31144630 | 日常 | | 1351755 | 20140501071058 | 3883270 | 31156448 | 日常 | | 1351755 | 20140501071211 | 3884298 | 31156459 | 日常 | | 1351755 | 20140504062935 | 3885400 | 31187661 | 日常 | | 1351755 | 20140504064728 | 3885441 | 31187901 | 日常 | | 1351755 | 20140506005929 | 3885442 | 31206330 | 日常 | | 1351755 | 20140507011953 | 3885819 | 31215998 | 日常 | | 1351755 | 20140507234822 | 3887251 | 31226061 | 日常 | | 1351755 | 20140606025854 | 3909337 | 31508530 | 日常 | | 1351755 | 20140608045937 | 3909844 | 31530027 | 日常 | | 1351755 | 20140613054258 | 3919178 | 31579140 | 日常 | | 1351755 | 20140616024454 | 3925814 | 31608256 | 日常 | | 1351755 | 20140617030956 | 3926459 | 31618386 | 日常 | | 1351755 | 20140620082141 | 3928773 | 31650181 | 日常 | | 1351755 | 20140622024654 | 3930966 | 31665991 | 日常 | | 1351755 | 20140623102021 | 3930967 | 31679343 | 日常 | | 1351755 | 20140625184423 | 3932336 | 31702304 | 日常 | | 1351755 | 20140627022903 | 3932960 | 31713333 | 日常 | | 1351755 | 20140627023152 | 3936061 | 31713356 | 日常 | | 1351755 | 20140628035046 | 3937205 | 31723449 | 日常 | | 1351755 | 20140702154925 | 3939545 | 31768305 | 日常 | | 1351755 | 20140703230546 | 3939899 | 31779173 | 日常 | | 1351755 | 20140708162252 | 3944540 | 31828850 | 日常 | | 1351755 | 20140602045302 | 3951193 | 31468640 | 日常 | | 1351755 | 20140713084618 | 3952147 | 31876808 | 日常 | | 1351755 | 20140716150931 | 3952483 | 31911884 | 日常 | | 1351755 | 20140715041543 | 3952484 | 31895492 | 日常 | | 1351755 | 20140713173203 | 3952485 | 31881859 | 日常 | | 1351755 | 20140719043207 | 3952495 | 31938401 | 日常 | | 1351755 | 20140430003745 | 3953297 | 31143495 | 日常 | | 1351755 | 20140504063746 | 3956120 | 31187756 | 日常 | | 1351755 | 20140719171223 | 3956612 | 31945704 | 日常 | | 1351755 | 20140502102322 | 3956790 | 31169335 | 日常 | | 1351755 | 20140504064224 | 3959342 | 31187822 | 日常 | | 1351755 | 20140506010040 | 3959348 | 31206334 | 日常 | | 1351755 | 20140721233528 | 3959389 | 31967519 | 日常 | | 1351755 | 20140725192310 | 3962518 | 32016607 | 日常 | | 1351755 | 20140507012152 | 3963270 | 31216020 | 日常 | | 1351755 | 20140507234927 | 3963276 | 31226065 | 日常 | | 1351755 | 20140508233157 | 3963946 | 31235415 | 日常 | | 1351755 | 20140727082223 | 3965750 | 32033823 | 日常 | | 1351755 | 20140727082329 | 3965754 | 32033839 | 日常 | | 1351755 | 20140728104556 | 3965755 | 32047590 | 日常 | | 1351755 | 20140729080240 | 3968913 | 32057656 | 日常 | | 1351755 | 20140731152452 | 3971850 | 32090620 | 日常 | | 1351755 | 20140801174526 | 3971851 | 32105549 | 日常 | | 1351755 | 20140802170430 | 3971852 | 32117514 | 日常 | | 1351755 | 20140816061424 | 3989166 | 32290083 | 日常 | | 1351755 | 20140818015551 | 3991388 | 32309625 | 日常 | | 1351755 | 20140818235957 | 3995934 | 32321578 | 日常 | | 1351755 | 20140820053219 | 3996680 | 32335852 | 日常 | | 1351755 | 20140820053248 | 3996681 | 32335860 | 日常 | | 1351755 | 20140821162456 | 3996683 | 32354154 | 日常 | | 1351755 | 20140824003120 | 3999032 | 32378723 | 日常 | | 1351755 | 20140608050042 | 3999413 | 31530031 | 日常 | | 1351755 | 20140825001423 | 4000438 | 32405461 | 日常 | | 1351755 | 20140608050149 | 4002316 | 31530044 | 日常 | | 1351755 | 20140614015114 | 4002433 | 31586568 | 日常 | | 1351755 | 20140617030803 | 4002439 | 31618374 | 日常 | | 1351755 | 20140617030905 | 4002442 | 31618382 | 日常 | | 1351755 | 20140620082211 | 4002459 | 31650186 | 日常 | | 1351755 | 20140827062443 | 4004203 | 32457314 | 日常 | | 1351755 | 20140828052755 | 4004207 | 32468171 | 日常 | | 1351755 | 20140828052839 | 4004751 | 32468178 | 日常 | | 1351755 | 20140622024646 | 4017556 | 31665989 | 日常 | | 1351755 | 20140623102103 | 4019167 | 31679349 | 日常 | | 1351755 | 20140623102028 | 4019171 | 31679344 | 日常 | | 1351755 | 20140625184527 | 4022436 | 31702314 | 日常 | | 1351755 | 20140627022947 | 4022632 | 31713337 | 日常 | | 1351755 | 20140907000525 | 4022637 | 32578104 | 日常 | | 1351755 | 20140627023239 | 4025132 | 31713371 | 日常 | | 1351755 | 20140628035015 | 4025462 | 31723440 | 日常 | | 1351755 | 20140911001614 | 4028195 | 32618101 | 日常 | | 1351755 | 20140702155027 | 4030491 | 31768313 | 日常 | | 1351755 | 20140703234409 | 4031063 | 31779255 | 日常 | | 1351755 | 20140917095342 | 4034346 | 32699134 | 日常 | | 1351755 | 20140921000257 | 4036595 | 32736791 | 日常 | | 1351755 | 20140708162328 | 4038127 | 31828858 | 日常 | | 1351755 | 20140709160602 | 4039635 | 31838639 | 日常 | | 1351755 | 20140711052908 | 4041601 | 31853128 | 日常 | | 1351755 | 20140712054250 | 4041605 | 31864153 | 日常 | | 1351755 | 20140923083958 | 4043539 | 32761187 | 日常 | | 1351755 | 20140713084649 | 4044744 | 31876813 | 日常 | | 1351755 | 20140713173241 | 4045013 | 31881861 | 日常 | | 1351755 | 20140715041625 | 4046606 | 31895496 | 日常 | | 1351755 | 20140716152241 | 4047866 | 31912002 | 日常 | | 1351755 | 20140719043214 | 4051099 | 31938404 | 日常 | | 1351755 | 20140719171245 | 4052417 | 31945707 | 日常 | | 1351755 | 20140720172508 | 4052420 | 31955881 | 日常 | | 1351755 | 20140721233954 | 4054446 | 31967532 | 日常 | | 1351755 | 20140725035609 | 4057496 | 32006571 | 日常 | | 1351755 | 20140725192353 | 4057503 | 32016610 | 日常 | | 1351755 | 20140727082249 | 4057525 | 32033834 | 日常 | | 1351755 | 20140727082352 | 4064666 | 32033844 | 日常 | | 1351755 | 20140728104633 | 4064672 | 32047594 | 日常 | | 1351755 | 20140729080338 | 4067296 | 32057673 | 日常 | | 1351755 | 20140731152503 | 4075418 | 32090624 | 日常 | | 1351755 | 20140801174550 | 4075426 | 32105553 | 日常 | | 1351755 | 20140802170440 | 4081287 | 32117515 | 日常 | | 1351755 | 20140803174636 | 4082019 | 32130492 | 日常 | | 1351755 | 20140816061436 | 4116730 | 32290086 | 日常 | | 1351755 | 20140818015559 | 4123112 | 32309626 | 日常 | | 1351755 | 20140819000012 | 4127139 | 32321582 | 日常 | | 1351755 | 20140820053212 | 4129694 | 32335850 | 日常 | | 1351755 | 20140821162507 | 4134211 | 32354157 | 日常 | | 1351755 | 20140824003127 | 4138216 | 32378724 | 日常 | | 1351755 | 20140825001433 | 4140471 | 32405462 | 日常 | | 1351755 | 20140827062503 | 4181253 | 32457319 | 日常 | | 1351755 | 20140828052819 | 4181259 | 32468175 | 日常 | | 1351755 | 20140828052857 | 4188394 | 32468179 | 日常 | | 1351755 | 20140907000419 | 4209225 | 32578098 | 日常 | | 1351755 | 20140911001621 | 4222747 | 32618102 | 日常 | | 1351755 | 20140917095359 | 4233229 | 32699136 | 日常 | | 1351755 | 20140921000317 | 4242131 | 32736793 | 日常 | | 1351755 | 20140923083937 | 4250795 | 32761184 | 日常 | | 1351755 | 20141204043553 | 4380935 | 33501596 | 日常 | +----------+----------------+----------+----------+-------------+ 117 rows in set (26.07 sec)
「routine」這個編輯摘要也只有Bludeck用過,從2014年6月用到2015年2月。
MariaDB [zhwiki_p]> select rev_user , rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='test finished' limit 5000; +----------+----------------+----------+----------+---------------+ | rev_user | rev_timestamp | rev_page | rev_id | rev_comment | +----------+----------------+----------+----------+---------------+ | 1351755 | 20151015014002 | 3813089 | 37563017 | test finished | | 1351755 | 20151020162956 | 3813089 | 37616211 | test finished | | 1351755 | 20151020163728 | 3813089 | 37616288 | test finished | | 1351755 | 20140621152702 | 5165465 | 31663290 | test finished | | 1351755 | 20140621153748 | 5165465 | 31663409 | test finished | | 1351755 | 20140623144110 | 5165465 | 31681486 | test finished | | 1351755 | 20140624054644 | 5165465 | 31686532 | test finished | | 1351755 | 20140624055726 | 5165465 | 31686637 | test finished | | 1351755 | 20151003001650 | 5165465 | 37427153 | test finished | | 1351755 | 20151005162132 | 5165465 | 37457652 | test finished | | 1351755 | 20151025214750 | 5165465 | 37664188 | test finished | +----------+----------------+----------+----------+---------------+ 11 rows in set (25.81 sec)
從2014年6月到2015年10月。
MariaDB [zhwiki_p]> select rev_user , rev_timestamp, rev_page, rev_comment from revision where rev_comment='收工' limit 5000; +----------+----------------+----------+-------------+ | rev_user | rev_timestamp | rev_page | rev_comment | +----------+----------------+----------+-------------+ | 15539 | 20070110214402 | 470899 | 收工 | | 82128 | 20070724005936 | 556570 | 收工 | | 1351755 | 20141213152228 | 4226999 | 收工 | | 1351755 | 20141222162311 | 4285106 | 收工 | | 1351755 | 20141222163445 | 4297566 | 收工 | | 1351755 | 20141213145524 | 4398193 | 收工 | | 1351755 | 20141214155800 | 4400113 | 收工 | | 1351755 | 20150904233111 | 4919207 | 收工 | | 1351755 | 20150916034627 | 4929797 | 收工 | | 1351755 | 20150912040131 | 4954187 | 收工 | | 1351755 | 20150915023258 | 4985213 | 收工 | | 1351755 | 20151022012723 | 5014077 | 收工 | | 1351755 | 20151019013030 | 5021024 | 收工 | | 1351755 | 20151019145339 | 5031803 | 收工 | | 1351755 | 20151019144748 | 5043560 | 收工 | | 1351755 | 20151105213209 | 5048291 | 收工 | | 1351755 | 20151028052411 | 5050589 | 收工 | | 1351755 | 20151115011051 | 5054381 | 收工 | | 1351755 | 20151113131821 | 5063890 | 收工 | | 1351755 | 20151114145030 | 5067253 | 收工 | | 1351755 | 20151116032851 | 5067910 | 收工 | | 1351755 | 20151114150932 | 5072560 | 收工 | | 1960229 | 20160413114422 | 5234277 | 收工 | +----------+----------------+----------+-------------+
「收工」這個編輯摘要Bluedeck從2014年12月用到2015年11月。
MariaDB [zhwiki_p]> select rev_user , rev_timestamp, rev_id, rev_comment from revision where rev_comment='Archive' limit 5000; +----------+----------------+----------+-------------+ | rev_user | rev_timestamp | rev_id | rev_comment | +----------+----------------+----------+-------------+ | 90660 | 20090914152248 | 11150115 | Archive | | 1676 | 20051108072005 | 1165163 | Archive | | 10070 | 20150426072029 | 35501079 | Archive | | 13769 | 20070202161858 | 3441096 | Archive | | 59964 | 20080114223635 | 6025059 | Archive | | 1676 | 20051108072014 | 1165165 | Archive | | 1911556 | 20150207101954 | 34238958 | Archive | | 1401447 | 20140330133833 | 30851627 | Archive | | 476067 | 20091012142351 | 11378729 | Archive | | 476067 | 20091012142706 | 11378762 | Archive | | 834818 | 20121018042006 | 23334476 | Archive | | 476067 | 20090521133934 | 10111426 | Archive | | 235906 | 20090117124342 | 9074280 | Archive | | 1634825 | 20140627132458 | 31718861 | Archive | | 41486 | 20070523170143 | 4244940 | Archive | | 235906 | 20120312024040 | 19534201 | Archive | | 226510 | 20121225155451 | 24236903 | Archive | | 59964 | 20080117221947 | 6044423 | Archive | | 59964 | 20080123193436 | 6088619 | Archive | | 59964 | 20080128202709 | 6122400 | Archive | | 418960 | 20091214094417 | 11837042 | Archive | | 476067 | 20090401132341 | 9698839 | Archive | | 476067 | 20090419081813 | 9845650 | Archive | | 476067 | 20090419143255 | 9848197 | Archive | | 476067 | 20090423064014 | 9875829 | Archive | | 476067 | 20090501074320 | 9939225 | Archive | | 476067 | 20090512130318 | 10036443 | Archive | | 476067 | 20090520141710 | 10103534 | Archive | | 476067 | 20090524092935 | 10136345 | Archive | | 476067 | 20090530141019 | 10194228 | Archive | | 476067 | 20090605145234 | 10243829 | Archive | | 476067 | 20090708014511 | 10536051 | Archive | | 476067 | 20090709104542 | 10549585 | Archive | | 476067 | 20090806154228 | 10806526 | Archive | | 511509 | 20090928093025 | 11265184 | Archive | | 511509 | 20110319110329 | 16033182 | Archive | | 235906 | 20090117124330 | 9074278 | Archive | | 476067 | 20090818131551 | 10915863 | Archive | | 476067 | 20090818131653 | 10915874 | Archive | | 90660 | 20090914152418 | 11150124 | Archive | | 476067 | 20090818131544 | 10915860 | Archive | | 476067 | 20090818131648 | 10915872 | Archive | | 757371 | 20140803144205 | 32128594 | Archive | | 476067 | 20090818131725 | 10915883 | Archive | | 476067 | 20090818131718 | 10915880 | Archive | | 12259 | 20090911141421 | 11122585 | Archive | | 511509 | 20090928093037 | 11265188 | Archive | | 757371 | 20130816040137 | 28242503 | Archive | | 235906 | 20101029180934 | 14782034 | Archive | | 943713 | 20110624172336 | 16886835 | Archive | | 511509 | 20110319110327 | 16033180 | Archive | | 379101 | 20140524084444 | 31382204 | Archive | | 235906 | 20120312024021 | 19534197 | Archive | | 943713 | 20110624172210 | 16886826 | Archive | | 46136 | 20110618175425 | 16828114 | Archive | | 46136 | 20110618175700 | 16828131 | Archive | | 379101 | 20140907001027 | 32578136 | Archive | | 999313 | 20120131091805 | 19100536 | Archive | | 379101 | 20150511065541 | 35682254 | Archive | | 1520631 | 20140508075943 | 31229480 | Archive | | 1351755 | 20140329150505 | 30842352 | Archive | | 1351755 | 20140401031754 | 30864896 | Archive | | 1351755 | 20140428122936 | 31129812 | Archive | | 1351755 | 20140507055850 | 31217970 | Archive | | 1351755 | 20140519074851 | 31333594 | Archive | | 1351755 | 20140527052107 | 31408754 | Archive | | 1351755 | 20140602044003 | 31468466 | Archive | | 1351755 | 20140616091140 | 31611970 | Archive | | 1351755 | 20140618062933 | 31629601 | Archive | | 1351755 | 20140622025510 | 31666029 | Archive | | 1351755 | 20140623145947 | 31681773 | Archive | | 1351755 | 20140705081829 | 31792523 | Archive | | 1351755 | 20140707033157 | 31811041 | Archive | | 1351755 | 20140713132748 | 31879643 | Archive | | 1351755 | 20140731125919 | 32088534 | Archive | | 1351755 | 20140815083922 | 32279029 | Archive | | 1351755 | 20140819080234 | 32326061 | Archive | | 1351755 | 20140908093736 | 32593615 | Archive | | 1351755 | 20141011001533 | 32932753 | Archive | | 1351755 | 20141015015309 | 32974618 | Archive | | 1351755 | 20141021143033 | 33039801 | Archive | | 1351755 | 20141027181819 | 33099803 | Archive | | 1351755 | 20141108150255 | 33220151 | Archive | | 1351755 | 20141129163406 | 33459287 | Archive | | 1351755 | 20150206020253 | 34221819 | Archive | | 1351755 | 20150206020333 | 34221825 | Archive | | 1351755 | 20150810203654 | 36786861 | Archive | | 757371 | 20140803144208 | 32128595 | Archive | | 1351755 | 20140420120954 | 31054605 | Archive | | 379101 | 20150121200354 | 34045825 | Archive | | 1351755 | 20140329150342 | 30842343 | Archive | | 1351755 | 20140401031726 | 30864889 | Archive | | 1351755 | 20140507055629 | 31217958 | Archive | | 1351755 | 20140519074816 | 31333589 | Archive | | 1351755 | 20140527052030 | 31408742 | Archive | | 1351755 | 20140602043923 | 31468460 | Archive | | 1351755 | 20140616091135 | 31611969 | Archive | | 1351755 | 20140618062905 | 31629598 | Archive | | 1351755 | 20140622025448 | 31666026 | Archive | | 1351755 | 20140623145930 | 31681766 | Archive | | 1351755 | 20140705081803 | 31792518 | Archive | | 1351755 | 20140707033121 | 31811034 | Archive | | 1351755 | 20140713132644 | 31879627 | Archive | | 1351755 | 20140813165344 | 32258625 | Archive | | 1351755 | 20140815083841 | 32279026 | Archive | | 1351755 | 20140819080108 | 32326050 | Archive | | 1351755 | 20140908093617 | 32593600 | Archive | | 1351755 | 20140929092527 | 32815315 | Archive | | 1351755 | 20141011001511 | 32932751 | Archive | | 1351755 | 20141013070608 | 32957296 | Archive | | 1351755 | 20141015015305 | 32974615 | Archive | | 1351755 | 20141027181754 | 33099797 | Archive | | 1351755 | 20141108150215 | 33220141 | Archive | | 1351755 | 20141129163303 | 33459275 | Archive | | 1351755 | 20141223053552 | 33694163 | Archive | | 1351755 | 20141230002228 | 33772981 | Archive | | 1351755 | 20150206020237 | 34221816 | Archive | | 1351755 | 20150206020506 | 34221847 | Archive | | 1351755 | 20150810203404 | 36786857 | Archive | +----------+----------------+----------+-------------+ 119 rows in set (22.35 sec) MariaDB [zhwiki_p]> select rev_user , rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='ARC' limit 5000; +----------+----------------+----------+----------+-------------+ | rev_user | rev_timestamp | rev_page | rev_id | rev_comment | +----------+----------------+----------+----------+-------------+ | 1351755 | 20150824153532 | 5165465 | 36962874 | ARC | +----------+----------------+----------+----------+-------------+ 1 row in set (29.12 sec) MariaDB [zhwiki_p]> select rev_user , rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='arc' limit 5000; +----------+----------------+----------+----------+-------------+ | rev_user | rev_timestamp | rev_page | rev_id | rev_comment | +----------+----------------+----------+----------+-------------+ | 28258 | 20140123073529 | 140048 | 29936714 | arc | | 28258 | 20150407081309 | 140048 | 35036067 | arc | | 28258 | 20140123073419 | 1847919 | 29936700 | arc | | 1351755 | 20140129044541 | 3779732 | 29997673 | arc | | 1351755 | 20140126020118 | 5165465 | 29964096 | arc | | 1351755 | 20140129044527 | 5165465 | 29997665 | arc | | 1351755 | 20140406070745 | 5165465 | 30919578 | arc | +----------+----------------+----------+----------+-------------+
近期使用Archive、arc、ARC這樣的編輯摘要存檔討論頁的基本上都是Bluedeck。(最近還有一位User:Kp2729使用arc,不過看上去和Bluedeck並無關連)從2014年1月用到2015年9月。之後Bluedeck開始使用自動化的工具存檔,摘要為ARC+、ARC-。
MariaDB [zhwiki_p]> select rev_user , rev_timestamp, rev_page, rev_id ,rev_comment from revision where rev_comment='VAN' limit 5000; +----------+----------------+----------+----------+-------------+ | rev_user | rev_timestamp | rev_page | rev_id | rev_comment | +----------+----------------+----------+----------+-------------+ | 1351755 | 20151020173712 | 623 | 37616748 | VAN | | 1351755 | 20141015155822 | 160864 | 32982289 | VAN | | 1351755 | 20140928150317 | 215310 | 32809102 | VAN | | 1890236 | 20160103051226 | 1346634 | 38641293 | VAN | | 1890236 | 20160107102630 | 1556662 | 38682987 | VAN | | 1351755 | 20151120231342 | 4236199 | 37950991 | VAN | | 1351755 | 20151021002709 | 4459622 | 37617904 | VAN | +----------+----------------+----------+----------+-------------+ 7 rows in set (22.39 sec)
只有Bluedeck和Black9869184在編輯摘要里用過VAN代表破壞,前者從2014年9月用到2015年11月。兩位用戶看上去無關聯。
結論
[編輯]綜合以上結果,從編輯摘要的角度來看,Bluedeck帳戶的使用者不像是發生了變化。