SELECT m.id_mot, m.titre, 
    (SELECT COUNT(L.id_mot) FROM spip_mots_liens AS L WHERE L.id_mot = m.id_mot) AS nb 
FROM spip_mots AS m WHERE m.id_groupe=2 ORDER BY m.titre;