USE fawiki_p; SELECT log_title, COUNT(*) FROM logging WHERE log_type = "block" AND log_timestamp > 20190000000000 AND REGEXP_REPLACE(log_title, '[0-9\.]+', '') <> "" GROUP BY log_title ORDER BY COUNT(*) DESC;