SELECT page_title, page_is_redirect FROM plwiki_p.page LEFT JOIN plwiki_p.iwlinks ON page_id = iwl_from AND iwl_prefix = 's'

WHERE 

page_namespace = 0 AND

page_title IN (SELECT SUBSTRING(page_title, LOCATE( ':', page_title )+1, 1000) FROM plwikisource_p.page) AND

iwl_prefix IS NULL AND

page_id NOT IN (SELECT

                        page_id

                    FROM

                        plwiki_p.page,

                        plwiki_p.templatelinks

                    WHERE

                        page_id=tl_from AND

                        page_namespace=0 AND

                        tl_namespace=10 AND

                        tl_title='Ujednoznacznienie')

LIMIT 7000;