4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Gersthofer SV
TEMPORADA 2017/2018
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 Team Wiener Linien Team Wiener 30 89 38 62
2 Elektra Elektra 30 57 28 59
3 Favoritner AC Favoritner 30 65 42 56
4 Donaufeld Donaufeld 30 70 42 54
5 Technopool Admira Technopool 30 45 55 47
6 Wienerberg Wienerberg 30 67 54 46
7 Gerasdorf Stammersdorf Gerasdorf 30 59 56 44
8 Slovan HAC Slovan HAC 30 50 48 44
9 Austria XIII Austria XIII 30 56 50 39
10 SC Wiener Viktoria Wiener 30 66 61 39
11 Mannswörth Mannswörth 30 50 60 36
12 Post Post 30 41 59 32
13 Sportunion Mauer Sportunion 30 46 70 28
14 Donau Donau 30 36 63 27
15 Ostbahn XI Ostbahn XI 30 36 68 25
16 Gersthofer SV Gersthofer 30 42 81 21
TEMPORADA 2016/2017
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 Karabakh Wien Karabakh 30 80 21 71
2 Elektra Elektra 30 59 38 56
3 Mannswörth Mannswörth 30 57 42 55
4 Team Wiener Linien Team Wiener 30 60 49 50
5 Donaufeld Donaufeld 30 51 33 49
6 Austria XIII Austria XIII 30 50 47 46
7 Ostbahn XI Ostbahn XI 30 59 53 43
8 SC Wiener Viktoria Wiener 30 55 77 41
9 Wienerberg Wienerberg 30 69 42 38
10 Post Post 30 46 53 38
11 Favoritner AC Favoritner 30 53 51 37
12 Gerasdorf Stammersdorf Gerasdorf 30 41 44 37
13 Gersthofer SV Gersthofer 30 33 54 31
14 Admira Landhaus Admira 30 27 50 25
15 Sportunion Mauer Sportunion 30 36 80 23
16 Simmeringer SC Simmeringer 30 33 75 21
TEMPORADA 2015/2016
CUARTA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Wienerberg Wienerberg 30 65 33 62
2 Team Wiener Linien Team Wiener 30 65 44 55
3 Donaufeld Donaufeld 30 60 45 54
4 Elektra Elektra 30 69 42 50
5 Austria XIII Austria XIII 30 54 37 49
6 Gerasdorf Stammersdorf Gerasdorf 30 50 42 46
7 SC Wiener Viktoria Wiener 30 51 50 42
8 Sportunion Mauer Sportunion 30 48 49 42
9 Post Post 30 42 57 40
10 Gersthofer SV Gersthofer 30 44 53 39
11 Mannswörth Mannswörth 30 36 38 38
12 Admira Landhaus Admira 30 52 54 36
13 Favoritner AC Favoritner 30 29 50 34
14 Simmeringer SC Simmeringer 30 40 55 27
15 Ostbahn XI Ostbahn XI 30 40 62 24
16 ASV 13 ASV 13 30 40 74 24
TEMPORADA 2014/2015
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Stadlau Stadlau 30 70 23 69
2 Admira Landhaus Admira 30 56 40 56
3 Mannswörth Mannswörth 30 48 31 49
4 Austria XIII Austria XIII 30 49 31 47
5 Wienerberg Wienerberg 30 46 45 47
6 Team Wiener Linien Team Wiener 30 52 44 46
7 Elektra Elektra 30 49 46 46
8 Gerasdorf Stammersdorf Gerasdorf 30 46 40 44
9 Gersthofer SV Gersthofer 30 37 41 42
10 Ostbahn XI Ostbahn XI 30 44 44 40
11 Simmeringer SC Simmeringer 30 44 51 33
12 SC Wiener Viktoria Wiener 30 27 44 32
13 Favoritner AC Favoritner 30 35 49 31
14 ASV 13 ASV 13 30 34 56 29
15 Post Post 30 27 50 28
16 Donau Donau 30 28 57 18
TEMPORADA 2013/2014
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Donaufeld Donaufeld 29 74 30 69
2 Stadlau Stadlau 29 58 18 57
3 Team Wiener Linien Team Wiener 29 71 43 52
4 Admira Landhaus Admira 29 49 37 52
5 Ostbahn XI Ostbahn XI 29 62 38 51
6 Gerasdorf Stammersdorf Gerasdorf 29 49 34 48
7 Austria XIII Austria XIII 29 38 29 45
8 Favoritner AC Favoritner 29 40 42 45
9 Post Post 29 59 53 44
10 Mannswörth Mannswörth 29 46 56 40
11 Donau Donau 29 37 34 37
12 Wienerberg Wienerberg 29 40 40 37
13 First Vienna II First Vienna 29 45 58 29
14 Gersthofer SV Gersthofer 29 33 48 27
15 Simmeringer SC Simmeringer 29 21 81 10
16 NAC NAC 29 15 96 7
TEMPORADA 2012/2013
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 SC Wiener Viktoria Wiener 30 84 28 68
2 Post Post 30 59 33 60
3 Stadlau Stadlau 30 60 27 59
4 Donaufeld Donaufeld 30 65 40 54
5 Team Wiener Linien Team Wiener 30 57 35 51
6 Favoritner AC Favoritner 30 57 50 50
7 Donau Donau 30 47 41 49
8 NAC NAC 30 68 49 47
9 Admira Landhaus Admira 30 51 44 43
10 Austria XIII Austria XIII 30 52 51 39
11 Gersthofer SV Gersthofer 30 32 48 32
12 Gerasdorf Stammersdorf Gerasdorf 30 43 63 31
13 First Vienna II First Vienna 30 37 61 30
14 Fortuna 05 Fortuna 05 30 35 72 25
15 Slovan-Hütteldorfer Slovan-Hütt 30 37 78 20
16 Columbia Floridsdorf Columbia 30 25 89 11
TEMPORADA 2011/2012
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 Ostbahn XI Ostbahn XI 30 71 38 63
2 NAC NAC 30 68 33 59
3 Stadlau Stadlau 30 48 22 54
4 Team Wiener Linien Team Wiener 30 41 31 52
5 Post Post 30 54 38 51
6 Austria XIII Austria XIII 30 56 45 49
7 Donaufeld Donaufeld 30 54 44 47
8 Gerasdorf Stammersdorf Gerasdorf 30 54 48 42
9 Donau Donau 30 31 37 41
10 Gersthofer SV Gersthofer 30 31 35 40
11 Admira Landhaus Admira 30 46 40 37
12 Fortuna 05 Fortuna 05 30 50 55 37
13 Favoritner AC Favoritner 30 40 50 37
14 Slovan HAC Slovan HAC 30 31 68 25
15 Wienerberg Wienerberg 30 30 61 18
16 LAC-IC LAC-IC 30 24 84 14
TEMPORADA 2010/2011
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 Simmeringer SC Simmeringer 30 81 20 75
2 Admira Landhaus Admira 30 65 41 54
3 Post Post 30 49 28 54
4 Team Wiener Linien Team Wiener 30 57 34 52
5 LAC-IC LAC-IC 30 56 50 49
6 Stadlau Stadlau 30 65 39 46
7 Favoritner AC Favoritner 30 64 56 45
8 Gersthofer SV Gersthofer 30 49 45 45
9 Donaufeld Donaufeld 30 42 51 43
10 SC BiH Süssenbrunn Süssenbrunn 30 47 49 42
11 Wienerberg Wienerberg 30 48 58 39
12 Gerasdorf Stammersdorf Gerasdorf 30 41 61 33
13 Fortuna 05 Fortuna 05 30 35 58 29
14 Slovan-Hütteldorfer Slovan-Hütt 30 30 52 24
15 Mannswörth Mannswörth 30 32 65 22
16 Rennweger SV Rennweger 30 21 75 21
TEMPORADA 2009/2010
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 Columbia Floridsdorf Columbia 30 66 32 65
2 Post Post 30 60 25 59
3 Simmeringer SC Simmeringer 30 59 32 58
4 Stadlau Stadlau 30 66 29 52
5 Admira Landhaus Admira 30 75 46 52
6 Favoritner AC Favoritner 30 65 45 51
7 Favoriten Favoriten 30 64 52 49
8 Slovan HAC Slovan HAC 30 47 43 46
9 Rennweger SV Rennweger 30 70 59 43
10 Fortuna 05 Fortuna 05 30 55 76 41
11 Mannswörth Mannswörth 30 48 56 39
12 Gersthofer SV Gersthofer 30 35 53 34
13 Donaufeld Donaufeld 30 43 55 29
14 Gerasdorf Stammersdorf Gerasdorf 30 40 68 29
15 Ankerbrot Ankerbrot 30 34 71 25
16 Aspern Aspern 30 24 109 4
TEMPORADA 2008/2009
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 Schwechat Schwechat 30 72 13 72
2 Stadlau Stadlau 30 73 28 62
3 Post Post 30 59 27 54
4 Favoriten Favoriten 30 63 45 54
5 Admira Landhaus Admira 30 57 41 50
6 Fortuna 05 Fortuna 05 30 59 50 47
7 Columbia Floridsdorf Columbia 30 39 30 46
8 Donaufeld Donaufeld 30 48 32 45
9 Rennweger SV Rennweger 29 62 52 45
10 Gersthofer SV Gersthofer 30 44 48 41
11 Mannswörth Mannswörth 29 48 49 38
12 Ankerbrot Ankerbrot 30 37 56 33
13 Favoritner AC Favoritner 30 27 53 26
14 Gerasdorf Stammersdorf Gerasdorf 30 37 69 24
15 Slovan HAC Slovan HAC 30 33 82 19
16 Donau Donau 30 34 117 10

  USO DE MEMORIA  
