4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Kapfenberger SV

Kapfenberger SV

Entrenador: Matthias Puschl

Temporada 2021/2022
TEMPORADA 2021/2022
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Austria Lustenau Austria 30 69 26 70
2 FAC Wien FAC Wien 30 51 18 65
3 Blau-Weiß Linz Blau-Weiß 30 51 27 54
4 SV Lafnitz SV Lafnitz 30 53 42 52
5 SKU Amstetten Amstetten 30 59 35 51
6 Liefering Liefering 30 56 43 46
7 Grazer AK Grazer AK 30 47 39 46
8 SKN St. Polten Polten 30 43 38 42
9 Wacker Innsbruck Wacker 30 46 41 40
10 Vorwarts Steyr Vorwarts 30 39 52 37
11 Rapid Wien II Rapid Wien 30 45 62 33
12 Kapfenberger SV Kapfenberger 30 36 54 30
13 Horn Horn 30 34 55 28
14 Austria Wien II Austria Wien 30 31 56 25
15 FC Juniors OÖ Juniors 30 37 71 23
16 Dornbirn Dornbirn 30 35 73 22
TEMPORADA 2020/2021
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Blau-Weiß Linz Blau-Weiß 30 70 31 63
2 Liefering Liefering 30 69 31 63
3 Austria Klagenfurt Austria 30 64 32 59
4 Wacker Innsbruck Wacker 30 50 33 57
5 SV Lafnitz SV Lafnitz 30 56 35 55
6 Grazer AK Grazer AK 30 46 42 46
7 Dornbirn Dornbirn 30 40 53 38
8 FC Juniors OÖ Juniors 30 38 49 37
9 FAC Wien FAC Wien 30 39 41 36
10 Kapfenberger SV Kapfenberger 30 34 51 33
11 Austria Wien II Austria Wien 30 41 52 32
12 SKU Amstetten Amstetten 30 38 61 31
13 Austria Lustenau Austria 30 44 55 30
14 Rapid Wien II Rapid Wien 30 37 53 30
15 Horn Horn 30 40 62 30
16 Vorwarts Steyr Vorwarts 30 30 55 30
TEMPORADA 2019/2020
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 SV Ried SV Ried 30 73 39 64
2 Austria Klagenfurt Austria 30 65 36 64
3 Liefering Liefering 30 73 47 53
4 Austria Wien II Austria Wien 30 62 44 48
5 SKU Amstetten Amstetten 30 51 47 45
6 Wacker Innsbruck Wacker 30 44 49 44
7 Vorwarts Steyr Vorwarts 30 42 36 41
8 SV Lafnitz SV Lafnitz 30 42 42 39
9 FC Juniors OÖ Juniors 30 50 63 38
10 Blau-Weiß Linz Blau-Weiß 30 51 57 37
11 Austria Lustenau Austria 30 57 58 35
12 Dornbirn Dornbirn 30 40 59 34
13 Horn Horn 30 58 67 32
14 FAC Wien FAC Wien 30 32 51 32
15 Grazer AK Grazer AK 30 40 50 31
16 Kapfenberger SV Kapfenberger 30 34 69 22
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
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Mattersburg Mattersburg 36 69 36 71
2 Liefering Liefering 36 70 55 65
3 LASK LASK 36 45 36 56
4 Kapfenberger SV Kapfenberger 36 52 45 49
5 SKN St. Polten Polten 36 39 41 49
6 Wacker Innsbruck Wacker 36 32 43 43
7 Austria Lustenau Austria 36 49 56 42
8 FAC Wien FAC Wien 36 40 49 41
9 Horn Horn 36 34 50 38
10 TSV Hartberg Hartberg 36 46 65 38
TEMPORADA 2013/2014
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 SCR Altach SCR Altach 36 79 41 73
2 Austria Lustenau Austria 36 57 36 59
3 Liefering Liefering 36 72 48 57
4 SKN St. Polten Polten 36 52 48 53
5 Kapfenberger SV Kapfenberger 36 55 48 52
6 Mattersburg Mattersburg 36 53 67 44
7 Horn Horn 36 52 70 44
8 TSV Hartberg Hartberg 36 41 60 44
9 Parndorf Parndorf 36 41 59 39
10 First Vienna First Vienna 36 36 61 20
TEMPORADA 2012/2013
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Grödig Grödig 36 71 30 75
2 SCR Altach SCR Altach 36 57 39 65
3 Austria Lustenau Austria 36 60 39 61
4 SKN St. Polten Polten 36 65 60 54
5 Kapfenberger SV Kapfenberger 36 56 50 53
6 Horn Horn 36 50 55 46
7 First Vienna First Vienna 36 48 64 46
8 FC Lustenau FC Lustenau 36 44 66 38
9 TSV Hartberg Hartberg 36 35 54 33
10 Blau-Weiß Linz Blau-Weiß 36 38 67 26
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
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 86 50 74
2 Rapid Wien Rapid Wien 36 89 43 70
3 Austria Wien Austria Wien 36 59 46 62
4 Sturm Graz Sturm Graz 36 68 45 60
5 SV Ried SV Ried 36 58 38 60
6 Austria Karnten Austria 36 47 57 41
7 LASK LASK 36 35 67 37
8 Kapfenberger SV Kapfenberger 36 48 81 36
9 Mattersburg Mattersburg 36 42 71 33
10 SCR Altach SCR Altach 36 56 90 30
TEMPORADA 2007/2008
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Kapfenberger SV Kapfenberger 33 79 45 66
2 Gratkorn Gratkorn 33 51 35 55
3 Austria Lustenau Austria 33 59 45 54
4 FC Lustenau FC Lustenau 33 50 39 53
5 Austria Wien II Austria Wien 33 45 44 50
6 RB Juniors Salzburg Juniors 33 51 52 46
7 SC Schwanenstadt Schwanenstad 33 48 51 45
8 Leoben Leoben 33 44 46 41
9 Schwadorf Schwadorf 33 48 53 41
10 FC Kärnten FC Kärnten 33 37 51 40
11 Parndorf Parndorf 33 45 61 37
12 Bad Aussee Bad Aussee 33 35 70 20
TEMPORADA 2006/2007
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 LASK LASK 33 74 34 76
2 SC Schwanenstadt Schwanenstad 33 59 41 63
3 Leoben Leoben 33 55 36 55
4 Austria Lustenau Austria 33 57 50 50
5 Gratkorn Gratkorn 33 45 41 47
6 FC Lustenau FC Lustenau 33 54 51 47
7 FC Kärnten FC Kärnten 33 41 41 42
8 Austria Wien II Austria Wien 33 42 52 38
9 Parndorf Parndorf 33 41 47 35
10 Admira Admira 33 45 67 33
11 Kapfenberger SV Kapfenberger 33 41 60 32
12 TSV Hartberg Hartberg 33 31 65 26
TEMPORADA 2005/2006
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 SCR Altach SCR Altach 36 61 35 68
2 LASK LASK 36 51 30 66
3 Austria Lustenau Austria 36 54 32 62
4 Austria Wien II Austria Wien 36 58 40 58
5 Gratkorn Gratkorn 36 47 40 54
6 Leoben Leoben 36 59 49 51
7 FC Kärnten FC Kärnten 36 57 50 51
8 Kapfenberger SV Kapfenberger 36 51 69 39
9 SC Schwanenstadt Schwanenstad 36 33 57 33
10 Kufstein Kufstein 36 23 92 16
TEMPORADA 2004/2005
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 SV Ried SV Ried 36 79 38 77
2 Kapfenberger SV Kapfenberger 36 64 37 71
3 FC Kärnten FC Kärnten 36 68 41 58
4 Austria Lustenau Austria 36 55 43 56
5 Leoben Leoben 36 43 49 47
6 SCR Altach SCR Altach 36 37 45 41
7 LASK LASK 36 38 64 39
8 Untersiebenbrunn Untersiebenb 36 45 66 34
9 Gratkorn Gratkorn 36 43 58 32
10 Wörgl Wörgl 36 32 63 32
TEMPORADA 2003/2004
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Wacker Innsbruck Wacker 36 65 44 72
2 Austria Lustenau Austria 36 55 36 65
3 Kapfenberger SV Kapfenberger 36 68 55 60
4 Untersiebenbrunn Untersiebenb 36 61 48 60
5 SV Ried SV Ried 36 60 43 56
6 Leoben Leoben 36 44 44 46
7 LASK LASK 36 46 55 44
8 Wörgl Wörgl 36 48 66 37
9 FC Lustenau FC Lustenau 36 40 58 31
10 BSV Juniors BSV Juniors 36 31 69 24
TEMPORADA 2002/2003
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Mattersburg Mattersburg 36 58 33 70
2 Leoben Leoben 36 69 57 57
3 Austria Lustenau Austria 36 41 40 53
4 Untersiebenbrunn Untersiebenb 36 59 58 52
5 LASK LASK 36 47 47 49
6 Kapfenberger SV Kapfenberger 36 50 49 48
7 FC Lustenau FC Lustenau 36 53 53 46
8 Wörgl Wörgl 36 44 58 45
9 Bad Bleiberg Bleiberg 36 49 60 44
10 Wiener SC Wiener SC 36 56 71 42

  USO DE MEMORIA  
