Retrieve Wikipedia Articles From a Selected Database with Highest Word Counts

Fork of Retrieve Wikipedia Articles From a Selected Database with Highest Word Counts by ShadowCipher02

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

This query focuses on the length of articles and retrieves the articles with the highest word counts in the Telugu Wikipedia. It's a different perspective, highlighting the longest articles on the site. You can adjust the LIMIT value to retrieve more or fewer results based on your interest.

SQL

-- Retrieve Wikipedia Articles From a Selected Database with Highest Word Counts

SELECT
  page_title AS Article_Title,
  page_len AS Word_Count
FROM
  page
WHERE
  page_namespace = 0 -- Namespace 0 corresponds to articles
ORDER BY Word_Count DESC
LIMIT 100; -- Limit the results to the top 10 articles with the highest word counts

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...