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.*, COUNT(*) FROM logging
WHERE log_type = 'block'
AND log_action = 'block'
AND log_timestamp > 20190821000000
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
)
LIMIT 100
SQL

Checking query status...
