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