Testi SAL 25% - Quarry

SQL

use itwikisource_p;
select 
	  concat('[[Autore:', autori.autore, ']]')                      Autore,
	  (select replace(cat_title, 'Nati_nel_', '')
	   from category join categorylinks on cat_title = cl_to
	   where cl_from = id_autore 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 = id_autore and cat_title like 'Morti_nel_%')  Morte
	from category cat
	join categorylinks catlink on cat.cat_title = catlink.cl_to
	join (
	  select author.page_title autore, author.page_id id_autore
	  from page author
	  join categorylinks catlink2 on author.page_id = catlink2.cl_from
	  where cl_to = 'Autori del XX secolo'
) q
SQL

Checking query status...
