| 1 |
1.03 ms |
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;
|
| 2 |
1.28 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 3 |
0.41 ms |
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;
|
| 4 |
0.91 ms |
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;
|
| 5 |
0.62 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 6 |
0.52 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 7 |
0.52 ms |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.player_goals AS player_goals_5, v0_.assists AS assists_6, v0_.points AS points_7, v0_.matches_played AS matches_played_8, v0_.minutes_played AS minutes_played_9, v0_.min_minutes_played AS min_minutes_played_10, v0_.points90 AS points90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpmap01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.points DESC, v0_.points90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.player_goals DESC, v0_.assists DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.player_goals AS player_goals_5, v0_.assists AS assists_6, v0_.points AS points_7, v0_.matches_played AS matches_played_8, v0_.minutes_played AS minutes_played_9, v0_.min_minutes_played AS min_minutes_played_10, v0_.points90 AS points90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpmap01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 10 ORDER BY v0_.points DESC, v0_.points90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.player_goals DESC, v0_.assists DESC, v0_.player ASC LIMIT 20;
|
| 8 |
0.83 ms |
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;
|
| 9 |
0.57 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 10 |
0.51 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 11 |
0.55 ms |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.matches_played AS matches_played_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.expected_goals AS expected_goals_9, v0_.expected_assists AS expected_assists_10, v0_.expected_points AS expected_points_11, v0_.expected_points90 AS expected_points90_12, v0_.tournament_id AS tournament_id_13 FROM view_tpxgxaxp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.expected_points90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_goals DESC, v0_.expected_assists DESC, v0_.expected_points DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.matches_played AS matches_played_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.expected_goals AS expected_goals_9, v0_.expected_assists AS expected_assists_10, v0_.expected_points AS expected_points_11, v0_.expected_points90 AS expected_points90_12, v0_.tournament_id AS tournament_id_13 FROM view_tpxgxaxp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 10 ORDER BY v0_.expected_points90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_goals DESC, v0_.expected_assists DESC, v0_.expected_points DESC, v0_.player ASC LIMIT 20;
|
| 12 |
0.73 ms |
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;
|
| 13 |
0.57 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 14 |
0.48 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 15 |
0.50 ms |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.goals_scored AS goals_scored_8, v0_.expected_goals AS expected_goals_9, v0_.ordinary_position AS ordinary_position_10, v0_.expected_goals90 AS expected_goals90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpmxg01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.goals_scored DESC, v0_.expected_goals90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_goals DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.goals_scored AS goals_scored_8, v0_.expected_goals AS expected_goals_9, v0_.ordinary_position AS ordinary_position_10, v0_.expected_goals90 AS expected_goals90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpmxg01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 10 ORDER BY v0_.goals_scored DESC, v0_.expected_goals90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_goals DESC, v0_.player ASC LIMIT 20;
|
| 16 |
0.68 ms |
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;
|
| 17 |
0.66 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 18 |
0.50 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 19 |
0.49 ms |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.assists AS assists_8, v0_.expected_assists AS expected_assists_9, v0_.ordinary_position AS ordinary_position_10, v0_.expected_assists90 AS expected_assists90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpaxa01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.assists DESC, v0_.expected_assists90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_assists DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.assists AS assists_8, v0_.expected_assists AS expected_assists_9, v0_.ordinary_position AS ordinary_position_10, v0_.expected_assists90 AS expected_assists90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpaxa01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 10 ORDER BY v0_.assists DESC, v0_.expected_assists90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_assists DESC, v0_.player ASC LIMIT 20;
|
| 20 |
0.74 ms |
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;
|
| 21 |
0.53 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 22 |
0.46 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 23 |
0.49 ms |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.expected_points AS expected_points_5, v0_.ordinary_position AS ordinary_position_6, v0_.matches_played AS matches_played_7, v0_.minutes_played AS minutes_played_8, v0_.min_minutes_played AS min_minutes_played_9, v0_.points AS points_10, v0_.expected_points90 AS expected_points90_11, v0_.tournament_id AS tournament_id_12 FROM view_tppxp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.expected_points DESC, v0_.expected_points90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.points DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.expected_points AS expected_points_5, v0_.ordinary_position AS ordinary_position_6, v0_.matches_played AS matches_played_7, v0_.minutes_played AS minutes_played_8, v0_.min_minutes_played AS min_minutes_played_9, v0_.points AS points_10, v0_.expected_points90 AS expected_points90_11, v0_.tournament_id AS tournament_id_12 FROM view_tppxp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 10 ORDER BY v0_.expected_points DESC, v0_.expected_points90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.points DESC, v0_.player ASC LIMIT 20;
|
| 24 |
0.69 ms |
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;
|
| 25 |
0.55 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 26 |
0.49 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 27 |
0.57 ms |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.chances_created AS chances_created_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.chanses90 AS chanses90_9, v0_.tournament_id AS tournament_id_10 FROM view_tpsc01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.chanses90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.chances_created DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.chances_created AS chances_created_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.chanses90 AS chanses90_9, v0_.tournament_id AS tournament_id_10 FROM view_tpsc01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 10 ORDER BY v0_.chanses90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.chances_created DESC, v0_.player ASC LIMIT 20;
|
| 28 |
0.74 ms |
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;
|
| 29 |
0.52 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 30 |
0.64 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 31 |
0.52 ms |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.goals_scored AS goals_scored_5, v0_.matches_played AS matches_played_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.chances_created AS chances_created_9, v0_.goals_chances_created AS goals_chances_created_10, v0_.tournament_id AS tournament_id_11 FROM view_tpkg01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND (NOT (v0_.chances_created <= 2 OR v0_.goals_scored <= 1)) AND v0_.tournament_id = ? ORDER BY v0_.goals_chances_created DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.goals_scored DESC, v0_.chances_created DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.goals_scored AS goals_scored_5, v0_.matches_played AS matches_played_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.chances_created AS chances_created_9, v0_.goals_chances_created AS goals_chances_created_10, v0_.tournament_id AS tournament_id_11 FROM view_tpkg01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND (NOT (v0_.chances_created <= 2 OR v0_.goals_scored <= 1)) AND v0_.tournament_id = 10 ORDER BY v0_.goals_chances_created DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.goals_scored DESC, v0_.chances_created DESC, v0_.player ASC LIMIT 20;
|
| 32 |
0.66 ms |
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;
|
| 33 |
0.52 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 34 |
0.47 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 35 |
0.54 ms |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.passes AS passes_5, v0_.successfull_passes AS successfull_passes_6, v0_.pass_percentage AS pass_percentage_7, v0_.matches_played AS matches_played_8, v0_.minutes_played AS minutes_played_9, v0_.min_minutes_played AS min_minutes_played_10, v0_.role_code2 AS role_code2_11, v0_.tournament_id AS tournament_id_12 FROM view_tpppp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.role_code2 NOT IN ('GK') AND v0_.tournament_id = ? ORDER BY v0_.pass_percentage DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.successfull_passes DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.passes AS passes_5, v0_.successfull_passes AS successfull_passes_6, v0_.pass_percentage AS pass_percentage_7, v0_.matches_played AS matches_played_8, v0_.minutes_played AS minutes_played_9, v0_.min_minutes_played AS min_minutes_played_10, v0_.role_code2 AS role_code2_11, v0_.tournament_id AS tournament_id_12 FROM view_tpppp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.role_code2 NOT IN ('GK') AND v0_.tournament_id = 10 ORDER BY v0_.pass_percentage DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.successfull_passes DESC, v0_.player ASC LIMIT 20;
|
| 36 |
0.73 ms |
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;
|
| 37 |
1.04 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 38 |
0.47 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 39 |
0.49 ms |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.passes AS passes_5, v0_.key_passes AS key_passes_6, v0_.key_passes90 AS key_passes90_7, v0_.matches_played AS matches_played_8, v0_.minutes_played AS minutes_played_9, v0_.min_minutes_played AS min_minutes_played_10, v0_.tournament_id AS tournament_id_11 FROM view_tpnp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.key_passes90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.key_passes DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.passes AS passes_5, v0_.key_passes AS key_passes_6, v0_.key_passes90 AS key_passes90_7, v0_.matches_played AS matches_played_8, v0_.minutes_played AS minutes_played_9, v0_.min_minutes_played AS min_minutes_played_10, v0_.tournament_id AS tournament_id_11 FROM view_tpnp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 10 ORDER BY v0_.key_passes90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.key_passes DESC, v0_.player ASC LIMIT 20;
|
| 40 |
0.65 ms |
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;
|
| 41 |
0.54 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 42 |
0.43 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 43 |
0.52 ms |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.smart_passes AS smart_passes_8, v0_.progressive_passes AS progressive_passes_9, v0_.smart_progressive_passes90 AS smart_progressive_passes90_10, v0_.tournament_id AS tournament_id_11 FROM view_tpspp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.smart_progressive_passes90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.smart_passes DESC, v0_.progressive_passes DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.smart_passes AS smart_passes_8, v0_.progressive_passes AS progressive_passes_9, v0_.smart_progressive_passes90 AS smart_progressive_passes90_10, v0_.tournament_id AS tournament_id_11 FROM view_tpspp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 10 ORDER BY v0_.smart_progressive_passes90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.smart_passes DESC, v0_.progressive_passes DESC, v0_.player ASC LIMIT 20;
|
| 44 |
0.73 ms |
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;
|
| 45 |
0.47 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 46 |
0.42 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 47 |
0.51 ms |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.long_passes AS long_passes_8, v0_.through_balls AS through_balls_9, v0_.long_passes_through_balls90 AS long_passes_through_balls90_10, v0_.tournament_id AS tournament_id_11 FROM view_tplpgs01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.long_passes_through_balls90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.long_passes DESC, v0_.through_balls DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.long_passes AS long_passes_8, v0_.through_balls AS through_balls_9, v0_.long_passes_through_balls90 AS long_passes_through_balls90_10, v0_.tournament_id AS tournament_id_11 FROM view_tplpgs01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 10 ORDER BY v0_.long_passes_through_balls90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.long_passes DESC, v0_.through_balls DESC, v0_.player ASC LIMIT 20;
|
| 48 |
0.64 ms |
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;
|
| 49 |
0.49 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 50 |
0.44 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 51 |
0.51 ms |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.aerial_duels AS aerial_duels_8, v0_.aerial_duels_won_perc AS aerial_duels_won_perc_9, v0_.head_pass AS head_pass_10, v0_.successful_head_pass_perc AS successful_head_pass_perc_11, v0_.role_code2 AS role_code2_12, v0_.tournament_id AS tournament_id_13 FROM view_tphs01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.role_code2 NOT IN ('GK') AND (NOT (v0_.head_pass < 10 OR v0_.aerial_duels < 10)) AND v0_.tournament_id = ? ORDER BY v0_.successful_head_pass_perc DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.aerial_duels DESC, v0_.aerial_duels_won_perc DESC, v0_.head_pass DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.aerial_duels AS aerial_duels_8, v0_.aerial_duels_won_perc AS aerial_duels_won_perc_9, v0_.head_pass AS head_pass_10, v0_.successful_head_pass_perc AS successful_head_pass_perc_11, v0_.role_code2 AS role_code2_12, v0_.tournament_id AS tournament_id_13 FROM view_tphs01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.role_code2 NOT IN ('GK') AND (NOT (v0_.head_pass < 10 OR v0_.aerial_duels < 10)) AND v0_.tournament_id = 10 ORDER BY v0_.successful_head_pass_perc DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.aerial_duels DESC, v0_.aerial_duels_won_perc DESC, v0_.head_pass DESC, v0_.player ASC LIMIT 20;
|
| 52 |
0.73 ms |
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;
|
| 53 |
0.50 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 54 |
0.56 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 55 |
0.54 ms |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.accelerations AS accelerations_8, v0_.progressive_run AS progressive_run_9, v0_.accelerations90 AS accelerations90_10, v0_.progressive_run90 AS progressive_run90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpamub01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.progressive_run90 DESC, v0_.accelerations90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.accelerations DESC, v0_.progressive_run DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.accelerations AS accelerations_8, v0_.progressive_run AS progressive_run_9, v0_.accelerations90 AS accelerations90_10, v0_.progressive_run90 AS progressive_run90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpamub01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 10 ORDER BY v0_.progressive_run90 DESC, v0_.accelerations90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.accelerations DESC, v0_.progressive_run DESC, v0_.player ASC LIMIT 20;
|
| 56 |
0.64 ms |
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;
|
| 57 |
0.53 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 58 |
0.43 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 59 |
0.55 ms |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.yellow_cards AS yellow_cards_8, v0_.red_cards AS red_cards_9, v0_.yellow_cards90 AS yellow_cards90_10, v0_.tournament_id AS tournament_id_11 FROM view_tpgrk01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND ((v0_.yellow_cards > 0 OR v0_.red_cards > 0)) AND v0_.tournament_id = ? ORDER BY v0_.yellow_cards DESC, v0_.yellow_cards90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.red_cards DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.yellow_cards AS yellow_cards_8, v0_.red_cards AS red_cards_9, v0_.yellow_cards90 AS yellow_cards90_10, v0_.tournament_id AS tournament_id_11 FROM view_tpgrk01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND ((v0_.yellow_cards > 0 OR v0_.red_cards > 0)) AND v0_.tournament_id = 10 ORDER BY v0_.yellow_cards DESC, v0_.yellow_cards90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.red_cards DESC, v0_.player ASC LIMIT 20;
|
| 60 |
0.78 ms |
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;
|
| 61 |
0.53 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 62 |
0.52 ms |
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"
"2018"
"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 = '2018' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 63 |
0.44 ms |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.penalties AS penalties_8, v0_.penalties_goals AS penalties_goals_9, v0_.tournament_id AS tournament_id_10 FROM view_tps01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.penalties > 0 AND v0_.tournament_id = ? ORDER BY v0_.penalties_goals DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.penalties DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.penalties AS penalties_8, v0_.penalties_goals AS penalties_goals_9, v0_.tournament_id AS tournament_id_10 FROM view_tps01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.penalties > 0 AND v0_.tournament_id = 10 ORDER BY v0_.penalties_goals DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.penalties DESC, v0_.player ASC LIMIT 20;
|