4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Celta C – Gran Peña

Celta C – Gran Peña

Entrenador: Luis Bonilla

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Bergantiños FC Bergantiños 32 47 18 70
2 Celta C – Gran Peña Celta Gran. 32 46 30 57
3 Arosa Arosa 32 36 21 54
4 Ourense UD Ourense UD 32 44 34 51
5 SD Sarriana SD Sarriana 32 42 29 50
6 At. Arteixo At. Arteixo 32 45 35 47
7 Alondras CF Alondras CF 32 37 34 43
8 Silva SD Silva SD 32 35 32 43
9 CD Lugo B CD Lugo B 32 32 32 43
10 CD Estradense Estradense 32 29 30 42
11 Viveiro Viveiro 32 37 41 40
12 Betanzos CF Betanzos CF 32 34 31 39
13 Somozas Somozas 32 38 39 39
14 Rápido de Bouzas Rápido 32 33 38 39
15 Barbadás Barbadás 32 30 34 38
16 UD Paiosaco UD Paiosaco 32 29 39 38
17 Pontevedra B Pontevedra 32 25 61 23
18 CSD Arzua CSD Arzua 32 23 64 15
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Deportivo Fabril Deportivo 30 47 18 61
2 Arosa Arosa 30 45 26 58
3 Rápido de Bouzas Rápido 30 39 24 56
4 RC Villalbés Villalbés 30 35 24 46
5 Ourense UD Ourense UD 30 38 30 45
6 Alondras CF Alondras CF 30 36 29 41
7 At. Arteixo At. Arteixo 30 37 42 41
8 Somozas Somozas 30 32 37 40
9 CD Estradense Estradense 30 33 38 39
10 Celta C – Gran Peña Celta Gran. 30 47 37 38
11 UD Paiosaco UD Paiosaco 30 31 42 37
12 Silva SD Silva SD 30 38 46 37
13 Viveiro Viveiro 30 29 37 37
14 CSD Arzua CSD Arzua 30 28 48 31
15 Barco Barco 30 26 38 31
16 Choco Choco 30 27 52 15
TEMPORADA 2021/2022
PREFERENTE GALICIA GRUPO 6
Equipo PJ GF GC Puntos
1 Ourense UD Ourense UD 10 20 6 29
2 Celta C – Gran Peña Celta Gran. 10 14 11 23
3 Pontevedra B Pontevedra 10 23 19 20
4 Portonovo Portonovo 10 17 13 20
5 Barbadás Barbadás 10 14 15 20
6 Umia Umia 10 19 14 17
7 Cultural Areas Cultural 10 16 17 15
8 Villalonga FC Villalonga 10 9 15 12
9 Pontellas Pontellas 10 12 23 8
10 Verín Verín 10 10 21 8
TEMPORADA 2020/2021
PREFERENTE GALICIA GRUPO 8
Equipo PJ GF GC Puntos
1 Celta C – Gran Peña Celta Gran. 3 5 5 7
2 Juvenil Ponteareas Juvenil 3 5 5 7
3 At. Arnoia At. Arnoia 3 1 2 7
4 Barbadás Barbadás 3 3 2 6
5 Villalonga FC Villalonga 3 6 5 5
6 Cultural Areas Cultural 3 4 5 3
TEMPORADA 2019/2020
PREFERENTE GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ribadumia Ribadumia 26 41 14 56
2 UD Atios UD Atios 26 55 20 51
3 Cultural Areas Cultural 26 54 37 49
4 Céltiga FC Céltiga FC 26 49 31 46
5 Villalonga FC Villalonga 26 44 34 46
6 Barbadás Barbadás 26 50 32 45
7 Mondariz CF Mondariz CF 26 35 29 45
8 At. Arnoia At. Arnoia 26 33 30 41
9 CD Moaña CD Moaña 26 45 37 39
10 Pontevedra B Pontevedra 26 40 46 34
11 Porriño Industrial Porriño 26 34 43 34
12 Sanxenxo Sanxenxo 26 22 27 33
13 Juvenil Ponteareas Juvenil 26 48 38 32
14 CD Beluso CD Beluso 26 34 46 29
15 Cambados Cambados 26 33 47 29
16 CD Velle CD Velle 26 32 37 28
17 Celta C – Gran Peña Celta Gran. 26 25 46 26
18 Portonovo Portonovo 26 29 38 25
19 CD Valladares Valladares 26 22 52 15
20 Poligono San Ciprian Poligono 26 15 56 11
TEMPORADA 2018/2019
PRIMERA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 Portonovo Portonovo 34 58 24 69
2 Pontevedra B Pontevedra 34 75 44 66
3 Umia Umia 34 69 44 62
4 Arcade Arcade 34 74 44 60
5 Racing Castrelos Racing 34 63 46 55
6 SP Guardes SP Guardes 34 62 43 54
7 Celta C – Gran Peña Celta Gran. 33 55 41 54
8 Campo Lameiro CD Campo 34 45 41 50
9 La Guia La Guia 34 47 49 46
10 Atlético Cuntis Atlético 34 54 58 46
11 Unión Dena CF Unión Dena 34 50 56 45
12 San Martín Villajuan Martín 33 44 56 44
13 Caselas Caselas 34 38 44 43
14 Erizana Erizana 34 59 84 41
15 U.D. Mos U.D. Mos 34 38 50 38
16 Gondomar Cf Gondomar Cf 34 33 55 23
17 Salvatierra SD Salvatierra 34 31 66 23
18 Domaio FC Domaio FC 34 32 82 23
TEMPORADA 2017/2018
PRIMERA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 Amanecer Amanecer 34 76 31 70
2 Cambados Cambados 34 75 33 68
3 Juvenil Ponteareas Juvenil 34 63 44 65
4 Portonovo Portonovo 34 67 41 64
5 SP Guardes SP Guardes 34 57 39 61
6 Celta C – Gran Peña Celta Gran. 34 51 43 54
7 Unión Dena CF Unión Dena 34 54 49 53
8 San Martín Villajuan Martín 34 54 46 51
9 Umia Umia 34 57 50 50
10 Domaio FC Domaio FC 34 65 60 45
11 Pontevedra B Pontevedra 34 60 53 43
12 U.D. Mos U.D. Mos 34 54 57 43
13 Santa Mariña Santa 34 46 50 43
14 CCD Chain CCD Chain 34 39 68 39
15 UVCD Candean UVCD Candean 33 48 58 34
16 Zacande Zacande 34 41 67 32
17 Rápido Bahía Rápido 33 33 92 22
18 Racing Vilariño Racing 34 37 96 21
TEMPORADA 2016/2017
PRIMERA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 Campo Lameiro CD Campo 34 68 43 65
2 CD Beluso CD Beluso 34 60 35 65
3 Amanecer Amanecer 34 58 35 65
4 Marcón Atletico Marcón 34 60 38 65
5 Umia Umia 34 65 41 57
6 SP Guardes SP Guardes 34 62 48 52
7 Cambados Cambados 34 46 38 52
8 CCD Chain CCD Chain 34 52 55 48
9 Celta C – Gran Peña Celta Gran. 34 51 50 46
10 UVCD Candean UVCD Candean 34 49 55 46
11 U.D. Mos U.D. Mos 34 48 43 44
12 Juvenil Ponteareas Juvenil 34 40 45 44
13 Pontevedra B Pontevedra 34 36 37 42
14 Domaio FC Domaio FC 34 57 66 40
15 San Martín Villajuan Martín 34 46 57 38
16 SDR San Esteban Esteban 34 49 67 35
17 San Miguel C.F. Miguel C.F. 34 34 72 26
18 Atlético Cuntis Atlético 34 34 90 17
TEMPORADA 2015/2016
PRIMERA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 Erizana Erizana 34 84 44 76
2 Pontellas Pontellas 34 75 35 69
3 CD Moaña CD Moaña 33 68 28 68
4 UVCD Candean UVCD Candean 34 49 32 61
5 Juvenil Ponteareas Juvenil 33 55 42 57
6 Amanecer Amanecer 34 51 43 55
7 Celta C – Gran Peña Celta Gran. 34 54 51 53
8 SP Guardes SP Guardes 34 55 41 51
9 San Martín Villajuan Martín 34 44 42 51
10 SDR San Esteban Esteban 34 36 49 43
11 Campo Lameiro CD Campo 33 41 48 42
12 Umia Umia 34 39 59 40
13 Pontevedra B Pontevedra 34 47 46 39
14 CD Beluso CD Beluso 32 43 46 37
15 Unión Dena CF Unión Dena 33 38 67 30
16 Caldas CF Caldas CF 34 40 71 29
17 Rápido Bahía Rápido 34 39 76 28
18 Nigrán Cf Nigrán Cf 34 38 76 24
TEMPORADA 2014/2015
PRIMERA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 USD O Grove USD O Grove 34 52 30 69
2 Domaio FC Domaio FC 34 76 45 68
3 Caselas Caselas 34 66 38 65
4 CD Beluso CD Beluso 34 55 35 58
5 CD Moaña CD Moaña 34 50 45 57
6 SDR San Esteban Esteban 34 49 42 49
7 SP Guardes SP Guardes 34 50 43 48
8 Caldas CF Caldas CF 34 53 52 48
9 UVCD Candean UVCD Candean 34 49 48 48
10 Campo Lameiro CD Campo 34 46 39 46
11 Unión Dena CF Unión Dena 34 57 53 46
12 Celta C – Gran Peña Celta Gran. 34 45 41 46
13 Salvatierra SD Salvatierra 34 47 52 42
14 CCD Chain CCD Chain 34 55 55 40
15 Cambados Cambados 34 40 55 37
16 Cruceiro Do Hío Cruceiro 34 35 76 30
17 Marín CF Marín CF 34 29 62 28
18 UD Louro Tameiga Louro 34 30 73 22
TEMPORADA 2011/2012
PREFERENTE GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 Barbadás Barbadás 38 86 38 84
2 Céltiga FC Céltiga FC 38 81 41 80
3 Choco Choco 38 75 36 79
4 Pontellas Pontellas 38 59 32 70
5 Ribadumia Ribadumia 38 61 45 68
6 Arosa Arosa 38 60 43 67
7 Barco Barco 38 56 53 56
8 UD Atios UD Atios 38 58 50 55
9 Mondariz CF Mondariz CF 38 44 49 55
10 Marín CF Marín CF 38 50 49 51
11 Portonovo Portonovo 38 50 52 51
12 Verín Verín 38 54 58 48
13 Alerta Traviesas Alerta 38 56 66 47
14 Cruceiro Do Hío Cruceiro 38 49 57 44
15 Pontevedra B Pontevedra 38 42 56 42
16 Sporting Celanova Sporting 38 37 53 39
17 Celta C – Gran Peña Celta Gran. 38 50 71 39
18 Tomiño Tomiño 38 43 57 36
19 Nigrán Cf Nigrán Cf 38 36 93 21
20 CD Ourense B Ourense 38 34 82 20
TEMPORADA 2010/2011
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Lalín Lalín 38 76 45 75
2 Sanxenxo Sanxenxo 38 70 40 72
3 Barbadás Barbadás 38 53 44 64
4 Verín Verín 38 50 38 63
5 Nigrán Cf Nigrán Cf 38 65 46 62
6 Céltiga FC Céltiga FC 38 51 44 62
7 Pontellas Pontellas 38 59 37 61
8 Cruceiro Do Hío Cruceiro 38 49 41 56
9 Choco Choco 38 49 45 54
10 Arosa Arosa 38 58 50 53
11 Celta C – Gran Peña Celta Gran. 38 55 49 53
12 Marín CF Marín CF 38 50 47 53
13 CD Ourense B Ourense 38 47 50 52
14 Ribadumia Ribadumia 38 57 47 51
15 UD Atios UD Atios 38 48 43 51
16 Porriño Industrial Porriño 38 42 41 51
17 Rápido Bahía Rápido 38 38 55 49
18 Cambados Cambados 38 48 54 46
19 Arenteiro Arenteiro 38 30 78 21
20 A Peroxa CF A Peroxa CF 38 21 122 3
TEMPORADA 2009/2010
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Portonovo Portonovo 38 63 34 74
2 CD Estradense Estradense 38 77 35 72
3 Choco Choco 38 51 25 70
4 Arosa Arosa 38 59 48 64
5 Porriño Industrial Porriño 38 68 38 61
6 Sanxenxo Sanxenxo 38 53 36 61
7 Rápido Bahía Rápido 38 58 42 61
8 Pontellas Pontellas 38 52 40 59
9 Barbadás Barbadás 37 62 49 57
10 Ribadumia Ribadumia 38 67 61 51
11 Celta C – Gran Peña Celta Gran. 38 58 57 51
12 Cruceiro Do Hío Cruceiro 38 39 44 51
13 Cambados Cambados 38 54 63 49
14 Arenteiro Arenteiro 38 46 66 49
15 Sporting Celanova Sporting 38 49 56 47
16 Marín CF Marín CF 37 47 56 45
17 Caselas Caselas 38 43 66 35
18 Tomiño Tomiño 38 36 67 33
19 SD Nogueira de Ramuín Nogueira 37 39 74 27
20 AD Covadonga Covadonga 37 32 96 25
TEMPORADA 2008/2009
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 SD Compostela Compostela 38 68 26 85
2 Montañeros Montañeros 38 68 41 76
3 CD Ourense CD Ourense 38 74 40 71
4 CCD Cerceda CCD Cerceda 38 66 47 64
5 Narón BP Narón BP 38 67 55 58
6 Lalín Lalín 38 36 37 53
7 Coruxo Coruxo 38 48 39 53
8 Xallas FC Xallas FC 38 42 45 50
9 Negreira Negreira 38 42 52 50
10 Alondras CF Alondras CF 38 48 45 50
11 Somozas Somozas 38 46 59 46
12 Céltiga FC Céltiga FC 38 34 46 45
13 Club Ordenes SD Club Ordenes 38 36 35 45
14 Verín Verín 38 45 58 45
15 Rápido de Bouzas Rápido 38 38 54 44
16 Villalonga FC Villalonga 38 49 53 44
17 Pontevedra B Pontevedra 38 36 48 43
18 Portonovo Portonovo 38 36 51 39
19 Arosa Arosa 38 61 83 35
20 Celta C – Gran Peña Celta Gran. 38 29 55 34
TEMPORADA 1998/1999
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Porriño Industrial Porriño 38 55 34 70
2 Celta Fortuna Celta 38 61 36 67
3 CCD Cerceda CCD Cerceda 38 52 35 67
4 Viveiro Viveiro 38 52 39 64
5 Ponte Ourense Ponte 38 58 40 63
6 UD Xove Lago Xove Lago 38 48 33 63
7 Compostela - Zona Vella B Compostela 38 49 41 62
8 Gondomar Cf Gondomar Cf 38 56 43 59
9 As Pontes As Pontes 38 41 34 59
10 Arosa Arosa 38 43 44 58
11 CD Ourense B Ourense 38 70 61 56
12 Club Lemos Club Lemos 38 40 39 50
13 Betanzos CF Betanzos CF 38 51 50 48
14 Alondras CF Alondras CF 38 44 54 45
15 Villalonga FC Villalonga 38 59 69 44
16 Caselas Caselas 38 56 63 44
17 At. Arteixo At. Arteixo 38 37 56 35
18 Celta C – Gran Peña Celta Gran. 38 42 75 31
19 Sanxenxo Sanxenxo 38 28 58 29
20 Somozas Somozas 38 35 73 27
TEMPORADA 1997/1998
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Compostela - Zona Vella B Compostela 40 90 29 88
2 Lalín Lalín 40 66 42 76
3 Celta Fortuna Celta 40 68 35 75
4 Betanzos CF Betanzos CF 40 68 41 74
5 Ponte Ourense Ponte 40 82 53 74
6 Arosa Arosa 40 54 46 65
7 Caselas Caselas 40 71 50 63
8 Club Lemos Club Lemos 40 53 45 62
9 UD Xove Lago Xove Lago 40 49 43 60
10 Viveiro Viveiro 40 55 48 59
11 CCD Cerceda CCD Cerceda 40 57 46 55
12 Villalonga FC Villalonga 40 67 57 55
13 Celta C – Gran Peña Celta Gran. 40 64 63 54
14 Porriño Industrial Porriño 40 58 54 50
15 Gondomar Cf Gondomar Cf 40 49 57 49
16 Sanxenxo Sanxenxo 40 49 70 48
17 Somozas Somozas 40 46 63 45
18 CD Estradense Estradense 40 38 71 33
19 Imperator OAR Imperator 40 39 83 30
20 Laracha Laracha 40 43 98 24
21 Cambados Cambados 40 25 97 18
TEMPORADA 1996/1997
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Vista Alegre SD Vista Alegre 38 79 31 82
2 Ponte Ourense Ponte 38 84 37 77
3 Lalín Lalín 38 64 29 72
4 Viveiro Viveiro 38 58 47 69
5 Betanzos CF Betanzos CF 38 47 34 64
6 CCD Cerceda CCD Cerceda 38 52 36 61
7 Celta C – Gran Peña Celta Gran. 38 51 40 60
8 Villalonga FC Villalonga 38 54 43 57
9 Caselas Caselas 38 45 53 54
10 Club Lemos Club Lemos 38 46 54 51
11 Porriño Industrial Porriño 38 48 48 51
12 Somozas Somozas 38 35 39 47
13 Gondomar Cf Gondomar Cf 38 45 56 46
14 Arosa Arosa 38 56 61 43
15 UD Xove Lago Xove Lago 38 40 50 42
16 Cambados Cambados 38 43 61 42
17 CD Estradense Estradense 38 33 56 37
18 Mosteiro Mosteiro 38 30 58 34
19 Mindoniense Mindoniense 38 28 64 32
20 Ribadeo FC Ribadeo FC 38 35 76 27
TEMPORADA 1995/1996
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 CCD Cerceda CCD Cerceda 38 63 31 73
2 Ponte Ourense Ponte 38 70 43 72
3 Celta Fortuna Celta 38 92 44 71
4 Lalín Lalín 38 52 42 63
5 CD Estradense Estradense 38 40 33 60
6 Caselas Caselas 38 68 58 59
7 Viveiro Viveiro 38 61 50 58
8 Villalonga FC Villalonga 38 68 63 57
9 Porriño Industrial Porriño 38 63 51 57
10 Betanzos CF Betanzos CF 38 64 58 55
11 Mosteiro Mosteiro 38 47 44 52
12 Ribadeo FC Ribadeo FC 38 58 72 51
13 UD Xove Lago Xove Lago 38 46 44 50
14 Celta C – Gran Peña Celta Gran. 38 58 52 48
15 Somozas Somozas 38 57 59 45
16 Arosa Arosa 38 49 63 44
17 Mindoniense Mindoniense 38 29 57 37
18 SD Burela SD Burela 38 40 68 36
19 Flavia Flavia 38 32 79 24
20 Coruxo Coruxo 38 34 80 22

  USO DE MEMORIA  
