Replicas browser and optimizer
This query is marked as a draft
This query has been published
use wikidatawiki_p; select wb1.term_text as "redirect", (select ips_site_page from wb_items_per_site where ips_site_id = "arwiki" and ips_item_id = wb1.term_entity_id) as "title" from wb_terms wb1 where wb1.term_language = "ar" and replace(wb1.term_text," ","_") not in (select arwiki_p.page.page_title from arwiki_p.page where arwiki_p.page.page_namespace = 0) and wb1.term_text not like "%:%" and (select ips_site_page from wb_items_per_site where ips_site_id = "arwiki" and ips_item_id = wb1.term_entity_id) not like "%:%" and wb1.term_type = "alias" limit 100;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in