User "Aaron Schulz" posted a comment on MediaWiki.r97022.
Full URL: http://www.mediawiki.org/wiki/Special:Code/MediaWiki/97022#c22618
Commit summary:
Possible fix for issue reported in r83762. I had a hard time confirming the
problem/fix with profiling. Committing this now to get more attention.
Comment:
Query could also be like:
<pre>
SELECT /*! STRAIGHT_JOIN */ page_namespace,page_title,page_latest,fpp_rev_id
AS stable,fpp_quality AS quality,fpp_pending_since AS
pending_since,fpp_pending_since FROM `mw_flaggedpage_pending` FORCE INDEX
(fpp_quality_pending),`mw_revision`,`mw_change_tag` FORCE INDEX
(change_tag_rev_tag),`mw_page` WHERE (fpp_pending_since IS NOT NULL) AND
(page_id = fpp_page_id) AND (rev_page = page_id) AND (rev_id > fpp_rev_id) AND
(rev_id = ct_rev_id) AND ct_tag = '' AND fpp_quality = '0' AND page_namespace
IN ('0','6','10') GROUP BY fpp_pending_since,fpp_page_id ORDER BY
fpp_pending_since,fpp_page_id LIMIT 51
</pre>
If the dropdown is used with any option other than 'stable'.
_______________________________________________
MediaWiki-CodeReview mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-codereview
