April’s Puzzledrome Leaderboards
valid
Puzzledrome Leaderboards for April 2024
< Leaderboards for March 2024
// }
?>
This Month’s Overall Leaderboard
# | Player Username | Score | | # | Player Username | Score |
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_leaderboa...' 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 puzzle_type_id is null AND total_score > 0 AND puzzle_score_positions.run_id = AND accounts.enabled = 1 AND users.enabled = 1 AND users.include_in_leaderboard = 1) 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 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 puzzle_type_id is null AND total_score > 0 AND puzzle_score_positions.run_id = AND accounts.enabled = 1 AND users.enabled = 1 AND users.include_in_leaderboard = 1) AS p2 ON i = 1 AND p2.username = current.username
where current.username IS NULL OR p2.username IS NULL) AS scores
ORDER BY total_score DESCERROR: 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_leaderboa...' 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 puzzle_type_id is null AND total_score > 0 AND puzzle_score_positions.run_id = AND accounts.enabled = 1 AND users.enabled = 1 AND users.include_in_leaderboard = 1) 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 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 puzzle_type_id is null AND total_score > 0 AND puzzle_score_positions.run_id = AND accounts.enabled = 1 AND users.enabled = 1 AND users.include_in_leaderboard = 1) AS p2 ON i = 1 AND p2.username = current.username
where current.username IS NULL OR p2.username IS NULL) AS scores
ORDER BY total_score DESC |
Quick Crossword Leaderboard
# | Player Username | Score |
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 = 7)
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 = 7 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 = 7)
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 DESCERROR: 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 = 7)
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 = 7 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 = 7)
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 |
Play Quick Crossword
Sudoku Easy Leaderboard
# | Player Username | Score |
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 DESCERROR: 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 |
Play Sudoku Easy
Cryptic Crossword Leaderboard
# | Player Username | Score |
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 = 10)
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 = 10 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 = 10)
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 DESCERROR: 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 = 10)
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 = 10 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 = 10)
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 |
Play Cryptic Crossword
Sudoku Medium Leaderboard
# | Player Username | Score |
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 = 8)
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 = 8 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 = 8)
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 DESCERROR: 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 = 8)
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 = 8 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 = 8)
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 |
Play Sudoku Medium
Giant Cryptic Crossword Leaderboard
# | Player Username | Score |
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 = 12)
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 = 12 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 = 12)
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 DESCERROR: 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 = 12)
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 = 12 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 = 12)
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 |
Play Giant Crossword
Sudoku Hard Leaderboard
# | Player Username | Score |
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 = 9)
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 = 9 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 = 9)
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 DESCERROR: 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 = 9)
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 = 9 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 = 9)
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 |
Play Sudoku Hard
Nonagram Leaderboard
# | Player Username | Score |
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 = 1)
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 = 1 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 = 1)
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 DESCERROR: 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 = 1)
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 = 1 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 = 1)
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 |
Play Nonagram
Equaliser Leaderboard
# | Player Username | Score |
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 = 6)
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 = 6 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 = 6)
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 DESCERROR: 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 = 6)
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 = 6 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 = 6)
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 |
Play Equaliser
Dialling Codes Leaderboard