Untitled query #8634

SQL

SELECT 
    concat('# [[', subquery.page_title, ']]') AS title
FROM (
    SELECT 
        page_title,
        rev_len,
        COALESCE((SELECT pr.rev_len FROM revision pr WHERE pr.rev_id = r.rev_parent_id), 0) AS parent_len
    FROM revision r
    JOIN actor ON r.rev_actor = actor_id
    JOIN page ON r.rev_page = page_id 
    WHERE actor_name = "ԱշոտՏՆՂ" AND page_namespace = 0
) AS subquery
GROUP BY title
HAVING SUM(CAST(subquery.rev_len AS SIGNED) - CAST(subquery.parent_len AS SIGNED)) > 1000
ORDER BY SUM(CAST(subquery.rev_len AS SIGNED) - CAST(subquery.parent_len AS SIGNED)) DESC;
SQL

Checking query status...
