Links to renamed user pages (huwiki)

SQL

use huwiki_p;
SELECT pl_from_namespace AS 'From: NS', page_title AS 'From: Title',
	pl_title AS 'user' FROM logging, pagelinks, page
    TO temp
	WHERE log_title = pl_title AND pl_from = page_id
    AND log_user_text = 'Maintenance script'
    AND (pl_namespace = 2 OR pl_namespace = 3)
   	-- GROUP BY pl_title
    LIMIT 10; #00;

SELECT 'user' AS 'User', count('user') AS 'Count'
	FROM temp
    GROUP BY 'user';

/* SELECT pl_title AS 'User', count(pl_title) AS 'Count'
	FROM logging, pagelinks, page
    WHERE log_title = pl_title AND pl_from = page_id
    AND log_user_text = 'Maintenance script'
    AND (pl_namespace = 2 OR pl_namespace = 3)
    GROUP BY pl_title
    LIMIT 1000; */

/* SELECT DISTINCT pl_from_namespace AS 'Namespace', page_title AS 'Title', concat('Sablon:', page_title) AS 'Full title'
	FROM logging, pagelinks, page
	WHERE log_title = pl_title AND pl_from = page_id
    AND log_action = 'move' AND log_user_text = 'Atobot';
    AND pl_from_namespace = 10; */
SQL

Checking query status...
