4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ribamontán al Mar
TEMPORADA 2023/2024
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 SD Gama SD Gama 7 6 1 17
2 SD Barreda Balompié Barreda 7 18 7 16
3 SD Textil Escudo Textil 7 10 4 13
4 CD Monte CD Monte 6 9 6 13
5 Peña Revilla SD Peña 7 7 4 11
6 SD San Martín Arena Martín 7 5 6 11
7 Cayón B Cayón B 7 10 10 10
8 Barquereño Barquereño 7 11 7 9
9 EMD Santillana Santillana 7 11 9 9
10 SD Solares B Solares 7 8 7 9
11 Ribamontán al Mar Ribamontán 7 6 4 8
12 FC Miengo FC Miengo 6 9 11 8
13 CD Naval B CD Naval B 7 7 10 6
14 Rayo Santa Cruz Rayo Santa. 7 8 12 6
15 Noja Noja 7 7 11 6
16 Arenas de Frajanas Arenas 7 3 8 6
17 Selaya Selaya 7 6 11 4
18 Estrella Roja Estrella 7 5 18 3
TEMPORADA 2022/2023
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 Atlético Mineros Atlético 34 77 31 78
2 Velarde CF Velarde CF 34 64 29 72
3 CD Bezana CD Bezana 34 80 48 68
4 CD Colindres Colindres 34 70 38 64
5 SD Barreda Balompié Barreda 34 65 45 62
6 Barquereño Barquereño 34 64 39 59
7 Selaya Selaya 34 49 32 58
8 Ribamontán al Mar Ribamontán 34 51 47 48
9 CD Monte CD Monte 34 55 49 47
10 Rayo Santa Cruz Rayo Santa. 34 50 50 45
11 Noja Noja 34 50 51 44
12 Arenas de Frajanas Arenas 34 38 58 35
13 SD San Martín Arena Martín 34 38 72 34
14 EMD Santillana Santillana 34 39 50 32
15 Estrella Roja Estrella 34 38 69 32
16 Vimenor B Vimenor B 34 31 53 29
17 CD Ramales CD Ramales 34 35 76 29
18 SD Nueva Montaña Nueva 34 26 83 20
TEMPORADA 2021/2022
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 SD Solares SD Solares 34 69 23 75
2 Revilla Revilla 34 68 30 69
3 SD Gama SD Gama 34 75 42 66
4 Velarde CF Velarde CF 34 72 28 65
5 CD Bezana CD Bezana 34 65 36 62
6 Atlético Mineros Atlético 34 60 48 55
7 CD Ramales CD Ramales 34 59 50 55
8 SD San Martín Arena Martín 34 52 51 52
9 Barquereño Barquereño 34 51 52 51
10 CD Monte CD Monte 34 48 58 47
11 Nueva Montaña Nueva 34 46 52 43
12 Arenas de Frajanas Arenas 34 48 61 39
13 Ribamontán al Mar Ribamontán 34 39 56 39
14 Rinconeda Rinconeda 34 48 67 37
15 FC Miengo FC Miengo 34 44 71 35
16 CD Los Rios CD Los Rios 34 51 86 31
17 Ampuero FC Ampuero FC 34 36 76 18
18 Ayrón Club Ayrón Club 34 31 75 18
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Tropezón Tropezón 20 40 19 43
2 Gimnástica Torrelavega Gimnástica 20 42 20 37
3 UM Escobedo UM Escobedo 20 27 17 37
4 CF Vimenor CF Vimenor 20 29 20 32
5 UC Cartes UC Cartes 20 23 22 29
6 Selaya Selaya 20 24 32 29
7 Castro Castro 20 20 23 27
8 SD Torina SD Torina 20 21 31 20
9 CD Guarnizo CD Guarnizo 20 18 30 19
10 SD Barreda Balompié Barreda 20 18 33 19
11 SD Solares SD Solares 20 9 24 10
12 Cayón Cayón 20 47 14 51
13 Rayo Cantabria Rayo 20 45 16 46
14 Siete Villas Siete Villas 20 30 15 42
15 Sámano Sámano 20 33 20 37
16 SD Textil Escudo Textil 20 27 17 33
17 Atlético Albericia Atlético 20 27 30 20
18 Rinconeda Rinconeda 20 19 37 19
19 Revilla Revilla 20 21 36 17
20 CD Bezana CD Bezana 20 14 40 16
21 Barquereño Barquereño 20 17 33 15
22 Ribamontán al Mar Ribamontán 20 12 34 12
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 CD Laredo CD Laredo 28 60 24 65
2 Gimnástica Torrelavega Gimnástica 28 58 23 60
3 Rayo Cantabria Rayo 28 54 24 57
4 Tropezón Tropezón 28 55 32 54
5 Cayón Cayón 28 54 23 51
6 UM Escobedo UM Escobedo 28 48 32 49
7 CD Bezana CD Bezana 28 43 27 47
8 SD Barreda Balompié Barreda 28 35 41 44
9 Barquereño Barquereño 28 35 37 36
10 CD Guarnizo CD Guarnizo 28 40 45 35
11 Siete Villas Siete Villas 28 32 31 34
12 SD Torina SD Torina 28 36 42 34
13 Sámano Sámano 28 32 49 33
14 Selaya Selaya 28 21 41 32
15 SD Textil Escudo Textil 28 31 49 27
16 SD Solares SD Solares 28 23 41 26
17 Ribamontán al Mar Ribamontán 28 27 56 25
18 CF Vimenor CF Vimenor 28 30 51 25
19 Atlético Albericia Atlético 28 33 50 25
20 UC Cartes UC Cartes 28 23 52 21
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 UM Escobedo UM Escobedo 38 80 29 86
2 CD Laredo CD Laredo 38 71 26 80
3 Tropezón Tropezón 38 73 34 76
4 Cayón Cayón 38 66 26 74
5 Rayo Cantabria Rayo 38 62 24 68
6 CD Bezana CD Bezana 38 60 50 65
7 Sámano Sámano 38 54 46 58
8 CF Vimenor CF Vimenor 38 51 56 54
9 SD Torina SD Torina 38 55 60 53
10 SD Textil Escudo Textil 38 49 43 51
11 Ribamontán al Mar Ribamontán 38 36 38 50
12 SD Barreda Balompié Barreda 38 48 59 47
13 Siete Villas Siete Villas 38 41 51 43
14 Atlético Albericia Atlético 38 43 47 42
15 SD Solares SD Solares 38 33 44 42
16 CD Guarnizo CD Guarnizo 38 41 54 40
17 Revilla Revilla 38 48 83 38
18 Velarde CF Velarde CF 38 35 67 36
19 CD Naval CD Naval 38 36 95 23
20 Rinconeda Rinconeda 38 37 87 19
TEMPORADA 2017/2018
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 Revilla Revilla 34 62 27 72
2 SD Torina SD Torina 34 55 27 72
3 Rinconeda Rinconeda 34 61 40 65
4 Ribamontán al Mar Ribamontán 34 49 30 61
5 CD Naval CD Naval 34 51 41 53
6 Valle Lebaniego Valle 34 55 56 45
7 Ayrón Club Ayrón Club 34 46 48 45
8 CD Colindres Colindres 34 42 38 42
9 UC Cartes UC Cartes 34 57 50 42
10 SD Gama SD Gama 34 48 51 41
11 CD Los Rios CD Los Rios 34 56 68 40
12 Cayón B Cayón B 34 53 72 40
13 EMF Meruelo EMF Meruelo 33 42 50 39
14 CD Monte CD Monte 34 42 68 38
15 Nueva Montaña Nueva 34 54 57 37
16 Santoña CF Santoña CF 33 32 52 37
17 Vimenor B Vimenor B 34 28 43 35
18 Internacional FC Santander Internaciona 34 46 61 33
TEMPORADA 2016/2017
1ª REGIONAL CANTABRIA
Equipo PJ GF GC Puntos
1 UC Cartes UC Cartes 34 73 35 73
2 Ribamontán al Mar Ribamontán 34 66 32 70
3 Peña Revilla SD Peña 34 65 39 64
4 Ayrón Club Ayrón Club 34 51 35 64
5 Buelna Buelna 34 66 46 58
6 Minerva Fc Minerva Fc 34 72 55 57
7 Barquereño Barquereño 34 72 55 56
8 Marina de Cudeyo Marina 34 61 49 49
9 Villaescusa SD Villaescusa 34 66 52 48
10 SD San Martín Arena Martín 34 47 59 45
11 Atco. Deva Atco. Deva 34 65 68 43
12 Santillana B Santillana 34 46 63 37
13 CD Ramales CD Ramales 34 49 67 36
14 Ampuero FC Ampuero FC 34 45 73 34
15 Nueva Montaña B Nueva 34 42 67 33
16 Juventud Atlético San Roman Juventud 34 44 70 33
17 Rio Gandara CD Gandara 34 47 84 28
18 CD Comillas CD Comillas 34 36 64 25
TEMPORADA 2015/2016
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 SD Barreda Balompié Barreda 36 76 21 85
2 EMF Meruelo EMF Meruelo 36 66 31 76
3 Velarde CF Velarde CF 36 68 40 68
4 SD Solares SD Solares 36 43 30 63
5 EMD Santillana Santillana 36 66 38 61
6 Nueva Montaña Nueva 36 58 39 57
7 Atlético España De Cueto Atlético 36 59 43 52
8 Noja Noja 36 52 62 50
9 Rinconeda Rinconeda 36 58 49 47
10 Internacional FC Santander Internaciona 35 49 52 44
11 CD Pontejos CD Pontejos 36 49 59 44
12 Arenas de Frajanas Arenas 36 47 64 44
13 Cayón B Cayón B 36 50 71 43
14 Santoña CF Santoña CF 36 48 58 43
15 Minerva Fc Minerva Fc 36 59 67 42
16 CD Los Rios CD Los Rios 35 43 47 42
17 Barquereño Barquereño 36 41 67 35
18 Ribamontán al Mar Ribamontán 36 35 65 29
19 Buelna Buelna 36 25 89 15
TEMPORADA 2014/2015
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 CD Guarnizo CD Guarnizo 34 63 23 85
2 Sámano Sámano 34 69 39 68
3 CD Naval CD Naval 34 49 28 60
4 EMD Santillana Santillana 34 55 39 59
5 Velarde CF Velarde CF 34 61 45 58
6 Barquereño Barquereño 33 64 40 56
7 EMF Meruelo EMF Meruelo 34 50 29 56
8 Reocin Reocin 32 63 47 50
9 Ribamontán al Mar Ribamontán 34 47 53 49
10 Noja Noja 34 40 50 40
11 Rinconeda Rinconeda 33 45 57 38
12 Nueva Montaña Nueva 34 38 61 35
13 SD Solares SD Solares 34 27 36 34
14 CD Los Rios CD Los Rios 34 52 67 34
15 CD Pontejos CD Pontejos 34 29 52 34
16 Minerva Fc Minerva Fc 34 35 67 32
17 SD Torina SD Torina 34 41 65 28
18 SD San Martín Arena Martín 34 36 66 27
TEMPORADA 2013/2014
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Gimnástica Torrelavega Gimnástica 38 82 18 89
2 CD Laredo CD Laredo 38 71 31 77
3 Deportivo Rayo Cantabria Deportivo 38 60 37 72
4 UM Escobedo UM Escobedo 38 50 30 71
5 Siete Villas Siete Villas 38 60 44 61
6 Cayón Cayón 38 46 36 61
7 SD Gama SD Gama 38 44 34 58
8 Rayo Cantabria Rayo 38 52 39 54
9 Atlético Albericia Atlético 38 38 44 54
10 Buelna Buelna 38 46 46 53
11 CF Vimenor CF Vimenor 38 49 48 51
12 CD Bezana CD Bezana 38 49 54 50
13 CD Colindres Colindres 38 43 59 46
14 Castro Castro 38 47 63 42
15 Selaya Selaya 38 39 57 41
16 SD Barreda Balompié Barreda 38 48 67 41
17 Santoña CF Santoña CF 38 42 59 41
18 CD Pontejos CD Pontejos 38 47 78 37
19 CD Guarnizo CD Guarnizo 38 42 78 23
20 Ribamontán al Mar Ribamontán 38 31 64 20
TEMPORADA 2012/2013
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Tropezón Tropezón 38 87 32 83
2 Deportivo Rayo Cantabria Deportivo 38 76 27 83
3 Cayón Cayón 38 49 21 73
4 CD Laredo CD Laredo 38 54 30 68
5 Castro Castro 38 52 33 68
6 CF Vimenor CF Vimenor 38 52 42 61
7 Santoña CF Santoña CF 38 53 51 58
8 SD Barreda Balompié Barreda 38 49 44 58
9 Siete Villas Siete Villas 38 48 49 53
10 CD Guarnizo CD Guarnizo 38 45 41 52
11 UM Escobedo UM Escobedo 38 67 54 51
12 CD Pontejos CD Pontejos 38 43 52 48
13 SD Gama SD Gama 38 32 40 48
14 Atlético Albericia Atlético 38 49 49 48
15 CD Bezana CD Bezana 38 42 47 47
16 Ribamontán al Mar Ribamontán 38 42 51 45
17 EMD Santillana Santillana 38 43 65 36
18 SD Textil Escudo Textil 38 35 69 30
19 EMF Meruelo EMF Meruelo 38 32 84 22
20 SD San Martín Arena Martín 38 14 83 12
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Noja Noja 38 99 30 85
2 CD Laredo CD Laredo 38 85 40 85
3 Rayo Cantabria Rayo 38 91 30 78
4 Cayón Cayón 38 58 36 78
5 Tropezón Tropezón 38 84 43 75
6 UM Escobedo UM Escobedo 38 63 50 68
7 Siete Villas Siete Villas 38 61 48 65
8 Deportivo Rayo Cantabria Deportivo 38 75 53 59
9 SD Barreda Balompié Barreda 38 57 59 50
10 Castro Castro 38 61 63 48
11 CD Guarnizo CD Guarnizo 38 59 55 46
12 CF Vimenor CF Vimenor 38 44 65 45
13 CD Pontejos CD Pontejos 38 50 65 41
14 Ribamontán al Mar Ribamontán 38 41 71 40
15 CD Bezana CD Bezana 38 43 66 38
16 Atlético Albericia Atlético 38 49 66 38
17 Buelna Buelna 38 36 76 33
18 SD San Martín Arena Martín 38 40 66 32
19 Barquereño Barquereño 38 33 69 30
20 Arenas de Frajanas Arenas 38 30 108 19
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Deportivo Rayo Cantabria Deportivo 38 83 29 82
2 Rayo Cantabria Rayo 38 79 28 80
3 Noja Noja 38 53 27 77
4 Siete Villas Siete Villas 38 65 39 72
5 CD Bezana CD Bezana 38 54 35 68
6 UM Escobedo UM Escobedo 38 81 48 65
7 Tropezón Tropezón 38 65 41 62
8 Ribamontán al Mar Ribamontán 38 54 51 62
9 Buelna Buelna 38 42 41 60
10 Cayón Cayón 38 58 48 54
11 CD Laredo CD Laredo 38 39 42 49
12 CD Guarnizo CD Guarnizo 38 46 56 46
13 Arenas de Frajanas Arenas 38 52 78 46
14 Castro Castro 38 54 62 44
15 CD Pontejos CD Pontejos 38 44 58 41
16 Atlético Albericia Atlético 38 40 60 40
17 CF Vimenor CF Vimenor 38 36 52 38
18 Solares Solares 38 28 66 28
19 Santoña CF Santoña CF 38 32 77 24
20 Reocin Reocin 38 10 77 11
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Noja Noja 38 85 31 80
2 UM Escobedo UM Escobedo 38 61 35 72
3 Tropezón Tropezón 38 78 38 71
4 CD Bezana CD Bezana 38 65 33 68
5 CD Laredo CD Laredo 38 57 41 68
6 Deportivo Rayo Cantabria Deportivo 38 72 45 67
7 Reocin Reocin 38 54 49 63
8 Siete Villas Siete Villas 38 66 60 62
9 Cayón Cayón 38 50 39 60
10 Ribamontán al Mar Ribamontán 38 54 51 54
11 Atlético Albericia Atlético 38 49 55 48
12 Solares Solares 38 51 59 47
13 Buelna Buelna 38 56 75 45
14 CD Pontejos CD Pontejos 38 65 73 45
15 Castro Castro 38 41 60 43
16 CF Vimenor CF Vimenor 38 37 53 37
17 SD Textil Escudo Textil 38 50 75 36
18 SD Barreda Balompié Barreda 38 36 58 35
19 Selaya Selaya 38 47 92 32
20 Atco. Deva Atco. Deva 38 40 92 24
TEMPORADA 2008/2009
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Gimnástica Torrelavega Gimnástica 38 103 15 101
2 Noja Noja 38 85 19 86
3 Tropezón Tropezón 38 56 16 82
4 UM Escobedo UM Escobedo 38 74 33 75
5 CD Bezana CD Bezana 38 56 34 66
6 Reocin Reocin 38 75 38 66
7 Siete Villas Siete Villas 38 51 55 54
8 Castro Castro 38 46 41 53
9 CD Laredo CD Laredo 38 42 51 49
10 Atlético Albericia Atlético 38 36 48 49
11 SD Barreda Balompié Barreda 38 42 59 49
12 Atco. Deva Atco. Deva 38 55 48 48
13 Ribamontán al Mar Ribamontán 38 51 56 46
14 Deportivo Rayo Cantabria Deportivo 38 38 64 41
15 Cayón Cayón 38 47 72 40
16 Solares Solares 38 36 53 39
17 CF Vimenor CF Vimenor 38 38 56 38
18 Santoña CF Santoña CF 38 41 66 36
19 C. Guarnizo C. Guarnizo 38 20 57 26
20 Velarde CF Velarde CF 38 15 126 6
TEMPORADA 2007/2008
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Gimnástica Torrelavega Gimnástica 38 113 25 100
2 Rayo Cantabria Rayo 38 103 31 88
3 UM Escobedo UM Escobedo 38 94 35 77
4 Noja Noja 37 63 26 75
5 Velarde CF Velarde CF 38 66 41 75
6 Reocin Reocin 38 67 34 73
7 CD Bezana CD Bezana 38 69 54 59
8 Tropezón Tropezón 38 50 46 57
9 CD Laredo CD Laredo 38 55 57 54
10 Ribamontán al Mar Ribamontán 38 52 64 46
11 Atco. Deva Atco. Deva 38 31 50 44
12 Santoña CF Santoña CF 38 36 54 42
13 Siete Villas Siete Villas 38 33 53 40
14 Castro Castro 38 44 69 39
15 CD Guarnizo CD Guarnizo 38 32 51 37
16 SD Barreda Balompié Barreda 38 25 70 35
17 Atlético Albericia Atlético 37 35 62 34
18 Trasmiera Trasmiera 38 30 66 34
19 SD Gama SD Gama 38 36 80 31
20 Buelna Buelna 38 35 101 19
TEMPORADA 2006/2007
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Noja Noja 38 80 25 87
2 UM Escobedo UM Escobedo 38 79 22 78
3 Tropezón Tropezón 38 71 31 77
4 CD Bezana CD Bezana 38 60 31 66
5 CD Laredo CD Laredo 38 48 38 65
6 Ribamontán al Mar Ribamontán 38 40 37 58
7 SD Barreda Balompié Barreda 38 43 47 56
8 Castro Castro 38 32 28 55
9 Trasmiera Trasmiera 38 45 44 51
10 Velarde CF Velarde CF 38 51 53 51
11 Gimnástica B Gimnástica 38 33 35 49
12 Atlético Albericia Atlético 38 35 43 45
13 Santoña CF Santoña CF 38 38 46 44
14 SD Gama SD Gama 38 35 57 43
15 Siete Villas Siete Villas 38 35 51 42
16 Reocin Reocin 38 27 40 39
17 Solares Solares 38 33 55 34
18 Cayón Cayón 38 34 71 33
19 SD Textil Escudo Textil 38 30 60 32
20 Selaya Selaya 38 26 61 31
TEMPORADA 2005/2006
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Gimnástica Torrelavega Gimnástica 38 88 26 86
2 UM Escobedo UM Escobedo 38 60 26 77
3 CD Bezana CD Bezana 38 53 30 74
4 Noja Noja 38 70 42 74
5 Velarde CF Velarde CF 38 63 36 73
6 Tropezón Tropezón 38 67 31 72
7 CD Laredo CD Laredo 38 37 27 60
8 Ribamontán al Mar Ribamontán 38 56 50 56
9 Castro Castro 38 65 64 53
10 Atlético Albericia Atlético 38 46 49 49
11 Solares Solares 38 53 58 48
12 Siete Villas Siete Villas 38 43 54 41
13 Trasmiera Trasmiera 38 37 49 41
14 SD Gama SD Gama 38 47 61 40
15 Santoña CF Santoña CF 38 37 55 40
16 Reocin Reocin 38 32 44 39
17 SD Barreda Balompié Barreda 38 33 59 39
18 CF Vimenor CF Vimenor 38 44 60 37
19 Revilla Revilla 38 44 74 33
20 Barquereño Barquereño 38 33 113 14
TEMPORADA 2004/2005
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Rayo Cantabria Rayo 38 84 24 91
2 UM Escobedo UM Escobedo 38 66 37 70
3 SD Barreda Balompié Barreda 38 49 47 67
4 Noja Noja 38 63 36 66
5 Tropezón Tropezón 38 56 38 64
6 Velarde CF Velarde CF 38 65 44 64
7 CD Bezana CD Bezana 38 50 34 63
8 Ribamontán al Mar Ribamontán 38 54 45 56
9 Reocin Reocin 38 47 50 49
10 Castro Castro 38 55 56 48
11 Atlético Albericia Atlético 38 48 57 48
12 Siete Villas Siete Villas 38 54 56 46
13 CD Laredo CD Laredo 38 42 47 46
14 Solares Solares 38 52 67 44
15 Trasmiera Trasmiera 38 36 42 44
16 CF Vimenor CF Vimenor 38 40 50 44
17 Barquereño Barquereño 38 31 53 42
18 SD Textil Escudo Textil 38 46 73 42
19 CD Guarnizo CD Guarnizo 38 29 52 34
20 Atco. Deva Atco. Deva 38 30 89 16

  USO DE MEMORIA  
