Untitled query #79052

SQL

SELECT	COUNT(rc_id) AS reviews,	actor_name,	SUM(comment_text LIKE "%发布已接受的[[PJ:AFC|条目建立]]草稿%" OR comment_text LIKE "%發布已接受的[[PJ:AFC|條目建立]]草稿%") AS "accept",	SUM(comment_text LIKE "%仍需改善的草稿%") AS "decline",	SUM(comment_text LIKE "%拒绝再次提交的草稿%" OR comment_text LIKE "%拒絕再次提交的草稿%") AS "reject",	CONCAT(ROUND(SUM(comment_text LIKE "%发布已接受的[[PJ:AFC|条目建立]]草稿%" OR comment_text LIKE "%發布已接受的[[PJ:AFC|條目建立]]草稿%") * 100 / COUNT(rc_id), 1), "%") AS "accept %",	CONCAT(ROUND(SUM(comment_text LIKE "%仍需改善的草稿%") * 100 / COUNT(rc_id), 1), "%") AS "decline %",	CONCAT(ROUND(SUM(comment_text LIKE "%拒绝再次提交的草稿%" OR comment_text LIKE "%拒絕再次提交的草稿%") * 100 / COUNT(rc_id), 1), "%") AS "reject %"FROM recentchanges_userindex LEFT JOIN actor ON rc_actor = actor_id LEFT JOIN comment ON rc_comment_id = comment_id WHERE	(rc_namespace = 118 OR rc_namespace = 2 OR rc_namespace = 0) AND (rc_type < 5) 	AND (comment_text LIKE "%发布已接受的[[PJ:AFC|条目建立]]草稿%" OR comment_text LIKE "%發布已接受的[[PJ:AFC|條目建立]]草稿%" OR comment_text LIKE "%仍需改善的草稿%" OR comment_text LIKE "%拒绝再次提交的草稿%" OR comment_text LIKE "%拒絕再次提交的草稿%")	AND (rc_timestamp >= DATE_ADD(NOW(), INTERVAL -28 DAY) )GROUP BY rc_actor ORDER BY reviews DESC;
SQL

Checking query status...
