gebruiker:bdijkstra/dump/Gebruikers naar taal

SELECT 
	CONCAT('[[:Categorie:',prefix,'|',REGEXP_REPLACE(prefix, '^.*_', ''),']]') AS code, 
	CONCAT('{{#invoke:Lang|name_from_code|',REGEXP_REPLACE(prefix, '^.*_', ''),'}}') AS name, 
	SUM(cat_pages) AS sum
FROM category c0, (
	SELECT DISTINCT REGEXP_REPLACE(cat_title, '-[0-9M]', '') AS prefix
	FROM category
	WHERE 
		cat_title REGEXP 'Wikipedia:Gebruiker_'
	ORDER BY cat_title) c1
WHERE cat_title REGEXP CONCAT('^',prefix,'-')
GROUP BY prefix
ORDER BY prefix