blob: fff6d9c36912bcfd6fd1ac0d2b793ced49d32ac0 [file]
SELECT
repo_name,
number,
count() AS comments
FROM github_events
WHERE event_type = 'IssueCommentEvent' AND (action = 'created') AND (number > 10)
GROUP BY repo_name, number
ORDER BY comments DESC, repo_name, number
LIMIT 50