Cities - Quarry

SQL

USE wikidatawiki_p;

SELECT DISTINCT page.page_title AS article_title
FROM page
JOIN pagelinks ON pl_from = page_id
LEFT JOIN langlinks ON page_id = ll_from AND ll_lang = 'ar'
WHERE page_namespace = 0
  AND page_is_redirect = 0
  AND page.page_title IN (
    SELECT ips_site_page
    FROM wb_items_per_site
    WHERE ips_site_id = 'enwiki'
      AND ips_item_id IN (
        SELECT wbt_item_terms.term_entity_id
        FROM wbt_item_terms
        JOIN wbt_term_in_lang ON wbt_item_terms.term_in_lang_id = wbt_term_in_lang.term_in_lang_id
        WHERE wbt_term_in_lang.term_text = 'Q7930989'
      )
  )
  AND ll_from IS NULL
LIMIT 20;
SQL

Checking query status...
