| 1 |
0.97 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 |
0.67 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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 3 |
0.49 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.81 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.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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 6 |
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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 7 |
0.45 ms |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu2101 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu2101 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC;
|
| 8 |
0.79 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.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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 10 |
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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 11 |
0.45 ms |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu2001 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu2001 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC;
|
| 12 |
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 = ?) 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.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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 14 |
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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 15 |
0.38 ms |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu1901 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu1901 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC;
|
| 16 |
0.59 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.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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 18 |
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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 19 |
0.48 ms |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu1801 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu1801 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC;
|
| 20 |
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;
|
| 21 |
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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 22 |
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"
"2021"
"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 = '2021' 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_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.avg_age_match_squad AS avg_age_match_squad_4, v0_.avg_age_starting_eleven AS avg_age_starting_eleven_5, v0_.avg_age_bench AS avg_age_bench_6, v0_.avg_age_substituted_in AS avg_age_substituted_in_7, v0_.tournament_id AS tournament_id_8 FROM view_ttga01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.avg_age_substituted_in DESC, v0_.matches_played DESC, v0_.avg_age_match_squad DESC, v0_.avg_age_starting_eleven DESC, v0_.avg_age_bench 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_.avg_age_match_squad AS avg_age_match_squad_4, v0_.avg_age_starting_eleven AS avg_age_starting_eleven_5, v0_.avg_age_bench AS avg_age_bench_6, v0_.avg_age_substituted_in AS avg_age_substituted_in_7, v0_.tournament_id AS tournament_id_8 FROM view_ttga01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.avg_age_substituted_in DESC, v0_.matches_played DESC, v0_.avg_age_match_squad DESC, v0_.avg_age_starting_eleven DESC, v0_.avg_age_bench DESC, v0_.team ASC;
|
| 24 |
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;
|
| 25 |
0.58 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"
"2021"
"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 = '2021' 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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 27 |
0.47 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_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu2101 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played 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_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu2101 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played DESC, v0_.player ASC LIMIT 20;
|
| 28 |
0.75 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.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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 30 |
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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 31 |
0.41 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_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu2001 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played 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_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu2001 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played DESC, v0_.player ASC LIMIT 20;
|
| 32 |
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;
|
| 33 |
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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 34 |
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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 35 |
0.53 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_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu1901 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played 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_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu1901 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played DESC, v0_.player ASC LIMIT 20;
|
| 36 |
0.70 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 |
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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 38 |
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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 39 |
0.43 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_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu1801 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played 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_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu1801 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played DESC, v0_.player ASC LIMIT 20;
|
| 40 |
0.75 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.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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 42 |
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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 43 |
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_.born AS born_5, v0_.player_goals AS player_goals_6, v0_.assists AS assists_7, v0_.points AS points_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.points90 AS points90_12, v0_.tournament_id AS tournament_id_13 FROM view_tpmapu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.points90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.player_goals DESC, v0_.assists 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_.born AS born_5, v0_.player_goals AS player_goals_6, v0_.assists AS assists_7, v0_.points AS points_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.points90 AS points90_12, v0_.tournament_id AS tournament_id_13 FROM view_tpmapu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 7 ORDER BY v0_.points90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.player_goals DESC, v0_.assists DESC, v0_.points DESC, v0_.player ASC LIMIT 20;
|
| 44 |
0.67 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.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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 46 |
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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 47 |
0.70 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_tpxgxaxpu2101 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_tpxgxaxpu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 7 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;
|
| 48 |
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 = ?) 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.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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 50 |
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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 51 |
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_.born AS born_5, v0_.passes AS passes_6, v0_.successfull_passes AS successfull_passes_7, v0_.pass_percentage AS pass_percentage_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.role_code2 AS role_code2_12, v0_.tournament_id AS tournament_id_13 FROM view_tppppu2101 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_.born 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_.born AS born_5, v0_.passes AS passes_6, v0_.successfull_passes AS successfull_passes_7, v0_.pass_percentage AS pass_percentage_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.role_code2 AS role_code2_12, v0_.tournament_id AS tournament_id_13 FROM view_tppppu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.role_code2 NOT IN ('GK') AND v0_.tournament_id = 7 ORDER BY v0_.pass_percentage DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.successfull_passes DESC, v0_.player ASC LIMIT 20;
|
| 52 |
1.02 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.84 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"
"2021"
"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 = '2021' 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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 55 |
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_.passes AS passes_6, v0_.key_passes AS key_passes_7, v0_.key_passes90 AS key_passes90_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.tournament_id AS tournament_id_12 FROM view_tpnpu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.key_passes90 DESC, v0_.born 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_.born AS born_5, v0_.passes AS passes_6, v0_.key_passes AS key_passes_7, v0_.key_passes90 AS key_passes90_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.tournament_id AS tournament_id_12 FROM view_tpnpu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 7 ORDER BY v0_.key_passes90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.key_passes DESC, v0_.player ASC LIMIT 20;
|
| 56 |
0.79 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.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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 58 |
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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 59 |
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_.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_.smart_passes AS smart_passes_9, v0_.progressive_passes AS progressive_passes_10, v0_.smart_progressive_passes90 AS smart_progressive_passes90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpsppu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.smart_progressive_passes90 DESC, v0_.born 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_.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_.smart_passes AS smart_passes_9, v0_.progressive_passes AS progressive_passes_10, v0_.smart_progressive_passes90 AS smart_progressive_passes90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpsppu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 7 ORDER BY v0_.smart_progressive_passes90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.smart_passes DESC, v0_.progressive_passes DESC, v0_.player ASC LIMIT 20;
|
| 60 |
0.71 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.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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 62 |
0.71 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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
| 63 |
0.58 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_.chances_created AS chances_created_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.matches_played AS matches_played_9, v0_.chanses90 AS chanses90_10, v0_.tournament_id AS tournament_id_11 FROM view_tpscu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.chanses90 DESC, v0_.born 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_.born AS born_5, v0_.chances_created AS chances_created_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.matches_played AS matches_played_9, v0_.chanses90 AS chanses90_10, v0_.tournament_id AS tournament_id_11 FROM view_tpscu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 7 ORDER BY v0_.chanses90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.chances_created DESC, v0_.player ASC LIMIT 20;
|