Tak vyřešeno:
$query="SELECT confid,Name,z.nazev AS Teamname,Team,Pos,P,G,A,GP,Time,Pims,plusminus,PPG,SHG,Shoot,Hits,ID FROM `playerstat` p LEFT JOIN zkratky z ON p.Team=z.zkratka WHERE confid=$confid AND Pos='Player'";
Tak vyřešeno:
$query="SELECT confid,Name,z.nazev AS Teamname,Team,Pos,P,G,A,GP,Time,Pims,plusminus,PPG,SHG,Shoot,Hits,ID FROM `playerstat` p LEFT JOIN zkratky z ON p.Team=z.zkratka WHERE confid=$confid AND Pos='Player'";