Статті Haida з сумою дифів інших

This query is marked as a draft This query has been published by Base.

SQL

SELECT p.page_id, p.page_title,
       (select
            sum(
                    IF(
                                rr.rev_actor = r.rev_actor,
                                0,
                      abs(coalesce(rr.rev_len) - (select coalesce(rrr.rev_len) from revision rrr where rrr.rev_id = rr.rev_parent_id))
                    )
            ) as haidaless_sum
        from revision rr
        where rr.rev_page = r.rev_page
        group by rev_page) as haidaless_sum
FROM page p
         JOIN revision r ON p.page_id = r.rev_page
         JOIN actor a ON r.rev_actor = a.actor_id
WHERE p.page_namespace = 0 AND a.actor_name = "Haida" AND r.rev_parent_id = 0 AND p.page_is_redirect = 0;

SQL

Checking query status...