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
	p1.page_title as nation_category,
    p2.page_title as squad,
    p3.page_title as subsquad,
FROM categorylinks as cl1
	JOIN page          AS p1  ON ( cl1.cl_from = p1.page_id    )
    JOIN categorylinks AS cl2 ON ( cl2.cl_to   = p1.page_title )
    JOIN page          AS p2  ON ( cl2.cl_from = p2.page_id    )
    JOIN categorylinks AS cl3 ON ( cl3.cl_from = p2.page_title )
    JOIN page          as p3  ON ( cl3.cl_from = p3.page_title )
WHERE
	cl1.cl_to = 'Squadre_sportive_per_nazione' AND
    p1.page_title != 'Squadre_nazionali' AND
    p1.page_title != 'Società_sportive_campioni_nazionali_per_nazione' AND
    p2.page_title NOT LIKE 'Squadre_automobilistiche%'

SQL

Checking query status...