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 Zambu Pinatar Zambu 28 216 102 73
2 Xerez Deportivo Xerez 28 173 83 71
3 ElPozo Ciudad de Murcia ElPozo 28 155 77 57
4 Avanza Jaén Avanza Jaén 28 145 85 56
5 Social Energy Alcalá FS Social 28 133 107 52
6 CD Albacete FS Albacete 28 140 90 51
7 Jaén Paraiso Interior B Jaén 28 125 84 47
8 Córdoba Patrimonio B Córdoba 28 110 106 39
9 Granada FS Granada FS 28 134 133 39
10 Virgili de Cadiz Virgili 28 108 129 39
11 Bujalance FS Bujalance 28 96 92 37
12 Nueva Era Nueva Era 28 93 142 33
13 El Puntarron FS Puntarron 28 134 154 29
14 AD Granja FS Granja 28 86 171 15
15 Coineña UDFS Coineña 28 67 230 8
16 FS Librilla FS Librilla 28 81 211 4
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Atlético Mengíbar FS Atlético 30 128 76 64
2 Melistar Futsal Melistar 30 139 89 61
3 Social Energy Alcalá FS Social 30 124 90 61
4 Bujalance FS Bujalance 30 123 106 58
5 Córdoba Patrimonio B Córdoba 30 129 86 58
6 Granada FS Granada FS 30 139 112 53
7 ElPozo Ciudad de Murcia ElPozo 30 155 135 52
8 Zambu Pinatar Zambu 30 110 96 51
9 Jaén Paraiso Interior B Jaén 30 117 103 49
10 Coineña UDFS Coineña 30 116 104 42
11 El Puntarron FS Puntarron 30 115 151 38
12 Xerez Deportivo Xerez 29 87 106 33
13 Nazareno Dos Hermanas FS Nazareno 30 105 127 29
14 Sporting FS Almería Sporting 30 69 125 26
15 Jumilla FS Jumilla FS 30 89 159 17
16 Africa Ceutí B Africa 29 73 153 7
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Imperial FS Imperial FS 30 157 94 71
2 Jaén Paraiso Interior B Jaén 30 117 77 63
3 Zambu Pinatar Zambu 30 111 85 58
4 ElPozo Ciudad de Murcia ElPozo 30 113 75 53
5 Granada FS Granada FS 30 118 95 51
6 Melistar Futsal Melistar 30 112 97 50
7 Coineña UDFS Coineña 30 100 93 47
8 Bujalance FS Bujalance 30 119 100 45
9 Social Energy Alcalá FS Social 30 117 108 44
10 Xerez Deportivo Xerez 30 113 120 43
11 Futsal Molina Futsal 30 114 100 42
12 Jumilla FS Jumilla FS 30 121 138 42
13 Nazareno Dos Hermanas FS Nazareno 30 86 126 28
14 Virgili de Cadiz Virgili 30 94 123 24
15 Victoria Kent Victoria 30 48 133 14
16 CD Olimpic de Triana FS Olimpic 30 70 146 9
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 ETB Calvia - Palma Futsal Calvia Palma 18 71 55 38
2 Sala 5 Martorell Sala 18 110 74 35
3 Hospitalet Bellsport Hospitalet 18 79 57 33
4 Escola Pia Sabadell Escola 18 79 65 31
5 Ibiza Gasifred Ibiza 18 81 62 31
6 Ripollet Ripollet 18 80 55 31
7 Cerdanyola Valles Cerdanyola 18 63 65 24
8 La Unión Santa Coloma Unión Santa 18 48 65 18
9 Palleja FS Palleja FS 18 51 89 11
10 Arenys de Munt Arenys Munt 18 42 117 6
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 CD Bayyana El Ejido Bayyana 23 130 45 66
2 Dos Hermanas FS Hermanas 22 82 69 47
3 Melistar Futsal Melistar 23 85 65 45
4 Real Betis Futsal B Real Betis. 23 92 79 37
5 Peligros FS Peligros FS 23 93 82 37
6 Jaén Paraiso Interior B Jaén 23 80 69 37
7 Zambu Pinatar Zambu 22 77 69 37
8 Virgili de Cadiz Virgili 22 80 77 32
9 Asociación Jerez Futsal Asociación 23 68 80 32
10 Coineña UDFS Coineña 23 67 68 29
11 Victoria Kent Victoria 23 63 69 26
12 Xerez Deportivo Xerez 23 66 73 26
13 Futuro Carmonense Futuro 23 77 98 23
14 El Puntarron FS Puntarron 22 79 111 22
15 Sporting Constitución FS Sporting 23 58 95 20
16 AV Torcal-Carranque Torcal-Carra 23 57 105 7
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Union África Ceutí Union 27 140 70 66
2 Inagroup El Ejido Inagroup 27 116 53 65
3 Melistar Futsal Melistar 28 115 95 54
4 Peligros FS Peligros FS 27 91 79 47
5 Coineña UDFS Coineña 27 90 91 44
6 Real Betis Futsal B Real Betis. 28 103 92 43
7 Virgili de Cadiz Virgili 28 100 95 41
8 Asociación Jerez Futsal Asociación 28 101 100 38
9 AV Torcal-Carranque Torcal-Carra 27 93 117 32
10 Sporting Constitución FS Sporting 25 80 93 31
11 Xerez Deportivo Xerez 28 99 113 30
12 Futuro Carmonense Futuro 28 88 109 30
13 Social Energy Alcalá FS Social 28 78 110 28
14 Victoria Kent Victoria 28 64 94 25
15 Bujalance FS Bujalance 28 76 123 11
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Xerez Deportivo Xerez 29 129 88 65
2 Coineña UDFS Coineña 29 134 70 62
3 Cerro de Reyes A Cerro Reyes 28 125 62 58
4 Inagroup El Ejido Inagroup 29 121 104 49
5 Melistar Futsal Melistar 27 103 78 48
6 Union África Ceutí Union 29 101 92 48
7 Peligros FS Peligros FS 29 104 89 43
8 Social Energy Alcalá FS Social 29 87 96 40
9 Victoria Kent Victoria 29 83 87 39
10 Real Betis Futsal B Real Betis. 29 101 110 39
11 Baeza Dental Company Baeza Dental 28 90 111 38
12 Villa de Fines Villa Fines 27 88 92 33
13 Infantes FS Infantes FS 29 97 110 33
14 Sporting Constitución FS Sporting 27 92 90 31
15 Villa Del Rio Fs Futsal Villa Futsal 29 56 151 14
16 CD Gador CD Gador 29 58 139 12
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Cerro de Reyes A Cerro Reyes 29 150 58 79
2 Córdoba Patrimonio Córdoba 29 160 92 73
3 Union África Ceutí Union 29 134 78 59
4 Xerez Deportivo Xerez 30 132 99 58
5 Peligros FS Peligros FS 30 153 105 52
6 Sporting Constitución FS Sporting 29 104 99 45
7 Villa del Río FS Villa Río 30 106 112 42
8 Victoria Kent Victoria 30 87 103 40
9 Coineña UDFS Coineña 30 138 122 39
10 CD Olimpic de Triana FS Olimpic 30 114 127 36
11 Real Betis Futsal B Real Betis. 30 99 120 34
12 CD Gador CD Gador 30 104 136 32
13 Infantes FS Infantes FS 29 92 127 31
14 Bujalance FS Bujalance 30 93 126 27
15 El Palo Pedregalejo Palo 30 79 144 16
16 Lucena FS Lucena FS 27 67 164 10
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Atlético Mengíbar FS Atlético 24 105 42 68
2 Union África Ceutí Union 24 103 54 46
3 Córdoba Patrimonio Córdoba 23 103 83 42
4 Peligros FS Peligros FS 24 100 74 41
5 Lucena FS Lucena FS 23 82 66 41
6 Victoria Kent Victoria 24 69 82 34
7 Coineña UDFS Coineña 24 85 85 33
8 Caceres Malpartida FS Caceres 24 70 88 29
9 Villa del Río FS Villa Río 24 73 92 28
10 CD Olimpic de Triana FS Olimpic 25 86 115 23
11 Sporting Constitución FS Sporting 24 70 90 23
12 Bujalance FS Bujalance 25 79 94 23
13 Isleño San Fernando FS Isleño 24 30 90 13
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Real Betis Futsal Real Betis. 24 143 67 64
2 Atlético Mengíbar FS Atlético 24 93 75 51
3 CD Olimpic de Triana FS Olimpic 24 118 94 41
4 Santaella 2010 FS Santaella 24 91 95 40
5 Coineña UDFS Coineña 24 113 90 38
6 Union África Ceutí Union 24 91 77 35
7 Virgili de Cadiz Virgili 24 76 75 34
8 FSD Puertollano Puertollano 24 103 102 27
9 Cd Fs Ategua Futsal Ategua 24 88 95 25
10 Racing Kallan Doors Racing 24 96 124 25
11 Bujalance FS Bujalance 24 65 96 22
12 Victoria Kent Victoria 24 76 122 21
13 El Ejido 2012 FS Ejido 2012 24 74 115 16
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Nazareno Dos Hermanas FS Nazareno 1 7 3 3
2 Racing Alameda Futsal Racing 1 4 0 3
3 Hotel Gran Sol Futsal Hotel Gran. 1 7 6 3
4 Sumurfit Kappa La Palma Fut Sumurfit 1 6 5 3
5 Manzanares Fs Futsal Manzanares 1 3 2 3
6 Incosur Coineña Futsal Incosur 1 3 3 1
7 Sporting San Vicente Futsal Sporting 1 3 3 1
8 Estopiñan Estopiñan 1 1 1 1
9 Manilva Fs Futsal Manilva 1 1 1 1
10 Orihuela Fs Futsal Orihuela 0 0 0 0
11 Union África Ceutí Union 1 6 7 0
12 AD Almendralejo Almendralejo 1 5 6 0
13 Cd Fs Ategua Futsal Ategua 1 2 3 0
14 El Ejido Murgicontrol Futsa Ejido 1 3 7 0
15 Bujalance Fs Futsal Bujalance 1 0 4 0
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Jumilla B. Carchelo Jumilla 28 157 65 76
2 Nazareno Dos Hermanas FS Nazareno 28 187 60 73
3 Cd Fs Ategua Futsal Ategua 28 115 80 63
4 Massey F. Valdepeñas Futsa Massey 28 113 108 51
5 Racing Alameda Futsal Racing 28 121 101 50
6 Incosur Coineña Futsal Incosur 28 116 107 50
7 Mutrayil Mercomotril Futsal Mutrayil 28 102 81 48
8 Bujalance Fs Futsal Bujalance 28 138 127 40
9 Albacete Fs Futsal Albacete 28 103 114 36
10 Alcala De Guadaira Futsal Alcala 28 114 125 32
11 Algarinejo Fs Futsal Algarinejo 28 102 127 26
12 El Ejido Murgicontrol Futsa Ejido 28 100 149 24
13 Manilva Fs Futsal Manilva 28 81 137 18
14 Melilla B Futsal Melilla 28 70 178 13
15 CD Vícar CD Vícar 28 80 140 12
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Ebrosala Ebrosala 26 123 83 56
2 Centelles Finques Cent. Centelles 26 129 92 52
3 Peñíscola FS Peñíscola 26 115 95 47
4 Sicoris Club Sicoris Club 26 91 77 47
5 Pinseque Ad Pinseque Ad 26 120 92 45
6 Alcañiz FS Alcañiz FS 26 126 111 45
7 Bajo Aragon-caspe F.s. Bajo 26 94 87 43
8 Club Manresa Fs Club Manresa 26 122 97 41
9 Sala Zaragoza A.d.-hispanid Sala 26 93 109 32
10 Tedreca A.c.d. Tedreca 26 106 128 28
11 Vila Sport-auto Real Vila 26 100 139 27
12 CFS Playas Salou Playas Salou 26 82 116 25
13 Penya B. Montserrat-monistr Penya 26 108 122 23
14 Maderas Altoaragon/rigar Li Maderas 26 57 118 16
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Centelles Finques Cent. Centelles 29 156 84 74
2 Pinseque Ad Pinseque Ad 29 143 67 71
3 Sicoris Club Sicoris Club 29 143 99 61
4 Sala Zaragoza A.d.-hispanid Sala 29 118 111 51
5 Tedreca A.c.d. Tedreca 28 135 101 50
6 Bajo Aragon-caspe F.s. Bajo 28 103 83 50
7 Club Manresa Fs Club Manresa 28 125 111 47
8 Alcañiz FS Alcañiz FS 28 120 116 46
9 F.s. Sant Cugat Winterthur F.s. Sant C. 28 119 122 43
10 Penya B. Montserrat-monistr Penya 28 117 127 39
11 Sala 5 Martorell Sala 29 116 124 36
12 Vilaseca F.s. Vilaseca 28 103 104 32
13 Maderas Altoaragon/rigar Li Maderas 28 71 102 20
14 Velez Rubio Velez Rubio 29 71 142 17
15 Andorra Polideportivo Futsa Andorra 28 65 150 12
16 F.s.palau Plegamans F.s.palau 26 68 130 11
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Club La Muela Fs Club Muela 28 137 77 65
2 Sala 5 Martorell Sala 28 132 74 61
3 Hospitalet Bellsport Hospitalet 28 130 87 61
4 Barça Barça 27 124 70 57
5 Pinseque Ad Pinseque Ad 28 116 91 52
6 Caspe-conserv. Rabinad Caspe-conser 27 100 93 41
7 Alcañiz FS Alcañiz FS 27 117 126 36
8 Sicoris Club Sicoris Club 28 98 101 35
9 Alto Aragón FS Alto Aragón 27 78 99 32
10 Montserrat Monistrol Montserrat 28 110 128 30
11 Club Manresa Fs Club Manresa 28 77 88 26
12 Velez Rubio Velez Rubio 28 90 139 25
13 Andorra Polideportivo Futsa Andorra 28 66 108 22
14 Epic Casino Fs Epic Casino 27 106 149 22
15 Alcorisa Fs Alcorisa Fs 27 95 146 21

  USO DE MEMORIA  
6,592,896 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4904
Total Execution Time  0.4924
  CADENA URL  
/segunda_division_b_futsal2024/grupo5/historico
  GET DATOS  
$_GET['/segunda_division_b_futsal2024/grupo5/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0162  SELECT id,name,alias,stepParent FROM categories WHERE parentId=110 ORDER BY order_id ASC
0.0148  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 110 AND group_code = 5 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 74089 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 68841 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.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 `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 = 63800 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.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 `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 = 58896 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 = 50546 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.0170  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 = 44588 AND t.round = 30 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 `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 = 40228 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 `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 = 35142 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 20046 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 `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 = 4613 AND t.round = 26 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 `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 = 2205 AND t.round = 1 ORDER BY team.conference 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 `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 = 1789 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 = 1228 AND t.round = 26 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 `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 = 930 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 741 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-28 11:18:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 11:18:24' 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-28 11:18:24' 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-28 11:18:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  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 = 74089 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74089 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.0156  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 = 74089 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74089 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0155  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 = 74089 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74089 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10