4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2020/2021
LIGA CHECA
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 34 85 20 86
2 Sparta Praha Sparta Praha 34 82 43 74
3 Jablonec Jablonec 34 59 33 69
4 Slovácko Slovácko 34 58 33 63
5 Viktoria Plzeň Viktoria 34 60 45 58
6 Slovan Liberec Slovan 34 44 32 52
7 Pardubice Pardubice 34 41 42 52
8 Baník Ostrava Baník 34 48 38 49
9 Sigma Olomouc Sigma 34 40 40 45
10 Bohemians 1905 Bohemians 34 40 37 43
11 Mladá Boleslav Mladá 34 49 54 39
12 Karviná Karviná 34 37 49 39
13 České Budějovice České 34 33 47 38
14 FC Trinity Zlín Trinity 34 30 50 32
15 Teplice Teplice 34 34 66 30
16 Zbrojovka Brno Zbrojovka 34 33 57 26
17 Pribram Pribram 34 26 65 25
18 SFC Opava SFC Opava 34 23 71 17
TEMPORADA 2019/2020
LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 5 11 2 85
2 Viktoria Plzeň Viktoria 5 8 2 76
3 Sparta Praha Sparta Praha 5 11 5 60
4 Slovan Liberec Slovan 5 5 13 51
5 Jablonec Jablonec 5 2 11 51
6 Baník Ostrava Baník 5 5 9 47
TEMPORADA 2018/2019
LIGA CHECA GRUPO 1
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 30 72 23 72
2 Viktoria Plzeň Viktoria 30 47 27 68
3 Sparta Praha Sparta Praha 30 52 27 57
4 Jablonec Jablonec 30 53 26 51
5 Baník Ostrava Baník 30 38 36 45
6 Mladá Boleslav Mladá 30 52 44 42
7 Slovan Liberec Slovan 30 33 28 42
8 Sigma Olomouc Sigma 30 37 43 40
9 FC Trinity Zlín Trinity 30 32 40 39
10 Teplice Teplice 30 32 42 36
11 Bohemians 1905 Bohemians 30 29 37 34
12 Slovácko Slovácko 30 32 45 34
13 SFC Opava SFC Opava 30 39 49 33
14 Pribram Pribram 30 33 63 31
15 Karviná Karviná 30 39 53 29
16 FK Dukla Praha Dukla Praha 30 25 62 20
TEMPORADA 2017/2018
LIGA CHECA
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 55 23 66
2 Slavia Praha Slavia Praha 30 50 19 59
3 Jablonec Jablonec 30 49 27 56
4 Sigma Olomouc Sigma 30 41 22 55
5 Sparta Praha Sparta Praha 30 43 25 53
6 Slovan Liberec Slovan 30 37 35 46
7 Bohemians 1905 Bohemians 30 30 29 38
8 Mladá Boleslav Mladá 30 31 43 34
9 Teplice Teplice 30 32 40 34
10 FC Trinity Zlín Trinity 30 31 48 33
11 FK Dukla Praha Dukla Praha 30 32 55 32
12 Slovácko Slovácko 30 23 32 31
13 Baník Ostrava Baník 30 36 43 31
14 Karviná Karviná 30 32 40 30
15 Vysocina Jihlava Vysocina 30 30 48 30
16 Zbrojovka Brno Zbrojovka 30 20 43 24
TEMPORADA 2016/2017
LIGA CHECA
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 30 65 22 69
2 Viktoria Plzeň Viktoria 30 47 21 67
3 Sparta Praha Sparta Praha 30 47 26 57
4 Mladá Boleslav Mladá 30 47 37 49
5 Teplice Teplice 30 38 25 48
6 FC Trinity Zlín Trinity 30 34 35 41
7 FK Dukla Praha Dukla Praha 30 39 35 40
8 Jablonec Jablonec 30 43 38 39
9 Slovan Liberec Slovan 30 31 28 39
10 Karviná Karviná 30 39 49 34
11 Slovácko Slovácko 30 29 38 32
12 Zbrojovka Brno Zbrojovka 30 32 45 32
13 Bohemians 1905 Bohemians 30 22 39 28
14 Vysocina Jihlava Vysocina 30 26 47 27
15 Hradec Králové Hradec 30 29 51 27
16 Pribram Pribram 30 29 61 22
TEMPORADA 2015/2016
LIGA CHECA
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 57 25 71
2 Sparta Praha Sparta Praha 30 61 24 64
3 Slovan Liberec Slovan 30 51 35 58
4 Mladá Boleslav Mladá 30 63 37 57
5 Slavia Praha Slavia Praha 30 48 26 52
6 Zbrojovka Brno Zbrojovka 30 37 38 47
7 Jablonec Jablonec 30 46 39 41
8 Slovácko Slovácko 30 37 51 40
9 Bohemians 1905 Bohemians 30 35 37 37
10 FK Dukla Praha Dukla Praha 30 44 41 35
11 Vysocina Jihlava Vysocina 30 31 54 31
12 Teplice Teplice 30 37 52 30
13 FC Trinity Zlín Trinity 30 34 50 30
14 Sigma Olomouc Sigma 30 35 49 27
15 Pribram Pribram 30 33 53 27
16 Baník Ostrava Baník 30 27 65 14
TEMPORADA 2014/2015
LIGA CHECA
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 70 24 72
2 Sparta Praha Sparta Praha 30 57 20 67
3 Jablonec Jablonec 30 58 22 64
4 Mladá Boleslav Mladá 30 43 34 46
5 Pribram Pribram 30 40 45 43
6 FK Dukla Praha Dukla Praha 30 34 40 41
7 Teplice Teplice 30 41 37 38
8 Bohemians 1905 Bohemians 30 35 41 38
9 Slovácko Slovácko 30 43 46 37
10 Vysocina Jihlava Vysocina 30 33 38 36
11 Slavia Praha Slavia Praha 30 40 45 34
12 Slovan Liberec Slovan 30 39 43 33
13 Zbrojovka Brno Zbrojovka 30 34 45 33
14 Baník Ostrava Baník 30 23 41 33
15 Hradec Králové Hradec 30 26 52 25
16 České Budějovice České 30 29 72 22
TEMPORADA 2013/2014
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 78 19 79
2 Viktoria Plzeň Viktoria 30 64 21 66
3 Mladá Boleslav Mladá 30 54 38 50
4 Slovan Liberec Slovan 30 37 46 48
5 Teplice Teplice 30 51 35 46
6 Slovácko Slovácko 30 43 40 40
7 FK Dukla Praha Dukla Praha 30 35 37 38
8 Vysocina Jihlava Vysocina 30 45 50 37
9 Zbrojovka Brno Zbrojovka 30 32 42 37
10 Baník Ostrava Baník 30 33 43 35
11 Jablonec Jablonec 30 43 53 34
12 Pribram Pribram 30 34 49 34
13 Slavia Praha Slavia Praha 30 24 51 30
14 Bohemians 1905 Bohemians 30 26 40 30
15 Sigma Olomouc Sigma 30 42 60 29
16 Znojmo Znojmo 30 32 49 27
TEMPORADA 2012/2013
LIGA CHECA
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 54 21 65
2 Sparta Praha Sparta Praha 30 55 23 63
3 Slovan Liberec Slovan 30 46 34 54
4 Jablonec Jablonec 30 49 41 49
5 Sigma Olomouc Sigma 30 38 29 47
6 FK Dukla Praha Dukla Praha 30 48 37 46
7 Slavia Praha Slavia Praha 30 41 33 42
8 Mladá Boleslav Mladá 30 34 43 38
9 Slovácko Slovácko 30 37 41 37
10 Vysocina Jihlava Vysocina 30 36 42 36
11 Teplice Teplice 30 36 47 32
12 Pribram Pribram 30 27 39 32
13 Zbrojovka Brno Zbrojovka 30 34 53 32
14 Baník Ostrava Baník 30 34 44 29
15 České Budějovice České 30 24 49 26
16 Hradec Králové Hradec 30 27 44 25
TEMPORADA 2011/2012
LIGA CHECA
Equipo PJ GF GC Puntos
1 Slovan Liberec Slovan 30 68 29 66
2 Sparta Praha Sparta Praha 30 51 25 64
3 Viktoria Plzeň Viktoria 30 66 33 63
4 Mladá Boleslav Mladá 30 49 34 50
5 Teplice Teplice 30 36 30 46
6 FK Dukla Praha Dukla Praha 30 42 35 42
7 Slovácko Slovácko 30 29 32 41
8 Jablonec Jablonec 30 54 43 40
9 Pribram Pribram 30 44 56 39
10 České Budějovice České 30 30 51 35
11 Sigma Olomouc Sigma 30 42 38 34
12 Slavia Praha Slavia Praha 30 28 34 34
13 Hradec Králové Hradec 30 22 38 31
14 Baník Ostrava Baník 30 31 48 28
15 Bohemians 1905 Bohemians 30 20 54 24
16 Viktoria Žižkov Viktoria 30 23 55 19
TEMPORADA 2010/2011
LIGA CHECA
Equipo PJ GF GC Puntos
1 Viktoria Plzeň Viktoria 30 70 28 69
2 Sparta Praha Sparta Praha 30 54 21 68
3 Jablonec Jablonec 30 65 34 58
4 Sigma Olomouc Sigma 30 47 29 47
5 Mladá Boleslav Mladá 30 49 40 46
6 Slovan Liberec Slovan 30 45 36 43
7 Bohemians 1905 Bohemians 30 33 33 43
8 Hradec Králové Hradec 30 26 36 41
9 Slavia Praha Slavia Praha 30 41 36 40
10 Teplice Teplice 30 39 46 39
11 České Budějovice České 30 30 48 33
12 Pribram Pribram 30 22 36 31
13 Slovácko Slovácko 30 27 43 31
14 Baník Ostrava Baník 30 31 46 30
15 Zbrojovka Brno Zbrojovka 30 33 55 24
16 FK Viagem Ústí nad Labem Viagem 30 22 67 19
TEMPORADA 2009/2010
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 42 14 62
2 Jablonec Jablonec 30 42 24 61
3 Baník Ostrava Baník 30 47 25 60
4 Teplice Teplice 30 44 25 55
5 Viktoria Plzeň Viktoria 30 42 33 48
6 Sigma Olomouc Sigma 30 49 36 47
7 Slavia Praha Slavia Praha 30 37 35 41
8 Mladá Boleslav Mladá 30 47 41 39
9 Slovan Liberec Slovan 30 34 39 37
10 Pribram Pribram 30 35 41 36
11 Zbrojovka Brno Zbrojovka 30 31 40 35
12 Bohemians 1905 Bohemians 30 21 29 34
13 České Budějovice České 30 24 35 31
14 Slovácko Slovácko 30 28 42 30
15 SK Kladno SK Kladno 30 24 50 25
16 FK Bohemians (Střížkov) Bohemians 30 27 65 0
TEMPORADA 2008/2009
LIGA CHECA
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 30 57 25 62
2 Sparta Praha Sparta Praha 30 48 25 56
3 Slovan Liberec Slovan 30 41 28 52
4 Sigma Olomouc Sigma 30 39 36 48
5 Jablonec Jablonec 30 43 37 46
6 Mladá Boleslav Mladá 30 39 38 46
7 Teplice Teplice 30 33 25 43
8 Viktoria Plzeň Viktoria 30 45 38 43
9 Baník Ostrava Baník 30 38 36 39
10 České Budějovice České 30 30 37 36
11 Zbrojovka Brno Zbrojovka 30 32 36 35
12 Pribram Pribram 30 30 40 34
13 FK Bohemians (Střížkov) Bohemians 30 33 46 34
14 SK Kladno SK Kladno 30 21 41 31
15 FC Trinity Zlín Trinity 30 26 49 29
16 Viktoria Žižkov Viktoria 30 27 45 22
TEMPORADA 2007/2008
LIGA CHECA
Equipo PJ GF GC Puntos
1 Slavia Praha Slavia Praha 30 45 24 60
2 Sparta Praha Sparta Praha 30 53 26 57
3 Baník Ostrava Baník 30 51 28 55
4 Zbrojovka Brno Zbrojovka 30 43 32 55
5 Teplice Teplice 30 40 27 53
6 Slovan Liberec Slovan 30 35 31 44
7 Mladá Boleslav Mladá 30 37 36 42
8 FC Trinity Zlín Trinity 30 28 31 38
9 Viktoria Plzeň Viktoria 30 32 37 38
10 Viktoria Žižkov Viktoria 30 35 48 37
11 Sigma Olomouc Sigma 30 20 26 36
12 Jablonec Jablonec 30 24 32 33
13 České Budějovice České 30 27 35 32
14 SK Kladno SK Kladno 30 31 45 27
15 Bohemians 1905 Bohemians 30 24 40 26
16 Mostecký Mostecký 30 31 58 20
TEMPORADA 2006/2007
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 44 20 62
2 Slovan Liberec Slovan 30 44 22 58
3 Mladá Boleslav Mladá 30 48 27 58
4 Slavia Praha Slavia Praha 30 44 23 58
5 Baník Ostrava Baník 30 43 33 46
6 Viktoria Plzeň Viktoria 30 35 29 46
7 Zbrojovka Brno Zbrojovka 30 34 32 46
8 Teplice Teplice 30 44 39 42
9 Jablonec Jablonec 30 30 30 38
10 České Budějovice České 30 28 46 34
11 Mostecký Mostecký 30 29 40 31
12 SK Kladno SK Kladno 30 23 37 31
13 FC Trinity Zlín Trinity 30 21 34 27
14 Sigma Olomouc Sigma 30 29 43 26
15 Pribram Pribram 30 15 37 21
16 Slovácko Slovácko 30 20 39 19
TEMPORADA 2005/2006
LIGA CHECA
Equipo PJ GF GC Puntos
1 Slovan Liberec Slovan 30 43 22 59
2 Slavia Praha Slavia Praha 30 56 34 54
3 Mladá Boleslav Mladá 30 50 36 54
4 Teplice Teplice 30 38 24 52
5 Sparta Praha Sparta Praha 30 43 39 45
6 Baník Ostrava Baník 30 35 32 40
7 Slovácko Slovácko 30 29 28 38
8 Jablonec Jablonec 30 35 39 37
9 Sigma Olomouc Sigma 30 34 44 37
10 Mostecký Mostecký 30 34 41 36
11 Zbrojovka Brno Zbrojovka 30 35 36 35
12 FC Trinity Zlín Trinity 30 27 33 35
13 Pribram Pribram 30 36 36 34
14 Viktoria Plzeň Viktoria 30 30 43 31
15 Vysocina Jihlava Vysocina 30 20 36 29
16 Chmel Blšany Chmel 30 22 44 26
TEMPORADA 2004/2005
LIGA CHECA
Equipo PJ GF GC Puntos
1 Sparta Praha Sparta Praha 30 53 28 64
2 Slavia Praha Slavia Praha 30 39 25 53
3 Teplice Teplice 30 36 27 53
4 Sigma Olomouc Sigma 30 39 34 51
5 Slovan Liberec Slovan 30 45 26 46
6 Jablonec Jablonec 30 33 27 45
7 Baník Ostrava Baník 30 33 36 37
8 Drnovice Drnovice 30 30 34 35
9 Pribram Pribram 30 30 41 35
10 FC Trinity Zlín Trinity 30 29 35 33
11 Zbrojovka Brno Zbrojovka 30 30 42 33
12 Slovácko Slovácko 30 30 22 32
13 Chmel Blšany Chmel 30 25 38 32
14 Mladá Boleslav Mladá 30 26 35 31
15 České Budějovice České 30 28 39 25
16 SFC Opava SFC Opava 30 25 42 18
TEMPORADA 2003/2004
LIGA CHECA
Equipo PJ GF GC Puntos
1 Baník Ostrava Baník 30 60 25 63
2 Sparta Praha Sparta Praha 30 48 24 58
3 Sigma Olomouc Sigma 30 43 24 55
4 Slavia Praha Slavia Praha 30 43 24 52
5 Synot Synot 30 43 37 48
6 Slovan Liberec Slovan 30 38 27 46
7 FC Trinity Zlín Trinity 30 31 39 41
8 České Budějovice České 30 38 38 40
9 Teplice Teplice 30 32 32 39
10 Jablonec Jablonec 30 27 32 38
11 Pribram Pribram 30 33 37 37
12 SFC Opava SFC Opava 30 34 55 31
13 Zbrojovka Brno Zbrojovka 30 33 43 30
14 Chmel Blšany Chmel 30 34 54 30
15 Viktoria Žižkov Viktoria 30 18 34 27
16 Viktoria Plzeň Viktoria 30 23 53 19

  USO DE MEMORIA  
