Links to renamed user pages (huwiki)

SQL

use huwiki_p;

-- CREATE TEMPORARY TABLE temp
	SELECT pl_from_namespace, page_title, pl_title
    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 pl_from_namespace AS 'From: NS', page_title AS 'From: Title',
	pl_title AS 'User' FROM temp;

SELECT pl_from_namespace AS 'User', count(pl_from_namespace) 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 10;
*/
SQL

Checking query status...
