UnPatrolled pages from Jan 1 to Mar 26

SQL

SELECT rc_timestamp AS "நேரம்", 
       actor_name AS "பயனர்", 
       CONCAT("[[", rc_title, "]]") AS "கட்டுரை", 
       rc_new_len AS "ஆரம்ப நீளம்"
FROM recentchanges_userindex
JOIN actor ON rc_actor = actor_id
WHERE rc_new = 1  -- Only new pages
    AND rc_namespace = 0  -- Only main namespace articles
    AND rc_patrolled = 0  -- Unpatrolled pages
    AND rc_timestamp BETWEEN "20250101000000" AND "20250326235959"
ORDER BY rc_timestamp DESC;

​x
 
SELECT rc_timestamp AS "நேரம்",        actor_name AS "பயனர்",        CONCAT("[[", rc_title, "]]") AS "கட்டுரை",        rc_new_len AS "ஆரம்ப நீளம்"FROM recentchanges_userindexJOIN actor ON rc_actor = actor_idWHERE rc_new = 1  -- Only new pages    AND rc_namespace = 0  -- Only main namespace articles    AND rc_patrolled = 0  -- Unpatrolled pages    AND rc_timestamp BETWEEN "20250101000000" AND "20250326235959"ORDER BY rc_timestamp DESC;​

SQL

Checking query status...