4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Wiener Neustadt
TEMPORADA 2023/2024
CUARTA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 Gloggnitz Gloggnitz 22 41 17 50
2 Marathon Korneuburg Marathon 22 44 19 47
3 Schrems Schrems 22 46 20 45
4 Wiener Neustadt Wiener 22 33 30 37
5 Kilb Kilb 22 36 23 36
6 St. Pölten II Pölten 22 34 37 31
7 SC Retz SC Retz 22 28 21 31
8 Zwettl Zwettl 22 34 37 31
9 Ortmann Ortmann 22 36 33 29
10 Rohrbach Rohrbach 22 27 31 28
11 St. Peter St. Peter 22 35 30 27
12 Langenrohr Langenrohr 22 31 42 26
13 Scheiblingkirchen-Warth Scheiblingki 22 26 33 25
14 Kottingbrunn Kottingbrunn 22 24 27 23
15 SV Haitzendorf Haitzendorf 22 23 44 14
16 Waidhofen / Thaya Waidhofen 22 15 69 9
TEMPORADA 2022/2023
TERCERA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Stripfing Stripfing 30 86 20 72
2 Elektra Elektra 30 55 32 59
3 Donaufeld Donaufeld 30 56 41 52
4 Wiener SC Wiener SC 30 43 30 49
5 FCM Traiskirchen Traiskirchen 30 44 37 47
6 Marchfeld Marchfeld 30 56 52 47
7 Kremser SC Kremser SC 30 47 51 44
8 Leobendorf Leobendorf 30 38 39 42
9 Mauerwerk Mauerwerk 30 52 63 41
10 SC Wiener Viktoria Wiener 30 47 51 39
11 Drassburg Drassburg 30 40 49 39
12 Neusiedl Neusiedl 30 49 45 38
13 Siegendorf Siegendorf 30 35 43 36
14 Scheiblingkirchen-Warth Scheiblingki 30 44 48 34
15 Wiener Neustadt Wiener 30 37 67 22
16 Bruck/Leitha Bruck/Leitha 30 19 80 12
TEMPORADA 2021/2022
TERCERA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 First Vienna First Vienna 26 52 18 58
2 Stripfing Stripfing 26 60 19 54
3 Wiener SC Wiener SC 26 48 32 46
4 Leobendorf Leobendorf 26 45 37 45
5 Neusiedl Neusiedl 26 39 37 41
6 Elektra Elektra 26 33 31 41
7 Marchfeld Marchfeld 26 44 41 40
8 SC Wiener Viktoria Wiener 26 36 36 38
9 FCM Traiskirchen Traiskirchen 26 41 42 35
10 Bruck/Leitha Bruck/Leitha 26 43 44 27
11 Mauerwerk Mauerwerk 26 29 56 23
12 Admira Wacker II Admira 26 33 53 19
13 Wiener Neustadt Wiener 26 31 55 19
14 Drassburg Drassburg 26 22 55 16
TEMPORADA 2020/2021
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Wiener SC Wiener SC 8 13 4 19
2 Bruck/Leitha Bruck/Leitha 9 24 11 18
3 Leobendorf Leobendorf 7 16 9 18
4 FCM Traiskirchen Traiskirchen 9 20 9 16
5 Team Wiener Linien Team Wiener 8 14 7 15
6 Stripfing Stripfing 6 10 4 15
7 Marchfeld Marchfeld 8 13 12 11
8 Admira Wacker II Admira 7 10 9 11
9 SC Wiener Viktoria Wiener 10 8 21 7
10 Mauerwerk Mauerwerk 8 7 18 6
11 Neusiedl Neusiedl 8 6 17 6
12 Drassburg Drassburg 9 12 22 5
13 Wiener Neustadt Wiener 7 2 12 4
TEMPORADA 2019/2020
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Marchfeld Marchfeld 18 34 15 42
2 Rapid Wien II Rapid Wien 18 32 13 37
3 Ebreichsdorf Ebreichsdorf 18 28 11 34
4 Wiener SC Wiener SC 18 37 27 30
5 Stripfing Stripfing 18 24 16 30
6 Team Wiener Linien Team Wiener 18 23 20 27
7 SC Wiener Viktoria Wiener 18 31 30 27
8 Mattersburg II Mattersburg 18 30 25 25
9 Drassburg Drassburg 18 25 30 25
10 Wiener Neustadt Wiener 18 29 34 23
11 Neusiedl Neusiedl 18 25 35 23
12 Mauerwerk Mauerwerk 18 25 32 20
13 Bruck/Leitha Bruck/Leitha 18 24 35 19
14 FCM Traiskirchen Traiskirchen 18 25 34 16
15 Admira Wacker II Admira 18 20 28 14
16 Leobendorf Leobendorf 18 11 38 9
TEMPORADA 2018/2019
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 WSG Tirol WSG Tirol 30 59 26 65
2 SV Ried SV Ried 30 61 21 63
3 Austria Lustenau Austria 30 55 34 50
4 Kapfenberger SV Kapfenberger 30 44 40 46
5 Blau-Weiß Linz Blau-Weiß 30 46 48 44
6 Wiener Neustadt Wiener 30 39 41 44
7 FC Juniors OÖ Juniors 30 52 55 42
8 Austria Klagenfurt Austria 30 43 35 41
9 FC Wacker Innsbruck II Wacker 30 40 44 41
10 FAC Wien FAC Wien 30 35 41 41
11 SKU Amstetten Amstetten 30 45 43 36
12 Liefering Liefering 30 50 54 35
13 Austria Wien II Austria Wien 30 46 62 34
14 SV Lafnitz SV Lafnitz 30 36 42 33
15 Horn Horn 30 33 62 25
16 Vorwarts Steyr Vorwarts 30 32 68 21
TEMPORADA 2017/2018
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Wacker Innsbruck Wacker 36 60 31 71
2 TSV Hartberg Hartberg 36 63 34 68
3 Wiener Neustadt Wiener 36 53 37 62
4 SV Ried SV Ried 36 68 41 61
5 Liefering Liefering 36 58 44 55
6 Austria Lustenau Austria 36 48 52 45
7 WSG Tirol WSG Tirol 36 45 56 40
8 Kapfenberger SV Kapfenberger 36 40 68 35
9 FAC Wien FAC Wien 36 37 75 30
10 Blau-Weiß Linz Blau-Weiß 36 35 69 26
TEMPORADA 2016/2017
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 LASK LASK 36 77 42 77
2 Liefering Liefering 36 58 49 60
3 Austria Lustenau Austria 36 58 49 57
4 Wacker Innsbruck Wacker 36 58 53 54
5 WSG Tirol WSG Tirol 36 56 54 51
6 Kapfenberger SV Kapfenberger 36 47 57 41
7 Blau-Weiß Linz Blau-Weiß 36 41 45 39
8 Wiener Neustadt Wiener 36 40 62 39
9 FAC Wien FAC Wien 36 39 48 38
10 Horn Horn 36 42 57 33
TEMPORADA 2015/2016
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 SKN St. Polten Polten 36 68 34 80
2 LASK LASK 36 65 35 72
3 Wacker Innsbruck Wacker 36 61 47 59
4 Liefering Liefering 36 65 49 57
5 Austria Lustenau Austria 36 56 40 57
6 Kapfenberger SV Kapfenberger 36 63 62 50
7 Wiener Neustadt Wiener 36 39 49 45
8 Austria Klagenfurt Austria 36 43 62 34
9 Austria Salzburg Austria 36 45 73 32
10 FAC Wien FAC Wien 36 23 77 17
TEMPORADA 2014/2015
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 99 42 73
2 Rapid Wien Rapid Wien 36 68 38 67
3 SCR Altach SCR Altach 36 50 49 59
4 Sturm Graz Sturm Graz 36 57 41 58
5 Wolfsberger AC Wolfsberger 36 44 50 52
6 SV Ried SV Ried 36 49 51 44
7 Austria Wien Austria Wien 36 45 51 43
8 Grödig Grödig 36 46 65 37
9 Admira Admira 36 32 61 34
10 Wiener Neustadt Wiener 36 37 79 29
TEMPORADA 2013/2014
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 110 35 80
2 Rapid Wien Rapid Wien 36 63 40 62
3 Grödig Grödig 36 68 71 54
4 Austria Wien Austria Wien 36 58 44 53
5 Sturm Graz Sturm Graz 36 55 55 48
6 SV Ried SV Ried 36 55 66 43
7 Admira Admira 36 51 67 42
8 Wolfsberger AC Wolfsberger 36 50 63 41
9 Wiener Neustadt Wiener 36 43 84 39
10 Wacker Innsbruck Wacker 36 42 70 29
TEMPORADA 2012/2013
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Austria Wien Austria Wien 36 84 31 82
2 Salzburg Salzburg 36 91 39 77
3 Rapid Wien Rapid Wien 36 57 39 57
4 Sturm Graz Sturm Graz 36 47 56 48
5 Wolfsberger AC Wolfsberger 36 53 56 47
6 SV Ried SV Ried 36 60 59 46
7 Wiener Neustadt Wiener 36 32 60 36
8 Wacker Innsbruck Wacker 36 41 73 36
9 Admira Admira 36 47 68 35
10 Mattersburg Mattersburg 36 36 67 35
TEMPORADA 2011/2012
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 60 30 68
2 Rapid Wien Rapid Wien 36 52 30 62
3 Admira Admira 36 59 52 55
4 Austria Wien Austria Wien 36 52 44 54
5 Sturm Graz Sturm Graz 36 47 41 51
6 SV Ried SV Ried 36 44 38 48
7 Wacker Innsbruck Wacker 36 36 45 45
8 Mattersburg Mattersburg 36 41 43 38
9 Wiener Neustadt Wiener 36 26 51 33
10 Kapfenberger SV Kapfenberger 36 21 64 23
TEMPORADA 2010/2011
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Sturm Graz Sturm Graz 36 66 33 66
2 Salzburg Salzburg 36 53 31 63
3 Austria Wien Austria Wien 36 64 37 61
4 SV Ried SV Ried 36 51 38 58
5 Rapid Wien Rapid Wien 36 52 41 53
6 Wacker Innsbruck Wacker 36 43 42 50
7 Wiener Neustadt Wiener 36 44 52 50
8 Kapfenberger SV Kapfenberger 36 42 61 38
9 Mattersburg Mattersburg 36 29 56 31
10 LASK LASK 36 22 75 19
TEMPORADA 2009/2010
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 68 27 76
2 Austria Wien Austria Wien 36 60 34 75
3 Rapid Wien Rapid Wien 36 80 38 73
4 Sturm Graz Sturm Graz 36 50 36 58
5 Wiener Neustadt Wiener 36 54 58 47
6 Mattersburg Mattersburg 36 45 71 41
7 LASK LASK 36 59 70 40
8 SV Ried SV Ried 36 39 47 38
9 Kapfenberger SV Kapfenberger 36 44 67 33
10 Austria Karnten Austria 36 29 80 15
TEMPORADA 2008/2009
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Wiener Neustadt Wiener 33 65 26 69
2 Wacker Innsbruck Wacker 33 65 44 62
3 Admira Admira 33 55 36 60
4 Austria Lustenau Austria 33 52 47 48
5 SKN St. Polten Polten 33 51 46 47
6 Austria Wien II Austria Wien 33 44 43 45
7 RB Juniors Salzburg Juniors 33 41 56 43
8 Gratkorn Gratkorn 33 39 55 40
9 FC Lustenau FC Lustenau 33 34 37 38
10 Grödig Grödig 33 37 52 35
11 Leoben Leoben 33 30 55 32
12 Vöcklabruck Vöcklabruck 33 40 56 30
TEMPORADA 1966/1967
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 26 72 29 61
2 Wacker Innsbruck Wacker 26 58 24 59
3 Austria Wien Austria Wien 26 43 23 49
4 LASK LASK 26 39 25 43
5 Wiener SC Wiener SC 26 60 36 42
6 SW Bregenz SW Bregenz 27 26 37 39
7 First Vienna First Vienna 26 42 49 37
8 Admira Admira 26 36 25 36
9 Grazer AK Grazer AK 26 27 44 31
10 Austria Klagenfurt Austria 26 21 33 30
11 Sturm Graz Sturm Graz 26 32 47 25
12 Wacker Wien Wacker Wien 26 28 50 25
13 Wiener Neustadt Wiener 26 21 44 21
14 Kapfenberger SV Kapfenberger 27 20 59 16
TEMPORADA 1965/1966
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Admira Admira 26 51 17 43
2 Rapid Wien Rapid Wien 26 64 22 40
3 Austria Wien Austria Wien 26 58 28 35
4 Wiener SC Wiener SC 26 57 32 30
5 First Vienna First Vienna 26 52 43 30
6 Austria Klagenfurt Austria 26 39 33 29
7 LASK LASK 26 46 37 27
8 FC Wacker Innsbruck Wacker 26 32 31 25
9 Schwechat Schwechat 26 40 42 23
10 Grazer AK Grazer AK 26 35 46 23
11 Kapfenberger SV Kapfenberger 26 26 51 20
12 Wiener Neustadt Wiener 26 24 59 18
13 Salzburg Salzburg 26 25 66 12
14 Simmeringer SC Simmeringer 26 26 68 9
TEMPORADA 1964/1965
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 LASK LASK 26 49 29 50
2 Admira Admira 26 52 28 49
3 Rapid Wien Rapid Wien 26 42 21 49
4 Wiener SC Wiener SC 26 54 36 48
5 First Vienna First Vienna 26 51 36 42
6 Schwechat Schwechat 26 27 28 39
7 Austria Wien Austria Wien 26 29 28 37
8 Wacker Innsbruck Wacker 26 29 23 34
9 Wiener Neustadt Wiener 26 31 32 31
10 Sturm Graz Sturm Graz 26 29 40 26
11 Grazer AK Grazer AK 26 28 48 26
12 Kapfenberger SV Kapfenberger 26 25 45 25
13 Wiener AC Wiener AC 26 31 54 20
14 Wacker Wien Wacker Wien 26 27 56 19
TEMPORADA 1963/1964
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 26 69 27 62
2 Austria Wien Austria Wien 26 61 36 54
3 LASK LASK 26 46 36 48
4 Schwechat Schwechat 26 51 41 44
5 Wiener SC Wiener SC 26 48 53 44
6 Grazer AK Grazer AK 26 49 42 38
7 Admira Admira 26 52 49 38
8 First Vienna First Vienna 26 38 33 32
9 Wiener AC Wiener AC 26 33 38 31
10 Wiener Neustadt Wiener 26 33 47 30
11 Kapfenberger SV Kapfenberger 26 38 56 26
12 Simmeringer SC Simmeringer 26 46 64 25
13 Stickstoff Linz Stickstoff 26 42 56 22
14 Dornbirn Dornbirn 26 31 59 17

  USO DE MEMORIA  
6,912,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1362
Total Execution Time  0.1374
  CADENA URL  
/historico/Wiener-Neustadt
  GET DATOS  
$_GET['/historico/Wiener-Neustadt']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0034  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Wiener-Neustadt' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3971 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3971 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3971 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73019
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3971 AND type_rel = 2
0.0026  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '3971' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '3971' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '3971' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73019 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=3971 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73019,71432,68180) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 68180 AND teamId = 3971
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 73019 AND teamId = 3971
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 3971
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73019 AND t.round = 23 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '3971' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3971' and rp.type = 4
0.0020  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '3971' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0038  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73019 WHERE rp.league_id = 73019 AND rp.teamId = 3971 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73019 WHERE rp.league_id = 73019 AND rp.teamId = 3971 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73019 WHERE rp.league_id = 73019 AND rp.teamId = 3971 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 3971 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73019 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 68180 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 63404 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 57018 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50222 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 44020 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 38776 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 33336 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15704 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 3813 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2482 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2014 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1093 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 870 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 8924 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1967` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 26094 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1966` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 26097 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1965` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 26100 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1964` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 26102 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC