4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2019/2020
EERSTE DIVISIE
Equipo PJ GF GC Puntos
1 Cambuur Cambuur 29 68 25 66
2 De Graafschap Graafschap 29 63 28 62
3 FC Volendam FC Volendam 29 57 42 55
4 Jong Ajax Jong Ajax 29 72 47 54
5 NAC Breda NAC Breda 29 48 30 50
6 Go Ahead Eagles Ahead Eagles 29 49 41 48
7 Excelsior Excelsior 29 65 55 47
8 NEC Nijmegen Nijmegen 29 51 37 45
9 Almere City Almere City 29 44 42 44
10 SC Telstar SC Telstar 29 47 48 44
11 Den Bosch Den Bosch 29 56 49 38
12 Jong Utrecht Jong Utrecht 29 48 47 38
13 FC Eindhoven Eindhoven 29 46 59 34
14 Jong AZ Jong AZ 29 45 61 28
15 MVV Maastricht Maastricht 29 37 53 27
16 TOP Oss TOP Oss 29 28 53 25
17 Roda JC Roda JC 29 36 52 22
18 Jong PSV Jong PSV 29 34 56 22
19 Dordrecht Dordrecht 29 34 66 20
20 Helmond Sport Helmond 29 25 62 17
TEMPORADA 2018/2019
EERSTE DIVISIE
Equipo PJ GF GC Puntos
1 Twente Twente 38 72 39 80
2 Sparta Rotterdam Sparta 38 78 47 69
3 Jong PSV Jong PSV 38 77 59 63
4 Den Bosch Den Bosch 38 64 49 63
5 Go Ahead Eagles Ahead Eagles 38 63 57 63
6 TOP Oss TOP Oss 38 48 40 62
7 Almere City Almere City 38 60 63 62
8 RKC Waalwijk Waalwijk 38 69 57 59
9 NEC Nijmegen Nijmegen 38 73 60 58
10 Cambuur Cambuur 38 61 48 58
11 Jong Ajax Jong Ajax 38 81 67 56
12 MVV Maastricht Maastricht 38 49 53 54
13 Roda JC Roda JC 38 57 59 53
14 FC Eindhoven Eindhoven 38 52 48 48
15 SC Telstar SC Telstar 38 45 58 48
16 FC Volendam FC Volendam 38 46 62 41
17 Dordrecht Dordrecht 38 54 84 36
18 Jong AZ Jong AZ 38 46 67 33
19 Jong Utrecht Jong Utrecht 38 47 90 23
20 Helmond Sport Helmond 38 37 72 22
TEMPORADA 2017/2018
EREDIVISIE
Equipo PJ GF GC Puntos
1 PSV PSV 34 87 39 83
2 Ajax Ajax 34 89 33 79
3 AZ Alkmaar AZ Alkmaar 34 72 38 71
4 Feyenoord Feyenoord 34 76 39 66
5 Utrecht Utrecht 34 58 53 54
6 Vitesse Vitesse 34 63 47 49
7 ADO Den Haag Haag 34 45 53 47
8 Heerenveen Heerenveen 34 48 53 46
9 PEC Zwolle PEC Zwolle 34 42 54 44
10 Heracles Heracles 34 50 64 42
11 Excelsior Excelsior 34 41 56 40
12 Groningen Groningen 34 50 50 38
13 Willem II Willem II 34 50 63 37
14 NAC Breda NAC Breda 34 41 57 34
15 VVV Venlo VVV Venlo 34 35 54 34
16 Roda JC Roda JC 34 42 69 30
17 Sparta Rotterdam Sparta 34 34 75 27
18 Twente Twente 34 37 63 24
TEMPORADA 2016/2017
EREDIVISIE
Equipo PJ GF GC Puntos
1 Feyenoord Feyenoord 34 86 25 82
2 Ajax Ajax 34 79 23 81
3 PSV PSV 34 68 23 76
4 Utrecht Utrecht 34 54 38 62
5 Vitesse Vitesse 34 51 40 51
6 AZ Alkmaar AZ Alkmaar 34 56 52 49
7 Twente Twente 34 48 50 45
8 Groningen Groningen 34 55 51 43
9 Heerenveen Heerenveen 34 54 53 43
10 Heracles Heracles 34 53 55 43
11 ADO Den Haag Haag 34 37 59 38
12 Excelsior Excelsior 34 43 60 37
13 Willem II Willem II 34 29 44 36
14 PEC Zwolle PEC Zwolle 34 39 67 35
15 Sparta Rotterdam Sparta 34 42 61 34
16 NEC Nijmegen Nijmegen 34 32 59 34
17 Roda JC Roda JC 34 26 51 33
18 Go Ahead Eagles Ahead Eagles 34 32 73 23
TEMPORADA 2015/2016
EREDIVISIE
Equipo PJ GF GC Puntos
1 PSV PSV 34 88 32 84
2 Ajax Ajax 34 81 21 82
3 Feyenoord Feyenoord 34 62 40 63
4 AZ Alkmaar AZ Alkmaar 34 70 53 59
5 Utrecht Utrecht 34 57 48 53
6 Heracles Heracles 34 47 49 51
7 Groningen Groningen 34 41 48 50
8 PEC Zwolle PEC Zwolle 34 56 54 48
9 Vitesse Vitesse 34 55 38 46
10 NEC Nijmegen Nijmegen 34 37 42 46
11 ADO Den Haag Haag 34 48 49 43
12 Twente Twente 34 49 64 43
13 Heerenveen Heerenveen 34 46 61 42
14 Roda JC Roda JC 34 34 55 34
15 Excelsior Excelsior 34 34 60 30
16 Willem II Willem II 34 35 53 29
17 De Graafschap Graafschap 34 39 66 23
18 Cambuur Cambuur 34 33 79 18
TEMPORADA 2014/2015
EERSTE DIVISIE
Equipo PJ GF GC Puntos
1 NEC Nijmegen Nijmegen 38 100 32 101
2 FC Eindhoven Eindhoven 38 70 39 80
3 Roda JC Roda JC 38 69 58 69
4 Emmen Emmen 38 88 57 67
5 FC Volendam FC Volendam 38 83 68 62
6 De Graafschap Graafschap 38 73 49 61
7 VVV Venlo VVV Venlo 38 48 43 60
8 Sparta Rotterdam Sparta 38 72 46 58
9 TOP Oss TOP Oss 38 73 67 56
10 Almere City Almere City 38 64 63 48
11 MVV Maastricht Maastricht 38 51 70 48
12 Jong Ajax Jong Ajax 38 64 67 47
13 Jong Twente Jong Twente 38 49 64 47
14 Jong PSV Jong PSV 38 50 56 46
15 SC Telstar SC Telstar 38 53 68 42
16 Den Bosch Den Bosch 38 46 61 39
17 Helmond Sport Helmond 38 52 85 38
18 Achilles 29 Achilles 29 38 44 71 33
19 Fortuna Sittard Fortuna 38 30 72 29
20 RKC Waalwijk Waalwijk 38 39 82 29
TEMPORADA 2013/2014
EREDIVISIE
Equipo PJ GF GC Puntos
1 Ajax Ajax 34 69 28 71
2 Feyenoord Feyenoord 34 76 40 67
3 Twente Twente 34 72 37 63
4 PSV PSV 34 60 45 59
5 Heerenveen Heerenveen 34 72 51 57
6 Vitesse Vitesse 34 65 49 55
7 Groningen Groningen 34 57 53 51
8 AZ Alkmaar AZ Alkmaar 34 54 50 47
9 ADO Den Haag Haag 34 45 64 43
10 Utrecht Utrecht 34 46 65 41
11 PEC Zwolle PEC Zwolle 34 47 49 40
12 Cambuur Cambuur 34 40 50 39
13 Go Ahead Eagles Ahead Eagles 34 45 69 38
14 Heracles Heracles 34 45 59 37
15 NAC Breda NAC Breda 34 43 54 35
16 RKC Waalwijk Waalwijk 34 44 64 32
17 NEC Nijmegen Nijmegen 34 54 82 30
18 Roda JC Roda JC 34 44 69 29
TEMPORADA 2012/2013
EREDIVISIE
Equipo PJ GF GC Puntos
1 Ajax Ajax 34 83 31 76
2 PSV PSV 34 103 43 69
3 Feyenoord Feyenoord 34 64 38 69
4 Vitesse Vitesse 34 68 42 64
5 Utrecht Utrecht 34 55 41 63
6 Twente Twente 34 60 33 62
7 Groningen Groningen 34 36 53 43
8 Heerenveen Heerenveen 34 50 63 42
9 ADO Den Haag Haag 34 49 63 40
10 AZ Alkmaar AZ Alkmaar 34 56 54 39
11 PEC Zwolle PEC Zwolle 34 42 55 39
12 Heracles Heracles 34 58 71 38
13 NAC Breda NAC Breda 34 40 56 38
14 RKC Waalwijk Waalwijk 34 39 48 37
15 NEC Nijmegen Nijmegen 34 44 66 37
16 Roda JC Roda JC 34 51 69 33
17 VVV Venlo VVV Venlo 34 33 62 28
18 Willem II Willem II 34 33 76 23
TEMPORADA 2011/2012
EREDIVISIE
Equipo PJ GF GC Puntos
1 Ajax Ajax 34 93 36 76
2 Feyenoord Feyenoord 34 70 37 70
3 PSV PSV 34 87 47 69
4 AZ Alkmaar AZ Alkmaar 34 64 35 65
5 Heerenveen Heerenveen 34 79 59 64
6 Twente Twente 34 82 46 60
7 Vitesse Vitesse 34 48 43 53
8 NEC Nijmegen Nijmegen 34 41 45 45
9 RKC Waalwijk Waalwijk 34 40 49 45
10 Roda JC Roda JC 34 55 70 44
11 Utrecht Utrecht 34 55 58 43
12 Heracles Heracles 34 52 62 40
13 NAC Breda NAC Breda 34 44 55 38
14 Groningen Groningen 34 41 61 37
15 ADO Den Haag Haag 34 38 66 32
16 VVV Venlo VVV Venlo 34 43 77 31
17 De Graafschap Graafschap 34 36 74 24
18 Excelsior Excelsior 34 28 76 19
TEMPORADA 2010/2011
EREDIVISIE
Equipo PJ GF GC Puntos
1 Ajax Ajax 34 72 30 73
2 Twente Twente 34 65 34 71
3 PSV PSV 34 79 34 69
4 AZ Alkmaar AZ Alkmaar 34 55 44 59
5 Groningen Groningen 34 65 52 57
6 Roda JC Roda JC 34 65 50 55
7 ADO Den Haag Haag 34 63 55 54
8 Heracles Heracles 34 65 56 49
9 Utrecht Utrecht 34 55 51 47
10 Feyenoord Feyenoord 34 53 54 44
11 NEC Nijmegen Nijmegen 34 57 56 43
12 Heerenveen Heerenveen 34 60 54 41
13 NAC Breda NAC Breda 34 44 60 40
14 De Graafschap Graafschap 34 31 56 38
15 Vitesse Vitesse 34 42 61 35
16 Excelsior Excelsior 34 45 66 35
17 VVV Venlo VVV Venlo 34 34 76 21
18 Willem II Willem II 34 37 98 15
TEMPORADA 2009/2010
EREDIVISIE
Equipo PJ GF GC Puntos
1 Twente Twente 34 63 23 86
2 Ajax Ajax 34 106 20 85
3 PSV PSV 34 72 29 78
4 Feyenoord Feyenoord 34 54 31 63
5 AZ Alkmaar AZ Alkmaar 34 64 34 62
6 Heracles Heracles 34 54 49 56
7 Utrecht Utrecht 34 39 33 53
8 Groningen Groningen 34 48 47 49
9 Roda JC Roda JC 34 56 60 47
10 NAC Breda NAC Breda 34 42 49 46
11 Heerenveen Heerenveen 34 44 64 37
12 VVV Venlo VVV Venlo 34 43 57 35
13 NEC Nijmegen Nijmegen 34 35 59 33
14 Vitesse Vitesse 34 38 62 32
15 ADO Den Haag Haag 34 38 59 30
16 Sparta Rotterdam Sparta 34 30 66 26
17 Willem II Willem II 34 36 70 23
18 RKC Waalwijk Waalwijk 34 30 80 15
TEMPORADA 2008/2009
EREDIVISIE
Equipo PJ GF GC Puntos
1 AZ Alkmaar AZ Alkmaar 34 66 22 80
2 Twente Twente 34 62 31 69
3 Ajax Ajax 34 74 41 68
4 PSV PSV 34 71 33 65
5 Heerenveen Heerenveen 34 66 57 60
6 Groningen Groningen 34 53 36 56
7 Feyenoord Feyenoord 34 54 46 45
8 NAC Breda NAC Breda 34 44 54 45
9 Utrecht Utrecht 34 41 44 44
10 Vitesse Vitesse 34 41 48 43
11 NEC Nijmegen Nijmegen 34 41 40 42
12 Willem II Willem II 34 35 58 37
13 Sparta Rotterdam Sparta 34 46 66 35
14 ADO Den Haag Haag 34 41 58 32
15 Heracles Heracles 34 35 53 32
16 Roda JC Roda JC 34 38 58 30
17 De Graafschap Graafschap 34 24 58 30
18 FC Volendam FC Volendam 34 38 67 29
TEMPORADA 2007/2008
EREDIVISIE
Equipo PJ GF GC Puntos
1 PSV PSV 34 65 24 72
2 Ajax Ajax 34 94 45 69
3 NAC Breda NAC Breda 34 48 40 63
4 Twente Twente 34 52 32 62
5 Heerenveen Heerenveen 34 88 48 60
6 Feyenoord Feyenoord 34 64 41 60
7 Groningen Groningen 34 53 54 51
8 NEC Nijmegen Nijmegen 34 49 50 49
9 Roda JC Roda JC 34 55 55 47
10 Utrecht Utrecht 34 59 55 46
11 AZ Alkmaar AZ Alkmaar 34 48 53 43
12 Vitesse Vitesse 34 46 55 43
13 Sparta Rotterdam Sparta 34 52 76 34
14 Heracles Heracles 34 34 64 32
15 Willem II Willem II 34 40 49 31
16 De Graafschap Graafschap 34 33 64 30
17 VVV Venlo VVV Venlo 34 44 76 29
18 Excelsior Excelsior 34 32 75 27
TEMPORADA 2006/2007
EREDIVISIE
Equipo PJ GF GC Puntos
1 PSV PSV 34 75 25 75
2 Ajax Ajax 34 84 35 75
3 AZ Alkmaar AZ Alkmaar 34 83 31 72
4 Twente Twente 34 67 37 66
5 Heerenveen Heerenveen 34 60 43 55
6 Roda JC Roda JC 34 47 36 54
7 Feyenoord Feyenoord 34 56 66 53
8 Groningen Groningen 34 54 54 51
9 Utrecht Utrecht 34 41 44 48
10 NEC Nijmegen Nijmegen 34 36 44 44
11 NAC Breda NAC Breda 34 43 54 43
12 Vitesse Vitesse 34 50 55 38
13 Sparta Rotterdam Sparta 34 40 66 37
14 Heracles Heracles 34 32 64 32
15 Willem II Willem II 34 31 64 31
16 Excelsior Excelsior 34 43 65 30
17 RKC Waalwijk Waalwijk 34 33 60 27
18 ADO Den Haag Haag 34 40 72 17
TEMPORADA 2005/2006
EREDIVISIE
Equipo PJ GF GC Puntos
1 PSV PSV 34 71 23 84
2 AZ Alkmaar AZ Alkmaar 34 78 32 74
3 Feyenoord Feyenoord 34 79 34 71
4 Ajax Ajax 34 66 41 60
5 Groningen Groningen 34 46 43 56
6 Utrecht Utrecht 34 48 44 55
7 Heerenveen Heerenveen 34 63 58 50
8 Roda JC Roda JC 34 57 54 50
9 Twente Twente 34 44 36 47
10 NEC Nijmegen Nijmegen 34 43 43 47
11 Vitesse Vitesse 34 52 54 44
12 RKC Waalwijk Waalwijk 34 48 58 39
13 Heracles Heracles 34 35 58 39
14 Sparta Rotterdam Sparta 34 34 50 37
15 ADO Den Haag Haag 34 36 62 35
16 NAC Breda NAC Breda 34 45 66 33
17 Willem II Willem II 34 45 66 28
18 RBC Roosendaal Roosendaal 34 22 90 9
TEMPORADA 2004/2005
EREDIVISIE
Equipo PJ GF GC Puntos
1 PSV PSV 34 89 18 87
2 Ajax Ajax 34 74 33 77
3 AZ Alkmaar AZ Alkmaar 34 71 41 64
4 Feyenoord Feyenoord 34 90 51 62
5 Heerenveen Heerenveen 34 64 52 60
6 Twente Twente 34 48 38 54
7 Vitesse Vitesse 34 53 49 54
8 Roda JC Roda JC 34 60 55 47
9 RKC Waalwijk Waalwijk 34 44 51 47
10 Willem II Willem II 34 44 56 45
11 Utrecht Utrecht 34 40 43 44
12 Groningen Groningen 34 50 58 40
13 NEC Nijmegen Nijmegen 34 41 47 37
14 ADO Den Haag Haag 34 44 59 36
15 NAC Breda NAC Breda 34 43 67 35
16 RBC Roosendaal Roosendaal 34 38 77 32
17 De Graafschap Graafschap 34 32 78 19
18 Den Bosch Den Bosch 34 23 75 19
TEMPORADA 2003/2004
EREDIVISIE
Equipo PJ GF GC Puntos
1 Ajax Ajax 34 79 31 80
2 PSV PSV 34 92 30 74
3 Feyenoord Feyenoord 34 71 38 68
4 Heerenveen Heerenveen 34 45 35 58
5 AZ Alkmaar AZ Alkmaar 34 65 42 57
6 Roda JC Roda JC 34 60 41 53
7 Willem II Willem II 34 47 54 49
8 Twente Twente 34 56 53 48
9 NAC Breda NAC Breda 34 58 55 46
10 Utrecht Utrecht 34 42 52 46
11 RKC Waalwijk Waalwijk 34 47 55 40
12 RBC Roosendaal Roosendaal 34 34 47 40
13 Groningen Groningen 34 38 53 37
14 NEC Nijmegen Nijmegen 34 44 62 34
15 ADO Den Haag Haag 34 36 61 34
16 Vitesse Vitesse 34 39 56 28
17 FC Volendam FC Volendam 34 31 79 27
18 PEC Zwolle PEC Zwolle 34 27 67 26
TEMPORADA 2002/2003
EREDIVISIE
Equipo PJ GF GC Puntos
1 PSV PSV 34 87 20 84
2 Ajax Ajax 34 96 32 83
3 Feyenoord Feyenoord 34 89 39 80
4 NAC Breda NAC Breda 34 42 31 52
5 NEC Nijmegen Nijmegen 34 41 40 51
6 Roda JC Roda JC 34 58 54 50
7 Heerenveen Heerenveen 34 61 55 47
8 Utrecht Utrecht 34 49 49 47
9 RKC Waalwijk Waalwijk 34 44 51 46
10 AZ Alkmaar AZ Alkmaar 34 50 69 44
11 Willem II Willem II 34 48 51 42
12 Twente Twente 34 36 45 41
13 RBC Roosendaal Roosendaal 34 33 54 36
14 Vitesse Vitesse 34 37 51 33
15 Groningen Groningen 34 28 44 32
16 PEC Zwolle PEC Zwolle 34 31 62 32
17 Excelsior Excelsior 34 38 72 23
18 De Graafschap Graafschap 34 35 84 23
TEMPORADA 2001/2002
EREDIVISIE
Equipo PJ GF GC Puntos
1 Ajax Ajax 34 73 34 73
2 PSV PSV 34 77 32 68
3 Feyenoord Feyenoord 34 68 29 64
4 Heerenveen Heerenveen 34 57 27 60
5 Vitesse Vitesse 34 45 34 60
6 NAC Breda NAC Breda 34 55 52 54
7 Utrecht Utrecht 34 60 51 51
8 RKC Waalwijk Waalwijk 34 49 44 48
9 NEC Nijmegen Nijmegen 34 38 59 45
10 AZ Alkmaar AZ Alkmaar 34 43 45 43
11 Willem II Willem II 34 54 61 43
12 Twente Twente 34 41 41 42
13 Roda JC Roda JC 34 33 45 41
14 De Graafschap Graafschap 34 43 55 37
15 Groningen Groningen 34 40 59 37
16 Den Bosch Den Bosch 34 40 55 33
17 Sparta Rotterdam Sparta 34 26 75 24
18 Fortuna Sittard Fortuna 34 27 71 17
TEMPORADA 2000/2001
EREDIVISIE
Equipo PJ GF GC Puntos
1 PSV PSV 34 73 23 83
2 Feyenoord Feyenoord 34 67 37 66
3 Ajax Ajax 34 85 43 61
4 Roda JC Roda JC 34 59 41 59
5 Utrecht Utrecht 34 58 43 59
6 Vitesse Vitesse 34 56 43 59
7 RKC Waalwijk Waalwijk 34 48 36 59
8 Willem II Willem II 34 60 50 51
9 NAC Breda NAC Breda 34 41 40 49
10 Heerenveen Heerenveen 34 51 42 47
11 Twente Twente 34 47 60 41
12 NEC Nijmegen Nijmegen 34 42 53 40
13 AZ Alkmaar AZ Alkmaar 34 45 63 35
14 Groningen Groningen 34 36 56 33
15 De Graafschap Graafschap 34 44 66 31
16 Fortuna Sittard Fortuna 34 31 64 31
17 Sparta Rotterdam Sparta 34 42 72 25
18 RBC Roosendaal Roosendaal 34 37 90 14

  USO DE MEMORIA  
