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

                                                                            =

                                                                            replace(wikidatawiki_p.wb_items_per_site.ips_site_page," ", "_"))

limit 10;