أكثر معدلي مرشحات الإساءة تعديلا

SQL

select p.page_title, group_concat(p3.page_title SEPARATOR '***') as cats
    from page p
    inner join langlinks l1
    on l1.ll_from = p.page_id
    inner join  frwiki_p.page
    on  frwiki_p.page.page_title = replace(l1.ll_title, " ", "_")
    inner join  frwiki_p.categorylinks
    on  frwiki_p.categorylinks.cl_from =  frwiki_p.page.page_id
    inner join  frwiki_p.page p2
    on p2.page_title =  frwiki_p.categorylinks.cl_to
    inner join  frwiki_p.langlinks el
    on p2.page_id  = el.ll_from
    inner join page p3
    on p3.page_title = replace(replace(el.ll_title, "تصنيف:",""), " ", "_")
    where p.page_is_redirect = 0
    and p.page_namespace = 0
    and  frwiki_p.page.page_namespace = 0
    and  frwiki_p.page.page_is_redirect = 0
    and p2.page_id not in (select  frwiki_p.categorylinks.cl_from from  frwiki_p.categorylinks  where  frwiki_p.categorylinks.cl_to = (select SUBSTRING(replace(ll_title," ","_"), POSITION(":" IN replace(ll_title," ","_"))+1) from langlinks where ll_lang = "fa" and ll_from = 308278))
    and p.page_id not in (select cl_from from categorylinks where cl_to = p3.page_title)
    and p3.page_id not in (select cl_from from categorylinks  where cl_to = 'تصنيفات_مخفية')
    and p3.page_id not in (select cl_from from categorylinks  where cl_to = 'أحداث_جارية')
    and p3.page_id not in (select cl_from from categorylinks  where cl_to = 'تحويلات_تصنيفات_ويكيبيديا')
    and p3.page_title not like "صفحات_توضيح%"
    and p.page_id not in (select cl_from from categorylinks  where cl_to = 'صفحات_لا_تقبل_التصنيف_المعادل')
    and p.page_id in (select cl_from from categorylinks  where cl_to = 'جميع_المقالات_غير_المصنفة')
    and p2.page_is_redirect = 0
    and p2.page_namespace = 14
    and p3.page_namespace = 14
    and p3.page_is_redirect = 0
    and l1.ll_lang like "fa"
    and el.ll_lang like "ar"
    group by p.page_title;
SQL

Checking query status...
