4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Gimnástic Manresa Sub 19 Gimnástic 26 58 24 62
2 Barcelona Sub 19 B Barcelona 27 60 28 59
3 Gimnàstic Sub 19 Gimnàstic 27 67 28 58
4 CF Damm Sub 19 B Damm 26 39 29 51
5 Martinenc Sub 19 Martinenc 27 47 46 44
6 CE Europa Sub 19 Europa 27 46 42 42
7 Sant Andreu Sub 19 Sant Andreu 27 38 38 38
8 Sabadell Sub 19 B Sabadell 27 42 42 36
9 Olot Sub 19 Olot Sub 19 27 37 44 35
10 FE Grama Sub 19 Grama 27 33 47 34
11 CE APA Poblec Sub 19 Poblec 27 38 42 32
12 Espanyol Sub 19 B Espanyol 26 45 42 32
13 Cornellà Sub 19 B Cornellà 26 30 46 27
14 At. Segre Sub 19 Segre 27 38 55 23
15 Lloret Sub 19 Lloret 27 34 53 20
16 UE Figueres Sub 19 Figueres 27 25 71 14
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Escola Gava Sub 19 Escola Gava 30 49 37 61
2 Barcelona Sub 19 B Barcelona 30 73 30 60
3 Espanyol Sub 19 B Espanyol 30 55 23 58
4 Mercantil Sub 19 Mercantil 30 55 41 54
5 Gimnástic Manresa Sub 19 Gimnástic 30 64 44 52
6 CF Damm Sub 19 B Damm 30 53 41 50
7 Cornellà Sub 19 B Cornellà 30 47 42 46
8 Sant Andreu Sub 19 Sant Andreu 30 50 51 45
9 Martinenc Sub 19 Martinenc 30 43 34 43
10 Sabadell Sub 19 B Sabadell 30 51 50 43
11 Girona FC Sub 19 B Girona 30 32 44 35
12 UE Figueres Sub 19 Figueres 30 36 53 32
13 Jabac I Terrassa Sub 19 Jabac 30 33 58 27
14 UD Bellvitge Sub 19 Bellvitge 30 29 56 21
15 Cerdanyola Sub 19 Cerdanyola 30 32 60 21
16 Lleida Esportiu Sub 19 Lleida 30 31 69 19
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Barcelona Sub 19 B Barcelona 32 56 27 68
2 Badalona Sub 19 Badalona 32 64 39 61
3 FE Grama Sub 19 Grama 32 44 27 60
4 Gimnástic Manresa Sub 19 Gimnástic 32 64 37 59
5 Girona FC Sub 19 B Girona 32 58 39 54
6 CF Damm Sub 19 B Damm 32 56 34 52
7 Espanyol Sub 19 B Espanyol 32 62 45 47
8 UE Figueres Sub 19 Figueres 32 57 63 47
9 Cornellà Sub 19 B Cornellà 32 59 42 44
10 Jabac I Terrassa Sub 19 Jabac 32 41 48 42
11 Mataró CE Sub 19 Mataró 32 41 60 38
12 F. Base Reus Sub 19 Base Reus 32 49 53 37
13 Sants UE Sub 19 Sants 32 41 52 36
14 UE Costa Brava Sub 19 Costa Brava 32 41 53 36
15 Olot Sub 19 Olot Sub 19 32 39 55 35
16 Manresa Sub 19 Manresa 32 36 62 31
17 Manlleu Sub 19 Manlleu 32 35 107 8
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Athletic Sub 19 B Athletic 16 46 10 42
2 CD Getxo Sub 19 Getxo 16 23 12 36
3 CD Vasconia Sub 19 Vasconia 16 23 16 28
4 Danok Bat Sub 19 B Danok 16 27 25 24
5 Indartsu Sub 19 Indartsu 16 18 17 22
6 Santutxu Sub 19 B Santutxu 16 16 24 20
7 Gernika Sub 19 Gernika 16 16 27 15
8 Deusto Sub 19 Deusto 16 10 29 9
9 Durango Sub 19 Durango 16 14 33 7
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 CF Damm Sub 19 B Damm 34 78 38 70
2 Barcelona Sub 19 B Barcelona 34 77 32 69
3 Cornellà Sub 19 B Cornellà 34 63 29 69
4 UD Bellvitge Sub 19 Bellvitge 34 48 31 58
5 Sabadell Sub 19 Sabadell 34 71 43 57
6 Espanyol Sub 19 B Espanyol 34 68 49 55
7 Mataró CE Sub 19 Mataró 34 54 52 51
8 Jabac I Terrassa Sub 19 Jabac 34 53 47 51
9 Josep Maria Gené Josep Maria 34 61 57 49
10 Manresa Sub 19 Manresa 34 37 46 48
11 Mercantil Juvenil Mercantil 34 49 61 45
12 Badalona Sub 19 Badalona 34 46 49 43
13 CF Mollet CF Mollet 34 54 62 42
14 CE Europa Sub 19 Europa 34 41 52 41
15 Reus Deportiu Sub 19 Reus 34 36 54 40
16 AE Prat AE Prat 34 34 40 35
17 Cambrils Unió CE Cambrils 34 35 85 21
18 EF Girones-Sabat Girones-Saba 34 27 105 16
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Espanyol Sub 19 B Espanyol 34 78 30 75
2 Barcelona Sub 19 B Barcelona 34 82 34 69
3 Girona FC Sub 19 Girona 34 70 43 67
4 CF Damm Sub 19 B Damm 34 65 34 65
5 Sant Andreu Sub 19 Sant Andreu 34 37 34 57
6 UD Bellvitge Sub 19 Bellvitge 34 52 48 54
7 EF Girones-Sabat Girones-Saba 34 66 53 53
8 AE Prat AE Prat 34 54 58 51
9 CE Europa Sub 19 Europa 34 59 48 50
10 Cornellà Sub 19 B Cornellà 34 45 42 45
11 Reus Reus 34 46 60 42
12 CF Mollet CF Mollet 34 40 55 41
13 Mataró CE Sub 19 Mataró 34 41 51 38
14 Gavà Sub 19 Gavà 34 56 64 36
15 L'Hospitalet Sub 19 L'Hospitalet 34 47 55 35
16 CE Vila Olimpica Vila 34 46 83 25
17 Aec Manlleu Juvenil Manlleu 34 29 68 25
18 Blanca Subur Sub 19 Blanca Subur 34 36 89 16
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Barcelona Sub 19 B Barcelona 34 71 24 74
2 Lleida Esportiu Sub 19 Lleida 34 67 40 73
3 Mercantil Juvenil Mercantil 34 55 37 65
4 CF Damm Sub 19 B Damm 34 68 58 58
5 L'Hospitalet Sub 19 L'Hospitalet 34 52 35 56
6 Gavà Sub 19 Gavà 34 51 54 51
7 AE Prat AE Prat 34 56 50 46
8 Cornellà Sub 19 B Cornellà 34 51 43 44
9 Espanyol B Espanyol B 34 44 44 44
10 Mataró CE Sub 19 Mataró 34 48 51 42
11 CF Mollet CF Mollet 34 45 45 42
12 Aec Manlleu Juvenil Manlleu 34 38 39 41
13 UD Bellvitge Sub 19 Bellvitge 34 48 62 40
14 Rubí Rubí 34 44 49 38
15 UE Figueres Sub 19 Figueres 34 39 56 35
16 Premià Premià 34 37 66 35
17 Badalona B Juvenil Badalona 34 46 72 33
18 Fundación Privada Hermes Fundación 34 45 80 28
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Barcelona Sub 19 B Barcelona 34 88 19 93
2 Espanyol Sub 19 B Espanyol 34 77 34 70
3 Cornellà Sub 19 B Cornellà 34 79 47 67
4 CE Europa Sub 19 Europa 34 49 38 56
5 Jabac I Terrassa Sub 19 Jabac 34 58 39 53
6 Lleida Esportiu Sub 19 Lleida 34 57 47 47
7 UD Bellvitge Sub 19 Bellvitge 34 49 49 47
8 UDA Gramenet Milán Juvenil Gramenet 34 57 60 47
9 L'Hospitalet Sub 19 L'Hospitalet 34 60 61 44
10 AE Prat AE Prat 34 49 53 44
11 Ce Premià Ce Premià 34 47 52 43
12 UE Figueres Sub 19 Figueres 34 49 51 42
13 CF Mollet CF Mollet 34 46 55 42
14 UE Vilassar de Mar Vilassar 34 41 55 39
15 Reus Deportiu Sub 19 Reus 34 33 64 37
16 Nàstic Tarragona Sub 19 B Nàstic 34 46 66 36
17 Ce Farners Ce Farners 34 39 92 27
18 Girona FC Sub 19 B Girona 34 31 73 14
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Barcelona Sub 19 B Barcelona 32 75 24 79
2 Gavà Sub 19 Gavà 32 57 31 67
3 Sant Andreu Sub 19 Sant Andreu 32 56 34 63
4 L'Hospitalet Sub 19 L'Hospitalet 33 59 38 61
5 Jabac I Terrassa Sub 19 Jabac 32 70 56 61
6 Espanyol Sub 19 B Espanyol 32 61 39 52
7 CE Europa Sub 19 Europa 32 54 51 47
8 Premià Premià 33 39 46 42
9 CF Mollet CF Mollet 32 53 58 41
10 Girona FC Sub 19 B Girona 32 53 62 41
11 CF Damm Sub 19 B Damm 33 38 59 32
12 UDA Gramenet Milán Juvenil Gramenet 32 49 78 32
13 Cornellà Sub 19 B Cornellà 32 47 54 31
14 AE Prat AE Prat 32 43 55 31
15 UE Figueres Sub 19 Figueres 32 38 60 29
16 Mercantil Juvenil Mercantil 32 41 69 28
17 Fpef Calella Fpef Calella 32 47 68 27
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Barcelona Sub 19 B Barcelona 34 82 25 84
2 Espanyol Sub 19 B Espanyol 34 79 43 74
3 Mataró CE Sub 19 Mataró 34 61 46 56
4 Reus Deportiu Sub 19 Reus 34 64 52 55
5 Gavà Sub 19 Gavà 34 56 41 54
6 CE Europa Sub 19 Europa 34 52 39 51
7 AE Prat AE Prat 34 43 46 48
8 Girona FC Sub 19 B Girona 34 45 50 44
9 Sant Andreu Sub 19 Sant Andreu 34 33 44 44
10 CF Damm Sub 19 B Damm 34 55 58 42
11 CF Mollet CF Mollet 34 43 50 42
12 Mercantil Juvenil Mercantil 34 53 62 41
13 Gramenet B Juvenil Gramenet 34 55 67 40
14 Terrassa Sub 19 Terrassa 34 37 61 38
15 Cornellà Sub 19 B Cornellà 34 50 54 37
16 Cf Can Vidalet Vidalet 34 40 61 37
17 Ce L´hospitalet B L´hospitale 34 50 67 31
18 Ue Castelldefels Sub 19 Castelldefel 34 36 68 31
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Barcelona Sub 19 B Barcelona 34 88 23 77
2 Badalona Sub 19 Badalona 34 71 40 69
3 Espanyol Sub 19 B Espanyol 34 50 28 69
4 Aec Manlleu Juvenil Manlleu 34 75 50 64
5 CF Damm Sub 19 B Damm 34 73 42 62
6 Ue Castelldefels Sub 19 Castelldefel 34 61 40 60
7 AE Prat AE Prat 34 34 40 47
8 Cornellà B Cornellà B 34 54 63 47
9 Gramenet B Juvenil Gramenet 34 41 45 44
10 Fundació Mataró Fundació 34 42 59 44
11 Mercantil Juvenil Mercantil 34 42 59 44
12 CE Europa Sub 19 Europa 34 50 49 43
13 Sant Andreu Sub 19 Sant Andreu 34 52 77 40
14 Reus Reus 34 49 62 39
15 Oar Vic A Juvenil Juvenil 34 44 60 38
16 Tortosa Tortosa 34 44 69 31
17 Jabac I Terrassa Sub 19 Jabac 34 51 83 25
18 Lleida B Lleida B 34 32 64 21
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Barcelona B Barcelona B 34 115 19 94
2 Espanyol B Espanyol B 34 76 42 71
3 Gimnàstic Sub 19 Gimnàstic 34 65 32 62
4 Badalona B Juvenil Badalona 34 53 38 60
5 CF Damm Sub 19 B Damm 34 54 42 59
6 Terrassa Sub 19 Terrassa 34 54 41 54
7 Cornellà B Cornellà B 34 64 55 54
8 Aec Manlleu Juvenil Manlleu 34 69 76 54
9 Castelldefels Castelldefel 34 50 47 49
10 Sant Andreu Sub 19 Sant Andreu 34 41 48 47
11 Mercantil Juvenil Mercantil 34 51 56 44
12 AE Prat AE Prat 34 39 54 44
13 CE Europa Sub 19 Europa 34 63 69 38
14 Reus Reus 34 46 66 37
15 Bordeta De Lleida Bordeta 34 38 67 30
16 U.Bellvitge U.Bellvitge 34 40 77 30
17 Premià Premià 34 38 69 28
18 Manresa CE Manresa CE 34 22 80 13

  USO DE MEMORIA  
6,590,416 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.4872
Total Execution Time  0.4906
  CADENA URL  
/nacional_juvenil2024/grupo7/historico
  GET DATOS  
$_GET['/nacional_juvenil2024/grupo7/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=112 ORDER BY order_id ASC
0.0131  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 112 AND group_code = 7 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 73377 AND t.round = 27 ORDER BY team.conference ASC,t.position 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 `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 = 68412 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.0131  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 = 63620 AND t.round = 34 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 = 59003 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.0126  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 = 50787 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 44716 AND t.round = 34 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 `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 = 39216 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 34233 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 16650 AND t.round = 34 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 `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 = 4210 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 2731 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 2128 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 1514 AND t.round = 34 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 = 1168 AND t.round = 34 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 `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 = 907 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 753 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 16:16:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 16:16:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 16:16:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 16:16:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0207  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73377 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73377 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0233  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73377 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73377 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0133  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73377 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73377 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  SELECT *,(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 = 73377 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC