Puzzledrome

April’s Puzzledrome Leaderboards

valid

Puzzledrome Leaderboards for April 2024

< Leaderboards for March 2024

PD

This Month’s Overall Leaderboard

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
#Player UsernameScore #Player UsernameScore
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_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
XQ

Quick Crossword Leaderboard

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
#Player UsernameScore
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 = 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

SE

Sudoku Easy Leaderboard

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 UsernameScore
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

Play Sudoku Easy

XC

Cryptic Crossword Leaderboard

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
#Player UsernameScore
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 = 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

SM

Sudoku Medium Leaderboard

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
#Player UsernameScore
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 = 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

XG

Giant Cryptic Crossword Leaderboard

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
#Player UsernameScore
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 = 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

SH

Sudoku Hard Leaderboard

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
#Player UsernameScore
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 = 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

NG

Nonagram Leaderboard

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
#Player UsernameScore
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 = 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

EQ

Equaliser Leaderboard

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
#Player UsernameScore
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 = 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

DC

Dialling Codes Leaderboard