Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 CD Aurrera Vitoria Aurrera 10 40 9 25
2 Laudio Laudio 11 24 12 23
3 El Pilar Marianistas Pilar 11 27 22 19
4 Zuia de Fútbol Zuia Fútbol 11 13 14 18
5 San Viator San Viator 11 21 16 17
6 Salvatierra Salvatierra 11 14 14 17
7 Zaramaga Zaramaga 11 12 10 15
8 Mercedarias KE Mercedarias 11 16 26 12
9 CD Lakua Arriaga Lakua 10 15 19 11
10 Ariznabarra Ariznabarra 11 15 26 9
11 Vitoria B Vitoria B 11 11 24 8
12 CD Lantarón Lantarón 11 11 27 5
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Amurrio Amurrio 9 46 7 25
2 Laudio Laudio 9 14 9 20
3 Ansares Ansares 9 22 13 18
4 El Pilar Marianistas Pilar 9 20 13 18
5 CD Lakua Arriaga Lakua 9 15 13 15
6 Mercedarias KE Mercedarias 9 15 12 11
7 Zaramaga Zaramaga 9 10 23 8
8 Hauskaitz KK Hauskaitz 9 10 24 7
9 Aranbizkarra Aranbizkarra 9 8 27 4
10 San Ignacio B Ignacio 9 7 26 4
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Aurrera KE Aurrera KE 24 35 18 46
2 CD Elorrio CD Elorrio 24 29 13 45
3 CD Getxo CD Getxo 24 38 22 44
4 Gernika B Gernika B 24 37 28 41
5 SD San Pedro Pedro 24 34 28 39
6 SD Zamudio SD Zamudio 24 33 34 36
7 Gatika KT Gatika KT 24 21 22 36
8 Uritarra CD Uritarra CD 24 32 23 34
9 CD Padura CD Padura 24 30 23 33
10 CD Derio CD Derio 24 26 30 33
11 Abanto Club Abanto Club 24 35 33 30
12 Club Bermeo Club Bermeo 24 22 27 30
13 Iurretako KT Iurretako 24 29 25 29
14 Dínamo San Juan Dínamo Juan 24 18 27 26
15 SD Indautxu SD Indautxu 24 28 36 24
16 SD Erandio SD Erandio 24 24 36 24
17 Galdakao Galdakao 24 20 38 24
18 Cd Sondika Cd Sondika 24 19 47 14
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 SD San Pedro Pedro 34 58 27 68
2 Iurretako KT Iurretako 34 52 28 63
3 Gatika KT Gatika KT 34 47 26 62
4 SD Erandio SD Erandio 34 41 30 58
5 Urduliz FT Urduliz FT 34 32 24 51
6 Arratia CD Arratia CD 34 31 30 51
7 Galdakao Galdakao 34 40 46 49
8 CD Derio CD Derio 34 38 38 46
9 CD Elorrio CD Elorrio 34 37 28 44
10 Sd Ugeraga Sd Ugeraga 34 46 42 44
11 CD Loiu CD Loiu 34 30 31 44
12 Aurrera KE Aurrera KE 34 44 49 44
13 Cd Sondika Cd Sondika 34 28 38 44
14 CD Padura CD Padura 34 34 44 43
15 Apurtuarte Apurtuarte 34 32 37 38
16 Retuerto Sport Retuerto 34 38 47 37
17 SD Etxebarri Etxebarri 34 25 54 27
18 Zalla Zalla 34 20 54 17
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 JD Somorrostro Somorrostro 34 66 35 73
2 SD San Pedro Pedro 34 57 38 63
3 Gatika KT Gatika KT 34 57 34 62
4 Iurretako KT Iurretako 34 45 23 58
5 CD Padura CD Padura 34 34 20 58
6 Derio Derio 34 50 37 58
7 Sondika Sondika 34 38 28 51
8 SD Erandio SD Erandio 34 49 36 50
9 CD Elorrio CD Elorrio 34 54 44 50
10 Urduliz FT Urduliz FT 34 39 39 45
11 Retuerto Sport Retuerto 34 41 46 44
12 Apurtuarte Apurtuarte 34 35 42 39
13 Ugeraga Ugeraga 34 32 51 39
14 CD Loiu CD Loiu 34 25 42 34
15 Abanto Club Abanto Club 34 32 48 31
16 Zaldua KE Zaldua KE 34 43 73 30
17 Gallarta Gallarta 34 29 49 29
18 Lekeitio FT Lekeitio FT 34 28 69 21
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Sodupe Sodupe 34 76 33 72
2 CD Padura CD Padura 34 40 20 60
3 CD Loiu CD Loiu 34 41 29 60
4 Sondika Sondika 34 41 32 56
5 Apurtuarte Apurtuarte 34 43 30 52
6 Gallarta Gallarta 34 35 37 48
7 JD Somorrostro Somorrostro 34 43 43 48
8 Gatika KT Gatika KT 34 31 32 46
9 Iurretako KT Iurretako 34 36 34 44
10 Lekeitio FT Lekeitio FT 34 39 38 44
11 Urduliz FT Urduliz FT 34 38 50 42
12 Retuerto Sport Retuerto 34 38 38 40
13 SD Erandio SD Erandio 34 38 47 40
14 Derio Derio 34 23 33 38
15 CD Elorrio CD Elorrio 34 28 38 37
16 Abanto Club Abanto Club 34 38 50 35
17 Arratia CD Arratia CD 34 27 36 33
18 Trapagaran CF Trapagaran 34 21 56 24
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Deusto Deusto 34 48 24 70
2 CD Getxo CD Getxo 34 56 29 64
3 JD Somorrostro Somorrostro 34 52 27 63
4 Retuerto Sport Retuerto 34 37 21 57
5 Sodupe Sodupe 34 39 30 56
6 Iurretako KT Iurretako 34 46 28 53
7 Apurtuarte Apurtuarte 34 42 41 52
8 Sondika Sondika 34 32 26 51
9 Gallarta Gallarta 34 37 38 47
10 Gatika KT Gatika KT 34 38 40 44
11 Derio Derio 34 26 31 42
12 CD Elorrio CD Elorrio 34 35 36 40
13 Urduliz FT Urduliz FT 34 39 50 40
14 CD Loiu CD Loiu 34 40 48 39
15 Abanto Club Abanto Club 34 39 48 36
16 CD Padura CD Padura 34 28 44 34
17 Gurutzeta Gurutzeta 34 28 57 24
18 SD Indautxu SD Indautxu 34 31 75 20
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Santurtzi Santurtzi 34 61 30 63
2 SD Erandio SD Erandio 34 43 26 62
3 JD Somorrostro Somorrostro 34 54 28 61
4 Iurretako KT Iurretako 34 36 28 58
5 CD Getxo CD Getxo 34 34 26 54
6 Apurtuarte Club Apurtuarte 34 42 33 51
7 Gatika KT Gatika KT 34 43 33 49
8 CD Padura CD Padura 34 37 29 48
9 Cd Gallarta Cd Gallarta 34 45 42 47
10 Deusto Deusto 34 39 26 45
11 Derio Derio 34 31 33 45
12 Gurutzeta Gurutzeta 34 32 34 43
13 CD Loiu CD Loiu 34 34 47 40
14 Sondika Sondika 34 30 41 39
15 CD Elorrio CD Elorrio 34 32 33 37
16 CD Galea CD Galea 34 23 50 33
17 CD Basconia B Basconia 34 30 40 33
18 SD Moraza SD Moraza 34 15 82 9
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Sodupe Uc Sodupe Uc 34 43 19 63
2 Retuerto Sport Retuerto 34 45 28 62
3 Santurtzi Santurtzi 34 58 41 61
4 CD Derio CD Derio 34 48 40 54
5 SD Erandio SD Erandio 34 46 32 53
6 JD Somorrostro Somorrostro 34 48 43 53
7 Apurtuarte Club Apurtuarte 34 42 32 52
8 Iurretako KT Iurretako 34 36 29 52
9 Gurutzeta Kft Gurutzeta 34 37 38 47
10 Sd Deusto Sd Deusto 34 41 44 45
11 Cd Sondika Cd Sondika 34 35 35 42
12 Gatika KT Gatika KT 34 37 36 40
13 CD Loiu CD Loiu 34 42 45 40
14 CD Elorrio CD Elorrio 34 31 35 40
15 Cd Gallarta Cd Gallarta 34 38 43 40
16 SD Moraza SD Moraza 34 30 49 32
17 Sd Ugeraga Sd Ugeraga 34 35 57 27
18 SD San Pedro Pedro 34 27 73 18
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 CD Getxo CD Getxo 34 58 38 66
2 Club Bermeo Club Bermeo 34 63 38 65
3 JD Somorrostro Somorrostro 34 44 34 58
4 Deusto Deusto 34 52 35 56
5 Sondika Sondika 34 53 45 50
6 Apurtuarte Club Apurtuarte 34 47 55 49
7 Gallarta Gallarta 34 46 59 49
8 Gatika KT Gatika KT 34 49 40 48
9 Sodupe Sodupe 34 47 42 48
10 Derio Derio 34 37 32 47
11 SD Erandio SD Erandio 34 41 40 47
12 Santurtzi Santurtzi 34 39 52 39
13 Gurutzeta Gurutzeta 34 36 39 37
14 SD San Pedro Pedro 34 45 53 37
15 CD Elorrio CD Elorrio 34 26 32 35
16 Ugeraga Ugeraga 34 34 48 34
17 Galdakao Galdakao 34 36 54 32
18 SD Indautxu SD Indautxu 34 30 47 27
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Balmaseda FC Balmaseda 34 56 26 71
2 JD Somorrostro Somorrostro 34 51 26 66
3 Sondika Sondika 34 60 40 61
4 Club Bermeo Club Bermeo 34 61 49 56
5 Gallarta Gallarta 34 42 39 50
6 Deusto Deusto 34 37 34 50
7 CD Getxo CD Getxo 34 48 40 48
8 SD Indautxu SD Indautxu 34 44 38 47
9 Derio Derio 34 38 49 44
10 Sodupe Sodupe 34 33 37 40
11 Apurtuarte Club Apurtuarte 34 40 51 40
12 SD San Pedro Pedro 34 41 47 39
13 Galdakao Galdakao 34 28 38 39
14 Gurutzeta Gurutzeta 34 37 46 35
15 Berriz Berriz 34 40 67 35
16 Retuerto Sport Retuerto 34 38 43 34
17 Ugeraga Ugeraga 34 36 46 34
18 SD Basurto SD Basurto 34 35 49 31
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Santutxu Santutxu 34 53 30 64
2 Apurtuarte Apurtuarte 34 52 38 60
3 Club Bermeo Club Bermeo 34 52 35 59
4 SD San Pedro Pedro 34 49 39 56
5 CD Getxo CD Getxo 34 45 25 53
6 JD Somorrostro Somorrostro 34 41 32 53
7 Berriz Berriz 34 39 30 52
8 Galdakao Galdakao 34 29 30 46
9 Deusto Deusto 34 31 41 44
10 Sondika Sondika 34 39 36 43
11 Sporting Lutxana Sporting 34 39 52 42
12 Derio Derio 34 36 46 41
13 Ugeraga Ugeraga 34 35 39 40
14 Gallarta Gallarta 34 32 47 40
15 Balmaseda FC Balmaseda 34 48 51 39
16 Gatika KT Gatika KT 34 33 46 36
17 Gurutzeta Gurutzeta 34 41 56 35
18 Ortuella Ortuella 34 31 52 29
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Retuerto Sport Retuerto 34 53 33 69
2 Balmaseda FC Balmaseda 34 49 34 63
3 Santutxu Santutxu 34 50 35 62
4 Gatika KT Gatika KT 34 38 25 59
5 Apurtuarte Apurtuarte 34 53 39 56
6 JD Somorrostro Somorrostro 34 46 35 52
7 Ortuella Ortuella 34 37 44 47
8 SD San Pedro Pedro 34 44 36 45
9 Deusto Deusto 34 39 39 45
10 Club Bermeo Club Bermeo 34 45 46 43
11 CD Getxo CD Getxo 34 44 47 43
12 Ugeraga Ugeraga 34 28 35 43
13 Derio Derio 34 34 37 42
14 Sondika Sondika 34 45 39 41
15 Berriz Berriz 34 35 50 38
16 Galdakao Galdakao 34 32 52 35
17 Sodupe Sodupe 34 34 46 34
18 SD Moraza SD Moraza 34 33 67 21

  USO DE MEMORIA  
6,413,368 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1115
Total Execution Time  0.1135
  CADENA URL  
/preferente_euskadi2022/grupo1/historico
  GET DATOS  
$_GET['/preferente_euskadi2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0018  SELECT type FROM routes WHERE alias = 'preferente_euskadi2022'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'preferente_euskadi' 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=74 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 74 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 (1179918,760947,544162,543859,380875) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=74 ORDER BY order_id ASC
0.0023  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 = 63863 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 74 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 63863 AND t.round = 11 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 `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 = 60093 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0056  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 = 51264 AND t.round = 24 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 `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 = 39691 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 36612 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 = 16700 AND t.round = 34 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 `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 = 4069 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 2672 AND t.round = 34 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 `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 = 1980 AND t.round = 34 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 `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 = 1455 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 = 1134 AND t.round = 34 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 = 849 AND t.round = 34 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 `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 = 289 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 15:13:12' 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-04-19 15:13:12' 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-04-19 15:13:12' 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=3 AND last_update > '2024-04-19 15:13:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'preferente_euskadi' 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.0020  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 = 63863 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63863 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.0019  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 = 63863 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63863 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 = 63863 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63863 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030  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 = 63863 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC