Warning: mysqli_connect(): (HY000/2003): Can't connect to MySQL server on 'ligueenc_v3.mysql.db' (111) in /home/ligueenc/www/lib/Database.php on line 30
Unable to connect. Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 82
Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 83
Unable to process query : Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 82
Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 83
Unable to process query : Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 82
Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 83
Unable to process query : Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 82
Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 83
Unable to process query : Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 82
Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 83
Unable to process query : Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 82
Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 83
Unable to process query : Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 82
Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 83
Unable to process query : Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 52
Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 53
Unable to process query : SELECT PLAYER.ID_PLAYER,
PLAYER.FNAME,
PLAYER.LNAME,
CASE WHEN TEAM.IS_SUBS = 1 THEN '5 - Remplaçants' ELSE PLAYER.POSITION END AS POSITION,
PLAYER.LINK,
CLUB.NAME,
TEAM.IS_SUBS,
TEAM.DAY_FIRST,
TEAM.DAY_LAST,
(CASE WHEN TEAM.DAY_FIRST <= 29 AND TEAM.DAY_LAST >= 29 THEN 1 ELSE 0 END) AS ACTIVE,
SUM(COALESCE(SCORE.POINTS, 0)) AS POINTS,
SUM(COALESCE(SCORE.GOALS, 0)) AS GOALS,
SUM(COALESCE(SCORE.PASSES, 0)) AS PASSES,
COUNT(DISTINCT SCORE.DAY) AS NB_DAY,
SUM(COALESCE(SCORE.POINTS + (2*SCORE.GOALS) + SCORE.PASSES, 0)) AS TOTAL
FROM CLUB, PLAYER, TEAM
LEFT JOIN TEAM_DAY ON TEAM_DAY.ID_USER = TEAM.ID_USER
AND TEAM_DAY.ID_LEAGUE = TEAM.ID_LEAGUE
AND TEAM_DAY.ID_PLAYER = TEAM.ID_PLAYER
LEFT JOIN SCORE ON SCORE.ID_PLAYER = TEAM_DAY.ID_PLAYER
AND SCORE.DAY = TEAM_DAY.DAY
AND SCORE.DAY BETWEEN TEAM.DAY_FIRST AND TEAM.DAY_LAST
AND SCORE.DAY = 29
WHERE CLUB.ID_CLUB = PLAYER.ID_CLUB
AND TEAM.ID_PLAYER = PLAYER.ID_PLAYER
AND TEAM.ID_USER = 819
AND TEAM.ID_LEAGUE = 19
GROUP BY PLAYER.ID_PLAYER, PLAYER.LNAME, PLAYER.POSITION, CLUB.NAME,
TEAM.IS_SUBS, TEAM.DAY_FIRST, TEAM.DAY_LAST,
CASE WHEN TEAM.DAY_FIRST <= 29 AND TEAM.DAY_LAST >= 29 THEN 1 ELSE 0 END
ORDER BY 7 ASC, 4 ASC, 10 DESC Warning: mysqli_close() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 120