USE wikidatawiki_p;

​

SELECT

    rc_this_oldid,

    rc_timestamp,

    actor_name,

    rc_title,

    comment_text,

    rc_old_len,

    rc_new_len

FROM

    recentchanges_userindex JOIN comment ON rc_comment_id = comment_id JOIN actor_recentchanges ON rc_actor = actor_id

WHERE

    rc_patrolled=0 AND

    rc_namespace=0 AND

    comment_text REGEXP '.'

ORDER BY

    rc_timestamp DESC

LIMIT 100;