Untitled query #33089

SQL

use arwikisource_p;
select page_title 
from page
inner join page_props
on pp_page = page_id
where page_is_redirect = 0 
and pp_propname like "%wikibase_item%"
and TRIM(LEADING 'Q' FROM pp_value) not in (select wikidatawiki_p.wb_items_per_site.ips_item_id
                                                   from wikidatawiki_p.wb_items_per_site
                                                   where wikidatawiki_p.wb_items_per_site.ips_item_id = TRIM(LEADING 'Q' FROM pp_value)
                                                   and wikidatawiki_p.wb_items_per_site.ips_site_id like "%arwiki%"
                                       )
and page_title in (select arwiki_p.page.page_title
				   from arwiki_p.page
                   where arwiki_p.page.page_title = page_title
                   and arwiki_p.page.page_is_redirect = 0
                   and arwiki_p.page.page_namespace = 0)
limit 10;
SQL

Checking query status...
