User Registration Search

SQL

SELECT
    logging.log_action,
    logging.log_timestamp,
    logging.log_title,
    logging.log_params,
    comment.comment_text,
    user.user_name AS actor_username,
    user.user_editcount AS actor_editcount
FROM logging
	Join comment ON logging.log_comment_id = comment.comment_id
	JOIN actor ON actor.actor_id = logging.log_actor
    JOIN user ON actor.actor_user = user.user_id
WHERE true
	AND log_type = 'newusers'
    AND logging.log_timestamp > 20220000000000
    AND LOWER(CONVERT(logging.log_title USING 'utf8')) REGEXP "abdulaziz"
ORDER BY logging.log_timestamp DESC
LIMIT 100;
SQL

Checking query status...
