Untitled query #33089

SQL

use arwikinews_p;
select page_title, page_namespace
from page
inner join page_props
on pp_page = page_id
where page_is_redirect = 0 
and page_namespace = 14
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 = 14)
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 = 14);
SQL

Checking query status...
