| Player Name | Rating | First Place Finishes | Last Event | Highest Badges |
Error: Unknown column 'u.t®ion' in 'where clause' Query = SELECT * FROM cc_user_data u LEFT JOIN (SELECT u.user_id AS world_user, MAX(u.url) AS world_url, MAX(u.alttext) AS world_alt FROM cc_user_badges u RIGHT JOIN (SELECT u.user_id, MAX(u.year) AS maxyear, tmp.minvar FROM cc_user_badges u RIGHT JOIN (SELECT u.user_id, MIN(variable1) AS minvar FROM cc_user_badges u LEFT JOIN cc_tournament t ON u.event=t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE u.badgetype='world' AND t.status='Completed' AND t.edition='2E' GROUP BY user_id) tmp ON u.user_id=tmp.user_id AND u.variable1=tmp.minvar LEFT JOIN cc_tournament t ON u.event=t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE u.badgetype='world' AND t.status='Completed' AND t.edition='2E' GROUP BY user_id) tmp ON u.user_id=tmp.user_id AND u.variable1=tmp.minvar AND u.year=tmp.maxyear LEFT JOIN cc_tournament t ON u.event=t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE u.badgetype='world' AND t.status='Completed' AND t.edition='2E' GROUP BY u.user_id) world ON world.world_user=u.user_id LEFT JOIN (SELECT u.user_id AS cont_user, MAX(u.url) AS cont_url, MAX(u.alttext) AS cont_alt FROM cc_user_badges u RIGHT JOIN (SELECT u.user_id, MAX(u.year) AS maxyear, tmp.minvar FROM cc_user_badges u RIGHT JOIN (SELECT user_id, MIN(variable1) AS minvar FROM cc_user_badges u LEFT JOIN cc_tournament t ON u.event=t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE u.badgetype='continental' AND t.status='Completed' AND t.edition='2E' GROUP BY user_id) tmp ON u.user_id=tmp.user_id AND u.variable1=tmp.minvar LEFT JOIN cc_tournament t ON u.event=t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE u.badgetype='continental' AND t.status='Completed' AND t.edition='2E' GROUP BY user_id) tmp ON u.user_id=tmp.user_id AND u.variable1=tmp.minvar AND u.year=tmp.maxyear LEFT JOIN cc_tournament t ON u.event=t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE u.badgetype='continental' AND t.status='Completed' AND t.edition='2E' GROUP BY u.user_id) cont ON cont.cont_user=u.user_id LEFT JOIN (SELECT u.user_id AS nation_user, MAX(u.url) AS nation_url, MAX(u.alttext) AS nation_alt FROM cc_user_badges u RIGHT JOIN (SELECT u.user_id, MAX(u.year) AS maxyear, tmp.minvar FROM cc_user_badges u RIGHT JOIN (SELECT user_id, MIN(variable1) AS minvar FROM cc_user_badges u LEFT JOIN cc_tournament t ON u.event=t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE u.badgetype='national' AND t.status='Completed' AND t.edition='2E' GROUP BY user_id) tmp ON u.user_id=tmp.user_id AND u.variable1=tmp.minvar LEFT JOIN cc_tournament t ON u.event=t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE u.badgetype='national' AND t.status='Completed' AND t.edition='2E' GROUP BY user_id) tmp ON u.user_id=tmp.user_id AND u.variable1=tmp.minvar AND u.year=tmp.maxyear LEFT JOIN cc_tournament t ON u.event=t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE u.badgetype='national' AND t.status='Completed' AND t.edition='2E' GROUP BY u.user_id) nation ON nation.nation_user=u.user_id LEFT JOIN (SELECT u.user_id AS masters_user, MAX(u.url) AS masters_url, MAX(u.alttext) AS masters_alt FROM cc_user_badges u RIGHT JOIN (SELECT u.user_id, MAX(u.year) AS maxyear, tmp.minvar FROM cc_user_badges u RIGHT JOIN (SELECT user_id, MIN(variable1) AS minvar FROM cc_user_badges u LEFT JOIN cc_tournament t ON u.event=t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE u.badgetype='masters' AND t.status='Completed' AND t.edition='2E' GROUP BY user_id) tmp ON u.user_id=tmp.user_id AND u.variable1=tmp.minvar LEFT JOIN cc_tournament t ON u.event=t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE u.badgetype='masters' AND t.status='Completed' AND t.edition='2E' GROUP BY user_id) tmp ON u.user_id=tmp.user_id AND u.variable1=tmp.minvar AND u.year=tmp.maxyear LEFT JOIN cc_tournament t ON u.event=t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE u.badgetype='masters' AND t.status='Completed' AND t.edition='2E' GROUP BY u.user_id) masters ON masters.masters_user=u.user_id LEFT JOIN (SELECT u.user_id AS region_user, MAX(u.url) AS region_url, MAX(u.alttext) AS region_alt FROM cc_user_badges u RIGHT JOIN (SELECT u.user_id, MAX(u.year) AS maxyear, tmp.minvar FROM cc_user_badges u RIGHT JOIN (SELECT user_id, MIN(variable1) AS minvar FROM cc_user_badges u LEFT JOIN cc_tournament t ON u.event=t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE u.badgetype='regional' AND t.status='Completed' AND t.edition='2E' GROUP BY user_id) tmp ON u.user_id=tmp.user_id AND u.variable1=tmp.minvar LEFT JOIN cc_tournament t ON u.event=t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE u.badgetype='regional' AND t.status='Completed' AND t.edition='2E' GROUP BY user_id) tmp ON u.user_id=tmp.user_id AND u.variable1=tmp.minvar AND u.year=tmp.maxyear LEFT JOIN cc_tournament t ON u.event=t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE u.badgetype='regional' AND t.status='Completed' AND t.edition='2E' GROUP BY u.user_id) region ON region.region_user=u.user_id LEFT JOIN (SELECT p.player_id, COUNT(*) AS totalcount FROM cc_tournament_players p LEFT JOIN cc_tournament t ON p.tournament_id=t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE t.status='Completed' AND t.edition='2E' GROUP BY player_id) tcount ON u.user_id=tcount.player_id LEFT JOIN (SELECT p.player_id, COUNT(*) AS firstcount FROM cc_tournament_players p LEFT JOIN cc_tournament t ON p.tournament_id=t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE p.rank=1 AND t.status='Completed' AND t.edition='2E' GROUP BY player_id) fcount ON u.user_id=fcount.player_id LEFT JOIN (SELECT p.player_id, MAX(t.datetime) AS lastgame FROM cc_tournament_players p LEFT JOIN cc_tournament t ON p.tournament_id = t.tournament_id LEFT JOIN cc_format f ON t.format_id=f.format_id WHERE t.status='Completed' AND t.edition='2E' GROUP BY player_id) lastgame ON u.user_id=lastgame.player_id WHERE 1=1 AND u.t®ion=10rank != 0 ORDER BY t®ion=10rating DESC
|