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 10; #00;

/* 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 500;

/* 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...