7,489,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6540
Total Execution Time  0.6552
  CADENA URL  
/historico/Sparta-Praha/2021
  GET DATOS  
$_GET['/historico/Sparta-Praha/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0216  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 = 59218
0.0116  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 = 58011
0.0107  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10050 AND type_rel = 2
0.0122  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10050 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0119  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 (2898,6745,8526,8917,28406) ORDER BY n.cover_points DESC, update_date DESC
0.0177  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 = '10050' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0115  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 = 59218 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0116  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 = 58011 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0178  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=10050 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (67402,66139,64002,63448,62807,62628,50670) 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.0112  SELECT count(id) as num_players from rel_players WHERE league_id = 67402 AND teamId = 10050
0.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 64002 AND teamId = 10050
0.0113  SELECT count(id) as num_players from rel_players WHERE league_id = 66139 AND teamId = 10050
0.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 62628 AND teamId = 10050
0.0117  SELECT count(id) as num_players from rel_players WHERE league_id = 50670 AND teamId = 10050
0.0115  SELECT count(id) as num_players from rel_players WHERE league_id = 63448 AND teamId = 10050
0.0197  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 10050
0.0107  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 59218 AND t.round = 6 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 = '10050' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10050' and rp.type = 4
0.0112  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 = '10050' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0149  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 events2021 e ON e.player_id = p.id AND e.league_id = 59218 WHERE rp.league_id = 59218 AND rp.teamId = 10050 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 events2021 e ON e.player_id = p.id AND e.league_id = 59218 WHERE rp.league_id = 59218 AND rp.teamId = 10050 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0121  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 events2021 e ON e.player_id = p.id AND e.league_id = 59218 WHERE rp.league_id = 59218 AND rp.teamId = 10050 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0165  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 = 10050 AND l.year <= 2021 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 `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 58011 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 49964 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 56778 AND t.round = 5 ORDER BY team.conference ASC,t.position 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 `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 49595 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 43592 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 38696 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 33331 AND t.round = 30 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 `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 = 15408 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 3883 AND t.round = 30 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 `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 = 2481 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 2041 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 1355 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 1083 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 865 AND t.round = 30 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 `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 = 243 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 `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 = 8741 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  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 = 8745 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120  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 = 8747 AND t.round = 30 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 `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 = 8749 AND t.round = 30 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 `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 = 8750 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC