USE dewiki_p;

​

SELECT 

    log_title, log_namespace, comment_text

FROM

    logging_userindex, comment

WHERE

    log_namespace=2 AND

    log_type='block' AND

    log_comment_id=comment_id AND

    log_title like '%deniz%' COLLATE utf8_general_ci AND

    log_timestamp > '20190901000000'

​