Untitled query #48020

SQL

SELECT 
    (CAST(IF(rev.rev_deleted & 1, NULL, rev.rev_len) AS SIGNED) - 
    CAST(IF(rev.rev_deleted & 1, NULL, parent.rev_len) AS SIGNED)) AS length_difference,
    page.page_title, 
    rev.rev_timestamp
FROM 
    revision AS rev
JOIN 
    page ON page.page_id = rev.rev_page
JOIN 
    comment ON rev.rev_comment_id = comment.comment_id
JOIN 
    actor ON rev.rev_actor = actor.actor_id
LEFT JOIN 
    revision AS parent ON rev.rev_parent_id = parent.rev_id
WHERE
	actor_name = 'ԱշոտՏՆՂ' AND page_namespace = 0 
ORDER BY length_difference
LIMIT 400;
SQL

Checking query status...
