4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Zaragoza CFF 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
SEGUNDA FEDERACIÓN FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético B Fem Atlético 30 58 21 67
2 CE Europa Fem Europa 30 72 31 66
3 Real Madrid B Fem Real Madrid 30 64 23 63
4 Getafe Fem Getafe Fem 30 39 23 56
5 Pradejon Fem Pradejon 30 52 33 52
6 Racing Fem Racing Fem 30 47 32 49
7 Zaragoza CFF Fem Zaragoza 30 58 47 43
8 Espanyol B Fem Espanyol 30 48 49 42
9 Osasuna B Fem Osasuna 30 42 48 40
10 Club Bizkerre Fem Club 30 26 33 40
11 Viajes Interrías Fem Viajes 30 35 40 36
12 Athletic Club C Fem Athletic 30 25 48 34
13 CD Parquesol Fem Parquesol 30 29 58 30
14 Sárdoma Fem Sárdoma 30 28 60 26
15 PM Friol Fem Friol 30 34 72 17
16 Torrelodones CF Fem Torrelodones 30 26 65 15
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 4
Equipo PJ GF GC Puntos
1 Seagull Fem Seagull Fem 24 43 34 43
2 Zaragoza CFF Fem Zaragoza 24 34 23 41
3 Athletic Club B Fem Athletic 24 41 29 37
4 CD Parquesol Fem Parquesol 24 31 41 26
5 Real Sporting Fem Real 24 43 48 25
6 Espanyol B Fem Espanyol 24 27 60 24
7 CF Pozuelo Fem Pozuelo 24 22 42 21
8 Collerense Fem Collerense 24 35 60 18
9 PM Friol Fem Friol 24 25 52 15
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 3
Equipo PJ GF GC Puntos
1 Zaragoza CFF Fem Zaragoza 26 54 13 66
2 Seagull Fem Seagull Fem 26 55 15 63
3 Barcelona B Fem Barcelona 26 72 26 53
4 AEM Fem AEM Fem 26 55 33 48
5 Collerense Fem Collerense 26 56 32 48
6 Espanyol B Fem Espanyol 26 61 37 44
7 Sant Gabriel Fem Sant Gabriel 26 50 32 40
8 Pardinyes Fem Pardinyes 26 36 40 34
9 CE Europa Fem Europa 26 39 50 31
10 CF Igualada Fem Igualada 26 29 39 30
11 Son Sardina Fem Sardina 26 21 53 27
12 Sant Pere Pescador Fem Sant Pere P. 26 38 69 22
13 Pallejà Fem Pallejà 26 21 57 13
14 Mallorca Toppfotball Fem Mallorca 26 12 103 6
TEMPORADA 2017/2018
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Atlético Fem Atlético 30 74 21 77
2 Barcelona Fem Barcelona 30 98 12 76
3 Athletic Fem Athletic 30 51 41 56
4 Costa Adeje Tenerife Fem Costa Adeje 30 48 33 54
5 Valencia Fem Valencia 30 49 32 50
6 Real Betis Fem Real Betis 30 40 37 46
7 Real Sociedad Fem Real 30 42 37 38
8 Levante Fem Levante Fem 30 49 50 38
9 Sporting Huelva Fem Sporting 30 35 42 38
10 Madrid CFF Fem Madrid 30 34 56 36
11 Rayo Vallecano Fem Rayo 30 39 63 33
12 Sevilla FC Fem Sevilla 30 35 50 31
13 Albacete Fem Albacete 30 42 58 30
14 Espanyol Fem Espanyol 30 22 42 29
15 Zaragoza CFF Fem Zaragoza 30 31 67 23
16 Santa Teresa Fem Santa Teresa 30 20 68 19
TEMPORADA 2016/2017
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Atlético Fem Atlético 30 91 17 78
2 Barcelona Fem Barcelona 30 98 13 75
3 Valencia Fem Valencia 30 69 11 68
4 Levante Fem Levante Fem 30 53 49 57
5 Athletic Fem Athletic 30 64 44 53
6 Costa Adeje Tenerife Fem Costa Adeje 30 53 41 46
7 Rayo Vallecano Fem Rayo 30 49 53 43
8 Real Sociedad Fem Real 30 44 34 42
9 Santa Teresa Fem Santa Teresa 30 28 46 36
10 Sporting Huelva Fem Sporting 30 47 56 35
11 Real Betis Fem Real Betis 30 36 51 34
12 Zaragoza CFF Fem Zaragoza 30 31 65 32
13 Espanyol Fem Espanyol 30 30 60 23
14 Albacete Fem Albacete 30 37 76 20
15 Oiartzun KE Fem Oiartzun 30 23 74 18
16 Real Union Tacuense Fem Real Union. 30 22 85 15
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
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Barcelona Fem Barcelona 30 91 13 76
2 Athletic Fem Athletic 30 84 24 74
3 Atlético Fem Atlético 30 70 21 68
4 Levante Fem Levante Fem 30 52 21 65
5 Espanyol Fem Espanyol 30 47 25 54
6 Rayo Vallecano Fem Rayo 30 81 48 49
7 Zaragoza CFF Fem Zaragoza 30 65 77 45
8 Sant Gabriel Fem Sant Gabriel 30 40 44 40
9 Sporting Huelva Fem Sporting 30 41 52 38
10 Real Sociedad Fem Real 30 41 44 33
11 Levante Las Planas Fem Levante 30 34 47 32
12 Sevilla FC Fem Sevilla 30 37 52 30
13 Valencia Fem Valencia 30 29 51 30
14 Collerense Fem Collerense 30 47 77 29
15 C. Llanos Olivenza Fem Llanos 30 30 74 16
16 SD Lagunak SD Lagunak 30 13 132 1
TEMPORADA 2011/2012
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Barcelona Fem Barcelona 34 119 19 94
2 Athletic Fem Athletic 34 118 25 91
3 Espanyol Fem Espanyol 34 117 38 76
4 Rayo Vallecano Fem Rayo 34 90 44 70
5 Levante Fem Levante Fem 34 63 27 68
6 Atlético Fem Atlético 34 83 41 65
7 Real Sociedad Fem Real 34 58 35 62
8 Sporting Huelva Fem Sporting 34 51 48 56
9 Zaragoza CFF Fem Zaragoza 34 72 75 47
10 Sant Gabriel Fem Sant Gabriel 34 55 67 37
11 C. Llanos Olivenza Fem Llanos 34 39 65 35
12 Collerense Fem Collerense 34 54 91 33
13 Valencia Fem Valencia 34 37 83 31
14 SD Lagunak SD Lagunak 34 32 70 31
15 Ue L´estartit L´estartit 34 35 74 29
16 Málaga CF Fem Málaga 34 35 91 23
17 El Olivo Fem Olivo 34 43 112 19
18 Sd Reocín Sd Reocín 34 30 126 9
TEMPORADA 2010/2011
PRIMERA DIVISIÓN FEMENINA GRUPO 4
Equipo PJ GF GC Puntos
1 Espanyol Fem Espanyol 14 42 14 32
2 Rayo Vallecano Fem Rayo 14 41 20 30
3 Athletic Fem Athletic 14 32 15 28
4 Barcelona Fem Barcelona 14 13 13 19
5 Atlético Fem Atlético 14 17 24 17
6 Zaragoza CFF Fem Zaragoza 14 20 31 11
7 Real Sociedad Fem Real 14 9 28 10
8 Sant Gabriel Fem Sant Gabriel 14 19 48 10
TEMPORADA 2009/2010
PRIMERA DIVISIÓN FEMENINA GRUPO 4
Equipo PJ GF GC Puntos
1 Espanyol Fem Espanyol 14 43 8 36
2 Rayo Vallecano Fem Rayo 14 40 12 34
3 Athletic Fem Athletic 14 30 22 29
4 Atlético Fem Atlético 14 18 23 18
5 Barcelona Fem Barcelona 14 16 22 17
6 Zaragoza CFF Fem Zaragoza 14 18 29 12
7 Real Sociedad Fem Real 14 13 35 9
8 Levante Fem Levante Fem 14 8 35 5
TEMPORADA 2008/2009
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Rayo Vallecano Fem Rayo 30 98 16 81
2 Levante Fem Levante Fem 30 86 17 76
3 Athletic Fem Athletic 30 100 43 65
4 Espanyol Fem Espanyol 30 70 25 60
5 Zaragoza CFF Fem Zaragoza 30 52 33 51
6 Barcelona Fem Barcelona 30 48 32 49
7 Atlético Fem Atlético 29 48 32 47
8 AD Torrejón Femenino Torrejón 30 52 68 38
9 Sporting Huelva Fem Sporting 30 43 48 37
10 Real Sociedad Fem Real 29 26 45 32
11 SD Lagunak SD Lagunak 30 29 59 32
12 Ue L´estartit L´estartit 30 48 72 31
13 Málaga CF Fem Málaga 30 33 84 26
14 Valencia Fem Valencia 30 39 81 25
15 Extremadura Fem Extremadura 30 28 64 20
16 CF Pozuelo Fem Pozuelo 30 32 113 16
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

  USO DE MEMORIA  
