Untitled query #84855

SQL

USE arwiki_p;

-- Extract articles created on July 13, 2024
WITH created_articles AS (
    SELECT p.page_id, p.page_title, p.page_len
    FROM page p
    JOIN revision r ON p.page_id = r.rev_page
    WHERE r.rev_timestamp BETWEEN '20240713000000' AND '20240713235959'
    AND r.rev_parent_id = 0
    AND p.page_namespace = 0
)

-- Extract text and count words
SELECT ca.page_title, ca.page_len, LENGTH(t.old_text) - LENGTH(REPLACE(t.old_text, ' ', '')) + 1 AS word_count
FROM created_articles ca
JOIN text t ON ca.page_id = t.old_id
WHERE LENGTH(t.old_text) - LENGTH(REPLACE(t.old_text, ' ', '')) + 1 > 300
ORDER BY word_count DESC;
SQL

Checking query status...
