4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Noia Portus Apostoli Noia Portus 34 149 69 82
2 Peñíscola FS Peñíscola 34 122 82 64
3 CD UMA Antequera Antequera 34 123 100 62
4 Alzira FS Alzira FS 34 99 93 57
5 Atletico Benavente FS Atletico 34 152 146 54
6 Barça Atlétic Barça 34 148 120 52
7 Inagroup El Ejido Inagroup 34 95 87 52
8 Union África Ceutí Union 34 100 102 50
9 Full Energía Zaragoza Full 34 111 128 46
10 O Parrulo Ferrol Parrulo 34 106 119 45
11 Bisontes Castellón FS Bisontes 34 88 104 45
12 Real Betis Futsal B Real Betis. 34 122 118 44
13 CD Leganes FS Leganes 34 107 109 44
14 Atlético Mengíbar FS Atlético 34 109 115 42
15 Soliss FS Talavera Soliss 34 95 104 42
16 ETB Calvia - Palma Futsal Calvia Palma 34 112 126 35
17 Ciudad de Móstoles Ciudad 34 93 129 32
18 Club Inter Movistar FS Club Inter. 34 76 156 15
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Inagroup El Ejido Inagroup 16 69 61 31
2 Barça Atlétic Barça 16 58 46 27
3 Manzanares FS Manzanares 16 43 36 25
4 Atlético Mengíbar FS Atlético 16 47 44 23
5 Full Energía Zaragoza Full 16 68 54 22
6 Bisontes Castellón FS Bisontes 16 43 47 20
7 Alzira FS Alzira FS 16 41 49 19
8 Elche CF Sala Elche Sala 16 49 68 16
9 ElPozo Ciudad de Murcia ElPozo 16 36 49 13
10 Noia Portus Apostoli Noia Portus 14 49 30 34
11 Union África Ceutí Union 14 52 34 27
12 Atletico Benavente FS Atletico 14 46 40 20
13 Soliss FS Talavera Soliss 14 34 34 20
14 Ciudad de Móstoles Ciudad 14 44 44 18
15 CD Leganes FS Leganes 14 40 42 16
16 Rivas Futsal Rivas Futsal 14 29 44 14
17 Santiago Futsal Santiago 14 22 48 7
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Real Betis Futsal Real Betis. 23 83 47 50
2 CD UMA Antequera Antequera 23 82 43 45
3 Soliss FS Talavera Soliss 23 74 52 43
4 Manzanares FS Manzanares 23 67 56 43
5 Elche CF Sala Elche Sala 23 78 78 40
6 Ciudad de Móstoles Ciudad 23 73 63 33
7 ElPozo Ciudad de Murcia ElPozo 23 61 55 31
8 Noia Portus Apostoli Noia Portus 23 63 69 31
9 Atlético Mengíbar FS Atlético 23 60 61 30
10 Alzira FS Alzira FS 23 70 78 30
11 Barça Atlétic Barça 23 67 71 28
12 Union África Ceutí Union 23 58 65 26
13 Bisontes Castellón FS Bisontes 23 47 66 25
14 Santiago Futsal Santiago 23 42 59 22
15 Full Energía Zaragoza Full 23 82 103 22
16 Rivas Futsal Rivas Futsal 23 59 100 13
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Burela FS Burela FS 30 116 68 67
2 Real Betis Futsal Real Betis. 30 123 56 66
3 Atlético Mengíbar FS Atlético 30 109 65 62
4 Manzanares FS Manzanares 30 94 80 56
5 Barça Atlétic Barça 30 110 74 54
6 ElPozo Ciudad de Murcia ElPozo 30 111 73 53
7 Córdoba Patrimonio Córdoba 30 110 104 48
8 Santiago Futsal Santiago 30 99 88 45
9 Rivas Futsal Rivas Futsal 30 93 104 37
10 Noia Portus Apostoli Noia Portus 30 102 106 35
11 Bisontes Castellón FS Bisontes 30 66 98 33
12 Elche CF Sala Elche Sala 30 75 99 33
13 Full Energía Zaragoza Full 30 110 124 32
14 Soliss FS Talavera Soliss 30 93 129 29
15 Gran Canaria Gran Canaria 30 86 104 29
16 CD Salesianos Tenerife Salesianos 30 41 166 4
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 ElPozo Ciudad de Murcia ElPozo 30 131 84 61
2 Barça Atlétic Barça 30 122 70 60
3 Viña Albali Valdepeñas Viña Albali 30 114 72 60
4 Burela FS Burela FS 30 102 63 55
5 CD UMA Antequera Antequera 30 106 80 51
6 FSD Puertollano Puertollano 30 118 94 51
7 Real Betis Futsal Real Betis. 30 108 88 51
8 Rivas Futsal Rivas Futsal 30 110 91 48
9 Córdoba Patrimonio Córdoba 30 112 108 47
10 Bisontes Castellón FS Bisontes 30 82 99 40
11 Manzanares FS Manzanares 30 83 103 39
12 Atlético Mengíbar FS Atlético 30 81 90 38
13 Elche CF Sala Elche Sala 30 84 102 33
14 Noia Portus Apostoli Noia Portus 30 64 123 22
15 Prone Lugo FS Prone Lugo 30 64 125 18
16 Tenerife Iberia Toscal Tenerife 30 60 149 6
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Barça Atlétic Barça 26 122 65 59
2 Naturpellet Segovia Naturpellet 26 97 60 58
3 CD UMA Antequera Antequera 26 91 63 56
4 ElPozo Ciudad de Murcia ElPozo 26 99 73 51
5 Elche CF Sala Elche Sala 26 88 61 47
6 Viña Albali Valdepeñas Viña Albali 26 80 64 45
7 O Parrulo Ferrol Parrulo 26 83 73 43
8 Atlético Mengíbar FS Atlético 26 83 80 34
9 Real Betis Futsal Real Betis. 26 79 90 29
10 FSD Puertollano Puertollano 26 74 78 27
11 Rivas Futsal Rivas Futsal 26 89 103 26
12 Tenerife Iberia Toscal Tenerife 26 95 127 23
13 Prone Lugo FS Prone Lugo 26 49 116 8
14 Cidade De Narón Cidade 26 51 127 6
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 ElPozo Ciudad de Murcia ElPozo 26 139 85 59
2 Jimbee Cartagena Jimbee 26 104 74 57
3 Viña Albali Valdepeñas Viña Albali 26 103 77 54
4 Barça Atlétic Barça 26 101 69 52
5 Hércules San Vicente Hércules 26 129 81 51
6 Naturpellet Segovia Naturpellet 26 90 76 44
7 Gran Canaria Gran Canaria 26 107 76 43
8 Real Betis Futsal Real Betis. 26 102 89 41
9 O Parrulo Ferrol Parrulo 26 92 92 32
10 FSD Puertollano Puertollano 26 74 116 30
11 Prone Lugo FS Prone Lugo 26 64 102 22
12 Melilla FS Melilla FS 26 76 98 22
13 Cidade De Narón Cidade 26 38 102 11
14 FS Zamora Futsal Zamora 26 26 108 0
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 CD UMA Antequera Antequera 26 135 84 54
2 Elche CF Sala Elche Sala 26 101 67 53
3 Barça Atlétic Barça 26 112 68 52
4 Brihuega F.S. Brihuega 26 96 72 50
5 Viña Albali Valdepeñas Viña Albali 26 93 75 45
6 C.D. La Escuela C.D. Escuela 26 92 85 41
7 Jimbee Cartagena Jimbee 26 100 81 39
8 Melilla FS Melilla FS 26 88 75 39
9 Gran Canaria Gran Canaria 26 95 91 39
10 ElPozo Ciudad de Murcia ElPozo 26 102 93 37
11 O Parrulo Ferrol Parrulo 26 74 104 25
12 Hércules San Vicente Hércules 26 65 77 23
13 FS Zamora Futsal Zamora 26 45 92 20
14 Sierra de Salinas Sierra 26 37 171 0
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Levante UD FS Levante 24 97 61 55
2 Uruguay Tenerife Uruguay 24 121 79 49
3 Elche CF Sala Elche Sala 24 100 65 48
4 FC Barcelona Barcelona 24 94 68 45
5 Jimbee Cartagena Jimbee 24 100 89 39
6 ElPozo Ciudad de Murcia ElPozo 24 86 83 35
7 Brihuega F.S. Brihuega 24 91 79 35
8 Melilla F.S Melilla F.S 24 73 72 33
9 Hospitalet Bellsport Hospitalet 24 79 83 29
10 C.D. La Escuela C.D. Escuela 24 78 91 28
11 CD UMA Antequera Antequera 24 65 86 26
12 Hércules San Vicente Hércules 24 68 83 20
13 O Parrulo Ferrol Parrulo 24 45 158 1
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Peñíscola FS Peñíscola 26 115 74 54
2 Jumilla B. Carchelo Jumilla 26 96 63 54
3 Carnicer Torrejón Carnicer 26 117 84 48
4 ElPozo Ciudad de Murcia ElPozo 26 99 81 46
5 Fuconsa Jaén Fuconsa 26 93 69 45
6 Playas de Castellón FS Playas 26 114 99 41
7 Bp Andorra Bp Andorra 26 96 98 40
8 Barça Atlétic Barça 26 120 100 38
9 Cd Dominicos Futsal Dominicos 26 79 80 35
10 Melilla FS Melilla FS 26 81 114 30
11 CD UMA Antequera Antequera 26 71 94 28
12 FS Cartagena Cartagena 26 99 125 24
13 Maristas UPV FS Maristas 26 82 109 24
14 Uruguay Peruanos Futsal Uruguay 26 82 154 12
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Oxipharma FS Oxipharma 30 141 91 59
2 Manzanares FS Manzanares 30 111 99 56
3 ElPozo Ciudad de Murcia ElPozo 30 114 98 49
4 Fuconsa Jaén Fuconsa 30 82 85 48
5 C. A Gran Canaria Gran Canaria 30 123 112 47
6 Barça Atlétic Barça 30 118 113 46
7 CD UMA Antequera Antequera 30 104 91 45
8 Sala 5 Martorell Sala 30 130 110 44
9 Burela FS Burela FS 30 94 85 44
10 Union África Ceutí Union 30 118 128 42
11 Bp Andorra Bp Andorra 30 105 103 41
12 Maristas UPV FS Maristas 30 110 112 34
13 Hospitalet Bellsport Hospitalet 30 109 126 31
14 Melilla FS Melilla FS 30 87 108 31
15 Ibiza Gasifred Ibiza 30 105 128 30
16 Playas de Castellón FS Playas 30 91 153 25
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 FSD Puertollano Puertollano 36 125 58 90
2 Ribera Navarra FS Ribera 36 158 88 81
3 Maristas UPV FS Maristas 36 144 111 65
4 C. A Gran Canaria Gran Canaria 36 130 115 62
5 Burela FS Burela FS 36 108 82 60
6 Arcebansa Chint Zamora Arcebansa 36 111 99 60
7 Bp Andorra Bp Andorra 36 141 116 59
8 Lanzarote Lanzarote 36 152 143 52
9 El Pozo Murcia B Pozo Murcia 36 129 123 51
10 CD UMA Antequera Antequera 36 138 140 50
11 Barça Atlétic Barça 36 102 103 49
12 Ulejos Y Pavimentos Brihueg Ulejos 36 112 115 46
13 Union África Ceutí Union 36 101 107 46
14 Jaén FS Jaén FS 36 88 102 40
15 Ibiza Gasifred Ibiza 36 119 134 37
16 Melilla FS Melilla FS 36 92 144 32
17 Cáceres 2016 Cáceres 36 104 150 31
18 Albacete FS Albacete FS 36 99 143 26
19 Tobarra FS Tobarra FS 36 74 154 18
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Gijon El Llano Gijon Llano 28 121 101 51
2 Talavera Talavera 25 98 71 50
3 Bp Andorra Bp Andorra 26 94 71 45
4 RAM León RAM León 26 105 88 43
5 SDM Illescas Illescas 26 96 95 38
6 Cáceres 2016 Cáceres 26 86 106 34
7 Burela FS Burela FS 16 59 40 33
8 Lanzarote Lanzarote 26 90 102 32
9 Delta Badajoz Delta 25 118 107 31
10 Alto Aragón FS Alto Aragón 26 102 124 30
11 El Escorial El Escorial 25 102 100 29
12 Ribera Navarra FS Ribera 26 80 89 29
13 Aviles Oquendo Aviles 26 64 92 29
14 Racing Valverdeno Racing 24 78 115 20
15 C. A Gran Canaria Gran Canaria 9 37 29 16
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Arcebansa Zamora Arcebansa 20 74 44 44
2 Sala 10 Zaragoza Sala 20 92 65 44
3 Burela FS Burela FS 20 74 36 42
4 Az Ramos Talavera Ramos 20 75 65 33
5 Sport Sala Villaverde Sport Sala. 20 77 88 29
6 Bp Andorra Bp Andorra 20 78 79 28
7 Forma Cáceres 2016 Forma 20 72 72 22
8 Bilbo Bilbo 20 61 75 20
9 Ocaña Puertas Uniarte Ocaña 20 53 76 18
10 La Rápita La Rápita 20 52 75 18
11 Obras Y Estructuras Obras 20 54 87 13

  USO DE MEMORIA  
6,612,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.5380
Total Execution Time  0.5400
  CADENA URL  
/segunda_division_futsal2022/grupo1/historico
  GET DATOS  
$_GET['/segunda_division_futsal2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0144  SELECT type FROM routes WHERE alias = 'segunda_division_futsal2022'
0.0291  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_division_futsal' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0146  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 63428 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 109 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0151  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 = 63428 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.0149  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 = 58755 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.0152  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 = 50516 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 44362 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 39113 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 33894 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 16599 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 4457 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 3020 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 1936 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 1787 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 1215 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 924 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 735 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-23 22:04:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-23 22:04:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-23 22:04:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-23 22:04:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_division_futsal' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0146  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 events2022 e ON e.player_id = p.id AND e.league_id = 63428 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63428 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.0146  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 events2022 e ON e.player_id = p.id AND e.league_id = 63428 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63428 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0147  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 events2022 e ON e.player_id = p.id AND e.league_id = 63428 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63428 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0159  SELECT *,(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 = 63428 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