mpfc1 fa empty categories with en interwiki

SQL

USE fawiki_p;
select page_title, REPLACE (ll_title,'Category:','')
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

AND page_id NOT IN (
  SELECT pp_page
  FROM page_props
  WHERE pp_propname = 'hiddencat'
)

AND ll_lang = 'en'

SQL

Checking query status...