8,410,992 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.7334
Total Execution Time  0.7352
  CADENA URL  
/historico/Roda-Jc/2020
  GET DATOS  
$_GET['/historico/Roda-Jc/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0252  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 = 49963
0.0153  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 = 50502
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2174 AND type_rel = 2
0.0161  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2174 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0132  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 (36959,94499,99108,112706,142450) ORDER BY n.cover_points DESC, update_date DESC
0.0147  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 = '2174' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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 = 50502 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 49963 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  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=2174 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (62608,58234,57108,56547) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 57108 AND teamId = 2174
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 62608 AND teamId = 2174
0.0142  SELECT count(id) as num_players from rel_players WHERE league_id = 58234 AND teamId = 2174
0.0244  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 2174
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 `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 = 49963 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '2174' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2174' and rp.type = 4
0.0129  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 = '2174' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0125  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '2174' and rp.type = 4
0.0150  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 events2020 e ON e.player_id = p.id AND e.league_id = 49963 WHERE rp.league_id = 49963 AND rp.teamId = 2174 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.0140  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 events2020 e ON e.player_id = p.id AND e.league_id = 49963 WHERE rp.league_id = 49963 AND rp.teamId = 2174 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 events2020 e ON e.player_id = p.id AND e.league_id = 49963 WHERE rp.league_id = 49963 AND rp.teamId = 2174 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 2174 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,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 = 49963 AND t.round = 29 ORDER BY team.conference ASC,t.position 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 `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 = 43835 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 38711 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 30786 AND t.round = 34 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 = 15117 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 3873 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 2450 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 1911 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 1329 AND t.round = 34 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 `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 = 1090 AND t.round = 34 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 = 817 AND t.round = 34 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 `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 = 280 AND t.round = 34 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 `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 = 28 AND t.round = 34 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 `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 = 66 AND t.round = 34 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 `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 = 65 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 64 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 63 AND t.round = 34 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 `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 = 62 AND t.round = 34 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 `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 = 61 AND t.round = 35 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 `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 = 180 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 49963 ORDER BY nameShow LIMIT 100