SQL
AخA
USE enwiki_p;
SELECT /*SLOW OK*/ concat('[[:en:',page_title,']]')
FROM page
WHERE page_id IN (
SELECT tl_from
FROM templatelinks
WHERE tl_title = "Infobox_sportsperson"
AND tl_namespace = 10
AND tl_from IN (
SELECT ll_from
FROM langlinks
WHERE ll_from
GROUP BY ll_from
HAVING COUNT(*) > 20
)
AND tl_from NOT IN (
SELECT ll_from
FROM langlinks
WHERE ll_lang = "fa"
)
);
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.