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

Olympique Lyonnais Fem

Entrenador: Sonia Bompastor

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Fem Olympique 21 81 11 61
2 PSG Fem PSG Fem 21 66 15 50
3 Paris Fem Paris Fem 21 56 26 42
4 US Fleury-Merogis Fem Fleury-Merog 21 35 30 33
5 Stade de Reims Fem Stade Reims 21 31 30 32
6 Montpellier Fem Montpellier 21 30 34 29
7 Saint-Étienne Femenino Saint-Étien 21 30 51 28
8 Dijon Fem Dijon Fem 21 25 47 20
9 Le Havre Fem Havre 21 29 46 19
10 Guingamp Fem Guingamp 21 23 45 16
11 Lille Fem Lille Fem 21 26 64 12
12 Girondins Bordeaux Fem Girondins 21 15 48 10
TEMPORADA 2022/2023
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Fem Olympique 22 69 9 61
2 PSG Fem PSG Fem 22 45 12 55
3 Paris Fem Paris Fem 22 44 18 42
4 US Fleury-Merogis Fem Fleury-Merog 22 49 20 39
5 Montpellier Fem Montpellier 22 37 27 37
6 Stade de Reims Fem Stade Reims 22 40 40 32
7 Girondins Bordeaux Fem Girondins 22 26 33 27
8 Le Havre Fem Havre 22 31 45 24
9 Guingamp Fem Guingamp 22 20 41 24
10 Dijon Fem Dijon Fem 22 12 53 15
11 Rodez Fem Rodez Fem 22 16 48 12
12 Soyaux Fem Soyaux Fem 22 15 58 6
TEMPORADA 2021/2022
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Fem Olympique 22 79 8 64
2 PSG Fem PSG Fem 22 68 12 53
3 Paris Fem Paris Fem 22 49 21 50
4 US Fleury-Merogis Fem Fleury-Merog 22 36 26 43
5 Montpellier Fem Montpellier 22 38 25 35
6 Girondins Bordeaux Fem Girondins 22 38 29 35
7 Stade de Reims Fem Stade Reims 22 29 38 33
8 Guingamp Fem Guingamp 22 23 57 17
9 Soyaux Fem Soyaux Fem 22 18 55 16
10 Dijon Fem Dijon Fem 22 13 45 15
11 Issy Fem Issy Fem 22 19 57 13
12 Saint-Étienne Femenino Saint-Étien 22 17 54 7
TEMPORADA 2020/2021
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 PSG Fem PSG Fem 22 83 4 62
2 Olympique Lyonnais Fem Olympique 22 78 6 61
3 Girondins Bordeaux Fem Girondins 22 50 23 44
4 Paris Fem Paris Fem 22 39 29 37
5 Guingamp Fem Guingamp 22 29 32 31
6 Stade de Reims Fem Stade Reims 22 34 42 30
7 Montpellier Fem Montpellier 22 27 35 30
8 Dijon Fem Dijon Fem 22 24 37 26
9 US Fleury-Merogis Fem Fleury-Merog 22 18 42 25
10 Soyaux Fem Soyaux Fem 22 15 46 17
11 Issy Fem Issy Fem 22 11 77 10
12 Le Havre Fem Havre 22 14 49 8
TEMPORADA 2019/2020
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Fem Olympique 16 67 4 44
2 PSG Fem PSG Fem 16 60 7 41
3 Girondins Bordeaux Fem Girondins 16 36 12 37
4 Montpellier Fem Montpellier 16 39 18 30
5 Paris Fem Paris Fem 16 21 26 24
6 Guingamp Fem Guingamp 16 20 21 23
7 US Fleury-Merogis Fem Fleury-Merog 16 18 30 20
8 Soyaux Fem Soyaux Fem 16 15 30 16
9 Stade de Reims Fem Stade Reims 16 13 32 15
10 Dijon Fem Dijon Fem 16 10 32 14
11 Olympique Marsella Fem Olympique 16 12 62 6
12 Metz Femenino Metz 16 7 44 2
TEMPORADA 2018/2019
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Fem Olympique 22 89 6 62
2 PSG Fem PSG Fem 22 62 16 57
3 Montpellier Fem Montpellier 22 51 27 39
4 Girondins Bordeaux Fem Girondins 22 26 34 34
5 Paris Fem Paris Fem 22 34 28 32
6 Soyaux Fem Soyaux Fem 22 19 37 27
7 Dijon Fem Dijon Fem 22 29 44 24
8 Guingamp Fem Guingamp 22 24 33 24
9 US Fleury-Merogis Fem Fleury-Merog 22 24 34 22
10 Metz Femenino Metz 22 21 63 19
11 Lille Fem Lille Fem 22 20 43 18
12 Rodez Fem Rodez Fem 22 14 48 13
TEMPORADA 2017/2018
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Fem Olympique 22 104 5 64
2 PSG Fem PSG Fem 22 59 13 56
3 Montpellier Fem Montpellier 22 63 22 53
4 Paris Fem Paris Fem 22 31 37 30
5 Soyaux Fem Soyaux Fem 22 18 36 24
6 Lille Fem Lille Fem 22 24 47 23
7 Girondins Bordeaux Fem Girondins 22 19 33 22
8 US Fleury-Merogis Fem Fleury-Merog 22 22 45 22
9 Rodez Fem Rodez Fem 22 22 52 22
10 Guingamp Fem Guingamp 22 17 33 22
11 ASPTT Albi Fem ASPTT Albi 22 12 37 20
12 Olympique Marsella Fem Olympique 22 16 47 12
TEMPORADA 2016/2017
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Fem Olympique 22 103 6 63
2 Montpellier Fem Montpellier 22 73 10 55
3 PSG Fem PSG Fem 22 54 16 50
4 Olympique Marsella Fem Olympique 22 32 39 35
5 Juvisy Femenino Juvisy 22 42 25 32
6 Guingamp Fem Guingamp 22 28 36 29
7 Soyaux Fem Soyaux Fem 22 25 52 27
8 Rodez Fem Rodez Fem 22 22 56 21
9 ASPTT Albi Fem ASPTT Albi 22 14 49 19
10 Girondins Bordeaux Fem Girondins 22 14 43 16
11 Saint-Étienne Femenino Saint-Étien 22 19 48 15
12 Metz Femenino Metz 22 13 59 12
TEMPORADA 2015/2016
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Fem Olympique 22 115 6 58
2 PSG Fem PSG Fem 22 75 13 57
3 Montpellier Fem Montpellier 22 61 11 53
4 Juvisy Femenino Juvisy 22 49 20 48
5 Rodez Fem Rodez Fem 22 33 47 30
6 Saint-Étienne Femenino Saint-Étien 22 31 38 29
7 Soyaux Fem Soyaux Fem 22 27 51 25
8 Guingamp Fem Guingamp 22 26 60 25
9 ASPTT Albi Fem ASPTT Albi 22 25 44 23
10 La Roche-sur-Yon Femenino Roche-sur-Yo 22 24 58 16
11 VGA Saint-Maur Saint-Maur 22 22 78 8
12 Nîmes Fem Nîmes Fem 22 17 79 7
TEMPORADA 2014/2015
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Fem Olympique 22 147 6 66
2 PSG Fem PSG Fem 22 88 9 60
3 Juvisy Femenino Juvisy 21 52 22 45
4 Montpellier Fem Montpellier 21 60 19 41
5 Guingamp Fem Guingamp 21 39 31 39
6 Soyaux Fem Soyaux Fem 22 26 57 26
7 Rodez Fem Rodez Fem 22 33 50 24
8 Saint-Étienne Femenino Saint-Étien 22 24 46 22
9 ASPTT Albi Fem ASPTT Albi 22 21 65 22
10 Metz Femenino Metz 21 27 75 19
11 Issy Fem Issy Fem 22 13 75 6
12 Arras Femenino Arras 22 14 89 6
TEMPORADA 2013/2014
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Fem Olympique 22 95 12 63
2 PSG Fem PSG Fem 22 81 10 56
3 Juvisy Femenino Juvisy 22 64 24 55
4 Montpellier Fem Montpellier 22 67 20 46
5 Guingamp Fem Guingamp 22 29 43 27
6 Soyaux Fem Soyaux Fem 22 32 49 25
7 Rodez Fem Rodez Fem 22 29 46 23
8 Arras Femenino Arras 22 27 56 22
9 Saint-Étienne Femenino Saint-Étien 22 23 35 21
10 Hénin-Beaumont Femenino Hénin-Beaum 22 27 56 21
11 Yzeure Allier Femenino Yzeure 22 19 41 17
12 AS Muretaine Femenino Muretaine 22 8 109 1
TEMPORADA 2012/2013
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Fem Olympique 22 132 5 66
2 PSG Fem PSG Fem 22 75 10 56
3 Juvisy Femenino Juvisy 22 65 16 49
4 Montpellier Fem Montpellier 22 65 23 45
5 Yzeure Allier Femenino Yzeure 22 34 44 31
6 Guingamp Fem Guingamp 22 35 43 30
7 Saint-Étienne Femenino Saint-Étien 22 27 35 30
8 Rodez Fem Rodez Fem 22 24 49 24
9 Arras Femenino Arras 22 23 76 17
10 FC Vendenheim Femenino Vendenheim 22 14 74 13
11 Issy Fem Issy Fem 22 19 74 9
12 Toulouse Femenino Toulouse 22 17 81 7
TEMPORADA 2011/2012
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Fem Olympique 22 119 3 60
2 Juvisy Femenino Juvisy 22 62 21 56
3 Montpellier Fem Montpellier 22 74 17 54
4 PSG Fem PSG Fem 22 47 23 44
5 Saint-Étienne Femenino Saint-Étien 22 33 38 28
6 Guingamp Fem Guingamp 22 25 48 26
7 FC Vendenheim Femenino Vendenheim 22 39 68 25
8 Rodez Fem Rodez Fem 22 29 40 24
9 Yzeure Allier Femenino Yzeure 22 31 50 23
10 Hénin-Beaumont Femenino Hénin-Beaum 22 27 72 22
11 Soyaux Fem Soyaux Fem 22 19 68 6
12 AS Muretaine Femenino Muretaine 22 14 71 6
TEMPORADA 2010/2011
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Fem Olympique 22 106 6 66
2 PSG Fem PSG Fem 22 43 16 52
3 Montpellier Fem Montpellier 22 54 13 49
4 Juvisy Femenino Juvisy 22 62 30 48
5 Saint-Étienne Femenino Saint-Étien 22 25 27 34
6 Hénin-Beaumont Femenino Hénin-Beaum 22 19 37 26
7 Rodez Fem Rodez Fem 22 19 29 23
8 Guingamp Fem Guingamp 22 17 35 20
9 Yzeure Allier Femenino Yzeure 22 26 57 17
10 Le Mans FC Femeninno Mans 22 17 51 17
11 Toulouse Femenino Toulouse 22 19 50 16
12 La Roche-sur-Yon Femenino Roche-sur-Yo 22 15 71 11
TEMPORADA 2009/2010
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Fem Olympique 22 93 11 56
2 Juvisy Femenino Juvisy 22 58 18 55
3 PSG Fem PSG Fem 22 62 8 52
4 Montpellier Fem Montpellier 22 48 18 48
5 Yzeure Allier Femenino Yzeure 22 28 32 31
6 Hénin-Beaumont Femenino Hénin-Beaum 22 28 43 26
7 Saint-Étienne Femenino Saint-Étien 22 26 44 26
8 Toulouse Femenino Toulouse 22 25 50 22
9 Guingamp Fem Guingamp 22 38 76 20
10 La Roche-sur-Yon Femenino Roche-sur-Yo 22 23 58 18
11 Soyaux Fem Soyaux Fem 22 13 44 14
12 Montigny-le-Bretonneux Feme Montigny-le- 22 15 55 10
TEMPORADA 2008/2009
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Fem Olympique 22 114 11 64
2 Montpellier Fem Montpellier 22 63 23 52
3 Juvisy Femenino Juvisy 22 53 22 50
4 Yzeure Allier Femenino Yzeure 22 40 38 29
5 Hénin-Beaumont Femenino Hénin-Beaum 22 49 60 29
6 Guingamp Fem Guingamp 22 32 53 28
7 PSG Fem PSG Fem 22 29 30 27
8 Saint-Étienne Femenino Saint-Étien 22 40 46 27
9 Toulouse Femenino Toulouse 22 34 46 26
10 Soyaux Fem Soyaux Fem 22 22 51 19
11 Condé-sur-Noireau Femenino Condé-sur-N 22 30 76 17
12 FC Vendenheim Femenino Vendenheim 22 15 65 5
TEMPORADA 2007/2008
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Fem Olympique 22 93 4 58
2 Juvisy Femenino Juvisy 22 72 13 51
3 Montpellier Fem Montpellier 22 43 15 41
4 Saint-Étienne Femenino Saint-Étien 22 28 22 34
5 PSG Fem PSG Fem 22 25 33 31
6 Soyaux Fem Soyaux Fem 22 31 32 30
7 FC Vendenheim Femenino Vendenheim 22 34 60 27
8 Toulouse Femenino Toulouse 22 26 46 26
9 Hénin-Beaumont Femenino Hénin-Beaum 22 29 58 24
10 Guingamp Fem Guingamp 22 28 54 21
11 La Roche-sur-Yon Femenino Roche-sur-Yo 22 20 38 19
12 Evreux 27 Fem Evreux 22 11 65 13
TEMPORADA 2006/2007
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Olympique Lyonnais Fem Olympique 21 109 9 58
2 Montpellier Fem Montpellier 22 64 12 54
3 Juvisy Femenino Juvisy 22 54 18 53
4 Soyaux Fem Soyaux Fem 22 30 28 38
5 CNFE Clairefontaine Femenin CNFE 22 43 43 30
6 PSG Fem PSG Fem 23 38 33 29
7 Guingamp Fem Guingamp 22 27 47 27
8 Toulouse Femenino Toulouse 23 30 42 24
9 La Roche-sur-Yon Femenino Roche-sur-Yo 21 15 44 19
10 Hénin-Beaumont Femenino Hénin-Beaum 22 31 81 18
11 Compiègne Club Femenino Compiègne 22 31 71 16
12 Condé-sur-Noireau Femenino Condé-sur-N 22 32 76 13
TEMPORADA 2005/2006
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Juvisy Femenino Juvisy 22 83 15 63
2 Montpellier Fem Montpellier 22 68 15 54
3 Olympique Lyonnais Fem Olympique 22 34 12 38
4 Toulouse Femenino Toulouse 22 38 18 37
5 CNFE Clairefontaine Femenin CNFE 22 42 31 34
6 Soyaux Fem Soyaux Fem 22 40 30 34
7 Hénin-Beaumont Femenino Hénin-Beaum 22 27 51 29
8 PSG Fem PSG Fem 22 26 32 27
9 Compiègne Club Femenino Compiègne 22 23 41 21
10 La Roche-sur-Yon Femenino Roche-sur-Yo 22 21 54 17
11 FC Vendenheim Femenino Vendenheim 22 13 53 11
12 Saint Memmie Femenino Saint Memmie 22 15 78 10
TEMPORADA 2004/2005
LIGA FRANCESA FEMENINA
Equipo PJ GF GC Puntos
1 Montpellier Fem Montpellier 23 72 9 63
2 Juvisy Femenino Juvisy 22 78 12 57
3 Olympique Lyonnais Fem Olympique 22 50 20 47
4 Soyaux Fem Soyaux Fem 21 40 32 38
5 Toulouse Femenino Toulouse 22 43 32 37
6 CNFE Clairefontaine Femenin CNFE 23 40 31 34
7 Hénin-Beaumont Femenino Hénin-Beaum 22 42 46 29
8 FC Vendenheim Femenino Vendenheim 22 21 46 23
9 PSG Fem PSG Fem 22 24 50 14
10 Saint Memmie Femenino Saint Memmie 21 22 61 13
11 Guingamp Fem Guingamp 22 25 75 12
12 Condé-sur-Noireau Femenino Condé-sur-N 22 13 56 8

  USO DE MEMORIA  
