Popular Comments

SQL

#SELECT *
#FROM
#	comment as c
#WHERE
#	c.comment_id <100;


#SELECT 
#    #c.comment_text,
#    *
#    COUNT(*) AS usage_count
#FROM 
#    comment AS c
#JOIN 
#    revision AS r ON
#    	c.comment_id = r.rev_comment_id
#GROUP BY 
#    c.comment_text
#ORDER BY 
#    usage_count DESC
#LIMIT
#	100;
## this took ?? seconds


SELECT 
    c.comment_text, 
    COUNT(*) AS usage_count
FROM 
    comment AS c
JOIN 
    revision AS r ON
    	c.comment_id = r.rev_comment_id
WHERE 
    c.comment_hash IS NOT NULL
GROUP BY 
    c.comment_hash, c.comment_text
ORDER BY 
    usage_count DESC
LIMIT
	100;
SQL

Checking query status...
