select substring(rev_created, 1, 8) as data_RMD, count(*) as str_na_dzien

, min(rev_created), max(rev_created), min(page_len), max(page_len)

, min(page_title) as np_tytul

from

(

  select page_title, rev_created, page_touched, page_len

  from page 

  left join  

      (select rev_page, min(rev_timestamp) as rev_created from revision group by rev_page)

  as r on r.rev_page = page_id

  where page_namespace = 0 and page_is_redirect = 0

) as page_creation

group by 1

order by 1