Cities - Quarry

SQL

USE wikidatawiki_p;

SELECT DISTINCT wb_items_per_site.ips_item_id, wb_items_per_site.ips_site_page
FROM wb_items_per_site
LEFT JOIN langlinks ON wb_items_per_site.ips_site_page = langlinks.ll_title AND langlinks.ll_lang = 'ar'
WHERE wb_items_per_site.ips_site_id = 'enwiki'
  AND wb_items_per_site.ips_item_id IN (
    SELECT ips_item_id
    FROM wb_items_per_site
    WHERE ips_site_id = 'enwiki'
      AND ips_item_id IN (
        SELECT DISTINCT wd_item_id
        FROM wb_terms
        WHERE wd_item_id = 'Q515'
      )
  )
  AND langlinks.ll_from IS NULL
LIMIT 20;
SQL

Checking query status...
