Stub categories to restore

Fork of Article talk pages in categories intended for articles by Huji

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

SQL

use fawiki_p;

select
  cl_to,
  total,
  proportion
from (
  select
    c1.cl_to,
    count(*) as total,
    100 * sum(case when p1.page_namespace = 0 then 1 else 0 end) / count(*) as proportion
  from categorylinks c1
  join page p1
    on p1.page_id = c1.cl_from
  join page p2
    on p2.page_title = c1.cl_to
    and p2.page_namespace = 14 -- Category
  join categorylinks c2
    on p2.page_id = c2.cl_from
    and c2.cl_to = 'رده‌های_منتقل‌شده'
  group by cl_to
) t
where
  t.proportion > 50
  and t.proportion < 100
  and cl_to like 'مقاله‌های_خرد%'
limit 500

SQL

Checking query status...