4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Egabrense
TEMPORADA 2023/2024
PRIMERA ANDALUZA GRUPO 8
Equipo PJ GF GC Puntos
1 Villa Del Rio CF Villa 20 61 28 43
2 Palma del Rio Atletico CF Palma 20 42 17 42
3 Egabrense Egabrense 20 40 20 38
4 Peñarroya Pueblonuevo Peñarroya 19 33 19 34
5 Bujalance Futbol Base AD Bujalance 20 28 26 31
6 Ciudad Jardin CD Ciudad 19 31 21 29
7 Villafranca CF Villafranca 19 32 32 28
8 Belmezano Belmezano 19 38 26 27
9 Salerm Puente Genil B Salerm 19 31 29 26
10 CD Montalbeño Montalbeño 19 29 29 26
11 CD Priego CD Priego 19 17 23 21
12 Atco. Villanueva Atco. 19 28 36 20
13 Lucecor Lucecor 20 28 41 19
14 Córdoba CF SAD Córdoba 19 20 36 15
15 Villa De Espejo CD Villa Espejo 19 22 43 11
16 Parque Cruz Conde CF Parque Cruz 10 6 60 1
TEMPORADA 2022/2023
DIVISIÓN HONOR SENIOR GRUPO 1
Equipo PJ GF GC Puntos
1 La Palma CF La Palma CF 30 52 25 62
2 Cabecense Cabecense 30 45 23 54
3 UD Tomares UD Tomares 30 59 38 53
4 Chiclana CF Chiclana CF 30 40 25 52
5 Villafranco Villafranco 30 36 28 52
6 UD Algaida UD Algaida 30 43 30 47
7 Castilleja Castilleja 30 36 30 44
8 Los Barrios Los Barrios 30 27 26 43
9 Lebrijana Lebrijana 30 26 21 36
10 Viso UP Viso UP 30 34 35 35
11 Club Atl. Central Club Atl. C. 30 24 34 35
12 Montilla Montilla 30 21 30 34
13 Palma del Rio Atletico CF Palma 30 23 48 30
14 Arcos CF Arcos CF 30 32 54 26
15 Moguer CD Moguer CD 30 22 53 22
16 Egabrense Egabrense 30 31 51 21
TEMPORADA 2021/2022
DIVISIÓN HONOR SENIOR GRUPO 1
Equipo PJ GF GC Puntos
1 Coria CF Coria CF 38 57 21 75
2 Ayamonte Ayamonte 38 57 31 74
3 Bollullos CF Bollullos 38 50 39 69
4 Atlético Espeleño Atlético 38 56 35 67
5 Montilla Montilla 38 40 32 66
6 Castilleja Castilleja 38 62 40 60
7 Viso UP Viso UP 38 46 40 58
8 Arcos CF Arcos CF 38 51 36 58
9 La Palma CF La Palma CF 38 56 41 53
10 Club Atl. Central Club Atl. C. 38 45 55 52
11 Chiclana CF Chiclana CF 38 35 30 52
12 Egabrense Egabrense 38 41 57 50
13 Lebrijana Lebrijana 38 42 51 49
14 Torreblanca CF Torreblanca 38 35 45 47
15 CD Guadalcacín Guadalcacín 38 42 50 44
16 PD Rociera PD Rociera 38 49 67 44
17 CD Alcalá CD Alcalá 38 50 56 42
18 Jerez Industrial CF Jerez 38 31 48 37
19 Atlético Onubense Atlético 38 34 70 25
20 Atlético Algabeño Atlético 38 41 76 23
TEMPORADA 2020/2021
PRIMERA ANDALUZA GRUPO 21
Equipo PJ GF GC Puntos
1 Egabrense Egabrense 24 62 25 60
2 Palma del Rio Atletico CF Palma 24 48 27 42
3 FC Aguilarense Aguilarense 24 35 30 41
4 Lucecor Lucecor 24 37 33 40
5 Los Leones de Pozoblanco Leones 22 32 30 32
6 CD Castro Del Rio-Cajasol Castro 22 31 34 28
7 Bujalance Futbol Base AD Bujalance 22 26 37 23
8 CD El Carpio CF Carpio 22 23 36 19
TEMPORADA 2019/2020
PRIMERA ANDALUZA GRUPO 3
Equipo PJ GF GC Puntos
1 Montilla Montilla 24 58 19 58
2 CD Priego CD Priego 24 46 24 46
3 Almodóvar del Río Almodóvar 24 45 27 46
4 Palma del Rio Atletico CF Palma 24 53 29 43
5 Egabrense Egabrense 24 46 30 39
6 Atco. Villanueva Atco. 24 41 28 38
7 CD Alcazar CD Alcazar 24 35 33 36
8 Lucecor Lucecor 24 44 38 35
9 Villa Del Rio CF Villa 24 27 33 30
10 La Rambla CF Rambla 24 31 32 29
11 Bujalance Futbol Base AD Bujalance 24 33 48 24
12 Los Leones de Pozoblanco Leones 24 32 50 24
13 CD Castro Del Rio-Cajasol Castro 24 29 43 23
14 FC Aguilarense Aguilarense 24 33 71 23
15 Peñarroya Pueblonuevo Peñarroya 24 26 42 22
16 Salerm Puente Genil B Salerm 24 20 52 13
TEMPORADA 2018/2019
PRIMERA ANDALUZA GRUPO 3
Equipo PJ GF GC Puntos
1 Ciudad Jardin CD Ciudad 30 67 30 68
2 Montilla Montilla 30 66 22 67
3 Bujalance Futbol Base AD Bujalance 29 50 35 52
4 La Rambla CF Rambla 30 52 37 51
5 Villa Del Rio CF Villa 30 57 49 47
6 Palma del Rio Atletico CF Palma 30 60 51 46
7 CD Alcazar CD Alcazar 29 47 38 43
8 Salerm Puente Genil B Salerm 29 48 53 42
9 Almodóvar del Río Almodóvar 29 48 46 41
10 CD Priego CD Priego 30 46 46 40
11 Egabrense Egabrense 29 44 44 39
12 Atco. Villanueva Atco. 30 52 58 36
13 FC Aguilarense Aguilarense 29 39 45 34
14 Almedinilla Atl Almedinilla 30 39 56 32
15 UD Belalcazar Belalcazar 29 37 95 17
16 C.D. Stadium C.D. Stadium 25 20 67 12
TEMPORADA 2017/2018
PRIMERA ANDALUZA GRUPO 3
Equipo PJ GF GC Puntos
1 Peñarroya Pueblonuevo Peñarroya 30 61 22 66
2 Almodóvar del Río Almodóvar 30 66 39 55
3 Villa Del Rio CF Villa 30 52 38 51
4 Atco. Villanueva Atco. 30 61 49 49
5 Palma del Rio Atletico CF Palma 30 67 43 49
6 La Rambla CF Rambla 30 49 53 45
7 C.D. Stadium C.D. Stadium 30 46 37 44
8 Egabrense Egabrense 30 58 56 44
9 Bujalance Futbol Base AD Bujalance 30 57 49 44
10 Almedinilla Atl Almedinilla 30 49 35 44
11 CD Alcazar CD Alcazar 30 58 50 43
12 At. Menciano Menciano 30 64 47 42
13 CD Priego CD Priego 30 46 51 40
14 CD Montalbeño Montalbeño 30 40 48 39
15 Pedroche CD Pedroche CD 30 37 82 15
16 CD El Villar Villar 30 17 129 5
TEMPORADA 2016/2017
PRIMERA ANDALUZA GRUPO 3
Equipo PJ GF GC Puntos
1 Ciudad Jardin CD Ciudad 30 72 22 69
2 Montilla Montilla 30 68 23 69
3 Peñarroya Pueblonuevo Peñarroya 30 58 17 63
4 Futbol Base de la Rambla 88 Futbol Base 30 60 33 57
5 Villa Del Rio CF Villa 30 51 30 52
6 Egabrense Egabrense 30 46 38 46
7 Atco. Villanueva Atco. 30 39 25 44
8 Montalbeño CD Montalbeño 30 43 39 43
9 Bujalance Futbol Base AD Bujalance 30 44 65 35
10 CD Alcazar CD Alcazar 30 49 51 30
11 C.D. Stadium C.D. Stadium 30 44 59 30
12 CD El Villar Villar 30 34 61 29
13 Alcolea Los Ángeles Alcolea 30 31 63 28
14 C.D. El Higuerón - Especolc C.D. 30 44 81 25
15 Almedinilla Atl Almedinilla 30 34 66 23
16 Cardeña Atlético C.F. Cardeña 30 41 85 23
TEMPORADA 2015/2016
2ª ANDALUZA CÓRDOBA
Equipo PJ GF GC Puntos
1 Montilla Montilla 29 63 22 67
2 Almodóvar del Río Almodóvar 28 64 21 67
3 Ciudad Jardin CD Ciudad 29 74 29 59
4 Las Palmeras Ud Palmeras 28 67 39 54
5 Alcolea Los Ángeles Alcolea 30 65 51 50
6 Egabrense Egabrense 29 51 42 45
7 Almedinilla Atl Almedinilla 30 50 36 44
8 Villa Del Rio CF Villa 29 43 38 37
9 Bujalance Futbol Base AD Bujalance 29 41 47 36
10 CD Alcazar CD Alcazar 29 40 54 33
11 C.D. El Higuerón - Especolc C.D. 29 41 49 32
12 Atletico Espeleño B Atletico 29 34 64 31
13 Fray Albino-UCO Fray 29 41 61 23
14 Cañete Base Cañete Base 29 35 74 16
15 Vespertina Vespertina 17 14 38 12
16 Pozoblanco B Pozoblanco 29 22 80 12
TEMPORADA 2014/2015
2ª ANDALUZA CÓRDOBA
Equipo PJ GF GC Puntos
1 Salerm Puente Genil Salerm 26 75 22 62
2 CD Montalbeño Montalbeño 27 48 24 60
3 Egabrense Egabrense 27 49 30 56
4 Fuente Obejuna Fuente 27 46 21 46
5 Las Palmeras Ud Palmeras 26 57 41 45
6 Montilla Montilla 27 42 34 45
7 Rud La Carlota Carlota 27 61 47 38
8 Bujalance Futbol Base AD Bujalance 28 50 53 37
9 Cañete Base Cañete Base 26 33 38 34
10 Villa Del Rio CF Villa 26 45 44 33
11 Alcolea Los Ángeles Alcolea 26 46 49 31
12 C.D. El Higuerón - Especolc C.D. 26 31 49 29
13 CD Colonia Fuente Palmera Colonia 27 45 67 28
14 Belmezano Belmezano 26 22 69 23
15 Pozoblanco B Pozoblanco 26 30 62 20
16 Palma del Rio Atletico CF Palma 26 25 55 13
17 Hinojosa Hinojosa 0 0 0 0
TEMPORADA 2008/2009
2ª ANDALUZA CÓRDOBA
Equipo PJ GF GC Puntos
1 La Voz La Voz 36 72 43 77
2 Prasa Torrecampo Prasa 36 61 26 73
3 Ciudad Jardín Ciudad 36 75 34 70
4 Rud La Carlota Carlota 36 64 41 68
5 Atlético Espeleño Atlético 36 74 57 57
6 CD Apedem CD Apedem 36 49 49 56
7 Almodóvar del Río Almodóvar 36 58 52 55
8 Salerm Pte.Genil Salerm 36 56 46 53
9 Hinojosa Hinojosa 36 55 58 50
10 Las Palmeras Ud Palmeras 36 51 57 49
11 C.D. El Higuerón - Especolc C.D. 36 48 50 47
12 Palma del Rio Atletico CF Palma 36 43 51 47
13 Dielesur La Rambla Dielesur 36 47 57 46
14 Villa De Espejo CD Villa Espejo 36 43 42 43
15 CD Montalbeño Montalbeño 36 46 58 42
16 Priego Ind. Priego Ind. 36 51 68 39
17 UD Villanueva Rosario Villanueva 36 42 58 34
18 Egabrense Egabrense 36 53 87 31
19 Pozoalbense Pozoalbense 36 36 90 23
TEMPORADA 2007/2008
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético Antoniano Atlético 34 54 17 69
2 Coria CF Coria CF 34 61 23 65
3 Montilla Montilla 34 51 33 61
4 Utrera Utrera 34 65 40 55
5 Baena At. Baena At. 34 42 35 53
6 Paradas B. Paradas B. 34 42 28 51
7 Castilleja Castilleja 34 46 38 50
8 Cabecense Cabecense 34 37 34 49
9 UD Marinaleda Marinaleda 34 40 34 48
10 UD Tomares UD Tomares 34 49 49 46
11 Peñarroya Pueblonuevo Peñarroya 34 38 36 45
12 Pilas Pilas 34 44 53 45
13 Arahal Arahal 34 33 33 43
14 Camas Camas 34 38 49 43
15 Moron Moron 34 39 39 42
16 Egabrense Egabrense 34 26 59 30
17 CD Montalbeño Montalbeño 34 26 70 21
18 Priego Ind. Priego Ind. 34 33 94 14
TEMPORADA 2006/2007
2ª ANDALUZA CÓRDOBA
Equipo PJ GF GC Puntos
1 Baena At. Baena At. 34 70 16 86
2 Egabrense Egabrense 34 82 32 69
3 Priego Ind. Priego Ind. 34 79 32 68
4 UD Villanueva Rosario Villanueva 34 61 34 65
5 Miralbaida Miralbaida 34 70 45 62
6 CD Apedem CD Apedem 34 46 41 50
7 Belmezano Belmezano 34 52 44 48
8 Sur Sur 34 52 58 48
9 Ciudad Jardín Ciudad 34 50 48 45
10 Atlético Espeleño Atlético 34 45 49 42
11 Dielesur La Rambla Dielesur 34 35 45 42
12 Palma del Rio Atletico CF Palma 34 49 73 42
13 Posadas Bpie. Posadas 34 49 59 40
14 Guadalquivir Guadalquivir 34 49 61 40
15 C.D. Alcázar B C.D. 34 28 53 34
16 Hinojosa Hinojosa 34 40 60 31
17 Benamejí Benamejí 34 42 71 27
18 Fray Albino-UCO Fray 34 28 106 10
TEMPORADA 2005/2006
2ª ANDALUZA CÓRDOBA
Equipo PJ GF GC Puntos
1 Fc Aguilarense Aguilarense 32 62 22 75
2 Peñarroya Pueblonuevo Peñarroya 32 82 22 69
3 Dielesur La Rambla Dielesur 32 70 32 61
4 Miralbaida Miralbaida 32 61 52 48
5 Hinojosa Hinojosa 32 55 52 47
6 Posadas Bpie. Posadas 32 56 54 47
7 Belmezano Belmezano 32 52 55 47
8 Atlético Espeleño Atlético 32 48 43 46
9 CD Apedem CD Apedem 32 43 40 45
10 Egabrense Egabrense 32 60 39 44
11 Guadalquivir Guadalquivir 32 51 61 39
12 Priego Ind. Priego Ind. 32 39 62 39
13 Victoria Cf Victoria Cf 32 38 74 33
14 Puente Genil Puente Genil 32 54 72 32
15 CD Castro Del Rio-Cajasol Castro 32 47 59 30
16 Villa De Espejo CD Villa Espejo 32 37 65 30
17 Almedinilla Atl Almedinilla 32 36 87 26
TEMPORADA 2003/2004
2ª ANDALUZA CÓRDOBA
Equipo PJ GF GC Puntos
1 CD Pozoblanco Pozoblanco 34 96 12 87
2 Egabrense Egabrense 34 64 30 72
3 Baena At. Baena At. 34 57 25 67
4 UD Villanueva Rosario Villanueva 34 56 32 63
5 Posadas Bpie. Posadas 34 67 29 62
6 Fray Albino-UCO Fray 34 79 36 61
7 Priego Ind. Priego Ind. 34 61 47 58
8 Rute Calidad Rute Calidad 34 63 39 55
9 Peñarroya Pueblonuevo Peñarroya 34 75 65 49
10 CD Montalbeño Montalbeño 34 62 59 49
11 Palma del Rio Atletico CF Palma 34 49 46 44
12 CD Apedem CD Apedem 34 34 55 38
13 Dielesur La Rambla Dielesur 34 42 58 35
14 Séneca B Séneca B 34 34 68 28
15 CD Colonia Fuente Palmera Colonia 34 31 82 28
16 Hinojosa Hinojosa 34 38 74 25
17 Cerro Muriano Cf Cerro 34 42 107 25
18 Miralbaida Miralbaida 34 20 106 15
TEMPORADA 2002/2003
2ª ANDALUZA CÓRDOBA
Equipo PJ GF GC Puntos
1 Egabrense Egabrense 35 95 15 87
2 CD Pozoblanco Pozoblanco 35 90 21 79
3 Dielesur La Rambla Dielesur 35 59 36 66
4 Posadas Bpie. Posadas 35 52 42 59
5 Hinojosa Hinojosa 35 45 40 58
6 Peñarroya Pueblonuevo Peñarroya 35 75 52 56
7 Atl. Cordobes Atl. 35 46 31 52
8 Séneca B Séneca B 35 66 56 52
9 Universidad Cordoba Universidad 35 48 50 52
10 Miralbaida Miralbaida 35 47 61 47
11 Villa Del Rio CF Villa 35 51 46 46
12 Priego Ind. Priego Ind. 35 51 51 44
13 Rute Calidad Rute Calidad 35 49 39 42
14 CD Colonia Fuente Palmera Colonia 35 39 77 39
15 Palma del Rio Atletico CF Palma 35 42 63 37
16 Puente Genil Puente Genil 35 40 95 33
17 Virgen Del Valle AD Virgen Valle 35 30 89 20
18 Ciudad Jardín Ciudad 35 35 84 18
19 Fc Aguilarense Aguilarense 18 28 40 17
TEMPORADA 1993/1994
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Betis Deportivo Betis 38 84 21 57
2 UD Los Palacios Palacios 38 50 23 46
3 CD San Fernando Fernando 38 42 37 43
4 At. Cortegana Cortegana 38 52 44 41
5 AgD Ceuta AgD Ceuta 38 38 32 41
6 Cádiz CF Mirandilla Cádiz 38 44 40 40
7 At. Sanluqueño Sanluqueño 38 50 42 40
8 Atlético Sanlucar Atlético 38 49 40 40
9 Coria CF Coria CF 38 39 36 39
10 RB Linense RB Linense 38 35 36 39
11 San Juan San Juan 38 46 42 38
12 Mairena Mairena 38 49 44 38
13 Jerez Industrial CF Jerez 38 34 39 36
14 Puente Genil Puente Genil 38 40 52 36
15 Roteña Roteña 38 43 56 35
16 Lucena Lucena 38 42 56 35
17 Montilla Montilla 38 35 47 34
18 Egabrense Egabrense 38 31 59 30
19 CD Pozoblanco Pozoblanco 38 40 52 29
20 Lebrija Lebrija 38 35 80 23
TEMPORADA 1986/1987
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Sevilla At. Sevilla At. 38 87 24 58
2 Betis Deportivo Betis 38 97 31 58
3 At. Sanluqueño Sanluqueño 38 56 37 51
4 Bollullos CF Bollullos 38 56 30 50
5 Cádiz CF Mirandilla Cádiz 38 69 34 48
6 Utrera Utrera 38 55 31 46
7 Ayamonte Ayamonte 38 43 40 44
8 Coria CF Coria CF 38 62 51 43
9 Dos Hermanas CF Hermanas 38 52 46 43
10 Pilas Pilas 38 37 34 42
11 CD San Fernando Fernando 38 43 32 41
12 Palma del Rio Atletico CF Palma 38 32 50 34
13 Brenes Balompié Brenes 38 39 59 33
14 Mairena Mairena 38 34 46 33
15 RC Portuense Portuense 38 47 64 27
16 CD Rota CD Rota 38 33 61 25
17 Moguer CD Moguer CD 38 36 63 23
18 CD Pozoblanco Pozoblanco 38 32 64 22
19 Egabrense Egabrense 38 31 89 21
20 UA. Ceutí UA. Ceutí 38 35 90 18

  USO DE MEMORIA  
