Retrieve Telugu Wikipedia Articles with Most Interlanguage Links

This query is marked as a draft This query has been published by ShadowCipher02.

This query focuses on the connectivity of articles in Telugu Wikipedia to articles in other language versions of Wikipedia through interlanguage links. It can be useful for understanding which articles have the most connections to content in other languages. You can adjust the LIMIT value to retrieve more or fewer results based on your interests.

SQL

SELECT
  CONCAT('https://te.wikipedia.org/wiki/', REPLACE(page.page_title, ' ', '_')) AS Article_Link,
  page.page_title AS Article_Title,
  COUNT(ll_lang) AS Interlanguage_Link_Count
FROM
  langlinks
  JOIN page ON langlinks.ll_from = page.page_id
WHERE
  page.page_namespace = 0 -- Namespace 0 corresponds to articles
GROUP BY page_title
ORDER BY Interlanguage_Link_Count DESC
LIMIT 100;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...