Highly used EN WP categories missing in FA WP (v3)

Fork of Highly used EN WP categories missing in FA WP (v2) by Huji

This query is marked as a draft This query has been published by Huji.

SQL

use enwiki_p;
select cat_title, cat_pages
from category
left join page
on page_title = cat_title
where page_namespace = 14
and cat_pages > 1000
and 'fa' not in (
  select ll_lang from langlinks where ll_from = page_id
)
and cat_title not like 'WikiProject%'
and cat_title not like 'Wikipedia%'
and cat_title not like 'Articles%'
and cat_title not like 'Redirect%'
and cat_title not like '%redirects'
and cat_title not like '%articles'
and cat_title not like '%-Class_%_articles%'
and cat_title not like '%importance%'
order by cat_pages desc;

SQL

Checking query status...