USE enwiki_p;

SELECT page_title AS module,

    DATE(MIN(rev_timestamp))    AS first_edit,

    DATE(MAX(rev_timestamp))    AS latest_edit,

    COUNT(rev_id)               AS number_of_edits,

    (MIN(rev_parent_id) = 0)    AS created,

    ROUND((page_len / 1024), 1) AS size_in_kB

FROM revision

    INNER JOIN page ON page_id = rev_page

WHERE page_namespace = 828 -- Module namespace

AND (rev_user_text = 'Mr. Stradivarius' OR rev_user_text = 'Mr. Stradivarius on tour')

AND page_title NOT LIKE '%/doc' -- exclude documentation pages

AND page_title NOT LIKE '%/sandbox' -- exclude sandboxes

AND page_title NOT LIKE '%/testcases' -- exclude test case pages

GROUP BY page_title

ORDER BY page_title;