Page movers' redirects

SQL

USE nlwiki_p;
SELECT
CASE
	WHEN log_title LIKE '%.%.%.%/%' THEN 'Range'
	WHEN log_title LIKE '%:%:%:%:%:%/%' THEN 'Range'
	WHEN log_title LIKE '%.%.%.%' THEN 'Anon'
	WHEN log_title LIKE '%:%:%:%:%:%' THEN 'Anon'
	ELSE 'Account'
END AS 'Type', logging.log_params AS 'Parameters', COUNT(*) AS 'Count' FROM logging
WHERE log_type = 'block'
AND log_action = 'block'
AND log_timestamp > 20190601000000
AND log_deleted = 0
GROUP BY
CONCAT(
  CASE
	WHEN log_title LIKE '%.%.%.%/%' THEN 'Range'
	WHEN log_title LIKE '%:%:%:%:%:%/%' THEN 'Range'
	WHEN log_title LIKE '%.%.%.%' THEN 'Anon'
	WHEN log_title LIKE '%:%:%:%:%:%' THEN 'Anon'
	ELSE 'Account'
  END,
  log_params
)
ORDER BY COUNT(*) DESC;
SQL

Checking query status...
