IEG 2014 round 2 endorsements per proposal

SQL

SELECT COUNT(DISTINCT `rev_user_text`) AS endorsements, page_title FROM (
SELECT page_title, page_id, rev_user_text, rev_comment
FROM metawiki_p.page AS p 
JOIN metawiki_p.categorylinks AS cl 
ON p.page_id = cl.cl_from 
JOIN metawiki_p.revision AS r
ON p.page_id = r.rev_page
WHERE cl.cl_to IN ("IEG_2014_round_2")
AND cl.cl_type = "page"
AND p.page_namespace = 200
AND p.page_title LIKE "IEG/%"
AND (r.rev_comment LIKE ("%Endorse%") OR r.rev_comment LIKE ("%endorse"))) AS tmp 
GROUP BY page_title ORDER BY endorsements DESC;

SQL

Checking query status...