5,991,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7748
Total Execution Time  0.7760
  CADENA URL  
/historico/Gersthofer-Sv
  GET DATOS  
$_GET['/historico/Gersthofer-Sv']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (51)  
0.0131  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 = 'Gersthofer-Sv' 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.0157  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 = 'Gersthofer-Sv' 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.0130  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=17551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=17551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0134  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=17551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=17551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=17551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=17551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=17551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=17551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=17551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=17551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=17551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=17551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=17551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=17551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=17551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=17551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=17551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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 = 38915
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17551 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=584 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 584 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129  SELECT /*53 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 (809215,467932,467907,348427) ORDER BY n.cover_points DESC, update_date DESC
0.0132  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 = '17551' ORDER BY l.year DESC,cat.coefficient DESC
0.0136  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 = '17551' AND l.year = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0139  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 = '17551' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0144  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 = '17551' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137  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 = 38915 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0142  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=17551 AND l.year in (2017,2018,2019) ORDER BY l.id DESC, l.year DESC ;
0.0135  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 (43475,38915) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 38915 AND teamId = 17551
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 17551
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 38915 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '17551' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  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 = '17551' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 events2018 e ON e.player_id = p.id AND e.league_id = 38915 WHERE rp.league_id = 38915 AND rp.teamId = 17551 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.0165  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 events2018 e ON e.player_id = p.id AND e.league_id = 38915 WHERE rp.league_id = 38915 AND rp.teamId = 17551 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159  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 events2018 e ON e.player_id = p.id AND e.league_id = 38915 WHERE rp.league_id = 38915 AND rp.teamId = 17551 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 = 17551 AND l.year <= 2018 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0142  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 = 38915 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 38906 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 15765 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 3937 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 3585 AND t.round = 29 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 27184 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 27219 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 27236 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 27253 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 27271 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 38915 ORDER BY nameShow LIMIT 100