7,005,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1599
Total Execution Time  0.1612
  CADENA URL  
/historico/Kapfenberger-Sv/2022
  GET DATOS  
$_GET['/historico/Kapfenberger-Sv/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0046  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 = 'Kapfenberger-Sv' AND l.year = 2022 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.0020  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=3972 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=3972 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=3972 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=3972 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0030  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 = 63139
0.0030  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 = 63190
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3972 AND type_rel = 2
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3972 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (260835,581429) ORDER BY n.cover_points DESC, update_date DESC
0.0040  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 = '3972' ORDER BY l.year DESC,cat.coefficient DESC
0.0037  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 = '3972' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0031  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 = '3972' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = 63190 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 63139 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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=3972 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (68059,68052,67320) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 68052 AND teamId = 3972
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 68059 AND teamId = 3972
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 3972
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 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 = 63139 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '3972' 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 = '3972' 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 = '3972' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0035  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 events2022 e ON e.player_id = p.id AND e.league_id = 63139 WHERE rp.league_id = 63139 AND rp.teamId = 3972 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.0030  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 events2022 e ON e.player_id = p.id AND e.league_id = 63139 WHERE rp.league_id = 63139 AND rp.teamId = 3972 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 events2022 e ON e.player_id = p.id AND e.league_id = 63139 WHERE rp.league_id = 63139 AND rp.teamId = 3972 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 3972 AND l.year <= 2022 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 `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 = 63139 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.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 `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 = 58548 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.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 = 50149 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.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 `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.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 `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.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 `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.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 `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 = 3909 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 2764 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 = 8928 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 `tables2012` 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 = 1364 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 `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.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 `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 = 321 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2007` 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 = 8919 AND t.round = 33 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 `tables2006` 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 = 8916 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 `tables2005` 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 = 8914 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables2004` 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 = 8912 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables2003` 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 = 8911 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 dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 63139 ORDER BY nameShow LIMIT 100