荒らしの可能性があるウィキデートの編集

This query is marked as a draft This query has been published by 軽快.

匿名登録者による、日本語の説明・別名の追加、ラベル・説明・別名の変更であって、巡回されていないものの一覧

SQL

use jawiki_p;
select *
from revision_userindex as p_rev
where p_rev.rev_id in (31350861,31350879,31350891,31350922,31350954,40644334,46693261,46863438,46996003,47014959,47127846,47219018,47454159,47518047,47606511,47735915,48618327,48818135,49156335,49196639,49201227,49206199,49208407,49252907,49486610,49915202,50342919,50423443,50581349,50785706,50987712,51250008,51341459,51678811,51681043,51992456,52181219,52225568,52234767,52294190,52316163,52346886,52440238,52450641,52456199,52470431,52475136,52508230,52508360,52531269,52531273,52547950,52548875,52549325,52553853,52560335,52786191,52787249,52820163,52877385,52952863,52974627,53124189,53274738,53275503,53286507,53391826,53519507,53563052,53600039,53636574,53693537,53744459,53824952,53997695,54037673,54037676,54135114,54156346,54156863,54173589,54177881,54180021,54183130,54240725,54256135,54342294,54355891,54414218,54450004,54507122,54509715,54520636,54550947,54551836,54653536,54673764,54727436,54876357,54943786,54945393,54960505,54969410,54970479,54970520,54972259,54972278,54972297,54972311,54972589,54973747,54974185,54975194,54979456,54981854,54981876,54982447,54982980,54983649,54996601,55001366,55003801,55004913,55005730,55006295,55015615,55020630,55021489,55021608,55024642,55024792,55040158,55041801,55042050,55042115,55042497,55042675,55042750,55042844,55057209,55071880,55073789,55092470,55101018,55101693,55111601,55114308,55115440,55116504,55123853,55124499,55126467,55134742,55159996,55243922,55300572,55327234,55332617,55335261,55341732,55381296,55390188,55400953,55413523,55415389,55425216,55443540,55498860,55540988,55545553,55562653,55569735,55575867,55578805,55590954,55594193,55603454,55649677,55649739,55657094,55672484,55704981,55705684,55711290,55711347,55719574,55722427,55752086,55780284,55781978,55800038,55811346,55823921,55842785,55847861,55851153,55851450,55881378,55906374,55906519,55906648,55906657,55906734,55906736,55906743,55909459,55909660,55916158,55917969,55918081,55921501,55958888,55962566,56014783,56045517,56048906,56056341,56059183,56063739,56091044,56098755,56098758,56099508,56101026,56110687,56114629,56114960,56121837,56128158,56145611,56152823,56154287,56190051,56191551,56217541,56235301,56246532,56274064,56274997,56296958,56303768,56334083,56337838,56369068,56376034,56376249,56380855,56383557,56388129,56388289,56392620,56412840,56413213,56516459,56523515,56558227,56560516,56568242,56568332,56569482,56570866,56572615,56577392,56578202,56580220,56612423,56623290,56651078,56651973,56731249,56739796,56750002,56798956,56820792,56835808,56838885,56996255,57015506,57030330,57060879,57061463,57062175,57069771,57070994,57089109,57089110,57099090,57119998,57122511,57129429,57132374,57150165,57169004,57176691,57185788,57187617,57247063,57249298,57259641,57280009,57287009,57291250,57299089,57299630,57349060,57350774,57351357,57363536,57372598,57388166,57395628,57400172,57440012,57450869,57469728,57510429,57528118,57531853,57544755,57563597,57592962,57616488,57638415,57686681,57702637,57705801,57705876,57706094,57706296,57706794,57707432,57707760,57728807,57741115,57744487,57752686,57752700,57752703,57752708,57755512,57757252,57765733,57765923,57774057,57808406,57816825,57817506,57832469,57869986,57900373,57924850,57941322,57955483,57958979,57973080,57996949,58031309,58075904,58081502,58088198,58094342,58106095,58114994,58158778,58263281,58277806,58282389,58295953,58313111,58328229,58344068,58350070,58363579,58369415,58380273,58421864,58447856,58464688,58468355,58481125,58484270,58484330,58491351,58492078,58501449,58565189,58616901,58648942,58657186,58659122,58659865,58689359,58698930,58698960,58727364,58809601,58816934,58849057,58876772,58907305,58987367,59034300,59040637,59047214,59092878,59103813,59105447,59148360,59312149,59326112,59345717,59345908,59345957,59345980,59572391,59722532,59736506,59737709,59737720,59744785,59875843,59924497,59982732,60033938,60054389,60072171,60077919,60106075,60200062,60266394,60301403,60340413,60422836,60492646,60578554,60604887,60608811,60613810,60634650,60668060,60676981,60729400,60773105,60773111,60773183,60773286,60773292,60773342,60773343,60829650,60875018,60877357,60918512,60953762,60953833,60985878,61059151,61076448,61081163,61119761,61122738,61123627,61127893,61140748,61174718,61182834,61188702,61189591,61209737,61235450,61241957,61265864,61276748,61276846,61280911,61303902,61316694,61331306,61339703,61348273,61417776,61423895,61432655,61461060,61491341,61520341,61531531,61559651,61572404,61577419,61587329,61599944,61611441,61623422,61623785,61624242,61624421,61624447,61624600,61625009,61625166,61638414,61638819,61639164,61641714,61662733,61671491,61676095,61677441,61691426,61691979,61694933,61708354,61720961,61721407,61722090,61722669,61724380,61724764,61725066,61726311,61727451,61727802,61730029,61730689,61730755,61735724,61735919,61758703,61765463,61768272,61776190,61797457,61797844,61800685,61800839,61804753,61805416,61807677,61809880,61811373,61816993,61819363,61820043,61822610,61829400,61831012,61835034,61846114,61847848,61852658,61862032,61863242,61866985,61875643,61875729,61885756,61888888,61894811,61895734,61897760,61902459,61903577,61905411,61905692,61905825,61905848,61906483,61920528,61922233,61927545,61932309,61938567,61947442,61948083,61954893,61956211,61963967,61974331,61995557,61995700,61995742,62002093,62008591,62041129,62072148,62075173,62078118,62078346,62084092,62085310,62092964,62104429,62105844,62106091,62123004,62159483,62192477,62263916,62270109,62286481,62299459,62299468,62301152,62315562,62315947,62319259,62320130,62328322,62347126,62369076,62376562,62385440,62394098,62402666,62405278,62426982,62427014,62427246,62441098,62444140,62444462,62447834,62448651,62457888,62461123,62464127,62475606,62479648,62490800,62502918,62503967,62537661,62547995,62548216,62559256,62560258,62560494,62560856,62574132,62587762,62587802,62590507,62590517,62591332,62591629,62604990,62618558,62623251,62625748,62641747,62641964,62648215,62659906,62659915,62659927,62659967,62659984,62682174,62686038,62686835,62713455,62718351,62754502,62754534,62821720,62829631,62829692,62829702,62837941,62861307,62862667,62866798,62870789,62877775,62877911,62889796,62894710,62899710,62902509,62923076,62923558,62959490,62962117,62976972,62985156,63002359,63039650,63057888,63066477,63066850,63068037,63173692,63253849,63272716,63303585,63384243,63406000,63429533,63500847,63546196,63551266,63579090,63593940,63645802,63658065,63694972,63736709,63768569,63768632,63768677,63772871,63773878,63774042,63779564,63787499,63788632,63789361,63789375,63789441,63789572,63789600,63789603,63789605,63789612,63789617,63789646,63789662,63789737,63789753,63789766,63789787,63789795,63789803,63789809,63789887,63789929,63789930,63789950,63789962,63790035,63790110,63790147,63790158,63790195,63790225,63790228,63790557,63790588,63790600,63790630,63790853,63792760,63793024,63795993,63796043,63796070,63796102,63796105,63796113,63798822,63814369,63842336,63957436,64025318,64040602,64071527,64074448,64100895,64110476,64112857,64134077,64134105,64134182,64134218,64134223,64134477,64156623,64175668,64202253,64223177,64223806,64223880,64224063,64224725,64224787,64225359,64226728,64226778,64226794,64230530,64230739,64230785,64233236,64236340,64238117,64244070,64254684,64255128,64255564,64255573,64264361,64264375,64264413,64264437,64265254,64269009,64282514,64285507,64294373,64295585,64297531,64298555,64384075,64384120,64407291,64462431,64491528,64491830,64492616,64492697,64492701,64507387,64508194,64508247,64508415,64513852,64515835,64532514,64535368,64542957,64590871,64634167,64726182,64734443,64734486,64734490,64777364,64783455,64801809,64827314,64854099,64862240,64891681,64896775,64898438,64923404,64966230,64982977,64993383,64993428,65021308,65037559,65090941,65090993,65091026,65091126,65091167,65091306,65099875,65215161,65305671,65317076,65363019,65363060,65363148,65371980,65373892,65373928,65374239,65386655,65434170,65443958,65472082,65502169,65531798,65540631,65540755,65541278,65541911,65551357,65575485,65599520,65615886,65626828,65631754,65670660,65692939,65711872,65722041,65734434,65735490,65742925,65773105,65794292,65797398,65797502,65797518,65797606,65907650,65911730,65914726,65914978,65984870,65987914,65988361,66007027,66026251,66026713,66037101,66043324,66052692,66056066,66106729,66119501,66130611,66140320,66147427,66149373,66150230,66150833,66155309,66155652,66156849,66157063,66201857,66235525,66248355,66306205,66311553,66327642,66328597,66363051,66376339,66419137,66544366,66568625,66645136,66645159,66659702,66667363,66668658,66669979,66669982,66670024,66682184,66682253,66682387,66682490,66685246,66713448,66716233,66784759,66801752,66859200,66937216,66937967,66948514,66968501,66971535,67015350,67027969,67028059,67056981,67057786,67060793,67067373,67067381,67117114,67117448,67140734,67140871,67183509,67191316,67201751)

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...