8,076,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1763
Total Execution Time  0.1776
  CADENA URL  
/historico/Ribamontan-Mar
  GET DATOS  
$_GET['/historico/Ribamontan-Mar']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0031  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 = 'Ribamontan-Mar' 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.0019  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=2159 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=2159 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0047  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 = 73447
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2159 AND type_rel = 2
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2159 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0027  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 (576698,822157,831531,886617) ORDER BY n.cover_points DESC, update_date DESC
0.0027  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 = '2159' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '2159' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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=2159 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73447) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73447 AND teamId = 2159
0.0022  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 = '2159' 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 = '2159' and rp.type = 4
0.0022  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 = '2159' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 73447 WHERE rp.league_id = 73447 AND rp.teamId = 2159 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.0029  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 = 73447 WHERE rp.league_id = 73447 AND rp.teamId = 2159 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 73447 WHERE rp.league_id = 73447 AND rp.teamId = 2159 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 2159 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0028  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 = 68550 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.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 `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 = 63670 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.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 `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 = 58581 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 50271 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 44391 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 39193 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 34040 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 16698 AND t.round = 38 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 `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 = 4097 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 2553 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 = 1944 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0060  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 = 1400 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0071  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 = 1133 AND t.round = 38 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 `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 = 835 AND t.round = 38 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 = 133 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 10 AND t.round = 38 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 = 88 AND t.round = 38 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 `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 = 22115 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 22096 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC