Replicas browser and optimizer
This query is marked as a draft
This query has been published
use wikidatawiki_p; select ips_site_page, concat("Q", wb_items_per_site.ips_item_id), cnt from (select ips_item_id, count(*) as cnt from wb_items_per_site where ips_item_id in (select ips_item_id from wb_items_per_site where ips_site_id="cswiki" and ips_site_page in (select page_title from cswiki_p.revision_userindex join cswiki_p.page on page_id=rev_page where rev_user_text="Awewewe" and rev_parent_id=0 and page_namespace=0)) group by ips_item_id) as tmp join wb_items_per_site on tmp.ips_item_id=wb_items_per_site.ips_item_id where ips_site_id="cswiki" order by cnt desc;
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