Hrwiki year articles summary

SQL

use hrwiki_p;

select *
	#regexp_substr(page_title, '.*_u_'), 
	#sum(page_is_new) as new, count(case when pl_from is null then 1 end) as trivial_links, count(*) as total
from page
left join
(
  select distinct pl_from 
  from page
  inner join pagelinks on pl_title = page_title # Target page actually exists
  where pl_from_namespace = 0 and pl_namespace = 0 and page_namespace = 0 and page_is_redirect = 0
  and pl_title regexp '^[[:digit:]]+\.$' = 0 and pl_title regexp '.*_u_[[:digit:]]+\.$' = 0 
  and pl_title not like '%stoljeću' and pl_title not in ('Strip', 'Šport')
) pl on pl_from = page_id
where
  page_namespace = 0
  and page_is_redirect = 0
  and page_title regexp '.*_u_[[:digit:]]+\.$' = 1 and page_title not like 'Popis%'
#group by regexp_substr(page_title, '.*_u_') with rollup
SQL

Checking query status...
