4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Voitsberg
TEMPORADA 2016/2017
CUARTA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 TUS Bad Gleichenberg Gleichenberg 30 80 32 68
2 Voitsberg Voitsberg 30 72 34 64
3 Weindorf St. Anna Weindorf 30 75 39 64
4 Mettersdorf Mettersdorf 30 75 56 52
5 Leoben Leoben 30 55 47 50
6 TUS Heiligenkreuz Heiligenkreu 30 54 52 48
7 Wildon Wildon 30 62 43 47
8 Lebring Lebring 30 60 44 45
9 SC Fürstenfeld Fürstenfeld 30 62 54 43
10 SV Union Gnas Union Gnas 30 42 51 40
11 SC Bruck SC Bruck 30 49 59 37
12 Liezen Liezen 30 42 53 35
13 Kapfenberger SV KM II Kapfenberger 30 47 69 30
14 TSV Pöllau TSV Pöllau 30 49 74 29
15 Frohnleiten Frohnleiten 30 38 65 23
16 Zeltweg Zeltweg 30 18 108 4
TEMPORADA 2015/2016
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Gleisdorf Gleisdorf 29 59 25 64
2 Weindorf St. Anna Weindorf 29 71 46 60
3 SV Union Gnas Union Gnas 29 50 29 55
4 Liezen Liezen 29 49 30 50
5 Leoben Leoben 29 49 37 45
6 TUS Bad Gleichenberg Gleichenberg 29 46 42 44
7 Voitsberg Voitsberg 29 52 51 44
8 Lebring Lebring 29 56 47 41
9 Frohnleiten Frohnleiten 29 40 47 38
10 SC Fürstenfeld Fürstenfeld 29 41 47 37
11 TUS Heiligenkreuz Heiligenkreu 29 42 54 33
12 Lankowitz Lankowitz 15 35 19 32
13 Zeltweg Zeltweg 29 51 71 29
14 Kapfenberger SV KM II Kapfenberger 29 41 51 28
15 SV ADA Anger Anger 29 31 60 22
16 Kindberg-Mürzhofen Kindberg-Mü 29 24 81 8
TEMPORADA 2014/2015
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Deutschlandsberger Deutschlands 30 84 35 68
2 TUS Heiligenkreuz Heiligenkreu 30 71 38 66
3 Gleisdorf Gleisdorf 30 60 46 48
4 Frohnleiten Frohnleiten 30 48 48 47
5 SV Union Gnas Union Gnas 30 55 43 45
6 Zeltweg Zeltweg 30 61 50 44
7 SV ADA Anger Anger 30 50 44 44
8 Kapfenberger SV KM II Kapfenberger 30 52 48 44
9 Voitsberg Voitsberg 30 51 53 44
10 Weindorf St. Anna Weindorf 30 58 61 38
11 Liezen Liezen 30 37 49 37
12 Lebring Lebring 30 34 43 36
13 Leoben Leoben 30 45 55 34
14 SC Fürstenfeld Fürstenfeld 30 46 56 32
15 SV Gleinstätten Gleinstätte 30 63 78 31
16 Gratkorn Gratkorn 30 27 95 9
TEMPORADA 2013/2014
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Weiz Weiz 30 71 19 72
2 Gleisdorf Gleisdorf 30 70 39 61
3 Deutschlandsberger Deutschlands 30 72 42 59
4 SV Gleinstätten Gleinstätte 30 56 43 53
5 SV Union Gnas Union Gnas 30 43 34 46
6 TUS Heiligenkreuz Heiligenkreu 30 65 59 45
7 Frohnleiten Frohnleiten 30 53 49 42
8 Voitsberg Voitsberg 30 47 45 41
9 Leoben Leoben 30 40 44 39
10 SC Fürstenfeld Fürstenfeld 30 45 45 37
11 Gratkorn Gratkorn 30 41 55 32
12 SV ADA Anger Anger 30 35 47 31
13 Liezen Liezen 30 38 55 31
14 Wildon Wildon 30 38 59 30
15 Grossklein Grossklein 30 27 65 20
16 Irdning Irdning 30 32 73 18
TEMPORADA 2012/2013
CUARTA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 SV Lafnitz SV Lafnitz 30 80 36 63
2 Weiz Weiz 30 60 33 60
3 SV Gleinstätten Gleinstätte 30 61 41 53
4 Deutschlandsberger Deutschlands 30 58 49 51
5 Gleisdorf Gleisdorf 30 63 44 47
6 Frohnleiten Frohnleiten 30 47 48 47
7 SC Fürstenfeld Fürstenfeld 30 52 44 45
8 Voitsberg Voitsberg 30 50 39 42
9 Liezen Liezen 30 44 42 40
10 Wildon Wildon 30 43 62 38
11 TUS Heiligenkreuz Heiligenkreu 30 45 59 35
12 SV ADA Anger Anger 30 38 52 34
13 SV Pachern SV Pachern 30 50 60 32
14 Gratkorn II Gratkorn II 30 37 65 30
15 SVA Kindberg Kindberg 30 29 55 29
16 Zeltweg Zeltweg 30 33 61 25
TEMPORADA 2011/2012
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Kalsdorf Kalsdorf 30 74 38 64
2 Weiz Weiz 30 67 36 55
3 Liezen Liezen 30 57 33 54
4 Gleisdorf Gleisdorf 30 62 32 51
5 Voitsberg Voitsberg 30 57 42 46
6 SC Fürstenfeld Fürstenfeld 30 51 54 46
7 SV Lafnitz SV Lafnitz 30 64 59 44
8 SVA Kindberg Kindberg 30 50 47 43
9 SV ADA Anger Anger 30 60 56 42
10 Frohnleiten Frohnleiten 30 41 44 39
11 SV Pachern SV Pachern 30 43 65 35
12 Wildon Wildon 30 56 62 34
13 Gratkorn II Gratkorn II 30 42 73 33
14 Irdning Irdning 30 32 69 28
15 Grossklein Grossklein 30 49 68 26
16 Mürzhofen/Allerheiligen Mürzhofen/A 30 36 63 26
TEMPORADA 2010/2011
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 LASK Juniors LASK Juniors 30 55 37 58
2 Blau-Weiß Linz Blau-Weiß 30 55 27 57
3 Grazer AK Grazer AK 30 59 37 54
4 Allerheiligen Allerheilige 30 45 29 52
5 Union St. Florian Union 30 43 37 45
6 SV Pasching SV Pasching 30 38 33 45
7 Austria Klagenfurt Austria 30 42 37 43
8 SV Gleinstätten Gleinstätte 30 49 49 41
9 Vöcklamarkt Vöcklamarkt 30 45 45 38
10 SAK Klagenfurt Klagenfurt 30 38 40 38
11 Leoben Leoben 30 47 51 37
12 Sturm Graz II Sturm Graz 30 48 61 34
13 Wels Wels 30 21 42 33
14 Feldkirchen Feldkirchen 30 36 55 27
15 Weiz Weiz 30 34 53 26
16 Voitsberg Voitsberg 30 30 52 21
TEMPORADA 2009/2010
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 SV Pasching SV Pasching 30 77 24 63
2 WAC Sankt Andrä Sankt Andrä 30 66 32 61
3 Blau-Weiß Linz Blau-Weiß 30 49 31 55
4 St. Stefan St. Stefan 30 51 37 51
5 Grazer AK Grazer AK 30 57 40 50
6 Union St. Florian Union 30 58 38 47
7 Allerheiligen Allerheilige 30 57 49 46
8 Weiz Weiz 30 54 48 45
9 Voitsberg Voitsberg 30 48 44 45
10 Leoben Leoben 30 46 46 42
11 SAK Klagenfurt Klagenfurt 30 40 50 39
12 Wels Wels 30 44 50 37
13 Sturm Graz II Sturm Graz 30 50 50 35
14 SVL Flavia Solva Flavia Solva 30 46 59 27
15 St. Veit Glan Veit Glan 30 36 76 25
16 Bad Aussee Bad Aussee 30 14 119 5
TEMPORADA 2008/2009
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 TSV Hartberg Hartberg 30 63 25 64
2 Grazer AK Grazer AK 30 68 32 64
3 Sturm Graz II Sturm Graz 30 52 32 56
4 Voitsberg Voitsberg 30 65 37 54
5 WAC Sankt Andrä Sankt Andrä 30 41 30 54
6 Wels Wels 30 62 51 47
7 Blau-Weiß Linz Blau-Weiß 30 50 35 43
8 Union St. Florian Union 30 49 41 40
9 SAK Klagenfurt Klagenfurt 30 46 46 38
10 Allerheiligen Allerheilige 30 38 38 38
11 Weiz Weiz 30 48 52 34
12 St. Veit Glan Veit Glan 30 43 62 30
13 Bad Aussee Bad Aussee 30 29 66 28
14 Feldkirchen Feldkirchen 30 39 66 27
15 FC Kärnten FC Kärnten 30 22 70 23
16 Spittal Spittal 30 31 63 19
TEMPORADA 2006/2007
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Bad Aussee Bad Aussee 30 62 31 57
2 Wels Wels 30 58 34 56
3 Feldkirchen Feldkirchen 30 51 35 53
4 WAC Sankt Andrä Sankt Andrä 30 43 30 51
5 Vöcklabruck Vöcklabruck 30 41 28 47
6 Spittal Spittal 30 37 43 45
7 SAK Klagenfurt Klagenfurt 30 45 46 44
8 Allerheiligen Allerheilige 30 40 32 43
9 Sturm Graz II Sturm Graz 30 42 45 37
10 Union St. Florian Union 30 35 50 35
11 Grieskirchen Grieskirchen 30 33 38 34
12 FC Kärnten II Kärnten 30 35 46 34
13 Voitsberg Voitsberg 30 44 48 33
14 Blau-Weiß Linz Blau-Weiß 30 33 38 33
15 Köflach Köflach 30 29 59 30
16 Union Perg Union Perg 30 28 53 26
TEMPORADA 2005/2006
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 TSV Hartberg Hartberg 30 54 28 63
2 Spittal Spittal 30 48 35 54
3 Feldkirchen Feldkirchen 30 43 38 53
4 Voitsberg Voitsberg 30 44 38 48
5 WAC Sankt Andrä Sankt Andrä 30 49 33 45
6 Union St. Florian Union 30 45 33 44
7 Köflach Köflach 30 46 42 43
8 Wels Wels 30 41 40 40
9 SAK Klagenfurt Klagenfurt 30 39 55 39
10 Bad Aussee Bad Aussee 30 38 34 37
11 Sturm Graz II Sturm Graz 30 52 46 35
12 Blau-Weiß Linz Blau-Weiß 30 32 42 34
13 FC Superfund II Superfund 30 36 42 31
14 Vöcklabruck Vöcklabruck 30 37 49 31
15 Union Perg Union Perg 30 27 43 31
16 Bleiburg Bleiburg 30 30 63 24
TEMPORADA 2004/2005
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 SC Schwanenstadt Schwanenstad 30 43 26 62
2 TSV Hartberg Hartberg 30 55 33 50
3 Spittal Spittal 30 56 43 48
4 FC Superfund II Superfund 30 57 41 47
5 Köflach Köflach 30 42 32 47
6 Sturm Graz II Sturm Graz 30 49 46 44
7 Union St. Florian Union 30 36 30 43
8 Bleiburg Bleiburg 30 37 52 40
9 Feldkirchen Feldkirchen 30 46 55 38
10 Blau-Weiß Linz Blau-Weiß 30 33 32 37
11 WAC Sankt Andrä Sankt Andrä 30 36 41 37
12 Voitsberg Voitsberg 30 39 42 35
13 Wels Wels 30 34 42 35
14 Union Perg Union Perg 30 31 45 34
15 FC Kärnten II Kärnten 30 30 41 31
16 Kalsdorf Kalsdorf 30 32 55 21
TEMPORADA 2003/2004
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Gratkorn Gratkorn 30 67 28 63
2 TSV Hartberg Hartberg 30 62 30 60
3 Arnfels Arnfels 30 50 39 49
4 Köflach Köflach 30 53 49 48
5 Blau-Weiß Linz Blau-Weiß 30 40 33 47
6 SC Schwanenstadt Schwanenstad 30 41 35 44
7 Bleiburg Bleiburg 30 33 32 42
8 Sturm Graz II Sturm Graz 30 33 35 41
9 WAC Sankt Andrä Sankt Andrä 30 44 47 40
10 FC Kärnten II Kärnten 30 31 28 39
11 Voitsberg Voitsberg 30 45 49 39
12 Union St. Florian Union 30 35 41 38
13 Union Perg Union Perg 30 35 58 35
14 Spittal Spittal 30 27 38 34
15 Wels Wels 30 25 48 26
16 LASK Linz II LASK Linz 30 23 54 19
TEMPORADA 2002/2003
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Blau-Weiß Linz Blau-Weiß 30 72 22 72
2 TSV Hartberg Hartberg 30 58 37 59
3 SC Schwanenstadt Schwanenstad 30 58 38 52
4 Voitsberg Voitsberg 30 54 29 51
5 Gratkorn Gratkorn 30 42 24 51
6 Köflach Köflach 30 49 41 50
7 Spittal Spittal 30 41 34 42
8 FC Kärnten II Kärnten 30 38 41 42
9 Bleiburg Bleiburg 30 32 43 41
10 Sturm Graz II Sturm Graz 30 58 53 39
11 Union Perg Union Perg 30 42 47 36
12 Eintracht Wels Eintracht 30 35 55 33
13 Union St. Florian Union 30 33 56 31
14 SAK Klagenfurt Klagenfurt 30 32 52 28
15 St. Veit Glan Veit Glan 30 26 70 24
16 Zeltweg Zeltweg 30 28 56 23
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

  USO DE MEMORIA  
