4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Real Oviedo Fem
TEMPORADA 2023/2024
SEGUNDA FEDERACIÓN FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid B Fem Real Madrid 26 45 12 64
2 Atlético Baleares Fem Atlético 26 48 23 58
3 Viajes Interrías Fem Viajes 27 45 27 57
4 Real Oviedo Fem Real Oviedo 27 35 24 48
5 Racing Fem Racing Fem 26 33 26 41
6 R. Sociedad B Fem Sociedad 27 41 33 40
7 Zaragoza CFF Fem Zaragoza 26 37 30 37
8 Atlético C Fem Atlético 26 28 30 32
9 Huesca Fem Huesca Fem 27 30 36 32
10 Pradejon Fem Pradejon 26 28 30 31
11 Rayo Vallecano Fem Rayo 26 25 34 29
12 Real Sporting Fem Real 26 33 43 27
13 Athletic Club C Fem Athletic 26 29 46 25
14 Osasuna B Fem Osasuna 26 31 48 23
15 Club Bizkerre Fem Club 26 20 35 18
16 Espanyol B Fem Espanyol 26 29 60 15
TEMPORADA 2022/2023
PRIMERA FEDERACIÓN FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Barcelona B Fem Barcelona 30 58 31 59
2 Eibar Fem Eibar Fem 30 31 18 53
3 Deportivo Abanca Fem Deportivo 30 52 29 53
4 Osasuna Fem Osasuna Fem 30 42 23 52
5 Granada CF Fem Granada 30 40 28 50
6 CP Cacereño Fem Cacereño 30 34 28 48
7 AEM Fem AEM Fem 30 35 30 47
8 DUX Logroño Fem Logroño 30 42 38 43
9 Espanyol Fem Espanyol 30 38 35 40
10 Alba Fundación Fem Alba 30 32 32 37
11 Athletic Club B Fem Athletic 30 34 51 36
12 Rayo Vallecano Fem Rayo 30 31 45 35
13 UDG Tenerife B Fem Tenerife 30 24 37 34
14 Real Oviedo Fem Real Oviedo 30 28 45 27
15 Córdoba CF Fem Córdoba 30 27 48 24
16 CD Juan Grande Fem Juan Grande 30 24 54 19
TEMPORADA 2021/2022
PRIMERA DIVISIÓN B FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Levante Las Planas Fem Levante 30 64 37 62
2 Espanyol Fem Espanyol 30 50 34 58
3 Osasuna Fem Osasuna Fem 30 56 33 57
4 DUX Logroño Fem Logroño 30 48 33 53
5 Barcelona B Fem Barcelona 30 52 32 51
6 Deportivo Abanca Fem Deportivo 30 49 29 51
7 AEM Fem AEM Fem 30 46 39 50
8 Real Oviedo Fem Real Oviedo 30 38 36 46
9 Zaragoza CFF Fem Zaragoza 30 45 45 43
10 Athletic Club B Fem Athletic 30 44 41 39
11 CD Parquesol Fem Parquesol 30 41 51 38
12 Racing Fem Racing Fem 30 37 43 38
13 Pradejon Fem Pradejon 30 32 53 30
14 Atlético B Fem Atlético 30 34 60 30
15 Real Sporting Fem Real 30 33 53 23
16 Seagull Fem Seagull Fem 30 23 73 9
TEMPORADA 2020/2021
PRIMERA DIVISIÓN B FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético B Fem Atlético 14 26 14 28
2 Real Oviedo Fem Real Oviedo 14 21 12 27
3 Madrid CF B Fem Madrid 14 16 16 21
4 Racing Fem Racing Fem 14 24 17 20
5 Real Sporting Fem Real 14 27 25 18
6 CD Parquesol Fem Parquesol 14 17 22 15
7 PM Friol Fem Friol 14 15 27 14
8 CF Pozuelo Fem Pozuelo 14 12 25 11
9 Deportivo Alavés Fem Deportivo 16 34 14 37
10 Osasuna Fem Osasuna Fem 16 35 18 34
11 Barcelona B Fem Barcelona 16 30 19 26
12 AEM Fem AEM Fem 16 28 16 25
13 Seagull Fem Seagull Fem 16 24 26 25
14 Zaragoza CFF Fem Zaragoza 16 18 15 22
15 Athletic Club B Fem Athletic 16 25 19 22
16 Espanyol B Fem Espanyol 16 12 52 7
17 Collerense Fem Collerense 16 17 44 4
TEMPORADA 2019/2020
PRIMERA DIVISIÓN B FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Athletic Club B Fem Athletic 22 43 17 48
2 Eibar Fem Eibar Fem 22 37 13 46
3 Barcelona B Fem Barcelona 22 61 28 45
4 Osasuna Fem Osasuna Fem 22 41 24 41
5 Deportivo Alavés Fem Deportivo 22 38 26 41
6 Seagull Fem Seagull Fem 22 38 27 35
7 AEM Fem AEM Fem 22 29 28 35
8 Zaragoza CFF Fem Zaragoza 22 43 46 32
9 Real Oviedo Fem Real Oviedo 22 37 37 31
10 CD Parquesol Fem Parquesol 22 33 31 28
11 Madrid CF B Fem Madrid 22 27 40 26
12 Atlético B Fem Atlético 22 32 34 26
13 Racing Fem Racing Fem 22 37 35 25
14 PM Friol Fem Friol 22 25 55 19
15 CF Pozuelo Fem Pozuelo 22 12 40 13
16 Real Sporting Fem Real 22 12 64 8
TEMPORADA 2018/2019
TERCERA FEDERACIÓN FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Deportivo Abanca Fem Deportivo 26 150 13 76
2 Real Oviedo Fem Real Oviedo 26 106 25 66
3 PM Friol Fem Friol 26 76 29 53
4 Racing Fem Racing Fem 26 87 31 51
5 Atlantida Matama Atlantida 26 60 42 47
6 Real Sporting Fem Real 26 67 47 43
7 Victoria CF Fem Victoria 26 41 47 38
8 Victoria FC Fem Victoria 26 33 48 35
9 Monte Fem Monte Fem 26 41 52 32
10 Valladares Valladares 26 29 66 23
11 Gijón Fem Gijón Fem 26 27 85 19
12 Sárdoma Fem Sárdoma 26 32 86 15
13 Atlético Arousana Fem Atlético 26 28 124 9
14 Oceja-Gimnastica Fem Oceja-Gimnas 26 26 108 9
TEMPORADA 2017/2018
TERCERA FEDERACIÓN FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Real Oviedo Fem Real Oviedo 26 114 7 75
2 Deportivo Abanca Fem Deportivo 26 155 11 73
3 Monte Fem Monte Fem 26 65 34 54
4 Atlantida Matama Atlantida 26 56 29 49
5 Racing Fem Racing Fem 26 84 42 46
6 Sárdoma Fem Sárdoma 26 55 35 42
7 Victoria CF Fem Victoria 26 54 47 41
8 PM Friol Fem Friol 26 53 54 37
9 Real Sporting Fem Real 26 55 53 32
10 Victoria FC Fem Victoria 26 32 52 31
11 Gijón Fem Gijón Fem 26 32 74 23
12 Llanera Fem Llanera Fem 26 29 106 19
13 Femiastur Femiastur 26 24 117 10
14 Vimenor Vimenor 26 6 153 0
TEMPORADA 2016/2017
TERCERA FEDERACIÓN FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Real Oviedo Fem Real Oviedo 26 108 9 70
2 Deportivo Abanca Fem Deportivo 26 120 19 65
3 Real Sporting Fem Real 26 75 36 53
4 Atlantida Matama Atlantida 26 62 29 52
5 PM Friol Fem Friol 26 67 42 51
6 Racing Fem Racing Fem 26 90 57 47
7 Sárdoma Fem Sárdoma 26 49 36 38
8 Victoria CF Fem Victoria 26 51 55 34
9 Femiastur Femiastur 26 55 67 26
10 Gijón Fem Gijón Fem 26 35 84 25
11 El Olivo Fem Olivo 26 33 85 22
12 Monte Fem Monte Fem 26 41 72 21
13 Atlético Arousana Fem Atlético 26 28 120 11
14 Tordoia Tordoia 26 23 126 8
TEMPORADA 2015/2016
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Athletic Fem Athletic 30 75 15 78
2 Barcelona Fem Barcelona 30 98 12 77
3 Atlético Fem Atlético 30 83 24 69
4 Levante Fem Levante Fem 30 56 38 54
5 Real Sociedad Fem Real 30 50 33 53
6 Valencia Fem Valencia 30 65 30 49
7 Costa Adeje Tenerife Fem Costa Adeje 30 49 44 47
8 Sporting Huelva Fem Sporting 30 44 39 46
9 Espanyol Fem Espanyol 30 28 48 36
10 Rayo Vallecano Fem Rayo 30 35 48 36
11 Santa Teresa Fem Santa Teresa 30 43 62 32
12 Zaragoza CFF Fem Zaragoza 30 38 68 32
13 Albacete Fem Albacete 30 47 93 25
14 Oiartzun KE Fem Oiartzun 30 24 67 24
15 Real Oviedo Fem Real Oviedo 30 21 78 11
16 Collerense Fem Collerense 30 28 85 10
TEMPORADA 2014/2015
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Barcelona Fem Barcelona 30 95 9 77
2 Atlético Fem Atlético 30 54 21 69
3 Athletic Fem Athletic 30 73 25 65
4 Valencia Fem Valencia 30 59 25 59
5 Levante Fem Levante Fem 30 60 25 55
6 Rayo Vallecano Fem Rayo 30 45 35 47
7 Espanyol Fem Espanyol 30 50 54 43
8 Sporting Huelva Fem Sporting 30 51 55 41
9 Santa Teresa Fem Santa Teresa 30 33 53 34
10 Real Oviedo Fem Real Oviedo 30 35 61 32
11 Real Sociedad Fem Real 30 39 47 30
12 Collerense Fem Collerense 30 32 65 25
13 Zaragoza CFF Fem Zaragoza 30 27 53 25
14 Albacete Fem Albacete 30 38 64 25
15 Sant Gabriel Fem Sant Gabriel 30 28 63 23
16 Sevilla FC Fem Sevilla 30 27 91 15
TEMPORADA 2013/2014
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Barcelona Fem Barcelona 30 82 12 79
2 Athletic Fem Athletic 30 80 22 69
3 Rayo Vallecano Fem Rayo 30 44 28 51
4 Levante Fem Levante Fem 30 38 29 51
5 Valencia Fem Valencia 30 45 27 51
6 Atlético Fem Atlético 30 66 37 50
7 Sporting Huelva Fem Sporting 30 43 37 43
8 Real Sociedad Fem Real 30 35 34 38
9 Collerense Fem Collerense 30 44 61 35
10 Sant Gabriel Fem Sant Gabriel 30 38 55 34
11 Real Oviedo Fem Real Oviedo 30 30 40 32
12 Espanyol Fem Espanyol 30 37 51 32
13 Zaragoza CFF Fem Zaragoza 30 29 55 31
14 Sevilla FC Fem Sevilla 30 23 60 26
15 Granada CF Fem Granada 30 41 82 22
16 Levante Las Planas Fem Levante 30 28 73 22
TEMPORADA 2012/2013
TERCERA FEDERACIÓN FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Real Oviedo Fem Real Oviedo 26 120 10 73
2 El Olivo Fem Olivo 26 95 22 65
3 PM Friol Fem Friol 26 73 26 60
4 Erizana Cf Erizana Cf 26 39 32 43
5 Ef Mareo Ef Mareo 26 35 38 40
6 Sárdoma Fem Sárdoma 26 44 62 36
7 Atlético Arousana Atlético 26 49 74 32
8 Cd Ponferrada 100 Ponferrada 26 48 67 28
9 Sd Compostela Compostela 26 42 58 27
10 Victoria Cf Victoria Cf 26 43 64 27
11 Gijón Ff Gijón Ff 26 32 66 27
12 León Ff León Ff 26 36 63 25
13 Cd Femiastur Femenino Femiastur 26 30 60 19
14 Trobajo Del Camino Femenino Trobajo 26 23 67 14
TEMPORADA 2011/2012
TERCERA FEDERACIÓN FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Real Oviedo Fem Real Oviedo 26 116 7 75
2 PM Friol Fem Friol 26 45 26 59
3 Cd Ponferrada 100 Ponferrada 26 67 38 50
4 Ef Mareo Ef Mareo 26 50 25 47
5 Erizana Cf Erizana Cf 26 41 44 41
6 Atlético Arousana Atlético 26 38 46 38
7 León Ff León Ff 26 47 52 34
8 Burgos CF Fem Burgos 26 46 49 33
9 Sd Compostela Compostela 26 34 63 28
10 Victoria Cf Victoria Cf 26 40 65 26
11 Gijón Ff Gijón Ff 26 35 53 25
12 Deportivo Abanca Fem Deportivo 26 29 51 24
13 Cd Amigos Del Duero Amigos Duero 26 39 72 19
14 Ud Llanera Ud Llanera 26 20 56 12
TEMPORADA 2010/2011
PRIMERA DIVISIÓN FEMENINA GRUPO 5
Equipo PJ GF GC Puntos
1 Valencia Fem Valencia 14 38 22 29
2 Sporting Huelva Fem Sporting 14 36 20 26
3 Sd Reocín Sd Reocín 14 26 23 25
4 Málaga CF Fem Málaga 14 21 21 25
5 AD Torrejón Femenino Torrejón 14 26 15 24
6 Real Oviedo Fem Real Oviedo 14 27 15 23
7 Gimnastic de Tarragona Fem Gimnastic 14 9 39 7
8 Eibar Fem Eibar Fem 14 11 39 1
TEMPORADA 2009/2010
PRIMERA DIVISIÓN FEMENINA GRUPO 5
Equipo PJ GF GC Puntos
1 Ue L´estartit L´estartit 10 32 9 27
2 Sevilla FC Fem Sevilla 10 24 7 22
3 Sporting Huelva Fem Sporting 11 26 18 18
4 Real Oviedo Fem Real Oviedo 10 16 17 16
5 Málaga CF Fem Málaga 10 10 19 8
6 Real Jaén Femenino Real Jaén F. 11 10 22 8
7 Eibar Fem Eibar Fem 10 11 37 4
TEMPORADA 2007/2008
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Rayo Vallecano Fem Rayo 26 82 23 71
2 Levante Fem Levante Fem 26 64 10 71
3 Athletic Fem Athletic 26 72 31 53
4 Espanyol Fem Espanyol 26 62 40 52
5 Atlético Fem Atlético 26 36 42 36
6 Zaragoza CFF Fem Zaragoza 26 40 47 35
7 AD Torrejón Femenino Torrejón 25 41 41 34
8 Ue L´estartit L´estartit 26 39 46 34
9 Extremadura Fem Extremadura 25 41 37 33
10 Real Sociedad Fem Real 26 22 47 26
11 Sporting Huelva Fem Sporting 26 27 43 23
12 Valencia Fem Valencia 25 35 56 22
13 Real Oviedo Fem Real Oviedo 25 20 67 14
14 CD Híspalis Fem Híspalis 26 23 74 13
TEMPORADA 2006/2007
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Athletic Fem Athletic 26 82 27 64
2 Espanyol Fem Espanyol 26 87 29 63
3 Levante Fem Levante Fem 26 76 25 55
4 Rayo Vallecano Fem Rayo 26 61 40 53
5 CD Híspalis Fem Híspalis 25 51 35 42
6 AD Torrejón Femenino Torrejón 26 42 39 37
7 Extremadura Fem Extremadura 26 34 45 35
8 Atlético Fem Atlético 26 31 46 31
9 Real Sociedad Fem Real 26 30 51 27
10 Sporting Huelva Fem Sporting 25 28 50 24
11 Real Oviedo Fem Real Oviedo 26 29 58 22
12 Zaragoza CFF Fem Zaragoza 26 20 50 20
13 Barcelona Fem Barcelona 26 26 58 16
14 SD Lagunak SD Lagunak 26 28 72 16

  USO DE MEMORIA  