7,321,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1468
Total Execution Time  0.1489
  CADENA URL  
/historico/Egabrense
  GET DATOS  
$_GET['/historico/Egabrense']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=955 AND type_rel = 2
0.0048  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 = '955' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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 = 73631 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0054  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=955 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0030  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 (73631,68671) 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.0043  SELECT count(id) as num_players from rel_players WHERE league_id = 68671 AND teamId = 955
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 73631 AND teamId = 955
0.0026  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 = 73631 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '955' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '955' and rp.type = 4
0.0021  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 = '955' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036  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 = 73631 WHERE rp.league_id = 73631 AND rp.teamId = 955 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 = 73631 WHERE rp.league_id = 73631 AND rp.teamId = 955 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 73631 WHERE rp.league_id = 73631 AND rp.teamId = 955 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 955 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68671 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.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 `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 = 58856 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.0022  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 = 58974 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.0022  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 = 61893 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.0022  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 = 51256 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 44622 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 39326 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 34154 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 16803 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 4106 AND t.round = 30 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 = 2931 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 `tables2008` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 113 AND t.round = 34 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 `tables2007` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2929 AND t.round = 34 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 `tables2006` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2928 AND t.round = 34 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 `tables2004` 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 = 2926 AND t.round = 34 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 `tables2003` 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 = 2925 AND t.round = 38 ORDER BY team.conference 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 `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 = 21910 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 `tables1987` 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 = 21766 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC