use arwiki_p;

select page_title, el_to

from externallinks

inner  join page

on page_id = el_from

where  el_to not like "%web.archive.org/web/%"

and el_to not in (select concat("https",SUBSTRING_INDEX(el_to,"/http", -1)) from externallinks where 

                  el_to like "%web.archive.org%"

                  and el_from = page_id)

and page_is_redirect =0

and page_namespace = 0

and page_title like "اللغة_العونغوتا"

limit 10;