Untitled query #48257

SQL

use dewiki_p;

select rev_id, 
            rev_page, 
            page_namespace, 
            rev_timestamp, 
            fr_timestamp
        from (
              select rev_id, rev_page, rev_timestamp, page_namespace from revision_userindex
                join page on page_id = rev_page where rev_id in
          (192744525,192746320,192747532,192756609,192756984,192773430,192773549,192773597,192773674,192774045,192774184,192858137,192858225,192873889,192873905,192873963,192873999,192874140,192953399,193211996,193374333,193374412,193374477,193375687,193375713,193375722,193375746,193392546,193392725,193392726,193420080,193420369,193671608,193671637) 
        ) auser
        left join flaggedrevs on
            fr_page_id = rev_page and
            fr_rev_id = rev_id;
SQL

Checking query status...