7,198,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.7519
Total Execution Time  0.7536
  CADENA URL  
/historico/Olympique-Lyonnais-Femenino
  GET DATOS  
$_GET['/historico/Olympique-Lyonnais-Femenino']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (50)  
0.0139  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 = 'Olympique-Lyonnais-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.0125  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=62138 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=62138 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=62138 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=62138 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=62138 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=62138 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=62138 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133  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 = 73344
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62138 AND type_rel = 2
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 62138 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (8809,17936,21987,23215,63708) ORDER BY n.cover_points DESC, update_date DESC
0.0132  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 = '62138' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 74405 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 73344 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136  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=62138 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (75295,74804,73659,73345,72924) 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.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 72924 AND teamId = 62138
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 75295 AND teamId = 62138
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 73659 AND teamId = 62138
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 73345 AND teamId = 62138
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 74804 AND teamId = 62138
0.0127  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 = '62138' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '62138' and rp.type = 4
0.0126  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 = '62138' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139  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 = 75295 WHERE rp.league_id = 75295 AND rp.teamId = 62138 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.0134  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 = 75295 WHERE rp.league_id = 75295 AND rp.teamId = 62138 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 75295 WHERE rp.league_id = 75295 AND rp.teamId = 62138 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 62138 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 = 72924 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 69644 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.0128  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 = 63405 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.0128  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 = 57118 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.0129  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 = 50112 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.0128  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 = 44478 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 39143 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 33910 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 19705 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 9741 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 28167 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 28172 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 28177 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 28180 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 28182 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 28183 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 28187 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 28189 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 28193 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2005` 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 = 28195 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 75295 ORDER BY nameShow LIMIT 100