4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Calamonte

Calamonte

Entrenador: Juan Manuel Fernandez

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CD Don Benito Benito 32 60 13 70
2 CD Coria CD Coria 32 57 19 66
3 CD Azuaga CD Azuaga 32 47 31 58
4 Villafranca Villafranca 32 43 25 52
5 Castuera Castuera 32 45 35 49
6 Moralo Moralo 32 49 43 47
7 CF Jaraíz CF Jaraíz 32 48 47 45
8 CD Diocesano Diocesano 32 47 46 45
9 Calamonte Calamonte 32 38 46 41
10 Olivenza Olivenza 32 31 34 41
11 Arroyo Arroyo 32 33 35 41
12 Jerez Jerez 32 39 48 39
13 Pueblonuevo Pueblonuevo 32 31 43 39
14 Trujillo Trujillo 32 29 36 35
15 CD Don Álvaro Álvaro 32 28 47 31
16 Montehermoso Montehermoso 32 33 54 31
17 Racing Valverdeño Racing 32 30 56 26
18 UD Fuente de Cantos Fuente 32 25 55 24
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 AD Llerenense Llerenense 30 52 22 64
2 CD Azuaga CD Azuaga 30 58 29 62
3 Moralo Moralo 30 52 24 55
4 Olivenza Olivenza 30 46 33 53
5 Jerez Jerez 30 39 25 49
6 Arroyo Arroyo 30 30 31 46
7 Trujillo Trujillo 30 28 28 44
8 Villafranca Villafranca 30 34 33 43
9 Calamonte Calamonte 30 38 33 42
10 UD Fuente de Cantos Fuente 30 23 28 39
11 Pueblonuevo Pueblonuevo 30 36 41 32
12 Montehermoso Montehermoso 30 31 53 31
13 CD Don Álvaro Álvaro 30 27 54 27
14 Miajadas Miajadas 30 23 41 26
15 Plasencia Plasencia 30 31 43 24
16 UC La Estrella Estrella 30 30 60 21
TEMPORADA 2021/2022
TERCERA FEDERACIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CD Diocesano Diocesano 30 61 30 63
2 Moralo Moralo 30 39 19 52
3 AD Llerenense Llerenense 30 44 32 51
4 Jerez Jerez 30 38 30 49
5 Arroyo Arroyo 30 40 30 48
6 Trujillo Trujillo 30 40 27 48
7 CD Azuaga CD Azuaga 30 41 31 48
8 Calamonte Calamonte 30 35 33 43
9 Plasencia Plasencia 30 24 29 38
10 Villafranca Villafranca 30 27 30 37
11 Olivenza Olivenza 30 31 35 33
12 CD Don Álvaro Álvaro 30 36 44 31
13 Miajadas Miajadas 30 30 48 29
14 EMD Aceuchal Aceuchal 30 24 42 29
15 CD Badajoz B Badajoz 30 24 38 27
16 Extremadura B Extremadura 30 18 54 0
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 UD Montijo UD Montijo 20 34 5 49
2 CD Coria CD Coria 20 36 14 45
3 Moralo Moralo 20 28 9 42
4 Extremadura B Extremadura 20 28 17 32
5 Plasencia Plasencia 20 27 14 30
6 EMD Aceuchal Aceuchal 20 22 25 26
7 Calamonte Calamonte 20 23 25 23
8 Chinato Chinato 20 17 32 15
9 Campanario Campanario 20 13 35 15
10 CP Valdivia CP Valdivia 20 14 44 13
11 AD Lobón AD Lobón 20 10 32 12
12 CP Cacereño Cacereño 20 43 9 50
13 CD Diocesano Diocesano 20 37 12 44
14 Jerez Jerez 20 23 16 36
15 Miajadas Miajadas 20 21 19 28
16 Arroyo Arroyo 20 15 24 25
17 CD Azuaga CD Azuaga 20 18 25 23
18 AD Llerenense Llerenense 20 14 26 22
19 Trujillo Trujillo 20 25 28 19
20 Racing Valverdeño Racing 20 13 33 19
21 Olivenza Olivenza 20 20 26 18
22 UD Fuente de Cantos Fuente 20 18 29 16
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Villanovense Villanovense 28 56 19 66
2 CD Coria CD Coria 28 54 23 65
3 CP Cacereño Cacereño 27 63 20 62
4 Extremadura B Extremadura 28 42 27 52
5 Moralo Moralo 28 53 32 52
6 Jerez Jerez 28 35 26 44
7 Trujillo Trujillo 28 39 41 43
8 Arroyo Arroyo 28 33 33 42
9 EMD Aceuchal Aceuchal 27 41 37 41
10 CD Diocesano Diocesano 28 48 34 40
11 CD Azuaga CD Azuaga 28 36 35 39
12 Olivenza Olivenza 28 39 52 37
13 Plasencia Plasencia 28 29 38 35
14 Calamonte Calamonte 28 36 44 34
15 UD Montijo UD Montijo 28 34 40 31
16 Miajadas Miajadas 28 27 46 30
17 UD Fuente de Cantos Fuente 28 29 47 29
18 AD Llerenense Llerenense 28 22 38 23
19 Racing Valverdeño Racing 28 19 56 15
20 CP Valdivia CP Valdivia 28 18 65 7
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 AD Mérida AD Mérida 38 92 23 91
2 CP Cacereño Cacereño 38 71 26 80
3 Moralo Moralo 38 63 23 80
4 CD Coria CD Coria 38 63 23 71
5 Plasencia Plasencia 38 65 33 70
6 Jerez Jerez 38 64 49 61
7 Extremadura B Extremadura 38 55 31 58
8 CD Azuaga CD Azuaga 38 46 43 51
9 CD Diocesano Diocesano 38 40 45 49
10 Calamonte Calamonte 38 44 45 49
11 AD Llerenense Llerenense 38 43 71 44
12 Olivenza Olivenza 38 45 60 43
13 CP Valdivia CP Valdivia 38 49 66 43
14 UD Montijo UD Montijo 38 41 54 42
15 Arroyo Arroyo 38 31 44 42
16 EMD Aceuchal Aceuchal 38 35 52 40
17 Racing Valverdeño Racing 38 39 76 38
18 Pueblonuevo Pueblonuevo 38 20 46 37
19 Castuera Castuera 38 43 73 31
20 Valdelacalzada Valdelacalza 38 22 88 17
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CD Don Benito Benito 38 68 18 89
2 CP Cacereño Cacereño 38 63 20 87
3 Plasencia Plasencia 38 75 29 86
4 CD Coria CD Coria 38 73 23 79
5 Moralo Moralo 38 74 30 79
6 Jerez Jerez 38 72 50 63
7 CD Diocesano Diocesano 38 48 53 52
8 CD Azuaga CD Azuaga 38 46 44 51
9 Calamonte Calamonte 38 44 47 47
10 UD Montijo UD Montijo 38 34 55 45
11 EMD Aceuchal Aceuchal 38 44 55 43
12 Castuera Castuera 38 48 70 42
13 Extremadura B Extremadura 38 52 60 41
14 Olivenza Olivenza 38 38 58 39
15 CP Valdivia CP Valdivia 38 23 41 39
16 Pueblonuevo Pueblonuevo 38 41 61 39
17 Arroyo Arroyo 38 34 64 36
18 Amanecer Amanecer 38 37 67 35
19 Trujillo Trujillo 38 32 64 34
20 Santa Amalia Santa Amalia 38 38 75 30
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CP Cacereño Cacereño 38 81 16 92
2 CD Badajoz CD Badajoz 38 90 17 85
3 Jerez Jerez 38 57 26 79
4 CD Azuaga CD Azuaga 38 83 42 74
5 CD Coria CD Coria 38 62 29 72
6 CD Don Benito Benito 38 62 26 68
7 Calamonte Calamonte 38 70 39 62
8 Plasencia Plasencia 38 59 56 59
9 Moralo Moralo 38 57 58 52
10 Olivenza Olivenza 38 44 54 47
11 UD Montijo UD Montijo 38 41 59 43
12 Amanecer Amanecer 38 52 58 43
13 Extremadura B Extremadura 38 49 55 40
14 CP Valdivia CP Valdivia 38 34 63 39
15 Arroyo Arroyo 38 31 64 37
16 Santa Amalia Santa Amalia 38 34 82 36
17 Pueblonuevo Pueblonuevo 38 34 64 35
18 UD Fuente de Cantos Fuente 38 42 69 34
19 Diter Zafra Diter Zafra 38 34 95 24
20 UC La Estrella Estrella 38 34 78 22
TEMPORADA 2015/2016
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Extremadura Extremadura 38 106 25 90
2 CD Badajoz CD Badajoz 38 90 25 87
3 Arroyo Arroyo 38 78 23 84
4 Jerez Jerez 38 69 24 83
5 CD Don Benito Benito 38 53 39 66
6 CD Azuaga CD Azuaga 38 75 47 64
7 Calamonte Calamonte 38 68 66 62
8 Pueblonuevo Pueblonuevo 38 49 41 57
9 CD Coria CD Coria 38 56 44 55
10 Diter Zafra Diter Zafra 38 45 65 47
11 Atl San José Promesas José 38 39 59 46
12 Moralo Moralo 38 53 58 44
13 UD Fuente de Cantos Fuente 38 46 66 43
14 CP Valdivia CP Valdivia 38 34 63 42
15 Olivenza Olivenza 38 38 61 36
16 Amanecer Amanecer 38 35 66 33
17 Santa Amalia Santa Amalia 38 35 70 31
18 Sanvicenteño Sanvicenteñ 38 36 83 31
19 Valdelacalzada Valdelacalza 38 29 71 27
20 Deportivo Pacense Deportivo 38 42 80 25
TEMPORADA 2014/2015
PREFERENTE EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 Amanecer Amanecer 30 66 15 75
2 Calamonte Calamonte 30 83 20 63
3 Cacereño B Cacereño B 30 67 37 61
4 CD Diocesano Diocesano 30 57 32 51
5 AD San Jorge Jorge 30 60 57 43
6 Navalmoral Navalmoral 30 36 44 42
7 Talayuela Talayuela 30 47 44 41
8 Arroyo Cp B Arroyo Cp B 30 39 38 40
9 Ciudad de Plasencia Ciudad 30 29 33 38
10 Chinato Chinato 30 42 57 37
11 Montehermoso Montehermoso 30 39 51 35
12 CD Ciconia Negra Ciconia 30 34 48 33
13 Trujillo Trujillo 30 36 60 28
14 Miajadas Miajadas 30 33 60 27
15 Moraleja Moraleja 30 30 58 24
16 Malpartida Malpartida 30 22 66 19
TEMPORADA 2013/2014
PREFERENTE EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Badajoz CD Badajoz 30 76 16 73
2 Calamonte Calamonte 30 76 26 67
3 CP Oliva CP Oliva 30 44 24 56
4 Emérita Augusta Emérita 30 51 28 56
5 SP Cerro Reyes Cerro Reyes 30 47 23 50
6 CD San Serván Serván 30 45 39 46
7 Valdelacalzada Valdelacalza 30 32 33 44
8 CD Vadesa CD Vadesa 30 39 46 38
9 Guadiana Guadiana 30 47 49 37
10 EF Puebla de la Calzada Puebla 30 41 43 37
11 Nueva Ciudad Nueva Ciudad 30 31 44 37
12 UD Talavera UD Talavera 30 39 46 36
13 EMD Solana EMD Solana 30 31 49 29
14 UD Frexnense Frexnense 30 33 59 27
15 CP Cheles CP Cheles 30 26 67 23
16 San Francisco de Olivenza Francisco 30 25 91 5
TEMPORADA 2010/2011
PREFERENTE EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 Pueblonuevo Pueblonuevo 38 74 26 86
2 Villafranca Villafranca 38 77 39 79
3 EF Puebla de la Calzada Puebla 38 58 29 71
4 CP Oliva CP Oliva 38 63 37 69
5 Fuente de Cantos Fuente 38 68 52 67
6 Montijo Montijo 38 53 47 59
7 Racing Valverdeño Racing 38 73 60 57
8 Calamonte Calamonte 38 47 50 53
9 UC La Estrella Estrella 38 51 51 51
10 Emérita Augusta Emérita 38 55 57 50
11 Nueva Ciudad Nueva Ciudad 38 52 58 49
12 Monesterio Monesterio 38 55 54 47
13 Cd Burguillos Burguillos 38 58 69 47
14 CD Azuaga CD Azuaga 38 67 63 46
15 UD Talavera UD Talavera 38 39 52 46
16 La Albuera-Faesal Albuera-Faes 38 47 59 44
17 Guadiana Guadiana 38 48 65 41
18 Gran Maestre Gran Maestre 38 53 76 36
19 San Francisco de Olivenza Francisco 38 43 82 28
20 CF San Jorge Jorge 38 41 96 24
TEMPORADA 2009/2010
PREFERENTE EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 Diter Zafra Diter Zafra 38 99 25 87
2 Atl San José Promesas José 38 64 31 71
3 CP Oliva CP Oliva 38 66 41 71
4 EF Puebla de la Calzada Puebla 38 59 39 71
5 Monesterio Monesterio 38 59 37 66
6 Fuente de Cantos Fuente 38 76 50 65
7 Calamonte Calamonte 38 60 36 65
8 Gran Maestre Gran Maestre 38 59 52 58
9 Emérita Augusta Emérita 37 70 42 57
10 Pueblonuevo Pueblonuevo 38 64 55 57
11 UD Montijo UD Montijo 38 52 50 56
12 UD Talavera UD Talavera 38 59 54 50
13 Guadiana Guadiana 38 56 60 49
14 La Albuera-Faesal Albuera-Faes 38 49 56 45
15 San Francisco de Olivenza Francisco 38 58 63 43
16 CF San Jorge Jorge 38 56 86 39
17 Campanario Campanario 38 49 98 39
18 San Benito San Benito 38 53 90 34
19 CF Extremadura Extremadura 38 33 102 20
20 Alburquerque Alburquerque 37 23 97 13
TEMPORADA 2008/2009
PREFERENTE EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 Extremadura Extremadura 38 105 26 87
2 Villafranca Villafranca 38 77 41 82
3 EF Puebla de la Calzada Puebla 38 57 45 67
4 Imperio De Mérida B Imperio 37 56 38 62
5 Alburquerque Alburquerque 38 49 46 62
6 Monesterio Monesterio 38 69 59 60
7 Calamonte Calamonte 38 42 40 57
8 UD Montijo UD Montijo 38 71 59 56
9 Atl San José Promesas José 38 47 53 51
10 Guadiana Guadiana 38 44 50 49
11 CF San Jorge Jorge 38 49 53 48
12 CP Oliva CP Oliva 37 45 48 47
13 San Francisco de Olivenza Francisco 38 56 68 47
14 Pueblonuevo Pueblonuevo 38 58 54 46
15 Gran Maestre Gran Maestre 38 51 48 45
16 UD Talavera UD Talavera 38 47 65 45
17 Racing Valverdeño Racing 38 46 61 44
18 CF Extremadura Extremadura 38 51 69 44
19 Nueva Ciudad Nueva Ciudad 38 48 87 37
20 Guareña Guareña 38 24 82 22
TEMPORADA 2001/2002
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CP Cacereño Cacereño 38 131 28 101
2 CD Don Benito Benito 38 91 33 84
3 Moralo Moralo 38 98 37 79
4 Villanovense Villanovense 38 78 37 73
5 CD Badajoz B Badajoz 38 58 38 69
6 Plasencia Plasencia 38 67 48 64
7 Villafranca Villafranca 38 58 45 62
8 Cerro de Reyes Cerro Reyes 38 64 48 60
9 Extremadura B Extremadura 38 65 59 50
10 Gran Maestre Gran Maestre 38 50 60 46
11 CD Coria CD Coria 38 49 68 46
12 UD Montijo UD Montijo 38 42 58 44
13 Estrella Estrella 38 49 67 44
14 Monesterio Monesterio 38 51 56 43
15 Santa Amalia Santa Amalia 38 37 71 42
16 Valdelacalzada Valdelacalza 38 41 77 41
17 Alburquerque Alburquerque 38 42 69 37
18 Imperio Imperio 38 39 76 27
19 Moraleja Moraleja 38 36 94 27
20 Calamonte Calamonte 38 29 106 24
TEMPORADA 1985/1986
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CD Badajoz CD Badajoz 38 110 10 68
2 CD Don Benito Benito 38 78 29 58
3 CP Cacereño Cacereño 38 86 27 58
4 UD Montijo UD Montijo 38 61 34 51
5 CF Extremadura Extremadura 38 70 27 51
6 Moralo Moralo 38 64 35 48
7 Mérida CP Mérida CP 38 57 34 48
8 UC La Estrella Estrella 38 60 56 43
9 Diter Zafra Diter Zafra 38 62 49 38
10 Sanvicenteño Sanvicenteñ 38 52 59 35
11 UD Fuente de Cantos Fuente 38 36 53 34
12 EMD Aceuchal Aceuchal 38 47 74 32
13 CD Villanovense Villanovense 38 32 44 32
14 Guareña Guareña 38 55 85 28
15 CD Azuaga CD Azuaga 38 43 73 28
16 Puebla Patria Puebla 38 37 80 27
17 Olivenza Olivenza 38 26 59 25
18 Villafranca Villafranca 38 38 67 25
19 Castuera Castuera 38 27 80 16
20 Calamonte Calamonte 38 37 103 15
TEMPORADA 1984/1985
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Plasencia Plasencia 38 130 19 66
2 CF Extremadura Extremadura 38 86 29 61
3 CP Cacereño Cacereño 38 99 28 58
4 Mérida CP Mérida CP 38 64 33 55
5 Diter Zafra Diter Zafra 38 66 30 50
6 CD Villanovense Villanovense 38 55 32 47
7 UD Montijo UD Montijo 38 48 47 40
8 Moralo Moralo 38 41 39 37
9 CD Don Benito Benito 38 56 47 36
10 UC La Estrella Estrella 38 34 45 36
11 Sanvicenteño Sanvicenteñ 38 35 58 34
12 UD Fuente de Cantos Fuente 38 46 86 30
13 Villafranca Villafranca 38 35 70 28
14 EMD Aceuchal Aceuchal 38 34 65 27
15 CD Azuaga CD Azuaga 38 40 84 27
16 Olivenza Olivenza 38 33 60 27
17 CD Badajoz Promesas Badajoz 38 47 60 27
18 Calamonte Calamonte 38 32 65 25
19 Monteresma Atalaya Monteresma 38 41 90 25
20 Vasco Núñez Vasco 38 55 90 24
TEMPORADA 1983/1984
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Diter Zafra Diter Zafra 38 99 28 59
2 Plasencia Plasencia 38 78 15 58
3 CP Cacereño Cacereño 38 88 25 54
4 CF Extremadura Extremadura 38 74 26 54
5 CD Don Benito Benito 38 74 48 48
6 Mérida CP Mérida CP 38 51 26 47
7 Moralo Moralo 38 53 40 44
8 UD Montijo UD Montijo 38 51 43 41
9 CD Villanovense Villanovense 38 45 33 40
10 Villafranca Villafranca 38 52 58 38
11 UC La Estrella Estrella 38 66 52 36
12 CD Azuaga CD Azuaga 38 37 63 33
13 Olivenza Olivenza 38 45 77 31
14 Calamonte Calamonte 38 51 83 31
15 CD Badajoz Promesas Badajoz 38 50 65 29
16 Sanvicenteño Sanvicenteñ 38 34 70 28
17 UD Fuente de Cantos Fuente 38 35 80 27
18 Puebla Patria Puebla 38 23 63 24
19 CD Quintanar del Rey Quintanar 38 34 92 21
20 AD Llerenense Llerenense 38 26 79 17

  USO DE MEMORIA  
7,739,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6394
Total Execution Time  0.6408
  CADENA URL  
/historico/Calamonte
  GET DATOS  
$_GET['/historico/Calamonte']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0294  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 = 72274
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=613 AND type_rel = 2
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0157  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 = '613' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0152  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 = 72274 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0164  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=613 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0153  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 (72274,71432) 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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 72274 AND teamId = 613
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 613
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 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 = 72274 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0150  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 = '613' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0147  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '613' and rp.type = 4
0.0156  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 = '613' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0200  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 = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 613 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.0154  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 = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 613 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 613 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 613 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72274 AND t.round = 32 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 `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 = 67988 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.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 `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 = 62398 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.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 `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 = 50282 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.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 `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 = 44402 AND t.round = 38 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 `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 = 39038 AND t.round = 38 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 `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 = 33364 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 `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 = 4099 AND t.round = 30 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 `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 = 2691 AND t.round = 30 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 `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 = 1223 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 `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 = 952 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 `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 = 312 AND t.round = 38 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 `tables2002` 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 = 22059 AND t.round = 38 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 `tables1986` 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 = 21756 AND t.round = 38 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 `tables1985` 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 = 21742 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 `tables1984` 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 = 21727 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC