Unable to process query : User 'ligueenc_v3' has exceeded the 'max_questions' resource (current value: 4) 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 <= 7 AND TEAM.DAY_LAST >= 7 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 = 7
, 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 <= 7)
LEFT JOIN SCORE ON SCORE.ID_PLAYER = TEAM_DAY.ID_PLAYER
AND SCORE.DAY = TEAM_DAY.DAY
-- AND SCORE.DAY <= 7
WHERE CLUB.ID_CLUB = PLAYER.ID_CLUB
AND TEAM.ID_PLAYER = PLAYER.ID_PLAYER
AND TEAM.ID_USER = 1381
AND TEAM.ID_LEAGUE = 5
GROUP BY PLAYER.ID_PLAYER, PLAYER.LNAME, PLAYER.POSITION, CLUB.NAME, TEAM_DAY_LAST.IS_VALID
ORDER BY 5 ASC, 11 DESC, 3 ASC