set @prefix := "Nux/";

set @namespace := 2;

​

select

    *

from (

      select

          page_id,

          page_title,

          min(rev_timestamp) as created,

          page_is_redirect,

          count(rev_id) as rev_count

      from page

          inner join revision on rev_page = page_id

      where

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

          page_namespace = @namespace

      group by

          page_id

    ) subquery

    join page using (page_id)

group by

    page_id, created

;