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

SELECT
  page_title AS Article_Title,
  page_namespace AS Namespace,
  page_len AS Word_Count
FROM
  page
WHERE
  page_namespace = 0 -- Namespace 0 corresponds to articles
  AND page_len < 100;
  
 LIMIT 1;

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