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;

​