Untitled query #79052

SQL

SELECT 
	COUNT(`rc_id`) AS `reviews`, 
	`actor_name` as `user`, 
	SUM(`comment_text` LIKE "%发布已接受的[[PJ:AFC|条目建立]]草稿%" OR `comment_text` LIKE "%發布已接受的[[PJ:AFC|條目建立]]草稿%") AS `acceptCount`, 
	SUM(`comment_text` LIKE "%仍需改善的草稿%") AS `declineCount`, 
	SUM(`comment_text` LIKE "%拒绝再次提交的草稿%" OR `comment_text` LIKE "%拒絕再次提交的草稿%") AS `rejectCount`, 
	CONCAT(ROUND(SUM(`comment_text` LIKE "%发布已接受的[[PJ:AFC|条目建立]]草稿%" OR `comment_text` LIKE "%發布已接受的[[PJ:AFC|條目建立]]草稿%") * 100 / COUNT(`rc_id`), 1), "%") AS `acceptPercentage`, 
	CONCAT(ROUND(SUM(`comment_text` LIKE "%仍需改善的草稿%") * 100 / COUNT(`rc_id`), 1), "%") AS `declinePercentage`, 	CONCAT(ROUND(SUM(`comment_text` LIKE "%拒绝再次提交的草稿%" OR `comment_text` LIKE "%拒絕再次提交的草稿%") * 100 / COUNT(`rc_id`), 1), "%") AS `rejectPercentage` 
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...
