Untitled query #77956

SQL

    select DISTINCT 
    p.page_title, 
    #a.actor_name, 
    (select parent.rev_len from revision parent where r.rev_parent_id = parent.rev_id and p.page_id = parent.rev_page) as old_len,
    r.rev_len as new_len,
    r.rev_parent_id,
    r.rev_id
    #,parent.rev_len
    #,SUM(CAST(r.rev_len as signed)-CAST(parent.rev_len as signed)) AS byte_count
    
    from change_tag t
    INNER JOIN change_tag_def ctd on ctd.ctd_id = t.ct_tag_id
    INNER JOIN revision r on r.rev_id = t.ct_rev_id
    INNER JOIN actor a ON r.rev_actor = a.actor_id
    inner join comment c on c.comment_id = r.rev_comment_id
    INNER JOIN page p on r.rev_page=p.page_id
    
    
    #INNER JOIN revision parent
    #ON r.rev_parent_id = parent.rev_id
    
    
    where p.page_namespace = 0
    #and p.page_id = parent.rev_page
    
    #and ctd.ctd_name in ("contenttranslation", "contenttranslation-v2") #id = 3 # id = 120
    #and r.rev_parent_id = 0
    AND r.rev_timestamp between 20230901000000 AND 20231201000000
    AND a.actor_name in ('Mr. Ibrahem')
    AND p.page_title in ('انعدام_الجنسية_في_لبنان')
    
    #and comment_text like "%User:Mr. Ibrahem/%"
    #group by r.rev_sha1
    #group by p.page_title, a.actor_name#, c.comment_text
    #limit 20
SQL

Checking query status...
