Error 1064. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND accounts.enabled = 1 AND users.enabled = 1 AND users.include_in_leaderb...' at line 9 SELECT DISTINCT IFNULL(scores.old_username, scores.new_username) AS username, scores.score AS total_score FROM (SELECT previous.username AS old_username, current.username AS new_username, previous.total_score AS old_score, current.current_score AS new_score, IFNULL(previous.total_score,0) + IFNULL(current.current_score,0) AS score FROM mutex LEFT OUTER JOIN (SELECT users.preferred_user_name AS username, total_score FROM users INNER JOIN user_accounts ON user_accounts.user_id = users.user_id INNER JOIN accounts ON user_accounts.account_id = accounts.account_id INNER JOIN puzzle_score_positions ON puzzle_score_positions.user_id = users.user_id WHERE total_score > 0 AND puzzle_score_positions.run_id = AND accounts.enabled = 1 AND users.enabled = 1 AND users.include_in_leaderboard = 1 AND puzzle_score_positions.puzzle_type_id = 2) AS previous ON i = 0 LEFT OUTER JOIN (SELECT SUM(points_awarded) AS current_score, user AS username FROM puzzle_play_statistics WHERE points_awarded > 0 AND puz_type = 2 GROUP BY user) AS current ON i = 1 or previous.username = current.username LEFT OUTER JOIN (SELECT users.preferred_user_name AS username, total_score from users INNER JOIN user_accounts ON user_accounts.user_id = users.user_id INNER JOIN accounts ON user_accounts.account_id = accounts.account_id INNER JOIN puzzle_score_positions ON puzzle_score_positions.user_id = users.user_id WHERE TOTAL_SCORE > 0 AND puzzle_score_positions.run_id = AND accounts.enabled = 1 AND users.enabled = 1 AND users.include_in_leaderboard = 1 AND puzzle_score_positions.puzzle_type_id = 2) AS p2 ON i = 1 AND p2.username = current.username WHERE current.username IS NULL OR p2.username IS NULL) AS scores WHERE scores.score > 0 ORDER BY total_score DESC

#	Player Username	Score
ERROR: Error 1064. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND accounts.enabled = 1 AND users.enabled = 1 AND users.include_in_leaderb...' at line 9 SELECT DISTINCT IFNULL(scores.old_username, scores.new_username) AS username, scores.score AS total_score FROM (SELECT previous.username AS old_username, current.username AS new_username, previous.total_score AS old_score, current.current_score AS new_score, IFNULL(previous.total_score,0) + IFNULL(current.current_score,0) AS score FROM mutex LEFT OUTER JOIN (SELECT users.preferred_user_name AS username, total_score FROM users INNER JOIN user_accounts ON user_accounts.user_id = users.user_id INNER JOIN accounts ON user_accounts.account_id = accounts.account_id INNER JOIN puzzle_score_positions ON puzzle_score_positions.user_id = users.user_id WHERE total_score > 0 AND puzzle_score_positions.run_id = AND accounts.enabled = 1 AND users.enabled = 1 AND users.include_in_leaderboard = 1 AND puzzle_score_positions.puzzle_type_id = 2) AS previous ON i = 0 LEFT OUTER JOIN (SELECT SUM(points_awarded) AS current_score, user AS username FROM puzzle_play_statistics WHERE points_awarded > 0 AND puz_type = 2 GROUP BY user) AS current ON i = 1 or previous.username = current.username LEFT OUTER JOIN (SELECT users.preferred_user_name AS username, total_score from users INNER JOIN user_accounts ON user_accounts.user_id = users.user_id INNER JOIN accounts ON user_accounts.account_id = accounts.account_id INNER JOIN puzzle_score_positions ON puzzle_score_positions.user_id = users.user_id WHERE TOTAL_SCORE > 0 AND puzzle_score_positions.run_id = AND accounts.enabled = 1 AND users.enabled = 1 AND users.include_in_leaderboard = 1 AND puzzle_score_positions.puzzle_type_id = 2) AS p2 ON i = 1 AND p2.username = current.username WHERE current.username IS NULL OR p2.username IS NULL) AS scores WHERE scores.score > 0 ORDER BY total_score DESC