<html><head></head><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px"><div dir="ltr" id="yui_3_16_0_1_1446029919199_41030">user_daily_contribs having been dropped, I am facing serious problems about a query. How to optimize this?</div><div dir="ltr"><br></div><div id="yui_3_16_0_1_1446029919199_41224" dir="ltr">SELECT<br class="" id="yui_3_16_0_1_1446029919199_41191"> u.user_name,<br class="" id="yui_3_16_0_1_1446029919199_41193"> COUNT(rev.rev_id) AS contribs<br class="" id="yui_3_16_0_1_1446029919199_41195">FROM<br class="" id="yui_3_16_0_1_1446029919199_41197"> user u<br class="" id="yui_3_16_0_1_1446029919199_41199"> INNER JOIN user_groups ug<br class="" id="yui_3_16_0_1_1446029919199_41201"> ON u.user_id = ug.ug_user<br class="" id="yui_3_16_0_1_1446029919199_41203"> INNER JOIN revision_userindex rev<br class="" id="yui_3_16_0_1_1446029919199_41205"> ON rev.rev_user = u.user_id<br class="" id="yui_3_16_0_1_1446029919199_41207">WHERE<br class="" id="yui_3_16_0_1_1446029919199_41209"> ug.ug_group IN ('sysop', 'bureaucrat', 'checkuser', 'oversight')<br class="" id="yui_3_16_0_1_1446029919199_41211"> AND rev.rev_timestamp >= 20150928000000<br class="" id="yui_3_16_0_1_1446029919199_41213">GROUP BY<br class="" id="yui_3_16_0_1_1446029919199_41215"> u.user_name<br class="" id="yui_3_16_0_1_1446029919199_41217"><br></div></div></body></html>