4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Arenas de Armilla
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 J. Torremolinos Torremolinos 30 62 21 69
2 Real Jaén Real Jaén 30 59 25 63
3 UD Torre Del Mar Torre 31 43 27 59
4 At. Malagueño Malagueño 30 48 19 57
5 Almería B Almería B 30 56 24 57
6 CF Motril CF Motril 30 34 18 49
7 Arenas de Armilla Arenas 30 28 33 44
8 Huétor Vega Huétor Vega 30 36 35 42
9 Poli Almería Poli 30 30 30 40
10 UDC Torredonjimeno Torredonjime 30 31 41 36
11 CD Torreperogil Torreperogil 30 29 37 35
12 Mancha Real Mancha Real 30 36 36 35
13 FC Málaga City Málaga City 30 22 38 30
14 Pvo. El Ejido Pvo. Ejido 30 24 36 30
15 CD Huétor Tájar Huétor 30 20 35 30
16 Maracena Maracena 30 27 47 28
17 CD Rincón CD Rincón 30 24 49 19
18 Atletico Melilla Atletico 31 15 73 4
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Marbella FC Marbella FC 30 67 17 72
2 Real Jaén Real Jaén 30 59 12 68
3 El Palo FC El Palo FC 30 43 20 63
4 UD Torre Del Mar Torre 30 53 31 55
5 At. Malagueño Malagueño 30 45 27 45
6 Huétor Vega Huétor Vega 30 42 35 45
7 CF Motril CF Motril 30 37 41 41
8 UDC Torredonjimeno Torredonjime 30 45 42 41
9 Almería B Almería B 30 40 34 41
10 Arenas de Armilla Arenas 30 36 36 39
11 CD Torreperogil Torreperogil 30 40 45 38
12 CD Huétor Tájar Huétor 30 52 44 37
13 Maracena Maracena 30 34 48 33
14 FC Málaga City Málaga City 30 22 48 25
15 Atletico Porcuna Atletico 30 30 54 21
16 CD Huracán Melilla Huracán 30 8 119 5
TEMPORADA 2021/2022
DIVISIÓN HONOR SENIOR GRUPO 2
Equipo PJ GF GC Puntos
1 CD Estepona CD Estepona 36 82 26 83
2 FC Málaga City Málaga City 36 61 29 75
3 Arenas de Armilla Arenas 36 64 23 70
4 Maracena Maracena 36 73 36 66
5 CD Villacarrillo Villacarrill 36 53 39 62
6 CD Rincón CD Rincón 36 54 39 60
7 CD Cantoria CD Cantoria 36 58 52 58
8 Atarfe Industrial Atarfe 36 53 50 54
9 Berja Berja 36 51 47 53
10 Cubillas FC Cubillas FC 36 48 40 52
11 Poli Almería Poli 36 42 36 50
12 CD Casabermeja Casabermeja 36 43 45 48
13 Celtic Pulianas Celtic 36 48 46 48
14 Begíjar CF Begíjar CF 36 40 45 45
15 Iliturgi 2016 Iliturgi 36 48 58 38
16 La Cañada Atlético Cañada 36 39 69 26
17 Loja Loja 36 29 73 18
18 Atlético Monachil Atlético 36 30 79 18
19 CD Churriana Churriana 36 29 113 16
TEMPORADA 2020/2021
DIVISIÓN HONOR SENIOR GRUPO 7
Equipo PJ GF GC Puntos
1 UD Torre Del Mar Torre 26 37 22 51
2 UD San Pedro Pedro 26 48 22 50
3 Arenas de Armilla Arenas 26 42 29 46
4 Begíjar CF Begíjar CF 26 38 25 43
5 Atarfe Industrial Atarfe 26 34 29 42
6 CD Rincón CD Rincón 26 33 30 37
7 CD Churriana Churriana 26 32 42 35
8 CD Villacarrillo Villacarrill 26 34 32 34
TEMPORADA 2019/2020
DIVISIÓN HONOR SENIOR GRUPO 2
Equipo PJ GF GC Puntos
1 CD Alhaurino Alhaurino 26 52 18 59
2 J. Torremolinos Torremolinos 27 46 17 57
3 CD Estepona CD Estepona 27 42 19 55
4 CD Rincón CD Rincón 26 48 32 46
5 Celtic Pulianas Celtic 27 45 40 46
6 Athletic Coín Athletic 27 37 37 44
7 Begíjar CF Begíjar CF 26 34 25 42
8 UD San Pedro Pedro 27 26 31 38
9 Atarfe Industrial Atarfe 26 36 28 36
10 Arenas de Armilla Arenas 26 37 34 36
11 Berja Berja 27 37 28 35
12 CD Villacarrillo Villacarrill 27 41 37 33
13 Martos CD Martos CD 27 34 46 30
14 CD Cantoria CD Cantoria 27 29 49 30
15 Cubillas FC Cubillas FC 26 25 28 29
16 CD Churriana Churriana 26 24 44 27
17 CD Casabermeja Casabermeja 27 22 38 24
18 Guadix CF Guadix CF 26 19 44 22
19 CD Villanueva Villanueva 26 21 60 11
TEMPORADA 2018/2019
DIVISIÓN HONOR SENIOR GRUPO 2
Equipo PJ GF GC Puntos
1 Atletico Porcuna Atletico 34 61 29 71
2 Maracena Maracena 34 58 33 69
3 Berja Berja 34 69 34 63
4 CD Casabermeja Casabermeja 34 41 32 56
5 Begíjar CF Begíjar CF 34 54 42 55
6 Celtic Pulianas Celtic 34 43 38 52
7 CD Estepona CD Estepona 34 42 41 51
8 Athletic Coín Athletic 34 48 35 50
9 Arenas de Armilla Arenas 34 58 51 50
10 CD Villacarrillo Villacarrill 34 43 44 49
11 Cd Oriente Cd Oriente 34 47 47 45
12 CD Vera CD Vera 34 46 47 41
13 Malaka Malaka 34 41 51 41
14 Navas CD Navas CD 34 42 42 40
15 CD Cártama CD Cártama 34 53 72 39
16 Cullar Vega Cullar Vega 34 43 60 33
17 Atlético Monachil Atlético 34 31 77 26
18 Cd Adra Milenaria Adra 34 24 69 18
TEMPORADA 2017/2018
DIVISIÓN HONOR SENIOR GRUPO 2
Equipo PJ GF GC Puntos
1 CD Torreperogil Torreperogil 34 80 35 76
2 Alhaurín de la Torre Alhaurín 34 71 32 73
3 Poli Almería Poli 34 67 28 68
4 CD Alhaurino Alhaurino 34 67 32 68
5 Atletico Porcuna Atletico 34 52 34 67
6 Cd Adra Milenaria Adra 34 51 47 49
7 Malaka Malaka 34 45 49 49
8 Estudiantes de Almeria Estudiantes 34 66 57 46
9 CD Estepona CD Estepona 34 47 50 44
10 Berja Berja 33 52 51 43
11 Navas CD Navas CD 34 48 56 43
12 Arenas de Armilla Arenas 34 42 48 40
13 Athletic Coín Athletic 34 53 58 38
14 Atlético Monachil Atlético 33 46 75 37
15 Cullar Vega Cullar Vega 33 41 62 36
16 UD Pavía UD Pavía 34 33 66 29
17 Churriana de la Vega Churriana 33 36 76 24
18 Roquetas CF 2016 Roquetas 30 31 72 22
TEMPORADA 2016/2017
DIVISIÓN HONOR SENIOR GRUPO 2
Equipo PJ GF GC Puntos
1 J. Torremolinos Torremolinos 36 96 28 86
2 CD Villacarrillo Villacarrill 36 70 43 78
3 Athletic Coín Athletic 36 62 40 69
4 Atletico Porcuna Atletico 36 73 53 68
5 CD Torreperogil Torreperogil 36 71 55 61
6 Arenas de Armilla Arenas 36 52 41 56
7 Estudiantes de Almeria Estudiantes 36 59 53 56
8 Cd Adra Milenaria Adra 36 61 65 48
9 CD Estepona CD Estepona 36 55 45 47
10 Poli Almería Poli 36 55 60 47
11 Cullar Vega Cullar Vega 36 45 56 47
12 Linares Deportivo B Linares 36 56 57 46
13 Atlético Monachil Atlético 36 50 56 45
14 UD Pavía UD Pavía 36 36 46 40
15 CD Ronda CD Ronda 36 45 71 38
16 CD Tiro Pichón Tiro Pichón 36 46 68 37
17 Cd Oriente Cd Oriente 36 39 66 34
18 La Cañada Atlético Cañada 36 38 70 31
19 Comarca Del Marmol Comarca 36 44 80 28
TEMPORADA 2015/2016
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 CF Motril CF Motril 34 83 28 75
2 Cd Huetor Vega Huetor Vega 34 78 24 73
3 Cd Oriente Cd Oriente 34 67 43 61
4 Arenas de Armilla Arenas 33 69 38 60
5 UD Pavía UD Pavía 34 54 37 57
6 Cullar Vega Cullar Vega 34 60 55 57
7 Cd Adra Milenaria Adra 33 54 47 55
8 CD Universidad de Almería Universidad 33 71 43 52
9 La Cañada Atlético Cañada 33 68 66 50
10 Purullena CF Purullena 34 54 56 46
11 Alfacar UD Alfacar UD 34 50 55 44
12 Vandalia Vandalia 34 41 58 40
13 Berja Berja 34 50 68 39
14 Churriana de la Vega Churriana 34 39 51 39
15 Ciudad de Roquetas Ciudad 33 47 65 34
16 Baza Baza 34 38 68 29
17 Los Molinos Los Molinos 34 44 83 27
18 Celtic Pulianas Celtic 33 32 114 8
TEMPORADA 2014/2015
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 Comarca Del Marmol Comarca 34 85 36 78
2 Arenas de Armilla Arenas 34 67 24 76
3 Cd Adra Milenaria Adra 34 69 43 67
4 Cd Huetor Vega Huetor Vega 34 56 38 59
5 UD Pavía UD Pavía 34 53 41 56
6 CD Universidad de Almería Universidad 34 57 45 50
7 Alfacar UD Alfacar UD 34 52 47 50
8 Almuñecar 77 Almuñecar 34 51 65 45
9 Churriana de la Vega Churriana 34 54 61 43
10 Vandalia Vandalia 34 56 55 42
11 Cullar Vega Cullar Vega 34 31 33 42
12 Cd Oriente Cd Oriente 34 47 44 41
13 Celtic Pulianas Celtic 34 59 71 41
14 Baza Baza 34 31 50 41
15 La Cañada Atlético Cañada 34 50 61 40
16 CD Mojácar CD Mojácar 34 40 64 34
17 CD Huercal CD Huercal 34 46 69 32
18 Atl. La Zubia Atl. Zubia 34 36 93 22
TEMPORADA 2013/2014
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 Pvo. El Ejido Pvo. Ejido 34 91 37 76
2 Guadix CF Guadix CF 34 71 30 71
3 Baza Baza 34 57 38 63
4 Huétor Vega Huétor Vega 34 68 50 56
5 UD Pavía UD Pavía 34 80 51 56
6 Atl. La Zubia Atl. Zubia 34 59 50 52
7 CD Universidad de Almería Universidad 34 57 43 51
8 Vandalia Vandalia 34 53 51 47
9 Cd Oriente Cd Oriente 34 44 58 45
10 Arenas de Armilla Arenas 34 45 49 42
11 Cullar Vega Cullar Vega 34 61 75 41
12 CD Mojácar CD Mojácar 34 54 64 39
13 Ciudad de Roquetas Ciudad 34 54 55 38
14 Churriana de la Vega Churriana 34 40 51 37
15 Alfacar UD Alfacar UD 34 42 62 36
16 Águilas De Zujaira Águilas 34 43 78 33
17 CD Vera CD Vera 34 50 82 31
18 CD Comarca de Níjar Comarca 34 35 80 22
TEMPORADA 2012/2013
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 Español de Alquián Español 34 101 37 76
2 Los Molinos Los Molinos 34 63 30 71
3 Guadix CF Guadix CF 34 63 32 64
4 Cp Berja Cp Berja 34 63 41 56
5 Baza Baza 34 60 35 55
6 Atl. La Zubia Atl. Zubia 34 60 39 54
7 Arenas de Armilla Arenas 34 53 51 49
8 Águilas De Zujaira Águilas 34 42 50 49
9 CD Vera CD Vera 34 49 53 48
10 Cúllar Vega Cf Cúllar Vega 34 51 57 47
11 UD Pavía UD Pavía 34 63 53 46
12 Cd Oriente Cd Oriente 34 52 65 45
13 Ciudad de Roquetas Ciudad 34 30 38 44
14 Churriana de la Vega Churriana 34 35 44 36
15 Huetor Tajar B Huetor Tajar 34 44 67 31
16 Atletismo Padul Atletismo 34 42 69 29
17 Cuevas CF Cuevas CF 34 29 85 22
18 Ad Parador Ad Parador 34 29 83 21
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Loja Loja 40 87 33 86
2 Unión Estepona Unión 40 76 37 85
3 Marbella FC Marbella FC 40 66 28 78
4 At. Malagueño Malagueño 39 77 34 76
5 Maracena Maracena 39 62 40 73
6 CD Comarca de Níjar Comarca 40 57 34 70
7 Mancha Real Mancha Real 40 53 34 70
8 UD San Pedro Pedro 40 67 46 67
9 El Palo FC El Palo FC 40 63 57 65
10 Martos CD Martos CD 40 49 45 59
11 Casino Real CF Casino Real 39 44 49 54
12 CD Ronda CD Ronda 40 49 60 51
13 Alhaurín de la Torre Alhaurín 40 59 63 50
14 CD Huétor Tájar Huétor 39 50 56 49
15 Motril CF Motril CF 40 51 45 48
16 CD Nerja Fundación Nerja 39 42 57 45
17 Vélez CF Vélez CF 39 36 60 39
18 Arenas de Armilla Arenas 40 35 51 37
19 Antequera CF Antequera 40 47 70 37
20 Ciudad Vícar Ciudad 40 22 80 18
21 UD Carboneras Carboneras 40 6 119 4
TEMPORADA 2010/2011
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 Arenas de Armilla Arenas 33 57 26 68
2 Los Molinos Los Molinos 32 71 32 62
3 Atlético Monachil Atlético 32 69 45 56
4 Español de Alquián Español 32 74 51 56
5 Guadix CF Guadix CF 32 55 29 55
6 Parador Roquetas Parador 32 50 43 54
7 Recreativo Granada Recreativo 32 67 33 53
8 Cullar Vega Cullar Vega 32 52 41 53
9 Atarfe Industrial Atarfe 32 48 30 51
10 Berja Berja 32 51 48 46
11 UD Pavía UD Pavía 32 44 43 44
12 Atl. La Zubia Atl. Zubia 32 50 65 40
13 Vandalia Vandalia 32 30 39 37
14 CD Vera CD Vera 32 32 65 31
15 Huétor Vega Huétor Vega 32 29 65 21
16 CD UD Íllora Íllora 32 33 94 17
17 UD Los Marinos Marinos 32 25 86 12
18 San Isidro CD Isidro 1 0 2 0
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Mancha Real Mancha Real 36 53 26 68
2 Motril CF Motril CF 36 54 24 66
3 El Palo FC El Palo FC 36 59 44 63
4 Almería B Almería B 36 62 37 61
5 CD Ronda CD Ronda 36 64 51 60
6 At. Malagueño Malagueño 36 56 44 59
7 CD Comarca de Níjar Comarca 36 52 34 57
8 Ciudad Vícar Ciudad 36 52 48 53
9 Loja Loja 36 42 40 49
10 Antequera CF Antequera 36 43 38 47
11 Vélez CF Vélez CF 36 50 52 47
12 CD Alhaurino Alhaurino 36 53 54 45
13 Adra Adra 36 47 59 45
14 CD Santa Fe CD Santa Fe 36 40 55 41
15 Carboneras Carboneras 36 43 63 38
16 CD Huétor Tájar Huétor 36 44 67 38
17 Baza Baza 36 36 54 37
18 Arenas de Armilla Arenas 36 33 63 35
19 Polideportivo Ejido B Polideportiv 19 21 22 24
20 CD Vera CD Vera 19 17 46 10
TEMPORADA 2008/2009
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Unión Estepona Unión 35 71 31 80
2 Almería B Almería B 35 80 35 75
3 Motril CF Motril CF 35 66 36 71
4 Baza Baza 35 53 29 61
5 At. Malagueño Malagueño 34 59 30 60
6 Polideportivo Ejido B Polideportiv 34 53 36 56
7 CD Comarca de Níjar Comarca 35 46 38 56
8 Vélez CF Vélez CF 34 52 45 51
9 Loja Loja 34 26 37 45
10 Ciudad Vícar Ciudad 34 52 47 44
11 CD Ronda CD Ronda 35 48 54 43
12 CD Alhaurino Alhaurino 35 52 56 42
13 Granada Atlético Granada 34 40 47 42
14 Arenas de Armilla Arenas 34 33 41 38
15 Adra Adra 34 37 59 36
16 CD Vera CD Vera 34 30 56 35
17 Granada 74 Granada 74 34 41 54 34
18 CD Santa Fe CD Santa Fe 35 38 63 34
19 Imperio Albolote Imperio 34 26 66 27
20 Casino Real CF Casino Real 34 26 69 26
TEMPORADA 2007/2008
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Ciudad de Roquetas Ciudad 36 79 36 75
2 Antequera CF Antequera 36 55 27 70
3 Arenas de Armilla Arenas 37 43 29 63
4 Vélez CF Vélez CF 36 58 37 62
5 Granada Atlético Granada 35 47 25 60
6 Polideportivo Ejido B Polideportiv 36 58 33 57
7 CD Alhaurino Alhaurino 37 49 46 57
8 Almería B Almería B 37 52 41 54
9 Mengibar Mengibar 36 61 39 53
10 CD Comarca de Níjar Comarca 36 47 47 53
11 Motril CF Motril CF 36 54 52 52
12 Granada 74 Granada 74 37 49 46 50
13 Ciudad Vícar Ciudad 36 43 39 50
14 Loja Loja 36 42 41 49
15 CD Vera CD Vera 36 67 61 47
16 Adra Adra 38 48 51 47
17 At. Malagueño Malagueño 38 45 45 46
18 UD Fuengirola Los Boliches Fuengirola 36 34 61 40
19 Torredonjimeno Torredonjime 36 38 95 28
20 Alhaurín de la Torre Alhaurín 36 41 71 26
21 Peña Real Madrid Peña Real M. 35 10 98 12
TEMPORADA 2006/2007
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Granada Atlético Granada 38 56 25 81
2 Ciudad de Roquetas Ciudad 38 62 31 79
3 Polideportivo Ejido B Polideportiv 38 53 26 70
4 Motril CF Motril CF 38 69 39 67
5 Arenas de Armilla Arenas 38 56 26 66
6 Adra Adra 38 60 41 65
7 Vélez CF Vélez CF 38 54 45 60
8 Antequera CF Antequera 38 47 41 59
9 UD Fuengirola Los Boliches Fuengirola 38 47 43 55
10 CD Alhaurino Alhaurino 38 54 58 51
11 Almería B Almería B 38 37 50 49
12 CD Vera CD Vera 38 50 49 46
13 CD Comarca de Níjar Comarca 38 39 52 45
14 Torredonjimeno Torredonjime 38 43 45 44
15 Alhaurín de la Torre Alhaurín 38 36 48 43
16 CD Huercal CD Huercal 38 41 51 41
17 Loja Loja 38 32 48 39
18 Carolinense Carolinense 38 36 56 35
19 Imperio Albolote Imperio 38 27 64 26
20 Maracena Maracena 38 22 83 21
TEMPORADA 2005/2006
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 Granada Granada 38 80 26 78
2 Motril CF Motril CF 38 77 27 77
3 Granada Atlético Granada 38 65 23 76
4 Arenas de Armilla Arenas 38 56 26 76
5 Torredonjimeno Torredonjime 38 67 36 70
6 CD Roquetas CD Roquetas 38 71 38 65
7 CD Huercal CD Huercal 38 64 47 62
8 UD Fuengirola Los Boliches Fuengirola 38 73 49 57
9 Alhaurín de la Torre Alhaurín 38 46 56 51
10 Almería B Almería B 38 45 46 51
11 Imperio Albolote Imperio 38 41 47 51
12 CD Vera CD Vera 38 36 54 47
13 CD Alhaurino Alhaurino 38 44 36 46
14 Maracena Maracena 38 49 47 46
15 Loja Loja 38 41 47 44
16 Comarca Níjar Comarca 38 40 48 43
17 Carolinense Carolinense 38 53 58 42
18 CD Santa Fe CD Santa Fe 38 34 62 41
19 Úbeda CF Úbeda CF 38 19 87 19
20 CD Basto CD Basto 38 18 159 9

  USO DE MEMORIA  
7,705,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.4326
Total Execution Time  0.4339
  CADENA URL  
/historico/Arenas-Armilla-Cd
  GET DATOS  
$_GET['/historico/Arenas-Armilla-Cd']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0155  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 = 'Arenas-Armilla-Cd' 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.0145  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=9051 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=9051 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9051 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0149  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 = '9051' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150  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 = 9051 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 67983 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.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 `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 = 63952 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `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 = 58972 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.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 `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 = 61680 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 51037 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.0154  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 = 44942 AND t.round = 34 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 `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 = 39237 AND t.round = 34 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 `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 = 34071 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 `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 = 16715 AND t.round = 34 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 `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 = 4080 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 2572 AND t.round = 34 ORDER BY team.conference 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 `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 = 1975 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 1234 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC