Untitled query #84855

SQL

USE arwiki_p;

-- استخراج مقالات ایجاد شده در 13 ژوئیه 2024
WITH created_articles AS (
    SELECT p.page_id, p.page_title, p.page_len, r.rev_id
    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
)

-- استخراج متن مقالات
SELECT ca.page_title, ca.page_len, 
       ROUND((LENGTH(r.rev_text) - LENGTH(REPLACE(r.rev_text, ' ', ''))) + 1) AS word_count
FROM created_articles ca
JOIN revision r ON ca.rev_id = r.rev_id
WHERE ROUND((LENGTH(r.rev_text) - LENGTH(REPLACE(r.rev_text, ' ', ''))) + 1) > 300
ORDER BY word_count DESC;
SQL

Checking query status...
