Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Muleño CF Muleño CF 28 56 24 61
2 Cieza Cieza 28 50 25 59
3 EDMF Churra EDMF Churra 28 39 24 51
4 Villa de Fortuna Villa 28 41 23 49
5 Unión Molinense Unión 28 44 34 47
6 CD Beniel CD Beniel 28 45 38 44
7 Abarán CF Abarán CF 28 38 35 42
8 Yeclano Deportivo B Yeclano 28 45 41 41
9 El Raal El Raal 28 36 35 39
10 Plus Ultra Plus Ultra 28 36 35 38
11 Santomera Santomera 28 33 29 36
12 Cehegin Cehegin 28 35 37 36
13 CD El Esparragal Esparragal 28 26 62 22
14 CD Hoya del Campo Hoya Campo 28 23 56 13
15 Independiente Ceutí Independient 28 24 73 9
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Caravaca Caravaca 22 42 20 46
2 Bala Azul Bala Azul 22 35 15 43
3 Abarán CF Abarán CF 22 46 24 42
4 Mar Menor B Mar Menor B 22 33 26 36
5 Unión Molinense Unión 22 31 31 34
6 El Raal El Raal 22 33 30 31
7 Balsicas Atlético Balsicas 22 31 39 30
8 Cehegin Cehegin 22 32 35 28
9 Atletico Cabezo de Torres Atletico 22 23 26 26
10 Independiente Ceutí Independient 22 23 31 24
11 EF Alhama EF Alhama 22 18 29 22
12 Juvenia Juvenia 22 14 55 7
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Racing Murcia Racing 27 76 23 67
2 CD Bullense CD Bullense 27 43 17 62
3 Abarán CF Abarán CF 27 56 31 57
4 FC La Unión Atl. Unión Atl. 27 62 34 45
5 CD Algar CD Algar 27 45 41 41
6 Mar Menor B Mar Menor B 27 44 38 37
7 Archena Sport Archena 27 41 41 36
8 Balsicas Atlético Balsicas 27 44 48 36
9 Villa de Fortuna Villa 27 45 50 36
10 Bala Azul Bala Azul 27 41 49 36
11 Cieza Cieza 27 34 40 32
12 EF Alhama EF Alhama 27 34 49 31
13 CD Beniel CD Beniel 27 42 50 29
14 Unión Molinense Unión 27 38 46 28
15 Ciudad de Calasparra Ciudad 27 39 54 28
16 Atletico Cabezo de Torres Atletico 27 28 55 28
17 CD El Esparragal Esparragal 27 36 61 25
18 Caravaca Caravaca 27 26 47 24
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 El Palmar El Palmar 34 63 29 78
2 Cartagena F.C. UCAM Cartagena 34 74 27 74
3 Abarán CF Abarán CF 34 89 37 69
4 Racing Murcia Racing 34 67 43 60
5 Plus Ultra Plus Ultra 34 53 34 59
6 Atletico Cabezo de Torres Atletico 34 58 40 57
7 Bala Azul Bala Azul 34 55 47 50
8 EF Alhama EF Alhama 34 42 46 48
9 Mar Menor B Mar Menor B 34 48 51 45
10 CD Bullense CD Bullense 34 45 50 43
11 CD Beniel CD Beniel 34 49 56 42
12 CD El Esparragal Esparragal 34 50 64 41
13 Villa de Fortuna Villa 34 59 76 38
14 Jumilla CD Jumilla CD 34 50 67 36
15 Balsicas Atlético Balsicas 34 45 62 33
16 Juvenia Juvenia 34 43 66 32
17 Montecasillas Montecasilla 34 49 78 32
18 Ind. De Ceutí Ind. Ceutí 34 30 96 13
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 CAP Ciudad de Murcia Ciudad 34 63 29 73
2 Olímpico de Totana Olímpico 34 52 31 68
3 CD Algar CD Algar 34 57 35 64
4 Mazarrón FC Mazarrón 34 70 45 60
5 Abarán CF Abarán CF 34 62 39 59
6 Plus Ultra Plus Ultra 34 44 30 58
7 EF Alhama EF Alhama 34 60 42 54
8 CD El Esparragal Esparragal 34 52 46 48
9 Unión Molinense Unión 34 44 50 45
10 CD Bullense CD Bullense 34 44 50 44
11 Balsicas Atlético Balsicas 34 51 57 40
12 Juvenia Juvenia 34 35 40 39
13 Cartagena F.C. UCAM Cartagena 34 37 61 35
14 Jumilla CD Jumilla CD 34 42 67 35
15 Racing Murcia Racing 34 46 59 32
16 Alquerias Alquerias 34 45 72 32
17 Abanilla Abanilla 34 49 74 30
18 Alcantarilla FC Alcantarilla 34 41 67 30
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Minerva Minerva 34 77 34 76
2 Bala Azul Bala Azul 34 78 46 71
3 FC Cartagena B Cartagena 34 86 46 62
4 Mazarrón FC Mazarrón 34 52 28 61
5 UD Los Garres Garres 34 45 25 61
6 Unión Molinense Unión 34 65 42 57
7 Alquerias Alquerias 34 61 41 56
8 Balsicas Atlético Balsicas 34 49 49 51
9 Alcantarilla FC Alcantarilla 34 39 32 47
10 Cartagena F.C. UCAM Cartagena 34 53 48 46
11 Jumilla CD Jumilla CD 34 49 56 43
12 Abanilla Abanilla 34 51 69 42
13 Racing Murcia Racing 34 60 73 36
14 CD El Esparragal Esparragal 34 46 60 34
15 Plus Ultra Plus Ultra 34 38 67 33
16 Caravaca Caravaca 34 41 68 32
17 Montecasillas Montecasilla 34 30 68 21
18 CD Lumbreras Lumbreras 34 25 93 14
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 UCAM Murcia B UCAM Murcia 34 77 29 73
2 Lorca FC B Lorca FC B 34 68 27 73
3 Olímpico de Totana Olímpico 34 54 36 64
4 Minerva Minerva 34 59 27 60
5 Cieza Cieza 34 57 35 59
6 CD Algar CD Algar 34 59 43 58
7 Mazarrón FC Mazarrón 34 59 45 57
8 UD Los Garres Garres 34 59 56 51
9 Montecasillas Montecasilla 34 56 55 50
10 FC Cartagena B Cartagena 34 50 41 48
11 Jumilla CD Jumilla CD 34 44 40 47
12 Beniajan H. Portman Beniajan 34 43 57 40
13 Unión Molinense Unión 34 38 50 38
14 Alquerias Alquerias 34 37 74 33
15 Bala Azul Bala Azul 34 37 53 31
16 CD Bullense CD Bullense 34 31 69 27
17 Sporting Club Aguileño Sporting 34 30 69 24
18 Juvenia Juvenia 34 27 79 16
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Lorca Deportiva Lorca 34 71 31 71
2 CAP Ciudad de Murcia Ciudad 34 61 27 71
3 At. Pulpileño Pulpileño 34 60 29 69
4 EDMF Churra EDMF Churra 34 59 23 67
5 Olímpico de Totana Olímpico 34 69 42 64
6 UCAM Murcia B UCAM Murcia 34 64 41 57
7 Montecasillas Montecasilla 34 50 39 55
8 Sporting Club Aguileño Sporting 34 48 41 52
9 CD Algar CD Algar 34 52 53 50
10 UD Los Garres Garres 34 57 57 45
11 Alquerias Alquerias 34 54 49 42
12 Bala Azul Bala Azul 34 52 84 41
13 CD Bullense CD Bullense 34 51 76 35
14 Jumilla CD Jumilla CD 34 37 59 33
15 AD Soho CF AD Soho CF 34 55 72 32
16 Calasparra Calasparra 34 45 79 32
17 Abarán CF Abarán CF 34 37 85 22
18 Balsicas Atlético Balsicas 34 33 68 18
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 EF Alhama EF Alhama 31 70 27 70
2 Caravaca Caravaca 32 71 32 69
3 FC Pinatar FC Pinatar 31 57 17 64
4 Balsicas Atlético Balsicas 31 60 45 60
5 CD Algar CD Algar 31 55 28 58
6 CAP Ciudad de Murcia Ciudad 31 44 50 45
7 AD Nuevo Versalles-Loranca Nuevo 31 46 40 43
8 Montecasillas Montecasilla 31 45 40 43
9 Calasparra Calasparra 31 55 51 40
10 Santomera Santomera 31 47 49 40
11 Bala Azul Bala Azul 31 35 55 35
12 UD Los Garres Garres 32 50 57 33
13 Yeclano B Yeclano B 31 29 40 31
14 Sporting Club Aguileño Sporting 31 22 41 31
15 Jumilla CD Jumilla CD 31 31 59 30
16 Alcantarilla Thader Alcantarilla 32 51 72 24
17 Ciudad de Cieza Ciudad Cieza 18 15 78 8
18 Guadalupe Guadalupe 1 2 4 0
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Muleño Cf Muleño Cf 34 87 34 74
2 FC La Unión Atl. Unión Atl. 34 74 26 72
3 FC Cartagena B Cartagena 34 78 26 71
4 FC Pinatar FC Pinatar 34 59 32 68
5 Cf Santomera Santomera 34 69 38 67
6 Caravaca Caravaca 34 76 43 66
7 Sporting Club Aguileño Sporting 34 60 41 63
8 EF Alhama EF Alhama 34 70 33 62
9 Ciudad De Calasparra Ciudad 34 58 52 50
10 CD Cieza B CD Cieza B 34 46 59 42
11 Balsicas Atlético Balsicas 34 48 72 41
12 Montecasillas Fc Montecasilla 34 51 75 35
13 Alcantarilla Thader Alcantarilla 34 45 93 35
14 Ud Los Garres Garres 34 47 59 33
15 Ad Guadalupe Guadalupe 34 42 67 31
16 CD Lumbreras Lumbreras 34 38 76 23
17 Ad Moratalla Moratalla 34 35 92 20
18 Ed Churra Ed Churra 34 30 95 16
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Águilas FC Águilas FC 38 69 18 96
2 Esperanza Esperanza 38 84 41 75
3 Deportiva Minera Deportiva 38 79 41 75
4 Torre Pacheco Torre 38 73 56 67
5 Ceuti At. Ceuti At. 38 70 54 63
6 Thader Murcia CF Thader 38 63 42 59
7 Pozo Estrecho Pozo 38 65 67 56
8 Cuarto Distrito Cuarto 38 54 55 53
9 Muleño CF Muleño CF 38 65 60 52
10 CD Bullense CD Bullense 38 57 52 52
11 El Palmar El Palmar 38 46 48 52
12 UD Los Garres Garres 38 65 72 52
13 Yeclano B Yeclano B 38 43 42 51
14 Mazarrón FC Mazarrón 38 43 54 44
15 Ciudad de Cieza Ciudad Cieza 38 45 62 43
16 Guadalupe Guadalupe 38 50 63 38
17 Lumbreras Lumbreras 38 45 60 37
18 Montecasillas Montecasilla 38 64 86 35
19 Ed Javalí-Ñora Javalí-Ñor 38 38 93 26
20 Emf Cotillas Cotillas 38 35 87 23
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 La Hoya La Hoya 37 83 33 87
2 Unión Molinense Unión 37 81 26 81
3 Racing Cartagena Mar Menor Racing 37 95 49 71
4 CD Bullense CD Bullense 37 56 48 66
5 Esperanza Esperanza 37 63 51 62
6 Minera Minera 37 65 45 57
7 Torre Pacheco Torre 37 67 45 56
8 Ceutí At. Ceutí At. 37 68 52 56
9 Muleño CF Muleño CF 37 66 61 50
10 Montecasillas Montecasilla 36 59 75 45
11 Ciudad de Cieza Ciudad Cieza 37 52 60 44
12 Alquerias Alquerias 37 53 59 42
13 UD Águilas UD Águilas 36 46 69 42
14 Guadalupe Guadalupe 37 61 71 40
15 Invercosta Progreso Invercosta 37 51 66 40
16 Pozo Estrecho Pozo 37 60 77 39
17 El Palmar El Palmar 37 51 61 38
18 Olímpico de Totana Olímpico 37 56 71 38
19 Alberca Huracán Alberca 37 53 147 22
20 San Ginés San Ginés 19 36 56 21
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Puente Tocinos Puente 38 81 32 78
2 Club Fortuna Club Fortuna 38 63 37 74
3 FC Cartagena B Cartagena 38 58 30 73
4 Cuarto Distrito Cuarto 38 68 45 73
5 CF Base Abarán Base Abarán 38 62 39 71
6 Minera Minera 38 60 43 70
7 CD Bullense CD Bullense 38 73 47 67
8 Ciudad de Cieza Ciudad Cieza 38 59 47 66
9 Ceutí At. Ceutí At. 38 55 36 58
10 Archena Archena 38 52 53 51
11 Olímpico de Totana Olímpico 38 60 51 50
12 Racing Cartagena Mar Menor Racing 38 50 51 49
13 Alberca Alberca 38 56 65 49
14 Santiago El Mayor Santiago 38 44 62 43
15 Molinense Molinense 38 54 66 37
16 Alquerias Alquerias 38 45 65 37
17 La Hoya La Hoya 38 28 56 37
18 Javalí-Ñora Javalí-Ñor 38 43 70 33
19 Pinatar B Pinatar B 38 50 91 24
20 Atletico Ciudad B Atletico 38 33 108 14
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,812,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1577
Total Execution Time  0.1598
  CADENA URL  
/murcia2022/grupo1/historico
  GET DATOS  
$_GET['/murcia2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0018  SELECT type FROM routes WHERE alias = 'murcia2022'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'murcia' 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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=81 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 81 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  SELECT /*53 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 (1099011,976498,863991,836089,719860) ORDER BY n.cover_points DESC, update_date DESC
0.0021  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 = 64036 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 81 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 64036 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.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 `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 = 59804 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 `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 = 51172 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.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 `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 = 45113 AND t.round = 34 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 `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 = 39329 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 `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 = 33980 AND t.round = 34 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 `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 = 16639 AND t.round = 34 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 `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 = 4096 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 `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 = 2688 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 `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 = 2074 AND t.round = 34 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 `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 = 1233 AND t.round = 38 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 `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 = 950 AND t.round = 38 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 `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 = 295 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 16:03:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 16:03:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 16:03:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 16:03:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'murcia' 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.0139  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 = 64036 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64036 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.0271  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 = 64036 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64036 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0070  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 = 64036 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64036 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0046  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 = 64036 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