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_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 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"
                                                   ) limit 10;
SQL

Checking query status...
