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,
  		CASE
            WHEN logging.log_title IN (SELECT logging.log_title
                                       FROM logging
                                       WHERE logging.log_timestamp > 20010000000000
                                       AND logging.log_type = 'block')
            THEN 1
  			ELSE 0
  		END AS blocked
    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 > 20010000000000 ) as first_pass
WHERE true
	AND (LOWER(CONVERT(first_pass.log_title USING 'utf8')) REGEXP "if_?you_?block_?this.*") # Match underscores for spaces
#ORDER BY first_pass.log_timestamp DESC
LIMIT 100;
SQL

Checking query status...
