USE fawiki_p;

SELECT CONCAT ("[[رده:",page_title,"]]"), 

       Count(ll_lang) 

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_title IN ( 'رده_خالی', 'رده_بهتر', 

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

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

       LEFT JOIN langlinks 

              ON page_id = ll_from 

WHERE  page_namespace = 14 

       AND page_is_redirect = 0 

       AND cl_to IS NULL 

       AND tl_title IS NULL 

GROUP  BY page_title 

ORDER  BY 2, 

          1;