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

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

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 indice.page_title
from category cat
join categorylinks catlink on cat.cat_title = catlink.cl_to
join page indice on catlink.cl_from = indice.page_id
where cat_title in (
  select concat('Libri_di_', author.page_title)
  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'
  )
)

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...