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

Suwon Bluewings

Entrenador: Ki-Hun Yeom

Temporada 2014/2015
TEMPORADA 2014/2015
K LEAGUE 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Jeonbuk Hyundai Motors Jeonbuk 33 54 35 68
2 Suwon Bluewings Suwon 33 53 36 60
3 Pohang Steelers Pohang 33 43 28 56
4 Seongnam FC Seongnam FC 33 37 29 54
5 FC Seoul FC Seoul 33 44 37 54
6 Jeju United Jeju United 33 51 50 46
7 Incheon United Incheon 33 31 29 45
8 Jeonnam Dragons Jeonnam 33 40 43 42
9 Ulsan HD FC Ulsan HD FC 33 42 39 40
10 Gwangju FC Gwangju FC 33 31 40 35
11 Busan I Park Busan Park 33 27 49 24
12 Daejeon Citizen Daejeon 33 27 65 13
TEMPORADA 2013/2014
K LEAGUE 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Jeonbuk Hyundai Motors Jeonbuk 5 8 2 81
2 Suwon Bluewings Suwon 5 7 4 67
3 FC Seoul FC Seoul 5 5 4 58
4 Pohang Steelers Pohang 5 4 6 58
5 Jeju United Jeju United 5 3 7 54
6 Ulsan HD FC Ulsan HD FC 5 5 9 50
TEMPORADA 2012/2013
K LEAGUE 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Ulsan HD FC Ulsan HD FC 12 15 8 73
2 Jeonbuk Hyundai Motors Jeonbuk 12 11 16 63
3 FC Seoul FC Seoul 12 15 15 62
4 Suwon Bluewings Suwon 12 12 14 53
5 Busan I Park Busan Park 12 10 14 52
6 Incheon United Incheon 12 11 16 50
7 Pohang Steelers Pohang 12 21 12 25
TEMPORADA 2011/2012
K LEAGUE 1 GRUPO 2
Equipo PJ GF GC Puntos
1 FC Seoul FC Seoul 14 22 14 96
2 Jeonbuk Hyundai Motors Jeonbuk 14 22 19 79
3 Pohang Steelers Pohang 14 32 16 77
4 Suwon Bluewings Suwon 14 13 15 73
5 Ulsan HD FC Ulsan HD FC 14 17 21 68
6 Jeju United Jeju United 14 15 13 63
7 Busan I Park Busan Park 14 11 21 53
8 Gyeongnam FC Gyeongnam 14 10 23 50
TEMPORADA 2010/2011
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Jeonbuk Hyundai Motors Jeonbuk 30 67 32 63
2 Pohang Steelers Pohang 30 59 33 59
3 FC Seoul FC Seoul 30 56 38 55
4 Suwon Bluewings Suwon 30 51 33 55
5 Busan I Park Busan Park 30 49 43 46
6 Ulsan HD FC Ulsan HD FC 30 33 29 46
7 Jeonnam Dragons Jeonnam 30 33 29 43
8 Gyeongnam FC Gyeongnam 30 41 40 42
9 Jeju United Jeju United 30 44 45 40
10 Seongnam FC Seongnam FC 30 43 47 35
11 Gwangju FC Gwangju FC 30 32 43 35
12 Daegu FC Daegu FC 30 35 46 33
13 Incheon United Incheon 30 31 40 32
14 Gimcheon Sangmu FC Gimcheon 30 36 53 29
15 Daejeon Citizen Daejeon 30 31 59 27
16 Gangwon FC Gangwon FC 30 14 45 15
TEMPORADA 2009/2010
K LEAGUE 1
Equipo PJ GF GC Puntos
1 FC Seoul FC Seoul 28 58 26 62
2 Jeju United Jeju United 28 54 25 59
3 Jeonbuk Hyundai Motors Jeonbuk 28 54 36 51
4 Ulsan HD FC Ulsan HD FC 28 47 30 50
5 Seongnam FC Seongnam FC 28 46 26 48
6 Gyeongnam FC Gyeongnam 28 41 32 48
7 Suwon Bluewings Suwon 28 39 44 41
8 Busan I Park Busan Park 28 36 37 33
9 Pohang Steelers Pohang 28 39 48 33
10 Jeonnam Dragons Jeonnam 28 40 49 32
11 Incheon United Incheon 28 42 51 31
12 Gangwon FC Gangwon FC 28 36 50 30
13 Daejeon Citizen Daejeon 28 27 50 22
14 Gwangju Sangmu Gwangju 28 17 43 19
15 Daegu FC Daegu FC 28 28 57 19
TEMPORADA 2008/2009
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Jeonbuk Hyundai Motors Jeonbuk 28 59 33 57
2 Pohang Steelers Pohang 28 55 33 53
3 FC Seoul FC Seoul 28 47 27 53
4 Seongnam FC Seongnam FC 28 40 34 45
5 Incheon United Incheon 28 31 29 43
6 Jeonnam Dragons Jeonnam 28 41 39 42
7 Gyeongnam FC Gyeongnam 28 38 32 40
8 Ulsan HD FC Ulsan HD FC 28 32 29 36
9 Daejeon Citizen Daejeon 28 29 38 33
10 Suwon Bluewings Suwon 28 29 32 32
11 Gwangju Sangmu Gwangju 28 33 40 30
12 Busan I Park Busan Park 28 36 42 29
13 Gangwon FC Gangwon FC 28 42 57 28
14 Jeju United Jeju United 28 22 44 28
15 Daegu FC Daegu FC 28 20 45 23
TEMPORADA 2007/2008
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Suwon Bluewings Suwon 26 46 24 54
2 FC Seoul FC Seoul 26 44 25 54
3 Seongnam FC Seongnam FC 26 45 21 51
4 Ulsan HD FC Ulsan HD FC 26 39 26 49
5 Pohang Steelers Pohang 26 43 34 44
6 Jeonbuk Hyundai Motors Jeonbuk 26 39 37 37
7 Incheon United Incheon 26 29 30 36
8 Gyeongnam FC Gyeongnam 26 35 39 35
9 Jeonnam Dragons Jeonnam 26 26 40 29
10 Jeju United Jeju United 26 23 31 28
11 Daegu FC Daegu FC 26 46 58 26
12 Busan I Park Busan Park 26 30 39 22
13 Daejeon Citizen Daejeon 26 18 35 21
14 Gwangju Sangmu Gwangju 26 22 46 16
TEMPORADA 2006/2007
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Seongnam FC Seongnam FC 26 43 18 55
2 Suwon Bluewings Suwon 26 36 24 51
3 Ulsan HD FC Ulsan HD FC 26 34 22 45
4 Gyeongnam FC Gyeongnam 26 41 31 44
5 Pohang Steelers Pohang 26 27 31 39
6 Daejeon Citizen Daejeon 26 34 27 37
7 FC Seoul FC Seoul 26 23 16 37
8 Jeonbuk Hyundai Motors Jeonbuk 26 36 32 36
9 Incheon United Incheon 26 30 32 33
10 Jeonnam Dragons Jeonnam 26 24 27 30
11 Jeju United Jeju United 26 27 35 30
12 Daegu FC Daegu FC 26 35 46 24
13 Busan I Park Busan Park 26 20 39 20
14 Gwangju Sangmu Gwangju 26 14 44 12
TEMPORADA 2005/2006
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Pohang Steelers Pohang 26 42 26 50
2 Seongnam FC Seongnam FC 26 41 25 47
3 Suwon Bluewings Suwon 26 29 22 43
4 FC Seoul FC Seoul 26 32 23 39
5 Ulsan HD FC Ulsan HD FC 26 22 23 35
6 Jeonnam Dragons Jeonnam 26 28 25 34
7 Daegu FC Daegu FC 26 32 30 34
8 Incheon United Incheon 26 24 27 33
9 Busan I Park Busan Park 26 38 42 31
10 Daejeon Citizen Daejeon 26 28 32 31
11 Jeonbuk Hyundai Motors Jeonbuk 26 25 34 28
12 Gyeongnam FC Gyeongnam 26 22 34 27
13 Jeju United Jeju United 26 23 30 25
14 Gwangju Sangmu Gwangju 26 17 30 22
TEMPORADA 2004/2005
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Incheon United Incheon 24 36 26 45
2 Seongnam FC Seongnam FC 24 40 24 43
3 Ulsan HD FC Ulsan HD FC 24 31 24 43
4 Jeju United Jeju United 24 26 18 42
5 Pohang Steelers Pohang 24 28 22 40
6 FC Seoul FC Seoul 24 37 32 32
7 Daejeon Citizen Daejeon 24 19 20 30
8 Daegu FC Daegu FC 24 29 36 30
9 Suwon Bluewings Suwon 24 29 32 28
10 Busan I Park Busan Park 24 28 31 28
11 Jeonnam Dragons Jeonnam 24 23 29 27
12 Jeonbuk Hyundai Motors Jeonbuk 24 24 41 18
13 Gwangju Sangmu Gwangju 24 23 38 17
TEMPORADA 2003/2004
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Ulsan HD FC Ulsan HD FC 24 22 14 41
2 Suwon Bluewings Suwon 24 31 24 41
3 Jeonnam Dragons Jeonnam 24 29 20 37
4 FC Seoul FC Seoul 24 20 17 33
5 Jeonbuk Hyundai Motors Jeonbuk 24 23 18 32
6 Pohang Steelers Pohang 24 23 24 32
7 Busan I Park Busan Park 24 21 19 30
8 Gwangju Sangmu Gwangju 24 18 20 29
9 Seongnam FC Seongnam FC 24 23 28 29
10 Daegu FC Daegu FC 24 30 31 28
11 Daejeon Citizen Daejeon 24 18 26 26
12 Incheon United Incheon 24 20 29 26
13 Jeju United Jeju United 24 19 27 25
TEMPORADA 2002/2003
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Seongnam FC Seongnam FC 44 85 50 91
2 Ulsan HD FC Ulsan HD FC 44 63 44 73
3 Suwon Bluewings Suwon 44 59 46 72
4 Jeonnam Dragons Jeonnam 44 65 48 71
5 Jeonbuk Hyundai Motors Jeonbuk 44 72 58 69
6 Daejeon Citizen Daejeon 44 50 51 65
7 Pohang Steelers Pohang 44 53 46 64
8 FC Seoul FC Seoul 44 69 68 56
9 Busan I Park Busan Park 44 41 71 49
10 Gwangju Sangmu Gwangju 44 41 60 46
11 Daegu FC Daegu FC 44 38 60 37
12 Bucheon SK Bucheon SK 44 39 73 21
TEMPORADA 2001/2002
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Seongnam FC Seongnam FC 27 43 32 49
2 Ulsan HD FC Ulsan HD FC 27 37 27 47
3 Suwon Bluewings Suwon 27 40 26 45
4 FC Seoul FC Seoul 27 37 30 40
5 Jeonnam Dragons Jeonnam 27 21 21 37
6 Pohang Steelers Pohang 27 31 34 36
7 Jeonbuk Hyundai Motors Jeonbuk 27 37 36 35
8 Bucheon FC 1995 Bucheon 1995 27 32 40 32
9 Busan I Park Busan Park 27 36 45 26
10 Daejeon Citizen Daejeon 27 17 40 14
TEMPORADA 2000/2001
K LEAGUE 1
Equipo PJ GF GC Puntos
1 Seongnam FC Seongnam FC 27 35 20 45
2 FC Seoul FC Seoul 27 30 23 43
3 Suwon Bluewings Suwon 27 40 35 41
4 Busan I Park Busan Park 27 38 33 41
5 Pohang Steelers Pohang 27 28 29 38
6 Ulsan HD FC Ulsan HD FC 27 34 39 36
7 Bucheon FC 1995 Bucheon 1995 27 29 29 35
8 Jeonnam Dragons Jeonnam 27 28 33 28
9 Jeonbuk Hyundai Motors Jeonbuk 27 23 33 25
10 Daejeon Citizen Daejeon 27 25 36 25
TEMPORADA 1999/2000
K LEAGUE 1
Equipo PJ GF GC Puntos
1 FC Seoul FC Seoul 27 48 28 57
2 Seongnam FC Seongnam FC 27 49 38 54
3 Bucheon FC 1995 Bucheon 1995 27 51 38 48
4 Jeonbuk Hyundai Motors Jeonbuk 27 38 40 45
5 Suwon Bluewings Suwon 27 51 47 42
6 Pohang Steelers Pohang 27 38 43 36
7 Jeonnam Dragons Jeonnam 27 32 38 36
8 Busan I Park Busan Park 27 44 49 33
9 Daejeon Citizen Daejeon 27 29 43 30
10 Ulsan HD FC Ulsan HD FC 27 28 44 24

  USO DE MEMORIA  
