FRC Tracker 2018

FRC 2020 - High Scores The tables below show various high score achievements from the season. SQL query failed: [ERROR: relation "match_2020" does not exist LINE 13: event,match_2020, ^] SELECT sq_match.score, sq_match.pts_foul, CASE WHEN match_2020.type = 2 THEN 'Q' WHEN match_2020.type = 3 THEN 'P' ELSE 'Unknown' END || '-' || match_2020.number AS match, sq_match.alliance, regexp_replace(event.name, '^FIRST Championship - ', '') AS event, event.region AS region, sq_match.team1, sq_match.team2, sq_match.team3 FROM event,match_2020, ((SELECT 'red' AS alliance, match.id AS id_match, match.date_create AS date, match.pts_foul_red AS pts_foul, match.score_red AS score, match_team1.num_team AS team1, match_team2.num_team AS team2, match_team3.num_team AS team3 FROM match_2020 AS match, match_team_2020 AS match_team1, match_team_2020 AS match_team2, match_team_2020 AS match_team3 WHERE match_team1.id_match = match.id AND match_team1.position = 1 AND match_team2.id_match = match.id AND match_team2.position = 2 AND match_team3.id_match = match.id AND match_team3.position = 3 ORDER BY match.score_red DESC LIMIT 25) UNION (SELECT 'blue' AS alliance, match.id AS id_match, match.date_create AS date, match.score_blue AS score, match.pts_foul_blue AS pts_foul, match_team1.num_team AS team1, match_team2.num_team AS team2, match_team3.num_team AS team3 FROM match_2020 AS match, match_team_2020 AS match_team1, match_team_2020 AS match_team2, match_team_2020 AS match_team3 WHERE match_team1.id_match = match.id AND match_team1.position = 4 AND match_team2.id_match = match.id AND match_team2.position = 5 AND match_team3.id_match = match.id AND match_team3.position = 6 ORDER BY match.score_blue DESC LIMIT 25 )) AS sq_match WHERE match_2020.id=sq_match.id_match AND event.id = match_2020.id_event ORDER BY sq_match.score DESC, sq_match.pts_foul, sq_match.date LIMIT 25 SELECT sq_match.score, sq_match.pts_foul, CASE WHEN match_2020.type = 2 THEN 'Q' WHEN match_2020.type = 3 THEN 'P' ELSE 'Unknown' END || '-' || match_2020.number AS match, sq_match.alliance, regexp_replace(event.name, '^FIRST Championship - ', '') AS event, event.region AS region, sq_match.team1, sq_match.team2, sq_match.team3 FROM event,match_2020, ((SELECT 'red' AS alliance, match.id AS id_match, match.date_create AS date, match.pts_foul_red AS pts_foul, match.score_red AS score, match_team1.num_team AS team1, match_team2.num_team AS team2, match_team3.num_team AS team3 FROM match_2020 AS match, match_team_2020 AS match_team1, match_team_2020 AS match_team2, match_team_2020 AS match_team3 WHERE match_team1.id_match = match.id AND match_team1.position = 1 AND match_team2.id_match = match.id AND match_team2.position = 2 AND match_team3.id_match = match.id AND match_team3.position = 3 ORDER BY match.score_red DESC LIMIT 25) UNION (SELECT 'blue' AS alliance, match.id AS id_match, match.date_create AS date, match.score_blue AS score, match.pts_foul_blue AS pts_foul, match_team1.num_team AS team1, match_team2.num_team AS team2, match_team3.num_team AS team3 FROM match_2020 AS match, match_team_2020 AS match_team1, match_team_2020 AS match_team2, match_team_2020 AS match_team3 WHERE match_team1.id_match = match.id AND match_team1.position = 4 AND match_team2.id_match = match.id AND match_team2.position = 5 AND match_team3.id_match = match.id AND match_team3.position = 6 ORDER BY match.score_blue DESC LIMIT 25 )) AS sq_match WHERE match_2020.id=sq_match.id_match AND event.id = match_2020.id_event ORDER BY sq_match.score DESC, sq_match.pts_foul, sq_match.date LIMIT 25 SQL query failed: [ERROR: relation "match_2020" does not exist LINE 12: event,match_2020, ^] SELECT sq_match.score_nofoul, CASE WHEN match_2020.type = 2 THEN 'Q' WHEN match_2020.type = 3 THEN 'P' ELSE 'Unknown' END || '-' || match_2020.number AS match, sq_match.alliance, regexp_replace(event.name, '^FIRST Championship - ', '') AS event, event.region AS region, sq_match.team1, sq_match.team2, sq_match.team3 FROM event,match_2020, ((SELECT 'red' AS alliance, match.id AS id_match, match.date_create AS date, match.score_red - match.pts_foul_red AS score_nofoul, match_team1.num_team AS team1, match_team2.num_team AS team2, match_team3.num_team AS team3 FROM match_2020 AS match, match_team_2020 AS match_team1, match_team_2020 AS match_team2, match_team_2020 AS match_team3 WHERE match_team1.id_match = match.id AND match_team1.position = 1 AND match_team2.id_match = match.id AND match_team2.position = 2 AND match_team3.id_match = match.id AND match_team3.position = 3 ORDER BY match.score_red - match.pts_foul_red DESC LIMIT 25) UNION (SELECT 'blue' AS alliance, match.id AS id_match, match.date_create AS date, match.score_blue - match.pts_foul_blue AS score_nofoul, match_team1.num_team AS team1, match_team2.num_team AS team2, match_team3.num_team AS team3 FROM match_2020 AS match, match_team_2020 AS match_team1, match_team_2020 AS match_team2, match_team_2020 AS match_team3 WHERE match_team1.id_match = match.id AND match_team1.position = 4 AND match_team2.id_match = match.id AND match_team2.position = 5 AND match_team3.id_match = match.id AND match_team3.position = 6 ORDER BY match.score_blue - match.pts_foul_blue DESC LIMIT 25 )) AS sq_match WHERE match_2020.id=sq_match.id_match AND event.id = match_2020.id_event ORDER BY sq_match.score_nofoul DESC, sq_match.date LIMIT 25 SELECT sq_match.score_nofoul, CASE WHEN match_2020.type = 2 THEN 'Q' WHEN match_2020.type = 3 THEN 'P' ELSE 'Unknown' END || '-' || match_2020.number AS match, sq_match.alliance, regexp_replace(event.name, '^FIRST Championship - ', '') AS event, event.region AS region, sq_match.team1, sq_match.team2, sq_match.team3 FROM event,match_2020, ((SELECT 'red' AS alliance, match.id AS id_match, match.date_create AS date, match.score_red - match.pts_foul_red AS score_nofoul, match_team1.num_team AS team1, match_team2.num_team AS team2, match_team3.num_team AS team3 FROM match_2020 AS match, match_team_2020 AS match_team1, match_team_2020 AS match_team2, match_team_2020 AS match_team3 WHERE match_team1.id_match = match.id AND match_team1.position = 1 AND match_team2.id_match = match.id AND match_team2.position = 2 AND match_team3.id_match = match.id AND match_team3.position = 3 ORDER BY match.score_red - match.pts_foul_red DESC LIMIT 25) UNION (SELECT 'blue' AS alliance, match.id AS id_match, match.date_create AS date, match.score_blue - match.pts_foul_blue AS score_nofoul, match_team1.num_team AS team1, match_team2.num_team AS team2, match_team3.num_team AS team3 FROM match_2020 AS match, match_team_2020 AS match_team1, match_team_2020 AS match_team2, match_team_2020 AS match_team3 WHERE match_team1.id_match = match.id AND match_team1.position = 4 AND match_team2.id_match = match.id AND match_team2.position = 5 AND match_team3.id_match = match.id AND match_team3.position = 6 ORDER BY match.score_blue - match.pts_foul_blue DESC LIMIT 25 )) AS sq_match WHERE match_2020.id=sq_match.id_match AND event.id = match_2020.id_event ORDER BY sq_match.score_nofoul DESC, sq_match.date LIMIT 25 FRC Tracker Home © 2009-2018, Idle Loop Software Design, LLC