Untitled query #34979

SQL

USE fawiki_p;               
SELECT /*SLOW OK*/ concat('*[[:Category:',page_title,']]')
    from page join 
       category  on cat_title=page_title and page_namespace=14 and page_is_redirect = 0
       LEFT JOIN templatelinks 
              ON tl_from = page_id AND tl_namespace = 10 and (cat_pages>0 or cat_subcats>0 or cat_files>0) AND tl_title not IN ( 'رده_خالی','رده_بهتر', 'رده_ابهام‌زدایی', 'رده_ردیابی‌کردن' ) where
              page_id NOT IN (
                SELECT ll_from
                FROM langlinks
                WHERE ll_lang  in ("en","fr","it","ar","ckb","ru","nl")
                ) group by page_id;
SQL

Checking query status...
