Untitled query #92102

SQL

SELECT 
    rc_timestamp AS "நேரம்", 
    actor_name AS "பயனர்", 
    CONCAT("[[", rc_title, "]]") AS "கட்டுரை", 
    rc_new_len AS "ஆரம்ப நீளம்", 
    "" AS "குறிப்பு"
FROM recentchanges_userindex
JOIN actor ON rc_actor = actor_id
LEFT JOIN user_groups ON actor_user = ug_user AND ug_group = 'autopatrolled'
WHERE rc_new = 1  -- Only new pages
    AND rc_namespace = 0  -- Only main namespace
    AND rc_patrolled = 2  -- Autopatrolled status
    AND rc_new_len > 100  -- Minimum content size
    AND rc_timestamp > "20220621000000" 
    AND rc_timestamp < "20220631240000"
    AND ug_user IS NULL  -- Excludes autopatrolled users
ORDER BY actor_name, rc_timestamp;
SQL

Checking query status...
