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

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

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

SQL

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

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...