set @prefix := "Nux/";

set @namespace := 2;

​

select

    page_title,

    STR_TO_DATE(min(rev_timestamp), '%Y%m%d%H%i%S') as created,

    STR_TO_DATE(max(rev_timestamp), '%Y%m%d%H%i%S') as modified,

    count(rev_id) as rev_count,

    page_is_redirect

from page

    inner join revision on rev_page = page_id

where

    page_title like concat(@prefix, '%') and

    page_namespace = @namespace

group by

    page_id

order by

    modified desc, page_title asc;