Query test 2 - Quarry

SQL

USE itwiki_p;
SELECT DISTINCT itpage.page_title
FROM page as itpage
JOIN wikidatawiki_p.wb_items_per_site as wbitems ON
(wbitems.ips_site_page = itpage.page_title
AND wbitems.ips_item_id IN
 (SELECT wbitems2.ips_item_id
FROM wikidatawiki_p.wb_items_per_site as wbitems2
WHERE wbitems2.ips_site_id = 'enwiki'
AND wbitems2.ips_site_page IN
  (
  SELECT DISTINCT enpage.page_title
  FROM enwiki_p.page as enpage
  WHERE enpage.page_namespace = 0
  AND enpage.page_is_redirect = 0
  AND enpage.page_id IN (
  SELECT DISTINCT encatlinks.cl_from
  FROM enwiki_p.categorylinks as encatlinks
  WHERE encatlinks.cl_to LIKE 'Olympic_gold_medalists_for%'
 )
)
)
)
WHERE itpage.page_namespace = 0
AND itpage.page_is_redirect = 0
AND itpage.page_id NOT IN (
SELECT DISTINCT itcatlinks.cl_from
FROM categorylinks as itcatlinks
WHERE itcatlinks.cl_to LIKE 'Vincitori_di_medaglia_d%oro_olimpica_per%'
)
LIMIT 10;
SQL

Checking query status...
