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

SQL

use arwiki_p;
select p1.page_title, pp_value, replace(pp_value, "Q","")
from page p1
inner join page_props
on pp_page = p1.page_id
where p1.page_namespace = 0
and p1.page_is_redirect = 0
and pp_propname = "wikibase_item"
and pp_value not in (
select wikidatawiki_p.revision.rev_page from wikidatawiki_p.revision
inner join comment 
where comment_text like "/* wbsetlabel-add:1|ar%"
inner join wikidatawiki_p.page
on wikidatawiki_p.page.page_id = wikidatawiki_p.revision.rev_page
where wikidatawiki_p.page.page_namespace = 0
and wikidatawiki_p.page.page_is_redirect = 0
and wikidatawiki_p.page.page_title = pp_value)
limit 10;

SQL

Checking query status...