e.g. I just tried

SELECT log_comment, COUNT(1) as num
FROM enwiki_p.logging 
WHERE log_type = "block"
GROUP BY log_comment 
ORDER BY num DESC;

And after a few minutes it comes back and says it has completed but doesn't show any results. I know there are results because if I introduce additional constraints, and it finishes quicker, I get them. :)