Untitled query #78728

SQL

CREATE TABLE `pageredlinks` (  `prl_from` int(8) unsigned 
                             NOT NULL DEFAULT '0',  `prl_namespace` int(11) 
                             NOT NULL DEFAULT '0',  `prl_title` varbinary(255) 
                             NOT NULL DEFAULT '',  
                             UNIQUE KEY `pl_from` (`prl_from`,`prl_namespace`,`prl_title`),  
                             KEY `prl_namespace` (`prl_namespace`,`prl_title`)
                            );
                           SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SELECT concat( '* {{tl|', prl_title, '}} ←', group_concat( concat( ' [[', page_title, ']]' )) )
FROM pageredlinks
INNER JOIN enwiki_p.page ON page_id = prl_from
WHERE prl_namespace = 10
AND   prl_title LIKE '%_stub'
AND   page_namespace = 0
GROUP BY prl_title;
SQL

Checking query status...
