Testi SAL 25% - Quarry

SQL

use itwikisource_p;
select 
	  concat('[[Autore:', autori.page_title, ']]')                      Autore,
	  (select replace(cat_title, 'Nati_nel_', '')
	   from category join categorylinks on cat_title = cl_to
	   where cl_from = page_id and cat_title like 'Nati_nel_%')   Nascita,
	  (select replace(cat_title, 'Morti_nel_', '')
	   from category join categorylinks on cat_title = cl_to
	   where cl_from = page_id and cat_title like 'Morti_nel_%')  Morte
    from page autori
	join categorylinks catlink on autori.page_id = catlink.cl_from
    join category on cl_to = cat_title
    where cat_title = 'Autori del XX secolo'
SQL

Checking query status...
