4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Barco
TEMPORADA 2023/2024
PREFERENTE GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 Villalonga FC Villalonga 30 60 25 66
2 Céltiga FC Céltiga FC 30 60 31 57
3 CD Valladares Valladares 30 51 35 52
4 Choco Choco 30 51 38 50
5 Porriño Industrial Porriño 31 53 44 47
6 Portonovo Portonovo 30 51 44 44
7 Cambados Cambados 30 48 50 44
8 Cultural Areas Cultural 31 41 49 43
9 Antela FC Antela FC 31 44 49 42
10 At. Arnoia At. Arnoia 30 45 50 42
11 UD Atios UD Atios 30 41 35 41
12 Juvenil Ponteareas Juvenil 30 42 39 40
13 CD Moaña CD Moaña 30 38 49 38
14 Barco Barco 30 40 42 36
15 Ribadumia Ribadumia 30 48 48 33
16 Alertanavia CP Alertanavia 30 28 57 25
17 CD Velle CD Velle 30 29 54 25
18 CD Allariz CD Allariz 31 37 68 19
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
TERCERA FEDERACIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 CD Lugo B CD Lugo B 32 54 23 68
2 Ourense CF Ourense CF 32 48 21 67
3 Somozas Somozas 32 43 30 63
4 Barco Barco 32 50 37 54
5 Deportivo Fabril Deportivo 32 49 23 53
6 Rápido de Bouzas Rápido 32 39 26 51
7 RC Villalbés Villalbés 32 43 24 50
8 CD Estradense Estradense 32 36 40 44
9 Alondras CF Alondras CF 32 30 29 40
10 Silva SD Silva SD 32 34 41 39
11 CSD Arzua CSD Arzua 32 29 35 38
12 Viveiro Viveiro 32 32 42 36
13 Choco Choco 32 32 43 35
14 Noia Noia 32 30 49 29
15 Juvenil Ponteareas Juvenil 32 25 43 28
16 At. Arnoia At. Arnoia 32 25 54 22
17 SD Sofán SD Sofán 32 29 68 17
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Bergantiños FC Bergantiños 22 37 16 48
2 CD Lugo B CD Lugo B 22 34 17 42
3 Somozas Somozas 22 41 21 41
4 RC Villalbés Villalbés 22 34 26 40
5 Deportivo Fabril Deportivo 22 41 27 32
6 Silva SD Silva SD 22 21 20 30
7 CSD Arzua CSD Arzua 22 32 23 29
8 Viveiro Viveiro 22 25 39 28
9 AG Estudiantil Estudiantil 22 27 45 20
10 As Pontes As Pontes 22 18 40 19
11 SD Fisterra SD Fisterra 22 22 35 17
12 UD Paiosaco UD Paiosaco 22 16 39 12
13 Arenteiro Arenteiro 22 33 13 47
14 Arosa Arosa 22 27 14 41
15 Alondras CF Alondras CF 22 31 15 37
16 CD Estradense Estradense 22 35 34 31
17 Choco Choco 22 28 22 31
18 Rápido de Bouzas Rápido 22 25 25 31
19 Barco Barco 22 26 27 30
20 Ourense CF Ourense CF 22 33 29 28
21 Ribadumia Ribadumia 22 24 36 26
22 Ourense UD Ourense UD 22 25 32 25
23 UD Atios UD Atios 22 18 32 20
24 Pontellas Pontellas 22 12 38 9
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 SD Compostela Compostela 27 50 15 61
2 Ourense CF Ourense CF 27 50 21 60
3 Arosa Arosa 27 42 31 47
4 Barco Barco 27 40 40 47
5 Choco Choco 27 40 28 43
6 CSD Arzua CSD Arzua 27 40 39 41
7 Deportivo Fabril Deportivo 27 38 28 40
8 Ourense UD Ourense UD 27 32 36 40
9 Arenteiro Arenteiro 27 29 31 35
10 CD Estradense Estradense 27 33 32 35
11 CD Lugo B CD Lugo B 27 51 33 35
12 Silva SD Silva SD 27 24 25 35
13 Bergantiños FC Bergantiños 27 27 31 34
14 RC Villalbés Villalbés 27 30 30 34
15 Somozas Somozas 27 31 43 32
16 Alondras CF Alondras CF 27 32 45 32
17 As Pontes As Pontes 27 39 44 28
18 Rápido de Bouzas Rápido 27 36 54 23
19 Pontellas Pontellas 27 22 56 20
20 UD Paiosaco UD Paiosaco 27 23 47 17
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Ferrol Racing 38 80 35 78
2 Bergantiños FC Bergantiños 38 58 42 74
3 SD Compostela Compostela 38 80 47 68
4 Alondras CF Alondras CF 38 47 36 65
5 Barco Barco 38 58 43 64
6 Ourense CF Ourense CF 38 51 24 64
7 Choco Choco 38 59 47 59
8 Ourense UD Ourense UD 38 45 39 59
9 Arosa Arosa 38 57 44 57
10 CD Lugo B CD Lugo B 38 55 53 52
11 RC Villalbés Villalbés 38 47 48 52
12 Silva SD Silva SD 38 52 56 48
13 Arenteiro Arenteiro 38 41 53 47
14 Somozas Somozas 38 45 52 46
15 UD Paiosaco UD Paiosaco 38 46 59 45
16 Céltiga FC Céltiga FC 38 36 66 41
17 Laracha Laracha 38 42 49 40
18 Ribadumia Ribadumia 38 41 65 38
19 Boiro Boiro 38 34 79 31
20 Porriño Industrial Porriño 38 37 74 27
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 SD Compostela Compostela 38 78 34 86
2 Bergantiños FC Bergantiños 38 77 29 80
3 RC Villalbés Villalbés 38 60 30 71
4 Alondras CF Alondras CF 38 61 34 69
5 Arosa Arosa 38 65 34 67
6 Somozas Somozas 38 63 42 63
7 Barco Barco 38 63 44 63
8 Choco Choco 38 50 44 59
9 Ourense CF Ourense CF 38 48 36 58
10 Boiro Boiro 38 52 53 58
11 Silva SD Silva SD 38 45 46 55
12 Ribadumia Ribadumia 38 44 55 47
13 Céltiga FC Céltiga FC 38 32 57 44
14 Arenteiro Arenteiro 38 39 61 42
15 Laracha Laracha 38 35 44 41
16 Cultural Areas Cultural 38 48 82 34
17 Noia Noia 38 42 72 32
18 Barbadás Barbadás 38 29 61 32
19 Negreira Negreira 38 31 63 31
20 Villalonga FC Villalonga 38 28 69 27
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Deportivo Fabril Deportivo 38 79 31 81
2 Rápido de Bouzas Rápido 38 51 24 72
3 CCD Cerceda CCD Cerceda 38 65 36 71
4 Bergantiños FC Bergantiños 38 52 31 68
5 RC Villalbés Villalbés 38 51 35 67
6 Arosa Arosa 38 51 38 64
7 SD Compostela Compostela 38 61 47 62
8 Villalonga FC Villalonga 38 55 40 59
9 Silva SD Silva SD 38 52 50 57
10 Choco Choco 38 55 50 52
11 Barbadás Barbadás 38 45 48 50
12 Negreira Negreira 38 51 48 49
13 Barco Barco 38 50 55 49
14 Alondras CF Alondras CF 38 50 45 48
15 Ribadumia Ribadumia 38 41 52 48
16 Céltiga FC Céltiga FC 38 42 45 47
17 CD Castro CD Castro 38 47 72 37
18 As Pontes As Pontes 38 32 67 28
19 Dubra Dubra 38 36 83 21
20 Club Ordenes SD Club Ordenes 38 24 93 9
TEMPORADA 2015/2016
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Boiro Boiro 38 71 33 77
2 CCD Cerceda CCD Cerceda 38 64 40 72
3 Deportivo Fabril Deportivo 38 74 46 67
4 Choco Choco 38 57 40 63
5 RC Villalbés Villalbés 38 51 43 58
6 Barco Barco 38 55 54 57
7 Alondras CF Alondras CF 38 44 41 56
8 Rápido de Bouzas Rápido 38 51 46 55
9 Arosa Arosa 38 55 48 54
10 As Pontes As Pontes 38 49 54 49
11 Ribadumia Ribadumia 38 54 51 48
12 Negreira Negreira 38 47 48 48
13 Silva SD Silva SD 38 53 56 48
14 Barbadás Barbadás 38 47 58 45
15 Club Ordenes SD Club Ordenes 38 33 45 45
16 Bergantiños FC Bergantiños 38 38 43 43
17 Galicia Mugardos Galicia 38 48 63 43
18 Ribadeo FC Ribadeo FC 38 41 68 35
19 Noia Noia 38 28 59 32
20 Verín Verín 38 30 54 31
TEMPORADA 2014/2015
PREFERENTE GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 Barco Barco 38 74 41 77
2 Verín Verín 38 67 32 75
3 Portonovo Portonovo 38 77 48 72
4 CD Estradense Estradense 38 58 35 67
5 Porriño Industrial Porriño 38 68 48 66
6 Villalonga FC Villalonga 38 50 39 60
7 Lalín Lalín 38 63 46 57
8 Gondomar Cf Gondomar Cf 38 62 52 56
9 CD Valladares Valladares 38 56 53 55
10 Mondariz CF Mondariz CF 38 58 60 55
11 UD Atios UD Atios 38 51 46 54
12 Arenteiro Arenteiro 38 51 54 51
13 Céltiga FC Céltiga FC 38 49 55 49
14 Marcón Atletico Marcón 38 52 56 48
15 CP Alertanavia Alertanavia 38 63 73 47
16 Erizana Erizana 38 59 69 46
17 SD Nogueira de Ramuín Nogueira 38 39 64 40
18 Pontellas Pontellas 38 35 66 27
19 Rápido Bahía Rápido 38 43 87 26
20 Pontevedra B Pontevedra 38 32 83 17
TEMPORADA 2013/2014
PREFERENTE GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ribadumia Ribadumia 38 75 46 69
2 Club Xuventú Sanxenxo Club 38 64 43 68
3 Villalonga FC Villalonga 38 70 38 65
4 CD Valladares Valladares 38 68 45 62
5 Lalín Lalín 38 64 57 59
6 Pontellas Pontellas 38 53 42 59
7 Gondomar Cf Gondomar Cf 38 51 41 57
8 Pontevedra B Pontevedra 38 65 64 56
9 CD Estradense Estradense 38 54 54 55
10 Barco Barco 38 48 48 54
11 Portonovo Portonovo 38 63 43 54
12 Porriño Industrial Porriño 38 51 49 52
13 Céltiga FC Céltiga FC 38 50 47 51
14 Mondariz CF Mondariz CF 38 49 56 50
15 CD Ourense B Ourense 38 50 56 49
16 Rápido Bahía Rápido 38 49 63 49
17 UD Atios UD Atios 38 47 49 46
18 Caselas Caselas 38 40 67 33
19 USD O Grove USD O Grove 38 37 75 31
20 Melias Melias 38 39 104 24
TEMPORADA 2012/2013
PREFERENTE GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 Cultural Areas Cultural 38 75 44 73
2 Arosa Arosa 38 79 37 72
3 Choco Choco 38 68 33 72
4 Sanxenxo Sanxenxo 38 56 35 70
5 Portonovo Portonovo 38 57 41 70
6 Gondomar Cf Gondomar Cf 38 80 50 66
7 Ribadumia Ribadumia 38 73 46 64
8 CD Valladares Valladares 38 49 37 59
9 UD Atios UD Atios 38 60 52 59
10 CD Lalín CD Lalín 38 59 52 52
11 Pontellas Pontellas 38 49 61 51
12 Barco Barco 38 56 62 49
13 Pontevedra B Pontevedra 38 51 57 48
14 USD O Grove USD O Grove 38 55 71 48
15 CD Estradense Estradense 38 47 54 47
16 Mondariz CF Mondariz CF 38 43 54 42
17 Arenteiro Arenteiro 38 40 62 39
18 Verín Verín 38 44 67 33
19 Marín CF Marín CF 38 25 76 24
20 Ourense CF Ourense CF 38 28 103 12
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 2008/2009
PREFERENTE GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 Cultural Areas Cultural 38 64 38 72
2 Barbadás Barbadás 38 61 41 70
3 CD Estradense Estradense 38 72 48 65
4 Cruceiro Do Hío Cruceiro 38 66 42 65
5 Porriño Industrial Porriño 38 60 47 65
6 Ribadumia Ribadumia 38 58 66 56
7 Arenteiro Arenteiro 38 60 50 54
8 Choco Choco 38 48 38 53
9 Pontellas Pontellas 38 53 45 53
10 Caselas Caselas 38 56 53 53
11 Sanxenxo Sanxenxo 38 53 59 51
12 Sporting Celanova Sporting 38 46 45 49
13 Marín CF Marín CF 38 56 70 47
14 Tomiño Tomiño 38 56 54 46
15 Salvatierra SD Salvatierra 38 41 45 46
16 CD Ourense B Ourense 38 47 65 46
17 Barco Barco 38 49 71 37
18 CD Grove CD Grove 38 42 58 36
19 Ponte Ourense Ponte 38 46 67 34
20 Melias Melias 38 43 75 34
TEMPORADA 1993/1994
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Bergantiños FC Bergantiños 38 49 26 51
2 Deportivo Fabril Deportivo 38 71 38 50
3 As Pontes As Pontes 38 64 38 47
4 Viveiro Viveiro 38 48 34 46
5 SD Burela SD Burela 38 42 36 44
6 UD Xove Lago Xove Lago 38 46 37 44
7 Betanzos CF Betanzos CF 38 53 43 42
8 CD Estradense Estradense 38 46 36 42
9 Villalonga FC Villalonga 38 42 44 39
10 Caselas Caselas 38 60 54 38
11 Rácing Vilalbés Rácing 38 40 40 38
12 Mindoniense Mindoniense 38 38 57 35
13 Somozas Somozas 38 40 51 34
14 Club Ordenes SD Club Ordenes 38 35 44 34
15 Lalín Lalín 38 40 47 32
16 Arenteiro Arenteiro 38 50 48 32
17 Mosteiro Mosteiro 38 33 47 32
18 Portonovo Portonovo 38 39 48 31
19 Barco Barco 38 32 66 25
20 Cambados Cambados 38 32 66 24
TEMPORADA 1992/1993
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Arosa Arosa 38 51 16 55
2 Viveiro Viveiro 38 65 29 52
3 Arenteiro Arenteiro 38 70 38 52
4 Villalonga FC Villalonga 38 44 25 44
5 Deportivo Fabril Deportivo 38 63 41 43
6 Cambados Cambados 38 48 41 42
7 Club Ordenes SD Club Ordenes 38 44 33 42
8 UD Xove Lago Xove Lago 38 46 36 40
9 Rácing Vilalbés Rácing 38 43 46 40
10 CD Estradense Estradense 38 34 45 37
11 Lalín Lalín 38 42 43 36
12 Portonovo Portonovo 38 40 42 36
13 Bergantiños FC Bergantiños 38 38 36 36
14 Caselas Caselas 38 45 59 36
15 Barco Barco 38 32 44 34
16 Mindoniense Mindoniense 38 44 56 33
17 SD Burela SD Burela 38 40 59 33
18 Gondomar Cf Gondomar Cf 38 44 60 31
19 Celta C – Gran Peña Celta Gran. 38 27 64 22
20 Meiras CF Meiras CF 38 26 73 16
TEMPORADA 1991/1992
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Ferrol Racing 38 82 34 54
2 Celta Fortuna Celta 38 61 24 53
3 Arenteiro Arenteiro 38 52 30 50
4 Bergantiños FC Bergantiños 38 58 27 49
5 Barco Barco 38 62 28 49
6 SD Burela SD Burela 38 52 37 44
7 CD Estradense Estradense 38 33 37 40
8 Club Ordenes SD Club Ordenes 38 36 27 39
9 Arosa Arosa 38 47 40 38
10 Mindoniense Mindoniense 38 40 44 38
11 Gondomar Cf Gondomar Cf 38 37 54 37
12 Celta C – Gran Peña Celta Gran. 38 41 46 37
13 Viveiro Viveiro 38 40 33 37
14 Villalonga FC Villalonga 38 48 44 37
15 Meiras CF Meiras CF 38 21 35 36
16 Flavia Flavia 38 29 43 31
17 Alondras CF Alondras CF 38 42 58 30
18 Coruxo Coruxo 38 32 79 23
19 Betanzos CF Betanzos CF 38 33 74 23
20 Club Lemos Club Lemos 38 27 79 15
TEMPORADA 1990/1991
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Lalín Lalín 38 81 23 59
2 Bergantiños FC Bergantiños 38 61 29 55
3 SD Burela SD Burela 38 58 22 51
4 Deportivo Fabril Deportivo 38 76 36 51
5 Racing Ferrol Racing 38 62 34 49
6 Celta Fortuna Celta 38 48 32 47
7 Villalonga FC Villalonga 38 53 47 43
8 Viveiro Viveiro 38 45 46 42
9 Celta C – Gran Peña Celta Gran. 38 53 55 39
10 Arenteiro Arenteiro 38 41 42 35
11 Arosa Arosa 38 34 47 34
12 Barco Barco 38 41 48 32
13 Club Ordenes SD Club Ordenes 38 36 46 32
14 Club Lemos Club Lemos 38 34 49 31
15 Betanzos CF Betanzos CF 38 38 58 31
16 Alondras CF Alondras CF 38 38 56 29
17 Meiras CF Meiras CF 38 28 63 27
18 Gondomar Cf Gondomar Cf 38 28 58 26
19 Sporting Sada Sporting 38 37 67 24
20 Boiro Boiro 38 29 63 23
TEMPORADA 1989/1990
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 SD Compostela Compostela 38 71 18 62
2 Deportivo Fabril Deportivo 38 66 35 56
3 Villalonga FC Villalonga 38 62 32 51
4 Bergantiños FC Bergantiños 38 53 34 46
5 Viveiro Viveiro 38 46 35 44
6 Arenteiro Arenteiro 38 47 38 42
7 Celta C – Gran Peña Celta Gran. 38 40 40 42
8 Betanzos CF Betanzos CF 38 57 42 42
9 Celta Fortuna Celta 38 44 32 39
10 Club Ordenes SD Club Ordenes 38 33 31 37
11 Barco Barco 38 46 47 35
12 SD Burela SD Burela 38 50 62 35
13 Gondomar Cf Gondomar Cf 38 39 51 34
14 Club Lemos Club Lemos 38 39 42 34
15 Boiro Boiro 38 31 37 33
16 Puebla Farnals Puebla 38 35 50 32
17 Tyde F.C. Tyde F.C. 38 44 62 28
18 Coruxo Coruxo 38 45 76 27
19 Juvenil Ponteareas Juvenil 38 24 58 23
20 Vista Alegre SD Vista Alegre 38 33 83 18
TEMPORADA 1988/1989
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Cambados Cambados 38 77 28 59
2 Juvenil Ponteareas Juvenil 38 56 35 46
3 SD Compostela Compostela 38 53 30 45
4 Barco Barco 38 58 46 43
5 Deportivo Fabril Deportivo 38 56 42 43
6 Club Lemos Club Lemos 38 40 30 43
7 Villalonga FC Villalonga 38 43 32 42
8 Celta C – Gran Peña Celta Gran. 38 45 38 42
9 Viveiro Viveiro 38 50 44 39
10 Boiro Boiro 38 46 51 39
11 Vista Alegre SD Vista Alegre 38 50 60 36
12 Betanzos CF Betanzos CF 38 45 51 36
13 Tyde F.C. Tyde F.C. 38 47 58 36
14 Puebla Galicia CF Puebla 38 36 48 35
15 Gondomar Cf Gondomar Cf 38 45 55 34
16 Coruxo Coruxo 38 35 49 31
17 Alondras CF Alondras CF 38 35 54 30
18 Sporting Sada Sporting 38 40 59 30
19 Céltiga FC Céltiga FC 38 43 65 29
20 CD Ourense B Ourense 38 32 57 22

  USO DE MEMORIA  
8,110,992 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1769
Total Execution Time  0.1782
  CADENA URL  
/historico/Barco
  GET DATOS  
$_GET['/historico/Barco']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
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 = 'Barco' 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.0018  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=433 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=433 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 73535
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=433 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 433 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (41299,93042,124366,528523,686049) 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 = '433' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '433' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '433' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 73535 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0041  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=433 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73535,67975) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 67975 AND teamId = 433
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 73535 AND teamId = 433
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 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 = 73535 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '433' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '433' and rp.type = 4
0.0042  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 = '433' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0042  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 = 73535 WHERE rp.league_id = 73535 AND rp.teamId = 433 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.0028  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 = 73535 WHERE rp.league_id = 73535 AND rp.teamId = 433 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 73535 WHERE rp.league_id = 73535 AND rp.teamId = 433 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 433 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73535 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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.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 `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 = 62385 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.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 `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 = 58579 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.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 `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 = 50269 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 = 44389 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 = 39025 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 `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 = 4050 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 `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 = 2588 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0058  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 = 1976 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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.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 = 307 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 `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 = 20990 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 `tables1993` 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 = 20989 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 `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 = 20988 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 `tables1991` 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 = 20987 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 `tables1990` 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 = 20986 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 `tables1989` 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 = 20985 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC