Retrieve Telugu Wikipedia Articles according to no.of words

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

This Quarry query is designed to extract information from any Wikipedia database (by changing the database name). It identifies and lists articles within the main namespace (namespace 0) that have more than or less than required no.of words in their content. In the results, it provides both the title of each article and a direct link to the article for easy access.

SQL

-- Get articles with more than 500 words from Telugu Wikipedia

-- Get articles with more than 500 words from Telugu Wikipedia with article links
USE tewiki_p;

SELECT
  CONCAT('https://te.wikipedia.org/wiki/', REPLACE(page_title, ' ', '_')) AS Article_Link,
  page_title AS Article_Title,
  page_len AS Word_Count
FROM
  page
WHERE
  page_namespace = 0
  AND page_len < 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...