User Registration Search

SQL

SELECT
	*
FROM (
    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 ) as first_pass
WHERE true
    AND first_pass.log_title NOT IN (SELECT logging.log_title
                                     FROM logging
                                     WHERE logging.log_timestamp > 20220000000000
                                     AND logging.log_type = 'block')
	AND LOWER(CONVERT(first_pass.log_title USING 'utf8')) LIKE "%samet_yücel%"
#ORDER BY first_pass.log_timestamp DESC
LIMIT 100;
SQL

Checking query status...
