use arwiki_p;

select *

from wikidatawiki_p.wb_items_per_site

where wikidatawiki_p.wb_items_per_site.ips_site_id like "%arwiki%"

and replace(wikidatawiki_p.wb_items_per_site.ips_site_page," ", "_") not in (select page_title from page 

                                                                            where page_is_redirect = 0 

                                                                            and page_namespace = 0

                                                                            and page_title= wikidatawiki_p.wb_items_per_site.ips_site_page)

limit 10;