7,560,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6878
Total Execution Time  0.6891
  CADENA URL  
/historico/Gran-Pena
  GET DATOS  
$_GET['/historico/Gran-Pena']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0137  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 = 'Gran-Pena' 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=1250 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=1250 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=1250 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=1250 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 75982
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1250 AND type_rel = 2
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2618 AND type_rel = 3
0.0137  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 = '1250' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '1250' 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 = 75982 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  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=1250 AND l.year in (2023,2024,2025) 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 (75982,72260,71432,68172) 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 = 72260 AND teamId = 1250
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 75982 AND teamId = 1250
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1250
0.0138  SELECT count(id) as num_players from rel_players WHERE league_id = 68172 AND teamId = 1250
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 = '1250' 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 = '1250' 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 = '1250' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 75982 WHERE rp.league_id = 75982 AND rp.teamId = 1250 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.0126  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 = 75982 WHERE rp.league_id = 75982 AND rp.teamId = 1250 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 75982 WHERE rp.league_id = 75982 AND rp.teamId = 1250 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 1250 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 67975 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `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 = 64089 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.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 `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 = 67010 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.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 61706 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.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 62844 AND t.round = 4 ORDER BY team.conference ASC,t.position 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 `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 = 51174 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.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 `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 = 45151 AND t.round = 34 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 `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 = 39708 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 `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 = 34039 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 16769 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 4055 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 `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 = 1452 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 `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 = 1147 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 `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 = 846 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 `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 = 131 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 `tables1999` 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 = 20995 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 `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 = 20994 AND t.round = 42 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 `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 = 21044 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 `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 = 21043 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC