select

    replace(p.page_title, '_', ' ') as page_title,

    count(*) as count

  from

    page p, revision r

  where

    r.rev_page = p.page_id and

    p.page_namespace = 2 and

    r.rev_timestamp >= date_format(date_sub(now(), interval 3 month), '%Y%m%d%H%i%s')

  group by

    p.page_title

  order by

    count desc

  ;

​