Redirect pages with interwiki

SQL

USE fawiki_p;
SELECT  CONCAT ('# [[',page.page_title,']] > [[:en:',langlinks.ll_title,']] >> [[' ,rd_title,']] >[[:en:',ourpage.ll_title,']]')
FROM page
INNER JOIN langlinks ON page_id = ll_from JOIN redirect join (SELECT * from page inner join langlinks ON page_id = ll_from where page.page_namespace = 0 AND page_is_redirect = 1 and ll_lang='en') as ourpage 
WHERE page_namespace = 0 and rd_from=page_id and ll_lang='en' and  ourpage.page_title=rd_title
    AND page_is_redirect = 1
GROUP BY page_title
ORDER BY COUNT(ll_from) DESC limit 1;
SQL

Checking query status...
