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 * # distinct regexp_substr(page_title, '.*_u_')
from page
where
  page_namespace = 0
  and page_is_redirect = 0
  and page_title regexp '.*_u_[[:digit:]]+\.$' = 1
  /*and 
  (
    page_is_new = 1 
    or page_id not in
    (
      select 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 pl_title regexp '^[[:digit:]]+\.$' = 0 and pl_title regexp '.*_u_[[:digit:]]+\.$' = 0
    )
  )*/
  #group by page_title
  #having count(*)>1
  order by rand()  
limit 100

SQL

Checking query status...