7,090,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1550
Total Execution Time  0.1564
  CADENA URL  
/historico/Voitsberg/2017
  GET DATOS  
$_GET['/historico/Voitsberg/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0030  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 = 'Voitsberg' AND l.year = 2017 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=18103 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=18103 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=18103 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 38904
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18103 AND type_rel = 2
0.0028  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 = '18103' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '18103' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 38904 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=18103 AND l.year in (2016,2017,2018) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (38908,38427) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 38908 AND teamId = 18103
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 18103
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 `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 = 38904 AND t.round = 30 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 = '18103' 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 = '18103' and rp.type = 4
0.0022  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 = '18103' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0047  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 events2017 e ON e.player_id = p.id AND e.league_id = 38904 WHERE rp.league_id = 38904 AND rp.teamId = 18103 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.0048  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 events2017 e ON e.player_id = p.id AND e.league_id = 38904 WHERE rp.league_id = 38904 AND rp.teamId = 18103 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 events2017 e ON e.player_id = p.id AND e.league_id = 38904 WHERE rp.league_id = 38904 AND rp.teamId = 18103 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 18103 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 38904 AND t.round = 30 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 = 15767 AND t.round = 30 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 `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 = 3939 AND t.round = 30 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 = 27166 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 `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 = 27164 AND t.round = 30 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 `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 = 27202 AND t.round = 30 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 = 24532 AND t.round = 30 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 `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 = 24535 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 `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 = 24538 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 `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 = 27600 AND t.round = 30 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 = 27592 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 `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 = 27576 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 `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 = 27570 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 `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 = 44521 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 `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.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 `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.0238  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