Thread:Extension talk:FlaggedRevs/Special:SpecialPages/reply (6)

I'm change extensions/FlaggedRevs/dataclasses/FlaggedRevsStats.php fragment to (change using index PRIMARY to page_rev): # For edits that started off pending, how long do they take to get reviewed? # Edits started off pending if made when a flagged rev of the page already existed. # Get the *first* reviewed rev *after* each edit and get the time difference. $res = $dbr->select(			array( 'revision', 'p' => 'flaggedrevs', 'n' => 'flaggedrevs' ),			array( 'MIN(rev_timestamp) AS rt', 'MIN(n.fr_timestamp) AS nft', 'MAX(p.fr_rev_id)' ),			array( 'rev_user' => 0, $timeCondition, "(rev_id % $mod) = 0" ),			__METHOD__,			array( 'GROUP BY' 	=> 'rev_id', 'USE INDEX' => array( 'p' => 'page_rev', 'n' => 'page_rev' ) #'USE INDEX' => array( 'p' => 'PRIMARY', 'n' => 'PRIMARY' ) ),			array( 'p' => array( 'INNER JOIN', array( // last review INNER 'p.fr_page_id = rev_page', 'p.fr_rev_id < rev_id', 'p.fr_timestamp < rev_timestamp' ) ), 'n'	=> array( 'INNER JOIN', array( // next review INNER 'n.fr_page_id = rev_page', 'n.fr_rev_id >= rev_id', 'n.fr_timestamp >= rev_timestamp' ) ) )		);