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 page_namespace = 0
and pp_propname like "wikibase_item"
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)
and pp_value not in (select arwiki_p.page_props.pp_value
				   from arwiki_p.page
                   inner join arwiki_p.page_props
                   on arwiki_p.page_props.pp_page = arwiki_p.page.page_id
                   where arwiki_p.page.page_title = page_title
                   and arwiki_p.page_props.pp_propname = "wikibase_item"
                   and arwiki_p.page.page_is_redirect = 0
                   and arwiki_p.page.page_namespace = 0)                   
limit 10;
SQL

Checking query status...
