A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /htdocs/public/www/application/models/estatisticas_jornadas_model.php:1)

Filename: core/Common.php

Line Number: 409

Database Error

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND competicao_id=113),0) AS estatistica_j,IFNULL((SELECT SUM(estatistica_v) F' at line 1

SELECT DISTINCT(classificacoes.clube_id),clubes.clube_nome,classificacoes.classificacao_clube_b,IFNULL((SELECT COUNT(estatistica_v) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_j,IFNULL((SELECT SUM(estatistica_v) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_v,IFNULL((SELECT SUM(estatistica_e) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_e,IFNULL((SELECT SUM(estatistica_d) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_d,IFNULL((SELECT SUM(estatistica_gm) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_gm,IFNULL((SELECT SUM(estatistica_gs) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_gs,IFNULL((SELECT SUM(estatistica_gm)-SUM(estatistica_gs) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_dg,IFNULL((SELECT SUM(estatistica_pts) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_pts,IFNULL((SELECT SUM(estatistica_goleadas) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_goleadas,IFNULL((SELECT SUM(estatistica_casa_j) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_casa_j,IFNULL((SELECT SUM(estatistica_casa_v) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_casa_v,IFNULL((SELECT SUM(estatistica_casa_e) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_casa_e,IFNULL((SELECT SUM(estatistica_casa_d) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_casa_d,IFNULL((SELECT SUM(estatistica_casa_gm) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_casa_gm,IFNULL((SELECT SUM(estatistica_casa_gs) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_casa_gs,IFNULL((SELECT SUM(estatistica_fora_j) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_fora_j,IFNULL((SELECT SUM(estatistica_fora_v) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_fora_v,IFNULL((SELECT SUM(estatistica_fora_e) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_fora_e,IFNULL((SELECT SUM(estatistica_fora_d) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_fora_d,IFNULL((SELECT SUM(estatistica_fora_gm) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_fora_gm,IFNULL((SELECT SUM(estatistica_fora_gs) FROM estatisticas_jornadas ej WHERE ej.clube_ID=estatisticas_jornadas.clube_id AND jornada_id IN() AND competicao_id=113),0) AS estatistica_fora_gs FROM estatisticas_jornadas RIGHT JOIN classificacoes ON estatisticas_jornadas.clube_id=classificacoes.clube_id INNER JOIN clubes ON classificacoes.clube_id=clubes.clube_id WHERE classificacoes.competicao_id =113 AND classificacoes.classificacao_activo=1 ORDER BY estatistica_pts DESC, estatistica_gm DESC, estatistica_dg DESC

Filename: /htdocs/public/www/models/estatisticas_jornadas_model.php

Line Number: 289