مساهمات مستخدم بالبايت *

SQL

SELECT *
/*DISTINCT 
    p.page_title, 
    a.actor_name, 
    r.rev_parent_id,
    r.rev_id,
    r.rev_len AS new_len, 
	IFNULL((SELECT parent.rev_len FROM revision parent WHERE r.rev_parent_id = parent.rev_id AND p.page_id = parent.rev_page), 0) AS old_len,
    (r.rev_len - IFNULL((SELECT parent.rev_len FROM revision parent WHERE r.rev_parent_id = parent.rev_id AND p.page_id = parent.rev_page), 0)) 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
#LEFT JOIN revision parent ON r.rev_parent_id = parent.rev_id AND p.page_id = parent.rev_page
WHERE p.page_namespace = 0
    AND r.rev_timestamp BETWEEN 20230901000000 AND 20231201000000
    AND a.actor_name IN ('Mr. Ibrahem')
    AND p.page_title IN ('انعدام_الجنسية_في_لبنان')
GROUP BY c.ct_rc_id#, p.page_title, a.actor_name, r.rev_len, r.rev_parent_id, r.rev_id
LIMIT 20;
SQL

Checking query status...
