pl wikisource Pages_Link_to_Redir

SQL

use plwikisource_p;

SELECT DISTINCT src_title, ppr_from_ns, src_len, src_latest, src_id

	FROM
	(SELECT DISTINCT pl_from as ppr_from , pl_namespace as ppr_ns, pl_title as ppr_title, pl_from_namespace as ppr_from_ns, page_id as ppr__page_id, page_title as ppr_page_title
    FROM
	pagelinks INNER JOIN (SELECT DISTINCT page_id, page_title, page_namespace FROM page WHERE page_is_redirect = 1) AS PGT on (page_title = pl_title AND page_namespace = pl_namespace) 
    WHERE
    (pl_from_namespace = 0 OR
    pl_from_namespace = 10 OR
    pl_from_namespace = 100 OR
    /* pl_from_namespace = 102 OR bez autorów */
    pl_from_namespace = 124) AND
    (pl_namespace = 0 OR
    pl_namespace = 100 OR
    pl_namespace = 102) ) AS PRR INNER JOIN (SELECT page_id as src_id, page_title as src_title, page_len as src_len, page_latest as src_latest FROM page) AS SRC on (ppr_from = src_id)
    
LIMIT 7000;
SQL

Checking query status...
