4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Pumarín CF
TEMPORADA 2023/2024
SEGUNDA RFFPA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Turón CD Turón 31 69 22 76
2 UD San Claudio Claudio 31 77 32 66
3 Europa de Nava Europa Nava 31 55 24 66
4 Nalón CF Nalón CF 31 48 23 59
5 Grujoan Grujoan 31 57 34 55
6 Madalena Madalena 31 61 53 53
7 Real Juvencia Real 31 48 41 51
8 UP Langreo B Langreo 31 61 48 46
9 Ribadesella Ribadesella 31 54 36 43
10 CD San Jorge Jorge 31 41 39 42
11 Pumarín CF Pumarín CF 31 37 40 41
12 Quintueles CF Quintueles 31 42 63 33
13 Ribadedeva Ribadedeva 31 34 47 32
14 Lealtad de Villaviciosa B Lealtad 31 42 64 26
15 Arguero CF Arguero CF 31 31 66 25
16 CD La Manjoya Manjoya 31 23 51 24
17 Rosal FC Rosal FC 31 31 83 20
18 Santa Marina de Mieres Santa Marina 31 23 68 15
TEMPORADA 2022/2023
SEGUNDA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Club Siero Club Siero 34 69 28 77
2 Club Asturias de Blimea Club 34 69 23 71
3 Unión Comercial Unión 34 76 45 68
4 Nalón CF Nalón CF 34 66 39 67
5 UD San Claudio Claudio 34 63 36 66
6 CD Turón CD Turón 34 68 42 60
7 Grujoan Grujoan 34 53 51 58
8 Real Juvencia Real 34 55 45 52
9 Pumarín CF Pumarín CF 34 53 52 52
10 Madalena Madalena 34 69 64 51
11 Ribadesella Ribadesella 34 56 61 44
12 Ribadedeva Ribadedeva 34 46 66 42
13 Europa de Nava Europa Nava 34 51 57 40
14 Juventud Estadio Juventud 34 45 62 29
15 Urraca CF B Urraca CF B 34 35 58 23
16 Canicas AC Canicas AC 34 37 87 21
17 Atlético Siero Atlético 34 42 93 21
18 Celtic de Puerto Celtic 34 35 79 19
TEMPORADA 2021/2022
SEGUNDA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Universidad Oviedo Universidad 24 64 27 54
2 Real Juvencia Real 24 58 28 50
3 CD Turón CD Turón 24 50 29 49
4 Pumarín CF Pumarín CF 24 50 26 45
5 Grujoan Grujoan 24 49 31 43
6 Covadonga B Covadonga B 24 40 42 36
7 CD La Manjoya Manjoya 24 41 38 33
8 Celtic de Puerto Celtic 24 36 47 33
9 La Corredoria Corredoria 24 40 57 24
10 SCD Campomanes Campomanes 24 33 57 23
11 Guillen Lafuerza Guillen 24 33 56 19
12 UD San Claudio B Claudio 24 34 65 19
13 Condal Club B Condal Club 24 38 63 16
TEMPORADA 2020/2021
SEGUNDA RFFPA GRUPO 3
Equipo PJ GF GC Puntos
1 Real Juvencia Real 8 21 12 16
2 La Corredoria Corredoria 8 14 20 11
3 UD San Claudio B Claudio 8 15 15 10
4 Pumarín CF Pumarín CF 8 14 16 10
5 Juventud Estadio Juventud 8 11 12 9
TEMPORADA 2014/2015
SEGUNDA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Nalón CF Nalón CF 34 96 21 81
2 Pumarín CF Pumarín CF 34 80 44 72
3 Vallobin CD Vallobin CD 34 90 41 71
4 Deportiva Piloñesa Deportiva 34 75 45 70
5 Real Juvencia Real 34 77 48 64
6 Ribadesella Ribadesella 34 64 39 63
7 Asturias de Blimea Asturias 34 61 42 61
8 Villaviciosa EIF Villaviciosa 34 69 55 57
9 Real Titánico Real 34 62 46 53
10 Beredi FS Beredi FS 34 64 64 51
11 Arguero CF Arguero CF 34 63 53 47
12 Caudal Deportivo B Caudal 34 53 63 40
13 Juventud Estadio Juventud 34 43 48 33
14 Grujoan CD Grujoan CD 34 43 71 29
15 Santiago De Aller Santiago 34 32 88 27
16 Iberia Bimenes CF Iberia 34 36 84 22
17 Celtic de Puerto Celtic 34 36 78 18
18 Riosa CD Riosa CD 34 26 140 10
TEMPORADA 2013/2014
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 TSK Roces TSK Roces 38 75 32 77
2 Llanes Llanes 38 86 41 76
3 Astur Astur 38 71 38 76
4 Mosconia Mosconia 38 78 38 70
5 CD Colunga CD Colunga 38 68 44 66
6 CD Rayo Carbayín Rayo 38 67 50 61
7 Navarro Navarro 38 47 35 61
8 Valdesoto Valdesoto 38 59 46 55
9 Atlético Siero Atlético 38 56 53 52
10 Sd Llano 2000 Llano 2000 38 46 44 52
11 Tineo Tineo 38 38 47 51
12 UD Llanera UD Llanera 38 58 56 50
13 Muros Balompié Muros 38 56 54 50
14 U.Comercial U.Comercial 38 50 52 49
15 CD Turón CD Turón 38 68 69 47
16 Boal CF Boal CF 38 51 59 46
17 SCD Campomanes Campomanes 38 54 65 45
18 Nalón CF Nalón CF 38 34 54 39
19 Pumarín CF Pumarín CF 38 53 65 31
20 Navia CF Navia CF 38 21 194 3
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Caudal Deportivo Caudal 38 90 21 91
2 Real Avilés Industrial Real Avilés 38 84 27 89
3 Langreo Langreo 38 60 30 70
4 CD Tuilla CD Tuilla 38 50 35 66
5 Condal Condal 38 48 37 62
6 Candás CF Candás CF 38 51 41 61
7 Luarca CF Luarca CF 38 36 40 56
8 Universidad Oviedo Universidad 38 58 53 56
9 Llanes Llanes 38 46 40 55
10 Cudillero CD Cudillero 38 53 39 55
11 CD Covadonga Covadonga 38 66 54 53
12 Navia CF Navia CF 38 36 55 46
13 UD Gijón Industrial Gijón 38 35 51 45
14 Lealtad Villaviciosa Lealtad 38 41 62 44
15 Navarro Navarro 38 44 60 42
16 UC Ceares UC Ceares 38 40 62 40
17 Real Oviedo Vetusta Real Oviedo 38 40 55 40
18 Nalón Olloniego Nalón 38 42 71 37
19 Pumarín CF Pumarín CF 38 31 51 37
20 Colloto Colloto 38 31 98 12
TEMPORADA 2010/2011
PRIMERA RFFPA
Equipo PJ GF GC Puntos
1 CD Covadonga Covadonga 38 70 18 91
2 Colloto Colloto 38 74 41 73
3 Pumarín CF Pumarín CF 38 51 23 70
4 Atlético de Lugones Atlético 38 59 39 66
5 Tineo Tineo 38 47 38 66
6 Urraca CF Urraca CF 38 64 62 53
7 Narcea Narcea 38 39 51 53
8 Valdesoto Valdesoto 38 52 52 52
9 La Caridad La Caridad 38 47 48 51
10 SCD Campomanes Campomanes 38 59 51 50
11 Real Avilés Industrial B Real Avilés 38 50 49 50
12 L´Entregu CF L´Entregu 38 50 47 48
13 Club Siero Club Siero 38 49 62 48
14 Universidad de Oviedo B Universidad 38 52 68 46
15 U.Comercial U.Comercial 38 43 59 45
16 San Martín San Martín 38 57 64 44
17 Deportiva Piloñesa Deportiva 38 43 64 44
18 Mosconia Mosconia 38 52 70 42
19 Astur Astur 38 45 62 37
20 UD Llanera UD Llanera 38 37 72 26
TEMPORADA 2003/2004
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Real Oviedo Real Oviedo 38 70 17 90
2 Astur Astur 38 81 32 80
3 Sporting Atlético Sporting 38 76 30 77
4 Marino de Luanco Marino 38 63 32 69
5 Langreo Langreo 38 57 33 65
6 Universidad Oviedo Universidad 38 50 44 60
7 Lealtad Villaviciosa Lealtad 38 64 43 59
8 Real Titánico Real 38 52 42 59
9 Ribadesella Ribadesella 38 44 46 55
10 UC Ceares UC Ceares 38 41 45 52
11 UD Gijón Industrial Gijón 38 40 57 50
12 Llanes Llanes 38 45 56 45
13 San Martín San Martín 38 39 55 45
14 Club Siero Club Siero 38 28 39 43
15 Mosconia Mosconia 38 40 59 39
16 Club Hispano Club Hispano 38 28 54 37
17 Pumarín CF Pumarín CF 38 30 58 35
18 Condal Condal 38 28 54 31
19 SD Lenense Proinastur Lenense 38 27 78 24
20 Navia CF Navia CF 38 37 66 22
TEMPORADA 2002/2003
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Caudal Deportivo Caudal 38 59 17 85
2 Real Titánico Real 38 71 26 81
3 Sporting Atlético Sporting 38 71 28 77
4 Real Oviedo Vetusta Real Oviedo 38 67 26 75
5 Universidad Oviedo Universidad 38 71 34 70
6 Lealtad Villaviciosa Lealtad 38 68 34 64
7 UD Gijón Industrial Gijón 38 46 36 61
8 Astur Astur 38 52 33 61
9 Club Siero Club Siero 38 54 47 57
10 Llanes Llanes 38 47 36 53
11 Club Hispano Club Hispano 38 47 49 52
12 Condal Condal 38 50 61 45
13 Navia CF Navia CF 38 44 61 45
14 Mosconia Mosconia 38 37 45 41
15 Pumarín CF Pumarín CF 38 39 67 39
16 CD Covadonga Covadonga 38 33 55 35
17 Narcea Narcea 38 34 71 32
18 Navarro Navarro 38 42 57 32
19 Colloto Colloto 38 29 89 25
20 CD Turón CD Turón 38 22 111 10
TEMPORADA 2001/2002
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Langreo Langreo 38 57 24 79
2 Real Avilés Industrial Real Avilés 38 75 26 78
3 Club Siero Club Siero 38 75 34 76
4 Ribadesella Ribadesella 38 62 34 66
5 Pumarín CF Pumarín CF 38 54 46 61
6 San Martín San Martín 38 41 33 60
7 Llanes Llanes 38 53 48 59
8 Colloto Colloto 38 47 41 59
9 Navarro Navarro 38 57 44 59
10 Real Titánico Real 38 46 45 55
11 Lealtad Villaviciosa Lealtad 38 57 56 52
12 Mosconia Mosconia 38 44 50 51
13 Navia CF Navia CF 38 53 58 48
14 Astur Astur 38 42 44 47
15 Narcea Narcea 38 35 49 45
16 Condal Condal 38 39 54 43
17 CD Turón CD Turón 38 35 70 33
18 Piloñesa Piloñesa 38 29 64 25
19 Valdesoto Valdesoto 38 33 80 21
20 San Lazaro SD Lazaro 38 31 65 21
TEMPORADA 2000/2001
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Marino de Luanco Marino 38 77 28 82
2 Real Oviedo Vetusta Real Oviedo 38 66 28 78
3 Langreo Langreo 38 75 33 76
4 Lealtad Villaviciosa Lealtad 38 69 40 75
5 Astur Astur 38 60 40 60
6 Navia CF Navia CF 38 58 50 59
7 Real Avilés Industrial Real Avilés 38 56 43 56
8 Real Titánico Real 38 50 55 56
9 San Martín San Martín 38 61 47 55
10 CD Turón CD Turón 38 46 50 50
11 Colloto Colloto 38 47 39 47
12 Mosconia Mosconia 38 53 48 47
13 Pumarín CF Pumarín CF 38 37 56 45
14 Valdesoto Valdesoto 38 54 73 44
15 Ribadesella Ribadesella 38 41 64 41
16 CD Trasona CD Trasona 38 36 60 41
17 Deportiva Piloñesa Deportiva 38 48 62 40
18 Llanes Llanes 38 41 69 39
19 CD Tuilla CD Tuilla 38 40 69 37
20 CD Covadonga Covadonga 38 29 90 20
TEMPORADA 1998/1999
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Marino de Luanco Marino 38 72 30 76
2 Club Siero Club Siero 38 60 35 67
3 Navia CF Navia CF 38 67 51 65
4 Real Titánico Real 38 63 47 64
5 San Martín San Martín 38 53 31 63
6 CD Tuilla CD Tuilla 38 63 43 59
7 Universidad Oviedo Universidad 38 56 43 58
8 Navarro Navarro 38 62 62 57
9 Colloto Colloto 38 43 42 55
10 Ribadesella Ribadesella 38 42 44 49
11 Andés Andés 38 35 49 48
12 Narcea Narcea 38 38 41 47
13 UD Gijón Industrial Gijón 38 49 58 47
14 Mosconia Mosconia 38 33 45 46
15 Deportiva Piloñesa Deportiva 38 46 61 46
16 Europa de Nava Europa Nava 38 34 42 42
17 Candás CF Candás CF 38 25 40 41
18 CD Covadonga Covadonga 38 52 69 41
19 Pumarín CF Pumarín CF 38 33 64 32
20 CD Trasona CD Trasona 38 40 69 31
TEMPORADA 1997/1998
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Lealtad Villaviciosa Lealtad 38 75 36 82
2 Universidad Oviedo Universidad 38 64 41 70
3 Club Siero Club Siero 38 58 32 67
4 San Martín San Martín 38 50 33 64
5 Navia CF Navia CF 38 56 37 63
6 Pumarín CF Pumarín CF 38 40 30 61
7 Narcea Narcea 38 46 41 60
8 Marino de Luanco Marino 38 44 39 53
9 CD Tuilla CD Tuilla 38 47 42 50
10 Andés Andés 38 45 48 49
11 Candás CF Candás CF 38 39 45 48
12 Ribadesella Ribadesella 38 43 55 47
13 Deportiva Piloñesa Deportiva 38 39 52 45
14 UD Gijón Industrial Gijón 38 51 53 45
15 Navarro Navarro 38 39 51 43
16 Colloto Colloto 38 40 57 43
17 Real Titánico Real 38 32 38 41
18 CD Praviano CD Praviano 38 25 40 40
19 Club Hispano Club Hispano 38 33 60 32
20 CD Turón CD Turón 38 24 60 23
TEMPORADA 1996/1997
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Club Siero Club Siero 38 64 30 75
2 Navia CF Navia CF 38 59 27 75
3 Caudal Deportivo Caudal 38 68 38 73
4 Lealtad Villaviciosa Lealtad 38 61 32 67
5 San Martín San Martín 38 63 46 66
6 Universidad Oviedo Universidad 38 67 44 62
7 Pumarín CF Pumarín CF 38 40 43 61
8 CD Turón CD Turón 38 52 55 55
9 Navarro Navarro 38 56 50 55
10 Real Titánico Real 38 55 42 47
11 Ribadesella Ribadesella 38 50 55 47
12 Candás CF Candás CF 38 43 51 44
13 Club Hispano Club Hispano 38 36 49 44
14 CD Tuilla CD Tuilla 38 39 50 42
15 Colloto Colloto 38 52 66 40
16 UD Gijón Industrial Gijón 38 44 60 40
17 Narcea Narcea 38 41 71 39
18 Santiago De Aller Santiago 38 47 69 35
19 Mosconia Mosconia 38 38 51 33
20 Astur Astur 38 23 69 29
TEMPORADA 1995/1996
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Real Titánico Real 38 63 39 78
2 Real Oviedo Vetusta Real Oviedo 38 89 36 75
3 Marino de Luanco Marino 38 67 31 75
4 Caudal Deportivo Caudal 38 66 39 65
5 Mosconia Mosconia 38 43 29 64
6 Universidad Oviedo Universidad 38 48 52 60
7 UD Gijón Industrial Gijón 38 45 38 60
8 Lealtad Villaviciosa Lealtad 38 63 53 58
9 Navia CF Navia CF 38 52 33 57
10 Ribadesella Ribadesella 38 65 57 56
11 San Martín San Martín 38 42 42 53
12 Club Siero Club Siero 38 45 41 53
13 Navarro Navarro 38 46 54 44
14 CD Turón CD Turón 38 34 51 44
15 Club Hispano Club Hispano 38 48 61 42
16 Pumarín CF Pumarín CF 38 44 55 41
17 Colloto Colloto 38 40 66 40
18 Deportiva Piloñesa Deportiva 38 43 62 36
19 Valdesoto Valdesoto 38 30 77 30
20 CD Praviano CD Praviano 38 21 78 15
TEMPORADA 1994/1995
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Caudal Deportivo Caudal 38 77 23 57
2 Club Siero Club Siero 38 79 39 53
3 Lealtad Villaviciosa Lealtad 38 77 39 52
4 Real Titánico Real 38 53 34 44
5 CD Turón CD Turón 38 57 41 44
6 San Martin del Rey Aurelio Martin 38 32 37 41
7 Club Hispano Club Hispano 38 53 52 40
8 Pumarín CF Pumarín CF 38 42 40 40
9 Universidad Oviedo Universidad 38 61 49 39
10 Marino de Luanco Marino 38 47 40 38
11 Navia CF Navia CF 38 37 36 38
12 CD Praviano CD Praviano 38 42 60 36
13 UD Gijón Industrial Gijón 38 59 63 34
14 Ribadesella Ribadesella 38 47 58 32
15 Deportiva Piloñesa Deportiva 38 33 53 32
16 Navarro Navarro 38 42 54 32
17 CD Tuilla CD Tuilla 38 41 63 31
18 Candás CF Candás CF 38 40 61 29
19 SD Lenense Proinastur Lenense 38 40 63 29
20 Santiago De Aller Santiago 38 27 81 19
TEMPORADA 1993/1994
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Caudal Deportivo Caudal 38 88 22 65
2 Club Siero Club Siero 38 67 19 64
3 Lealtad Villaviciosa Lealtad 38 76 20 62
4 Marino de Luanco Marino 38 75 31 50
5 San Martin del Rey Aurelio Martin 38 54 27 45
6 Deportiva Piloñesa Deportiva 38 50 48 40
7 UD Gijón Industrial Gijón 38 58 59 39
8 Club Hispano Club Hispano 38 44 46 36
9 Real Titánico Real 38 43 53 35
10 SD Lenense Proinastur Lenense 38 37 41 35
11 Ribadesella Ribadesella 38 49 49 35
12 Candás CF Candás CF 38 38 47 35
13 Santiago De Aller Santiago 38 50 54 33
14 CD Turón CD Turón 38 28 45 32
15 Navarro Navarro 38 26 43 31
16 Pumarín CF Pumarín CF 38 40 60 31
17 Navia CF Navia CF 38 34 54 27
18 Berrón Berrón 38 31 64 27
19 Astur Astur 38 25 68 25
20 Valdesoto Valdesoto 38 23 86 13
TEMPORADA 1992/1993
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Caudal Deportivo Caudal 38 85 30 61
2 Lealtad Villaviciosa Lealtad 38 75 29 58
3 Langreo Langreo 38 81 32 55
4 Club Siero Club Siero 38 56 32 51
5 Club Hispano Club Hispano 38 62 27 50
6 Santiago De Aller Santiago 38 44 32 43
7 Deportiva Piloñesa Deportiva 38 47 51 41
8 Candás CF Candás CF 38 37 40 39
9 CD Turón CD Turón 38 39 49 37
10 Marino de Luanco Marino 38 47 51 37
11 Real Titánico Real 38 41 44 37
12 Navia CF Navia CF 38 43 47 33
13 UD Gijón Industrial Gijón 38 48 45 32
14 SD Lenense Proinastur Lenense 38 34 58 30
15 Astur Astur 38 35 50 29
16 Ribadesella Ribadesella 38 34 51 29
17 Pumarín CF Pumarín CF 38 33 53 28
18 Mosconia Mosconia 38 39 68 28
19 Universidad Oviedo Universidad 38 39 72 26
20 Europa de Nava Europa Nava 38 24 82 16
TEMPORADA 1991/1992
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Lealtad Villaviciosa Lealtad 38 67 34 52
2 Caudal Deportivo Caudal 38 53 23 51
3 Langreo Langreo 38 58 28 51
4 Club Hispano Club Hispano 38 41 20 49
5 Marino de Luanco Marino 38 51 25 49
6 Real Titánico Real 38 51 29 48
7 Navia CF Navia CF 38 57 46 43
8 UD Gijón Industrial Gijón 38 32 36 39
9 CD Turón CD Turón 38 39 49 38
10 Santiago De Aller Santiago 38 39 39 36
11 Candás CF Candás CF 38 26 37 36
12 Ribadesella Ribadesella 38 32 35 35
13 Club Siero Club Siero 38 31 37 32
14 Pumarín CF Pumarín CF 38 38 46 32
15 Universidad Oviedo Universidad 38 44 56 31
16 Astur Astur 38 25 38 31
17 CD Tuilla CD Tuilla 38 39 57 29
18 Lada Langreo Lada Langreo 38 31 58 28
19 CD Praviano CD Praviano 38 32 55 27
20 San Martín San Martín 38 32 70 23

  USO DE MEMORIA  
