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_squads.page_title AS squads,
    p_squad .page_title AS squad 
FROM
	     categorylinks  AS cl1
	JOIN page           AS p_nation ON ( cl1.cl_from = p_nation.page_id    )
    JOIN categorylinks  AS cl2      ON ( cl2.cl_to   = p_nation.page_title )
   	JOIN page           AS p_squads ON ( cl2.cl_from = p_squads.page_id    )
    JOIN categorylinks  AS cl3      ON ( cl3.cl_to   = p_nation.page_title )
    JOIN page           AS p_squad  ON ( cl3.cl_from = p_squad .page_id    )
WHERE
	cl1.cl_to = 'Squadre_sportive_per_nazione'               AND
    p_nation.page_title NOT LIKE '%_di_%'                    AND
    p_squad .page_title NOT LIKE 'Squadre_automobilistiche%' AND
    cl2.cl_type = 'subcat'

SQL

Checking query status...