Query test - Quarry

SQL

USE itwiki_p;
SELECT DISTINCT itpage.page_title
FROM page as itpage
JOIN enwiki_p.page as enpage ON (
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 REGEXP 'Olympic_(gold|silver|bronze)_medalists_for.*'
) 
AND itpage.page_title = enpage.page_title
)
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 REGEXP 'Vincitori_di_medaglia_(d\'oro|d\'argento|di bronzo)_olimpica_per.*'
);
SQL

Checking query status...
