FA and GA articles not set for flaggedrevs (fawiki)

Fork of FA and GA articles not set for flaggedrevs (idwiki) by Hidayatsrf

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

SQL

select
  CONCAT('[[:', replace(page_title, '_', ' '), ']]', ' <sup>[[Special:ProtectPage/', page_title, '|محافظت]]</sup>') as 'عنوان', /* title with protect link */
  case cl_to 
  	when 'مقاله‌های_برگزیده' then 'برگزیده' /* featured */
    when 'مقاله‌های_خوب'then 'خوب' /* good */
  end as 'رده',
  CONCAT('{{subst:formatnum:', page_len, '}} بایت') as 'حجم' /* size in bytes */
from categorylinks
join page
  on cl_from = page_id
  and page_namespace = 0
left join flaggedpages
  on fp_page_id = page_id
where
  cl_to in
  (
    'مقاله‌های_برگزیده', /* featured */
    'مقاله‌های_خوب' /* good */
  )
  and fp_page_id is null;

SQL

Checking query status...