Untitled query #42237

This query is marked as a draft This query has been published by Miriam (WMF).
SQL

select rev_id, rev_page, MAX(rev_timestamp)
from revision
where rev_page in (27291778,27260678,27261001,356898,27331990,1872707,27273652,1872804,27263823,1923728,414450,37788803,46644884,27306991,39122415,27362090,428662,417506,1872829,27262613,27354781,434636,54257580,50835552,27283740,9041992,27292483,46641161,434967,450326,413976,407867,27266258,434656,421641,27306515,449436,1847104,450461,46645781,23135838,27284572,46641170,46646317,1770047,419348,4673412,27296191,46647123,42864051,414426,2853551,27262471,54257707,27294272,46646710,46641694,27276873,46642403,420127,6158791,420169,46645820,46642355,1867366,50438675,30876369,37796971,1368464,44070260,46648437,421577,27219595,27318945,46641756,46644584,434606,27273546,469189,43824791,46641683,50438409,100456,27305991,50446519,420134,1872870,420191,46643790,27268625,1873684,27279085,27292040,435638,41318527,10078053,1872632,419388,46641857,26051384,413890,46646352,413956,428653,427376,46646944,46642660,27283593,27268507,428627,422823,46646158,27267782,414777,450363,414659,27286521,54257955,46437939,27273818,419516,1863298,435652,46643848,1281068,420136,46652793,46646648,7134310,414916,25958960,1847558,414804,46646280,54258120,54258013,54258126,54257796,54257749,54257520,54258149,54258178,54258134,54258201,46645960,54258214,54258239,54259012,54258925,54258545,54258520,54258795,54259235,54258483,54258589,54257897,54258345,53372179,54258033,54257645,54259228,27053677,54258783,54258722,54257892,54258602,54258569,54258069,54257999,54257859,54258453,54257976,54258496,54257447,54258532,54258669,54258911,79409,416913,351873,26787240,415702,415036,1866749,3665467,19065069,13939912,415035,33131881,18681491,30464103,27266895,1873667,26657615,27306797,19360784,38624156,46646725,27264640,46642592,31697595,1996199,48099093,414428,26822115,27278540,46645804,414602,224819,414618,311079,414632,414638,27309266,54257112,45157857,723216,1854607,19133811,219787,26851177,1627728,1873658,414457,54256803,10986172,27358422,221182,1597692,414683,9939550,414686,54256282,2948826,2488802,27282843,27272079,46646040,27307130,1854850,1853133,27295985,235641,46644838,27286927,414830,1695730,27264837,765249,46646560,415678,10078436,419353,54256981,434894,46645796,360028,46642795,46643722,37742380,46641820,46645822,27316155,29621535,46644326,420166,54256495,17311614,419138,419409,419412,54256088,26119658,46645189,1876802,46646539,51708344,46641532,1850820,46642746,1873585,42864367,46642212,1860750,54256722,27306911,19288600,415166,46645990,419520,9905087,35689322,420216,3321208,9863212,27281000,665207,420173,54259782,46646159,46648167,11200839,46642705,27320488,416770,54257063,46642289,46652764,37656698,27282217,27291024,2955799,1873595,159548,414463,1872846,27282040,27329380,420138,1871869,27262909,27354747,5316412,27274243,420144,1872579,421572,421588,46645845,1165960,420234,357375,46643844,46646353,27286027,17750010,426644,426646,416906,27294797,1873602,46647144,46642575,426677,426679,426685,1872601,1855115,46642087,27278836,26363008,427335,46641832,427337,46646472,416909,27272442,27273581,427339,1871091,27270232,46646293,46650716,434604,1847495,1082964,354361,1872049,22453270,46646817,53291906,27281194,46646779,434620,434622,434625,46644993,12250098,27748899,434634,36140989,1872551,469168,9690656,46645877,417484,46400342,27285207,46646217,1872729,415143,18152335,434663,1873613,1589837,46646541,1299635,46644039,30960897,46643872,427366,46643310,42627633,12753172,27307194,24421634,1872663,46646901,54259863,5289586,427375,41937950,1850095,1873695,27331911,46646961,15253270,414511,27303943,46645836,428585,428586,428588,11051298,1873034,27290591,24421613,6817209,428603,428608,331975,4783763,46651792,428630,428635,428640,46647219,27291991,23681392,428657,46646389,22970692,1872887,46646263,434736,27266407,1873621,34070960,1481090,434743,45286895,434909,46644924,9944636,46648305,1980076,46642138,46646455,415133,27275520,434727,43068256,46641313,27274618,27319806,46648734,46645061,1290018,1872569,1872744,8971026,46642117,7121294,1872895,27274143,27268695,27279901,27581500,46642547,1872687,27283452,27271162,435637,54259537,469238,27280049,27265015,5770475,46642598,27266387,27296698,46646629,723989,5603691,27342161,27311324,46646074,1872216,27272220,12596431,26898700,46646379,1906583,27353528,27280171,421677,46647164,35542972,46399592,433863,1873707,46650639,46654157,46642622,27266653,27269553,43824971,163684,27464304,24303079,27294634,27354938,449388,36007212,419626,46648738,352741,27290733,31704180,46652738,1872058,27265339,10448055,450368,27280710,46646985,46650682,27264194,1649025,450390,27261798,367560,1243465,45568232,1849086,23619322,25600906,5276205,27271687,27281458,46639094,53285594,416044,429874,27368350,45260091,23898624,27317054,2656347,450501,17169295,27293792,450506,1863450,27271794,46622934,450516,450517,450520,46642057,46646675,450270,1794676,450273,46643495,46644953,46214034,420324,46645665,450288,27270934,46646029,46645975,413358,1281601,1873069,354040,27282341,27267137,723901,6304425,1870449,46642827,46646043,46642779,46638621,27270199,434973,46641814,27292088,429871,429879,417661,27362227,12116716,1855074,419124,434904,23864436,46646750,27283462,46646008,1849949,46642521,53956138,54077368,54246606,54256449,54257813,54257250,16304960,427345,54258171,54261310,54257761,54258744,54261044,1857648,214880,449469,54256458,54258824,47962650,46643393,352474,433779,57318769,27362282,57683848,1859778,46646644,46642007,46646833,421594,723838,6617581,54257628,434707,27284618,27281663,10850875,60411693,27918146,60979387)
order by rev_timestamp
group by rev_page
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...
