it.wiki EGO: Categorie di squadre con più allenatori o giocatori

Exaustive description here
https://it.wikipedia.org/wiki/Wikipedia:Elenchi_generati_offline/Richieste#Categorie_di_squadre_con_pi%C3%B9_allenatori_o_giocatori

SQL

use itwiki_p;
SELECT
	p_nation.page_title as nation,
    p_squad .page_title as squad,
FROM
	categorylinks as cl1_squadsbynation
	JOIN page          AS p_nation        ON ( cl1_squadsbynation.cl_from = p_nation.page_id    )
    JOIN categorylinks AS cl_nationsquads ON ( cl_nationsquads.cl_to      = p_nation.page_title )
   	JOIN page          AS p_squad         ON ( cl_nationsquads.cl_from    = p_squad.page_id     )
WHERE
	cl1_squadsbynation.cl_to = 'Squadre_sportive_per_nazione' AND
    p_nation.page_title NOT LIKE = '%_di_%' AND
    p_squad.page_title NOT LIKE 'Squadre_automobilistiche%'

SQL

Checking query status...