Testing new accounts

SQL

SELECT
	rc_log.rc_id,
    rc_log.rc_timestamp,
	rc_log.rc_title AS 'Created user name',
    rc_log.rc_actor AS 'Creator actor',
	a.*,
    block.ipb_expiry,
	blockreason.comment_text,
	CASE
		WHEN block.ipb_sitewide = 1 THEN 'sitewide'
		ELSE (
			SELECT GROUP_CONCAT(
				CASE
					WHEN restriction.ir_type = 1 THEN (
						SELECT CONCAT( 'ns', page_namespace, '-', page_title ) FROM page WHERE page_id = restriction.ir_value
                    )
					WHEN restriction.ir_type = 2 THEN CONCAT( 'ns', restriction.ir_value, '-all' )
					ELSE 'Something went wrong'
				END
            )
			FROM ipblocks_restrictions restriction
			WHERE restriction.ir_ipb_id = block.ipb_id
        )
	END AS 'Restrictions'
FROM
	recentchanges rc_log
JOIN
	actor a
ON
	a.actor_id = rc_log.rc_actor
JOIN
	ipblocks block
ON
	block.ipb_user = a.actor_user
JOIN
	comment blockreason
ON
	blockreason.comment_id = block.ipb_reason_id
WHERE
	rc_log.rc_log_type = 'newusers'
	AND rc_log.rc_log_action NOT IN ('create')
ORDER BY rc_log.rc_timestamp DESC
LIMIT 10;
SQL

Checking query status...
