Index pages by authors born or died a multiple of 100 years ago

List of index pages (from Italian Wikisource) for books written by authors who were born or died an exact number of centuries ago

SQL

use itwikisource_p;
select concat('[[Indice:', indice.page_title, ']]') as indice, autori.autore
from category cat
join categorylinks catlink on cat.cat_title = catlink.cl_to
join page indice on catlink.cl_from = indice.page_id
join (
  select author.page_title autore
  from page author
  join categorylinks catlink2 on author.page_id = catlink2.cl_from
  where cl_to in (
    select cat_title
    from category
    where cat_title rlike 'Nati_nel_[0-9][0-9]20' or cat_title rlike 'Morti_nel_[0-9][0-9]20'
  ) autori
) on cat_title = concat('Libri_di_', autori.page_title)

SQL

Checking query status...