4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
TEMPORADA 2001/2002
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Kapfenberger SV Kapfenberger 30 79 29 66
2 Blau-Weiß Linz Blau-Weiß 30 62 34 61
3 TSV Hartberg Hartberg 30 54 26 59
4 Gratkorn Gratkorn 30 48 27 55
5 Spittal Spittal 30 49 30 53
6 SC Schwanenstadt Schwanenstad 30 47 35 49
7 Zeltweg Zeltweg 30 44 47 48
8 Voitsberg Voitsberg 30 42 41 41
9 Köflach Köflach 30 33 41 39
10 Eintracht Wels Eintracht 30 31 36 38
11 Union St. Florian Union 30 53 58 37
12 FC Kärnten II Kärnten 30 40 45 35
13 Bleiburg Bleiburg 30 26 34 33
14 Sankt Veit Sankt Veit 30 28 57 18
15 ATSV Wolfsberg ATSV 30 23 57 18
16 Donau Linz Donau Linz 30 27 89 8
TEMPORADA 2000/2001
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 SV Pasching SV Pasching 30 61 27 56
2 Kapfenberger SV Kapfenberger 30 50 34 51
3 TSV Hartberg Hartberg 30 47 30 48
4 BSV Juniors BSV Juniors 30 52 39 48
5 Gratkorn Gratkorn 30 44 35 45
6 Donau Linz Donau Linz 30 33 30 45
7 Blau-Weiß Linz Blau-Weiß 30 48 41 42
8 Alpe Adria Alpe Adria 30 38 44 41
9 Zeltweg Zeltweg 30 42 39 40
10 Spittal Spittal 30 47 51 39
11 Wels Wels 30 40 51 38
12 Voitsberg Voitsberg 30 40 48 37
13 Wolfsberger AC Wolfsberger 30 37 49 34
14 Union St. Florian Union 30 34 56 32
15 Lendorf Lendorf 30 24 45 31
16 SAK Klagenfurt Klagenfurt 30 29 47 26
TEMPORADA 1984/1985
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 SVL Flavia Solva Flavia Solva 30 66 23 60
2 Salzburger AK Salzburger 30 57 18 60
3 Kremser SC Kremser SC 30 52 31 59
4 Vorwarts Steyr Vorwarts 30 37 32 46
5 Sankt Veit Sankt Veit 30 42 35 43
6 Kufstein Kufstein 30 34 33 43
7 SW Bregenz SW Bregenz 30 33 39 43
8 Voitsberg Voitsberg 30 53 40 42
9 Thörl Thörl 30 37 36 42
10 WSG Tirol WSG Tirol 30 37 41 41
11 FC Salzburg FC Salzburg 30 40 48 41
12 Oberwart Oberwart 30 45 54 37
13 Simmeringer SC Simmeringer 30 29 44 34
14 Kapfenberger SV Kapfenberger 30 33 45 33
15 Badener Badener 30 30 58 22
16 Wolfsberger AC Wolfsberger 30 27 75 13
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  
7,029,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6607
Total Execution Time  0.6620
  CADENA URL  
/historico/Kapfenberger-Sv/2015
  GET DATOS  
$_GET['/historico/Kapfenberger-Sv/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0117  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 = 2015 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.0105  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.0105  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.0105  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.0105  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.0112  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 = 3909
0.0110  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 = 9283
0.0114  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 = 3804
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3972 AND type_rel = 2
0.0106  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.0111  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.0112  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 = 2015 ORDER BY l.year DESC,cat.coefficient DESC
0.0111  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.0109  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 = 9283 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106  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 = 3909 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0112  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 (2014,2015,2016) ORDER BY l.id DESC, l.year DESC ;
0.0108  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 (20742,16245,15704) 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.0115  SELECT count(id) as num_players from rel_players WHERE league_id = 15704 AND teamId = 3972
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 20742 AND teamId = 3972
0.0141  SELECT count(id) as num_players from rel_players WHERE league_id = 16245 AND teamId = 3972
0.0110  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0109  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.0107  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3972' and rp.type = 4
0.0111  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.0142  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 events2015 e ON e.player_id = p.id AND e.league_id = 3909 WHERE rp.league_id = 3909 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.0164  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 events2015 e ON e.player_id = p.id AND e.league_id = 3909 WHERE rp.league_id = 3909 AND rp.teamId = 3972 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 events2015 e ON e.player_id = p.id AND e.league_id = 3909 WHERE rp.league_id = 3909 AND rp.teamId = 3972 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143  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 <= 2015 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0127  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.0123  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.0123  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.0127  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.0121  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.0121  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.0122  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.0121  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 `tables2008` 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 = 8921 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124  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.0123  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.0123  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.0121  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.0125  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 `tables2002` 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 = 27565 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 `tables2001` 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 = 27556 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  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 `tables1985` 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 = 23111 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0119  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.0114  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.0111  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.0113  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
0.0108  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 = 3909 ORDER BY nameShow LIMIT 100