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

SQL

use arwiki_p;
select p1.page_title, pp_value, wikidatawiki_p.page.page_id, replace(pp_value, "Q","")
from page p1
inner join page_props
on pp_page = p1.page_id
inner join wikidatawiki_p.page
on wikidatawiki_p.page.page_title = pp_value
where p1.page_namespace = 0
and p1.page_is_redirect = 0
and pp_propname = "wikibase_item"
and wikidatawiki_p.page.page_id not in (  SELECT wbit_item_id FROM wikidatawiki_p.wbt_item_terms
  INNER JOIN wikidatawiki_p.wbt_term_in_lang
    ON wbtl_id = wbit_term_in_lang_id
  INNER JOIN wikidatawiki_p.wbt_text_in_lang
    ON wbxl_id = wbtl_text_in_lang_id
  WHERE wbxl_language = "ar"
  AND wbtl_type_id = 1
  and wbit_item_id = replace("Q","", pp_value))
limit 10;

SQL

Checking query status...