USE zhwiki_p;

SELECT log_id, log_timestamp, log_actor, log_title

FROM logging

WHERE log_type = 'block'

    AND log_title REGEXP '[MC][MC][MC]'

    # AND log_title NOT REGEXP '[0-9]+(\.|:)[0-9]+'

    # AND log_title NOT REGEXP '^[A-Za-z0-9._]+$'

    AND log_timestamp > 20200701000000

ORDER BY log_timestamp DESC

# LIMIT 20