select CONCAT('[[user:',page_Title,']]') AS 'عنوان_الصفحة_الأصلية',CONCAT('[[',rd_Title,']]') AS 'النطاق_الرئيس'/*,log_title  ar_id, ar_actor,actor_name*/

from redirect 

    inner join page on page_id =rd_from

    /*inner join archive on ar_id =rd_from

    inner join actor on actor_id =ar_actor

    inner join logging on log_deleted =page_title*/ 

​

​

    where /*rd_title not in (select page_title from page where page_title= rd_title and rd_namespace = page_namespace)*/

         page_is_redirect = 1

        AND page_namespace=2

        AND rd_namespace = 0

        AND page_content_model ='wikitext'

        AND rd_interwiki = ""

     /*   and log_type in ("delete")*/

ORDER BY page_id DESC

/*limit 100;*/