Untitled query #6042

SQL

# Finding the edit summaries for the study set
SELECT rev_id, rev1.rev_page, rev_timestamp, rev_comment
FROM 
    (SELECT rev_page, rev_timestamp AS max_time 
     FROM hewiki_p.revision 
     WHERE rev_id IN (
        1375915,
        178722,
        13966928,
        8573836,
        11552613,
        11479375,
        13387750,
        845546,
        332564,
        12124736,
        754266,
        355161,
        102216,
        14331336,
        5680702,
        12059037,
        14873946,
        15049772,
        3687981,
        9979812,
        7624560,
        13421599,
        13380242,
        14868836,
        1449503,
        762964,
        3665077,
        589607,
        2263096,
        1880916,
        2460888,
        13341609,
        3274092,
        15682292,
        490691,
        7930197,
        15643822,
        13717617,
        7078869,
        7816636,
        13486057,
        5802447,
        3001934,
        1488581,
        2650487,
        13518820,
        3345065,
        4168044,
        698827,
        1069299,
        1069299,
        15661908,
        10268474,
        10767724,
        12216499,
        3829210,
        1218617,
        12282366,
        16023648,
        15839569,
        17257949,
        6435708,
        6253754,
        811147,
        17312099,
        15497782,
        27618,
        10814153,
        3480330,
        6704870,
        13314860,
        10139706,
        10432961,
        162734,
        1861606,
        11364964,
        12078476,
        10394726,
        12498833,
        5143263,
        4226248,
        14909647,
        9416303,
        2074499,
        2067728,
        4324764,
        11002158,
        5253299,
        629475,
        3221670,
        9325334,
        13110716,
        11351740,
        1676293,
        2623767,
        6375504,
        14362059,
        6699168,
        8486714,
        3483141,
        17127835
        )) AS rev1
LEFT JOIN hewiki_p.revision AS rev2
ON rev1.rev_page = rev2.rev_page
AND rev2.rev_timestamp <= max_time
;
SQL

Checking query status...
