Untitled query #33664

SQL

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;
SQL

Checking query status...
