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 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 COALESCE(TEAM_DAY_LAST.ID_PLAYER, 0) = 0 THEN 0 ELSE 1 END AS TIT,
PLAYER.POSITION,
PLAYER.LINK,
CLUB.NAME AS CLUB,
COALESCE(CLUB_VALID.IS_VALID, 0) AS CLUB_CLOSED,
TEAM.IS_SUBS,
TEAM.DAY_FIRST,
TEAM.DAY_LAST,
(CASE WHEN TEAM.DAY_FIRST <= 14 AND TEAM.DAY_LAST >= 14 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
LEFT JOIN CLUB_VALID ON CLUB.ID_CLUB = CLUB_VALID.ID_CLUB AND CLUB_VALID.DAY = 14
, 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 TEAM_DAY TEAM_DAY_LAST ON TEAM_DAY_LAST.ID_USER = TEAM.ID_USER
AND TEAM_DAY_LAST.ID_LEAGUE = TEAM.ID_LEAGUE
AND TEAM_DAY_LAST.ID_PLAYER = TEAM.ID_PLAYER
AND TEAM_DAY_LAST.DAY = (SELECT MAX(DAY) FROM TEAM_DAY WHERE TEAM_DAY.ID_USER = TEAM.ID_USER AND TEAM_DAY.ID_LEAGUE = TEAM.ID_LEAGUE AND TEAM_DAY.DAY <= 14)
LEFT JOIN SCORE ON SCORE.ID_PLAYER = TEAM_DAY.ID_PLAYER
AND SCORE.DAY = TEAM_DAY.DAY
-- AND SCORE.DAY <= 14
WHERE CLUB.ID_CLUB = PLAYER.ID_CLUB
AND TEAM.ID_PLAYER = PLAYER.ID_PLAYER
AND TEAM.ID_USER = 793
AND TEAM.ID_LEAGUE = 19
GROUP BY PLAYER.ID_PLAYER, PLAYER.LNAME, PLAYER.POSITION, CLUB.NAME, TEAM_DAY_LAST.IS_VALID
ORDER BY 5 ASC, 11 DESC, 3 ASC Warning: mysqli_close() expects parameter 1 to be mysqli, boolean given in /home/ligueenc/www/lib/Database.php on line 120