Untitled query #84855

SQL

USE arwiki_p;

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
),

article_texts AS (
    SELECT ca.page_id, ca.page_title, ca.page_len, c.content_address
    FROM created_articles ca
    JOIN slots s ON ca.page_id = s.slot_page
    JOIN content c ON s.slot_content_id = c.content_id
)

SELECT at.page_title, at.page_len,
       ROUND((LENGTH(at.content_address) - LENGTH(REPLACE(at.content_address, ' ', ''))) / LENGTH(' ') + 1) AS word_count
FROM article_texts at
WHERE ROUND((LENGTH(at.content_address) - LENGTH(REPLACE(at.content_address, ' ', ''))) / LENGTH(' ') + 1) > 300
ORDER BY word_count DESC;
SQL

Checking query status...
