Select bb.cap, aa.id_joueur, aa.id_position, aa.prenom_joueur, aa.nom_joueur, SUM(t.pj) as pj, SUM(t.b) as b, SUM(t.p) as p, SUM(t.pts) as pts, SUM(t.pun) as pun, SUM(t.diff) as diff
FROM
marqueur_com.Hockey_LNH_Joueur as aa
LEFT OUTER JOIN
(
SELECT a.id_joueur, SUM(a.pj) as pj, SUM(a.b) as b, SUM(a.p) as p, SUM(a.b + a.p) as pts, SUM(a.pun) as pun, SUM(a.diff) as diff, 0 as pj_s, 0 as b_s, 0 as p_s, 0 as pts_s, 0 as pun_s, 0 as diff_s
FROM marqueur_com.Hockey_LNH_JoueurAnterieur as a
WHERE (a.id_ligue = 1) AND (a.id_saison = '167') and (a.series = 0) and a.id_joueur IN (
SELECT id_joueur FROM marqueur_com.Hockey_LNH_JoueurAnterieur WHERE id_saison = '167' and id_equipe = '24' and id_ligue = 1)
GROUP BY a.id_joueur
) as t
RIGHT OUTER JOIN (
select id_joueur, cap
from marqueur_com.Hockey_LNH_JoueurSalaire
where id_saison = '167') as bb on t.id_joueur = bb.id_joueur
GROUP BY id_joueur, prenom_joueur, nom_joueur
order by SUM(pts) desc, SUM(b) desc, SUM(pj), nom_joueur Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in /home/marqueur/public_html/hockey/stats/nhl/team.php on line 361