6,884,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.4576
Total Execution Time  0.4598
  CADENA URL  
/historico/Oviedo-Moderno-Femenino
  GET DATOS  
$_GET['/historico/Oviedo-Moderno-Femenino']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0052  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 = 'Oviedo-Moderno-Femenino' 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.0043  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=8867 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=8867 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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=8867 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0045  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 = 74006
0.0030  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8867 AND type_rel = 2
0.0033  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 8867 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024  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 (70738,75071,247115,284185,655937) ORDER BY n.cover_points DESC, update_date DESC
0.0039  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 = '8867' ORDER BY l.year DESC,cat.coefficient DESC
0.0042  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 = '8867' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0038  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 = '8867' 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 = 73459 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037  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=8867 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (74006,73459,68104) 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.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 68104 AND teamId = 8867
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 73459 AND teamId = 8867
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 74006 AND teamId = 8867
0.0026  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 = '8867' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0023  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '8867' and rp.type = 4
0.0029  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 = '8867' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0049  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 = 74006 WHERE rp.league_id = 74006 AND rp.teamId = 8867 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.0046  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 = 74006 WHERE rp.league_id = 74006 AND rp.teamId = 8867 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 74006 WHERE rp.league_id = 74006 AND rp.teamId = 8867 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  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 = 8867 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73459 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 68104 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.0032  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 = 63312 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.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 `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 = 61714 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.0034  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 = 58765 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.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 `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 = 49900 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.0032  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 = 44728 AND t.round = 26 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 `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 = 39302 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 35128 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0056  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 = 16581 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 4011 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 = 2747 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046  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 = 2115 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 = 1848 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 23923 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 = 23927 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0087  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 = 23929 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 23936 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 23941 AND t.round = 26 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 `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 = 23942 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 74006 ORDER BY nameShow LIMIT 100