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

  USO DE MEMORIA  
7,745,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.6741
Total Execution Time  0.6753
  CADENA URL  
/historico/Gama
  GET DATOS  
$_GET['/historico/Gama']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0153  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 = 'Gama' 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.0126  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=1198 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=1198 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1198 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=73 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 73 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  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 (359051) ORDER BY n.cover_points DESC, update_date DESC
0.0132  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 = '1198' ORDER BY l.year DESC,cat.coefficient DESC
0.0136  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 = '1198' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0141  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 = '1198' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0139  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 = 73447 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0142  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=1198 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0129  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,67977) 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 = 67977 AND teamId = 1198
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 73447 AND teamId = 1198
0.0253  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 = 73447 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '1198' 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 = '1198' and rp.type = 4
0.0127  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 = '1198' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 73447 WHERE rp.league_id = 73447 AND rp.teamId = 1198 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.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 = 73447 WHERE rp.league_id = 73447 AND rp.teamId = 1198 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 1198 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 = 1198 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 = 58851 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 51274 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 44658 AND t.round = 34 ORDER BY team.conference 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 `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.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 `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 = 33972 AND t.round = 34 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 `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 = 15444 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 `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 = 3913 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 `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.0133  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 = 1454 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 1148 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 `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 = 848 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 `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 = 288 AND t.round = 34 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 `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.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 `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.0148  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.0151  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 = 21903 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC