USE fawiki_p;

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

FROM   category

       JOIN  page

         ON page_title = cat_title AND page_is_redirect = 0 and page_namespace = 14 

       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   cl_to IS NULL 

       AND tl_title IS NULL 

GROUP  BY page_title;