SQL
AخA
USE itwiki_p;
SELECT DISTINCT page_title as itpagetitle
FROM page
JOIN enwiki_p.page as enpage ON (
enpage.page_namespace = 0
AND enpage.page_is_redirect = 0
AND enpage.page_id IN (
SELECT DISTINCT enwiki_p.cl_from
FROM enwiki_p.categorylinks
WHERE enwiki_p.cl_to LIKE 'Olympic_gold_medalists_for%'
)
)
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_id NOT IN (
SELECT DISTINCT cl_from
FROM categorylinks
WHERE cl_to LIKE 'Vincitori_di_medaglia_d%oro_olimpica_per%'
)
LIMIT 10;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.