USE fawiki_p;

SELECT DISTINCT CONCAT ('*[[:رده:',page_title,']]') FROM  page WHERE page_id  IN (SELECT tl_from FROM templatelinks WHERE tl_title = 'رده_بهتر' AND tl_namespace = 10) AND page_id  IN (SELECT DISTINCT page_id 

                FROM langlinks LEFT JOIN page

                        ON page_id = ll_from        

                WHERE ll_from IS NOT NULL  AND page_namespace = 14) AND page_namespace = 14;