6,994,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1474
Total Execution Time  0.1486
  CADENA URL  
/historico/Zaragoza-Cf-Femenino
  GET DATOS  
$_GET['/historico/Zaragoza-Cf-Femenino']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0032  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 = 'Zaragoza-Cf-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.0018  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=8848 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=8848 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=8848 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=8848 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 73459
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8848 AND type_rel = 2
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 8848 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (68038,88702,114588,123676,142920) ORDER BY n.cover_points DESC, update_date DESC
0.0025  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 = '8848' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '8848' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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.0027  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=8848 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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,73659,73459) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73459 AND teamId = 8848
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 74006 AND teamId = 8848
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73659 AND teamId = 8848
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 = '8848' 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 = '8848' 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 = '8848' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 8848 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.0020  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 = 8848 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 8848 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 8848 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 `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.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 `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 = 68578 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.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 `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.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 `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.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 `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 = 61715 AND t.round = 10 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 = 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.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 `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 = 44731 AND t.round = 26 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 `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 = 38973 AND t.round = 30 ORDER BY team.conference 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 `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 = 33773 AND t.round = 30 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 `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.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 `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.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 `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.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 `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 = 2114 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 1847 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 `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.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 `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 = 23926 AND t.round = 14 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 `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.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 `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 = 23935 AND t.round = 14 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 = 23940 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 `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