Hrwiki year articles with trivial links only

Fork of Hrwiki articles by Kubura with only initial edit by GregorB

This query is marked as a draft This query has been published by GregorB.

SQL

use hrwiki_p;

select pl_from from pagelinks where pl_from_namespace = 0 and pl_namespace = 0 and pl_title regexp '^[[:digit:]]+\.$' = 0
limit 100
/*
select page_title, count(*)#actor_name 
from page as p
join revision_userindex on rev_page = page_id
join actor_revision on rev_actor = actor_id
where
  page_namespace = 0
  and page_is_redirect = 0
  and page_title regexp '.*_u_[[:digit:]]+\.$' = 1
  #and page_is_new = 1
  and page_id not in
  (
    select pl_from from pagelinks where pl_from_namespace = 0 and pl_namespace = 0 and pl_title regexp '^[[:digit:]]+\.$' = 0
  )
  group by page_title
  having count(*)>1
  order by page_title  
limit 1000
*/

SQL

Checking query status...