17.88 ms
(43.34%)
|
33 |
SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name = ? AND t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1
Parameters: [
"Allsvenskan"
"SWE"
"2024"
"2015"
"2016"
"2017"
]
SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = 'Allsvenskan' AND c1_.area = 'SWE') WHERE t0_.name = '2024' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
13.38 ms
(32.43%)
|
17 |
SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC
Parameters: [
"Allsvenskan"
"SWE"
"2015"
"2016"
"2017"
]
SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = 'Allsvenskan' AND c1_.area = 'SWE') INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC;
|
0.78 ms
(1.89%)
|
1 |
SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttat01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.position ASC
SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttat01 v0_ WHERE v0_.tournament_id = 6 ORDER BY v0_.position ASC;
|
0.76 ms
(1.84%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.passes AS passes_4, v0_.long_passes AS long_passes_5, v0_.through_balls AS through_balls_6, v0_.long_passes_through_balls AS long_passes_through_balls_7, v0_.long_passes_through_balls90 AS long_passes_through_balls90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttlpgs01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.long_passes_through_balls90 DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.long_passes DESC, v0_.through_balls DESC, v0_.long_passes_through_balls DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.passes AS passes_4, v0_.long_passes AS long_passes_5, v0_.through_balls AS through_balls_6, v0_.long_passes_through_balls AS long_passes_through_balls_7, v0_.long_passes_through_balls90 AS long_passes_through_balls90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttlpgs01 v0_ WHERE v0_.tournament_id = 6 ORDER BY v0_.long_passes_through_balls90 DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.long_passes DESC, v0_.through_balls DESC, v0_.long_passes_through_balls DESC, v0_.team ASC;
|
0.66 ms
(1.60%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.accelerations AS accelerations_4, v0_.progressive_run AS progressive_run_5, v0_.accelerations90 AS accelerations90_6, v0_.progressive_run90 AS progressive_run90_7, v0_.tournament_id AS tournament_id_8 FROM view_ttamub01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.progressive_run90 DESC, v0_.accelerations90 DESC, v0_.matches_played DESC, v0_.accelerations DESC, v0_.progressive_run DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.accelerations AS accelerations_4, v0_.progressive_run AS progressive_run_5, v0_.accelerations90 AS accelerations90_6, v0_.progressive_run90 AS progressive_run90_7, v0_.tournament_id AS tournament_id_8 FROM view_ttamub01 v0_ WHERE v0_.tournament_id = 6 ORDER BY v0_.progressive_run90 DESC, v0_.accelerations90 DESC, v0_.matches_played DESC, v0_.accelerations DESC, v0_.progressive_run DESC, v0_.team ASC;
|
0.64 ms
(1.55%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.passes AS passes_4, v0_.key_passes AS key_passes_5, v0_.key_passes90 AS key_passes90_6, v0_.tournament_id AS tournament_id_7 FROM view_ttnp01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.key_passes90 DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.key_passes DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.passes AS passes_4, v0_.key_passes AS key_passes_5, v0_.key_passes90 AS key_passes90_6, v0_.tournament_id AS tournament_id_7 FROM view_ttnp01 v0_ WHERE v0_.tournament_id = 6 ORDER BY v0_.key_passes90 DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.key_passes DESC, v0_.team ASC;
|
0.62 ms
(1.50%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.penalties AS penalties_4, v0_.penalties_goals AS penalties_goals_5, v0_.penalties_against AS penalties_against_6, v0_.penalties_goals_against AS penalties_goals_against_7, v0_.tournament_id AS tournament_id_8 FROM view_tts01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.penalties DESC, v0_.matches_played DESC, v0_.penalties_goals DESC, v0_.penalties_against DESC, v0_.penalties_goals_against DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.penalties AS penalties_4, v0_.penalties_goals AS penalties_goals_5, v0_.penalties_against AS penalties_against_6, v0_.penalties_goals_against AS penalties_goals_against_7, v0_.tournament_id AS tournament_id_8 FROM view_tts01 v0_ WHERE v0_.tournament_id = 6 ORDER BY v0_.penalties DESC, v0_.matches_played DESC, v0_.penalties_goals DESC, v0_.penalties_against DESC, v0_.penalties_goals_against DESC, v0_.team ASC;
|
0.61 ms
(1.49%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.yellow_cards AS yellow_cards_4, v0_.red_cards AS red_cards_5, v0_.yellow_cards90 AS yellow_cards90_6, v0_.tournament_id AS tournament_id_7 FROM view_ttgrk01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.yellow_cards90 DESC, v0_.matches_played DESC, v0_.yellow_cards DESC, v0_.red_cards DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.yellow_cards AS yellow_cards_4, v0_.red_cards AS red_cards_5, v0_.yellow_cards90 AS yellow_cards90_6, v0_.tournament_id AS tournament_id_7 FROM view_ttgrk01 v0_ WHERE v0_.tournament_id = 6 ORDER BY v0_.yellow_cards90 DESC, v0_.matches_played DESC, v0_.yellow_cards DESC, v0_.red_cards DESC, v0_.team ASC;
|
0.59 ms
(1.43%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.games_matches AS games_matches_3, v0_.won AS won_4, v0_.tied_draw AS tied_draw_5, v0_.lost AS lost_6, v0_.goals_scored AS goals_scored_7, v0_.goals_conceded AS goals_conceded_8, v0_.points AS points_9, v0_.ordinary_position AS ordinary_position_10, v0_.tournament_id AS tournament_id_11 FROM view_ttatxg01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.won DESC, v0_.goals_scored ASC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.games_matches AS games_matches_3, v0_.won AS won_4, v0_.tied_draw AS tied_draw_5, v0_.lost AS lost_6, v0_.goals_scored AS goals_scored_7, v0_.goals_conceded AS goals_conceded_8, v0_.points AS points_9, v0_.ordinary_position AS ordinary_position_10, v0_.tournament_id AS tournament_id_11 FROM view_ttatxg01 v0_ WHERE v0_.tournament_id = 6 ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.won DESC, v0_.goals_scored ASC, v0_.team ASC;
|
0.58 ms
(1.41%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.clean_sheets AS clean_sheets_3, v0_.goals_conceded AS goals_conceded_4, v0_.chances_created_against AS chances_created_against_5, v0_.matches_played AS matches_played_6, v0_.shots_against AS shots_against_7, v0_.chanses90 AS chanses90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttds01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.chanses90 ASC, v0_.matches_played DESC, v0_.goals_conceded DESC, v0_.clean_sheets DESC, v0_.shots_against DESC, v0_.chances_created_against DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.clean_sheets AS clean_sheets_3, v0_.goals_conceded AS goals_conceded_4, v0_.chances_created_against AS chances_created_against_5, v0_.matches_played AS matches_played_6, v0_.shots_against AS shots_against_7, v0_.chanses90 AS chanses90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttds01 v0_ WHERE v0_.tournament_id = 6 ORDER BY v0_.chanses90 ASC, v0_.matches_played DESC, v0_.goals_conceded DESC, v0_.clean_sheets DESC, v0_.shots_against DESC, v0_.chances_created_against DESC, v0_.team ASC;
|
0.57 ms
(1.39%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.goals AS goals_3, v0_.x_g AS x_g_4, v0_.matches_played AS matches_played_5, v0_.goals_scored AS goals_scored_6, v0_.set_pieces AS set_pieces_7, v0_.tournament_id AS tournament_id_8 FROM view_ttfs01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.goals DESC, v0_.matches_played DESC, v0_.goals_scored DESC, v0_.set_pieces DESC, v0_.x_g DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.goals AS goals_3, v0_.x_g AS x_g_4, v0_.matches_played AS matches_played_5, v0_.goals_scored AS goals_scored_6, v0_.set_pieces AS set_pieces_7, v0_.tournament_id AS tournament_id_8 FROM view_ttfs01 v0_ WHERE v0_.tournament_id = 6 ORDER BY v0_.goals DESC, v0_.matches_played DESC, v0_.goals_scored DESC, v0_.set_pieces DESC, v0_.x_g DESC, v0_.team ASC;
|
0.57 ms
(1.39%)
|
1 |
SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttaht01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.games_matches DESC, v0_.won DESC, v0_.tied_draw DESC, v0_.lost DESC, v0_.goals_conceded DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttaht01 v0_ WHERE v0_.tournament_id = 6 ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.games_matches DESC, v0_.won DESC, v0_.tied_draw DESC, v0_.lost DESC, v0_.goals_conceded DESC, v0_.team ASC;
|
0.54 ms
(1.30%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.goals_scored AS goals_scored_4, v0_.shots AS shots_5, v0_.shots_on_goal AS shots_on_goal_6, v0_.shots_on_goal90 AS shots_on_goal90_7, v0_.tournament_id AS tournament_id_8 FROM view_ttspm01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.shots_on_goal90 DESC, v0_.matches_played DESC, v0_.goals_scored DESC, v0_.shots DESC, v0_.shots_on_goal DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.goals_scored AS goals_scored_4, v0_.shots AS shots_5, v0_.shots_on_goal AS shots_on_goal_6, v0_.shots_on_goal90 AS shots_on_goal90_7, v0_.tournament_id AS tournament_id_8 FROM view_ttspm01 v0_ WHERE v0_.tournament_id = 6 ORDER BY v0_.shots_on_goal90 DESC, v0_.matches_played DESC, v0_.goals_scored DESC, v0_.shots DESC, v0_.shots_on_goal DESC, v0_.team ASC;
|
0.53 ms
(1.27%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.goals AS goals_3, v0_.shots AS shots_4, v0_.goals_per_shot AS goals_per_shot_5, v0_.matches_played AS matches_played_6, v0_.shots_on_goal AS shots_on_goal_7, v0_.tournament_id AS tournament_id_8 FROM view_ttkg01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.goals_per_shot DESC, v0_.matches_played DESC, v0_.goals DESC, v0_.shots DESC, v0_.shots_on_goal DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.goals AS goals_3, v0_.shots AS shots_4, v0_.goals_per_shot AS goals_per_shot_5, v0_.matches_played AS matches_played_6, v0_.shots_on_goal AS shots_on_goal_7, v0_.tournament_id AS tournament_id_8 FROM view_ttkg01 v0_ WHERE v0_.tournament_id = 6 ORDER BY v0_.goals_per_shot DESC, v0_.matches_played DESC, v0_.goals DESC, v0_.shots DESC, v0_.shots_on_goal DESC, v0_.team ASC;
|
0.52 ms
(1.26%)
|
1 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.area AS area_4 FROM competition t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.area AS area_4 FROM competition t0 WHERE t0.id = 1;
|
0.52 ms
(1.26%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.chances_created AS chances_created_3, v0_.matches_played AS matches_played_4, v0_.goals_scored AS goals_scored_5, v0_.goals_concieved AS goals_concieved_6, v0_.chances_created_against AS chances_created_against_7, v0_.chanses90 AS chanses90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttsm01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.chanses90 DESC, v0_.matches_played DESC, v0_.goals_scored DESC, v0_.chances_created DESC, v0_.goals_concieved DESC, v0_.chances_created_against DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.chances_created AS chances_created_3, v0_.matches_played AS matches_played_4, v0_.goals_scored AS goals_scored_5, v0_.goals_concieved AS goals_concieved_6, v0_.chances_created_against AS chances_created_against_7, v0_.chanses90 AS chanses90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttsm01 v0_ WHERE v0_.tournament_id = 6 ORDER BY v0_.chanses90 DESC, v0_.matches_played DESC, v0_.goals_scored DESC, v0_.chances_created DESC, v0_.goals_concieved DESC, v0_.chances_created_against DESC, v0_.team ASC;
|
0.52 ms
(1.26%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.passes AS passes_4, v0_.smart_passes AS smart_passes_5, v0_.progressive_passes AS progressive_passes_6, v0_.smart_progressive_passes AS smart_progressive_passes_7, v0_.smart_progressive_passes90 AS smart_progressive_passes90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttspp01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.smart_progressive_passes90 DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.smart_passes DESC, v0_.progressive_passes DESC, v0_.smart_progressive_passes DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.passes AS passes_4, v0_.smart_passes AS smart_passes_5, v0_.progressive_passes AS progressive_passes_6, v0_.smart_progressive_passes AS smart_progressive_passes_7, v0_.smart_progressive_passes90 AS smart_progressive_passes90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttspp01 v0_ WHERE v0_.tournament_id = 6 ORDER BY v0_.smart_progressive_passes90 DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.smart_passes DESC, v0_.progressive_passes DESC, v0_.smart_progressive_passes DESC, v0_.team ASC;
|
0.50 ms
(1.21%)
|
1 |
SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttabt01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.games_matches DESC, v0_.won DESC, v0_.tied_draw DESC, v0_.lost DESC, v0_.goals_conceded DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttabt01 v0_ WHERE v0_.tournament_id = 6 ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.games_matches DESC, v0_.won DESC, v0_.tied_draw DESC, v0_.lost DESC, v0_.goals_conceded DESC, v0_.team ASC;
|
0.49 ms
(1.18%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.passes AS passes_3, v0_.successfull_passes AS successfull_passes_4, v0_.pass_percentage AS pass_percentage_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttppp01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.pass_percentage DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.successfull_passes DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.passes AS passes_3, v0_.successfull_passes AS successfull_passes_4, v0_.pass_percentage AS pass_percentage_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttppp01 v0_ WHERE v0_.tournament_id = 6 ORDER BY v0_.pass_percentage DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.successfull_passes DESC, v0_.team ASC;
|