6,949,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1818
Total Execution Time  0.1830
  CADENA URL  
/historico/Suwon-Bluewings/2015
  GET DATOS  
$_GET['/historico/Suwon-Bluewings/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (57)  
0.0035  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 = 'Suwon-Bluewings' 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.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=2440 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=2440 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=2440 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=2440 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=2440 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=2440 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=2440 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 9995
0.0024  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 = 19700
0.0023  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 = 9144
0.0025  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 = 9166
0.0024  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 = 10959
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2440 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2440 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (171372,513437,525761,796477,831556) ORDER BY n.cover_points DESC, update_date DESC
0.0044  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 = '2440' ORDER BY l.year DESC,cat.coefficient DESC
0.0042  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 = '2440' AND l.year = 2015 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '2440' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 9144 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 10959 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 19700 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=2440 AND l.year in (2014,2015,2016) 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 (37094,22576,20450,3804) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 37094 AND teamId = 2440
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 20450 AND teamId = 2440
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 22576 AND teamId = 2440
0.0047  SELECT count(id) as num_players from rel_players WHERE league_id = 3804 AND teamId = 2440
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 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 = 9995 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024  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 = '2440' 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 = '2440' 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 = '2440' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0059  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 = 9995 WHERE rp.league_id = 9995 AND rp.teamId = 2440 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.0038  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2015 e ON e.player_id = p.id AND e.league_id = 9995 WHERE rp.league_id = 9995 AND rp.teamId = 2440 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 events2015 e ON e.player_id = p.id AND e.league_id = 9995 WHERE rp.league_id = 9995 AND rp.teamId = 2440 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 2440 AND l.year <= 2015 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 `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 = 19700 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 9995 AND t.round = 33 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 `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 = 3759 AND t.round = 33 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 `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 = 10269 AND t.round = 5 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 = 2306 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 10268 AND t.round = 14 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 `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 = 1591 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 `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 = 10267 AND t.round = 14 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 = 1590 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 `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 = 1052 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 = 890 AND t.round = 30 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 `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 = 268 AND t.round = 26 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 `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 = 10279 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 10280 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 10281 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 10283 AND t.round = 26 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 `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 = 15157 AND t.round = 44 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 = 27328 AND t.round = 27 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 `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 = 27329 AND t.round = 27 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 `tables2000` 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 = 27330 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 9995 ORDER BY nameShow LIMIT 100