7,908,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6835
Total Execution Time  0.6849
  CADENA URL  
/historico/Pumarin-Cf
  GET DATOS  
$_GET['/historico/Pumarin-Cf']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0134  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 = 'Pumarin-Cf' 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.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=4688 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=4688 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254  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 = 73670
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4688 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=709 AND type_rel = 3
0.0131  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 709 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1088975,806083,759289,50689) ORDER BY n.cover_points DESC, update_date DESC
0.0128  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 = '4688' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '4688' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '4688' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 73670 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=4688 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (73670) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 73670 AND teamId = 4688
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 `tables2024` 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 = 73670 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0129  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 = '4688' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0124  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4688' and rp.type = 4
0.0126  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 = '4688' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0136  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 events2024 e ON e.player_id = p.id AND e.league_id = 73670 WHERE rp.league_id = 73670 AND rp.teamId = 4688 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 73670 WHERE rp.league_id = 73670 AND rp.teamId = 4688 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  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 events2024 e ON e.player_id = p.id AND e.league_id = 73670 WHERE rp.league_id = 73670 AND rp.teamId = 4688 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 4688 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0135  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 `tables2024` 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 = 73670 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.0146  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 `tables2023` 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 = 68983 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.0143  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 `tables2022` 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 = 63766 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 59036 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 4311 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 2589 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 1399 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 1129 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 22079 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 22063 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 22047 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 22031 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 `tables1998` 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 = 21983 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 `tables1997` 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 = 21965 AND t.round = 38 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 `tables1996` 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 = 21944 AND t.round = 38 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 `tables1995` 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 = 21923 AND t.round = 38 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 `tables1994` 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 = 21902 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 `tables1992` 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 = 21858 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 73670 ORDER BY nameShow LIMIT 100