USE fawiki_p;

SELECT Concat ("[[category:", page_title, "]]") 

FROM   page 

       JOIN category 

         ON page_title = cat_title 

       LEFT JOIN categorylinks 

              ON page_title = cl_to 

       LEFT JOIN templatelinks 

              ON tl_from = page_id 

                 AND tl_namespace = 10 

                 AND tl_title IN ( 'رده_خالی',

                                   'رده_بهتر', 

                                   'رده_ابهام•زدایی', 

                                   'رده_ردیابی•کردن' )  

WHERE  page_namespace = 14 

       AND page_is_redirect = 0 

       AND cl_to IS NULL 

       AND tl_title IS NULL 

GROUP  BY page_title;