Statistikk Damer 2008/2009

Problems whit the Database connection..

Feilmelding: 1030

Detaljert informasjon: Got error 12 from storage engine

SQL: select player_no, player_name,p.player_id, SUM(playerstat_goals) as playerstat_goals, SUM(playerstat_assists) as playerstat_assists, SUM(playerstat_penaltys) as playerstat_penaltys, SUM(playerstat_goals) + SUM(playerstat_assists) as points, count(ps.player_id) as cnt from jaaPlayerStat ps, jaaPlayer p, jaaMatch m where ps.player_id=p.player_id and season_id=2 and ps.match_id = m.match_id and team_id=2 and matchtype_id=1 group by ps.player_id order by points desc, playerstat_goals desc , playerstat_assists desc

Seriekamp

Spiller

Mål

Assist

Poeng

Snitt

Utv.min.

Kamper

Problems whit the Database connection..

Feilmelding: 1030

Detaljert informasjon: Got error 12 from storage engine

SQL: select player_no, player_name,p.player_id, SUM(playerstat_goals) as playerstat_goals, SUM(playerstat_assists) as playerstat_assists, SUM(playerstat_penaltys) as playerstat_penaltys, SUM(playerstat_goals) + SUM(playerstat_assists) as points, count(ps.player_id) as cnt from jaaPlayerStat ps, jaaPlayer p, jaaMatch m where ps.player_id=p.player_id and season_id=2 and ps.match_id = m.match_id and team_id=2 and matchtype_id=3 group by ps.player_id order by points desc, playerstat_goals desc , playerstat_assists desc