C1K98V - Article Create

SQL

USE enwiki_p;

SELECT 
    CONCAT(SUBSTR(rev_timestamp, 1, 4), "-", SUBSTR(rev_timestamp, 5, 2), "-", SUBSTR(rev_timestamp, 7, 2)) AS creation_date,
    actor_name AS user_name,
    COUNT(CONCAT(SUBSTR(rev_timestamp, 1, 4), "-", SUBSTR(rev_timestamp, 5, 2), "-", SUBSTR(rev_timestamp, 7, 2))) AS pages_created_count,
    SUM(p1.page_len) AS total_bytes
FROM 
    page p1
JOIN 
    revision ON rev_page = p1.page_id
JOIN 
    actor ON actor_id = rev_actor
WHERE 
    p1.page_namespace = 0
    AND rev_parent_id = 0
    AND p1.page_is_redirect = 0
    AND rev_timestamp >= 20240617000000
    AND actor_name = 'C1K98V'
GROUP BY 
    actor_name, 
    CONCAT(SUBSTR(rev_timestamp, 1, 4), "-", SUBSTR(rev_timestamp, 5, 2), "-", SUBSTR(rev_timestamp, 7, 2))
ORDER BY 
    creation_date DESC, 
    pages_created_count DESC;
SQL

Checking query status...
