Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Lagunak Lagunak 16 34 10 35
2 CD Lerinés CD Lerinés 16 30 21 31
3 Erriberri Erriberri 16 31 18 29
4 River Ega River Ega 16 35 30 26
5 Peña Azagresa Peña 16 23 21 21
6 Mendi Mendi 16 17 23 16
7 CD Muskaria CD Muskaria 16 13 28 15
8 Aluvión Aluvión 16 15 37 14
9 Lagun Artea Lagun Artea 16 19 29 13
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Avance Ezcabarte Avance 18 45 17 45
2 Erriberri Erriberri 18 36 19 38
3 Gares Gares 18 30 18 33
4 CD Zirauki CD Zirauki 18 24 21 28
5 CD Iruña CD Iruña 18 21 19 25
6 Zarramonza Zarramonza 18 26 28 22
7 CF Beti Casedano Beti 18 25 34 20
8 Lagun Artea Lagun Artea 18 24 37 17
9 Burladés B Burladés B 18 17 35 15
10 Infanzones Infanzones 18 16 36 6
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Cantolagua Cantolagua 22 44 24 49
2 River Ega River Ega 22 49 29 45
3 FC Bidezarra Bidezarra 22 40 23 44
4 Avance Ezcabarte Avance 22 53 29 43
5 CD Alesves CD Alesves 22 42 24 37
6 CD Iruña CD Iruña 21 34 35 34
7 Oberena Oberena 22 27 17 33
8 Gares Gares 22 21 22 29
9 Aoiz Aoiz 22 33 31 28
10 Burladés B Burladés B 22 34 38 28
11 CD Zirauki CD Zirauki 22 28 30 26
12 Artajonés Artajonés 21 25 32 26
13 Mendi Mendi 22 32 34 24
14 Infanzones Infanzones 22 28 42 23
15 Lagunak Lagunak 22 19 32 21
16 Erriberri Erriberri 22 25 43 19
17 Idoya Idoya 22 18 44 16
18 Zarramonza Zarramonza 22 26 49 15
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Peña Azagresa Peña 34 67 31 73
2 CD Fontellas Fontellas 34 58 42 61
3 Murchante Murchante 34 47 37 56
4 Oberena Oberena 34 52 37 53
5 Lourdes Lourdes 34 54 44 52
6 Mendi Mendi 33 52 42 49
7 Aoiz Aoiz 34 42 42 49
8 Gares Gares 34 40 42 48
9 River Ega River Ega 34 60 48 46
10 FC Bidezarra Bidezarra 34 34 40 45
11 Azkoyen Azkoyen 33 42 42 43
12 Erriberri Erriberri 33 48 53 43
13 CD Iruña CD Iruña 34 52 49 42
14 Idoya Idoya 34 44 54 41
15 Infanzones Infanzones 33 47 65 39
16 CF Beti Casedano Beti 34 47 64 38
17 Valtierrano Valtierrano 34 38 55 36
18 CD Ablitense Ablitense 34 36 73 26
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Beti Onak Beti Onak 34 71 40 68
2 Avance Ezcabarte Avance 34 56 28 67
3 CD Alesves CD Alesves 34 51 41 55
4 Peña Azagresa Peña 34 51 42 52
5 FC Bidezarra Bidezarra 34 44 35 49
6 Lourdes Lourdes 34 45 40 47
7 Valtierrano Valtierrano 34 41 41 47
8 CF Beti Casedano Beti 34 54 50 46
9 Erriberri Erriberri 34 46 45 46
10 Mendi Mendi 34 51 42 44
11 Aoiz Aoiz 34 42 44 44
12 Aluvión Aluvión 34 47 51 44
13 CD Ilumberri Ilumberri 34 36 48 44
14 CD Ablitense Ablitense 34 40 60 44
15 CD Ondalán CD Ondalán 34 37 44 43
16 CD Zirauki CD Zirauki 34 47 63 40
17 Cd Larrate Cd Larrate 34 45 57 31
18 AD San Juan B Juan 34 45 78 28
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Beti Kozkor Beti Kozkor 34 55 37 70
2 Gares Gares 34 49 28 60
3 Peña Azagresa Peña 34 68 46 59
4 Baztan Baztan 34 56 38 57
5 Avance Ezcabarte Avance 34 39 38 53
6 Aoiz Aoiz 34 53 61 51
7 Beti Onak Beti Onak 34 52 54 47
8 CD Ilumberri Ilumberri 34 55 47 46
9 AD San Juan B Juan 34 52 50 46
10 Aluvión Aluvión 34 47 46 46
11 CD Ablitense Ablitense 34 44 50 46
12 CD Alesves CD Alesves 34 55 53 45
13 Mendi Mendi 34 45 44 43
14 CD Zirauki CD Zirauki 34 43 62 42
15 Infanzones Infanzones 34 62 60 41
16 Azkoyen Azkoyen 34 32 46 36
17 Lagunak Lagunak 34 39 57 36
18 CD Cabanillas Cabanillas 34 30 59 27
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Lourdes Lourdes 34 70 45 63
2 Idoya Idoya 34 55 33 60
3 Valtierrano Valtierrano 34 52 42 58
4 Corellano Corellano 34 56 40 56
5 Avance Ezcabarte Avance 34 63 58 55
6 Peña Azagresa Peña 34 60 52 52
7 Lagunak Lagunak 34 52 43 52
8 AD San Juan B Juan 34 40 28 51
9 Azkoyen Azkoyen 34 50 51 48
10 CD Zirauki CD Zirauki 34 45 51 47
11 Aoiz Aoiz 34 41 44 46
12 Beti Kozkor Beti Kozkor 34 56 50 45
13 CD Ilumberri Ilumberri 34 55 61 44
14 Aluvión Aluvión 34 50 57 44
15 CD Tudela 1999 Tudela 1999 34 35 56 35
16 Artajonés Artajonés 34 44 61 34
17 Murchante Murchante 34 41 64 32
18 CD Buñuel CD Buñuel 34 35 64 19
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Mendi Mendi 30 52 25 65
2 Cantolagua Cantolagua 30 43 20 60
3 Baztan Baztan 30 66 45 53
4 CD Ilumberri Ilumberri 30 63 41 52
5 Beti Kozkor Beti Kozkor 30 39 39 46
6 CD Zirauki CD Zirauki 30 50 39 45
7 Aoiz Aoiz 30 27 31 45
8 Lagunak Lagunak 30 44 39 41
9 AD San Juan B Juan 30 29 27 40
10 Avance Ezcabarte Avance 30 43 50 38
11 Gares Gares 30 36 37 32
12 CF Beriain CF Beriain 30 34 45 29
13 Mutilvera B Mutilvera B 30 39 58 29
14 Lagun Artea Lagun Artea 30 48 66 27
15 CD Aibarés CD Aibarés 30 38 68 25
16 Amaya Amaya 30 31 52 24
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 CF Ardoi CF Ardoi 30 63 35 59
2 Mutilvera B Mutilvera B 30 67 30 56
3 Subiza Subiza 30 49 31 53
4 Avance Ezcabarte Avance 30 47 39 53
5 Lagunak Lagunak 30 47 40 49
6 Gares Gares 30 40 31 45
7 Aoiz Aoiz 30 43 30 44
8 CF Beriain CF Beriain 30 41 50 39
9 Cantolagua Cantolagua 30 41 47 38
10 AD San Juan B Juan 30 31 36 37
11 CD Ilumberri Ilumberri 30 34 44 37
12 Baztan Baztan 30 51 61 36
13 Aurrera De Leitza Aurrera 30 31 45 33
14 Cd Huarte Cd Huarte 30 36 56 32
15 Infanzones Infanzones 30 40 67 25
16 CF Beti Casedano Beti 30 39 58 23
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Beti Onak Beti Onak 30 61 45 59
2 Avance Ezcabarte Avance 29 45 33 50
3 CF Ardoi CF Ardoi 29 50 31 49
4 Artajonés Artajonés 30 54 40 49
5 Gares Gares 30 44 40 46
6 Baztan Baztan 29 65 56 45
7 Mutilvera B Mutilvera B 30 66 49 44
8 Cf Beriain Cf Beriain 30 44 36 44
9 Cd Cantolagua Cantolagua 29 48 51 42
10 Cp San Cristóbal Cristóbal 29 44 56 40
11 Cd Ademar Cd Ademar 30 48 58 37
12 CD Zirauki CD Zirauki 30 38 49 37
13 Mendi Mendi 30 44 41 36
14 Infanzones Infanzones 29 43 49 34
15 Universidad de Navarra Universidad 30 39 58 25
16 JD San Jorge Jorge 30 39 80 23
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Subiza Subiza 30 66 35 61
2 Lagunak Lagunak 30 43 31 53
3 Lagun Artea Lagun Artea 30 48 39 50
4 CF Ardoi CF Ardoi 30 45 36 46
5 JD San Jorge Jorge 30 56 56 45
6 Avance Ezcabarte Avance 30 53 44 43
7 CF Beriain CF Beriain 30 48 46 43
8 Cantolagua Cantolagua 30 51 46 40
9 Cp San Cristóbal Cristóbal 30 40 42 40
10 Artajonés Artajonés 30 41 46 39
11 Mutilvera B Mutilvera B 30 34 40 37
12 Baztan Baztan 30 48 52 36
13 Gares Gares 30 41 50 34
14 CD Valle de Egüés B Valle 30 41 53 34
15 Amaya Amaya 30 38 49 33
16 Gazte Berriak Gazte 30 31 59 24
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Burladés Burladés 30 57 32 61
2 Subiza Subiza 30 58 33 60
3 Avance Ezcabarte Avance 30 66 44 51
4 Cantolagua Cantolagua 30 45 42 46
5 Lagunak Lagunak 30 51 51 45
6 Gazte Berriak Gazte 30 48 54 44
7 Mendi Mendi 30 53 48 40
8 Mutilvera B Mutilvera B 30 49 46 40
9 Artajonés Artajonés 30 35 33 40
10 Amaya Amaya 30 46 47 40
11 Gares Gares 30 41 42 40
12 Cp San Cristóbal Cristóbal 30 47 49 39
13 Erriberri Erriberri 30 59 48 38
14 Aurrera De Leitza Aurrera 30 41 53 37
15 Infanzones Infanzones 30 34 57 22
16 CD Etxarri CD Etxarri 30 35 86 19
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Lagun Artea Lagun Artea 30 57 30 61
2 CF Ardoi CF Ardoi 30 59 34 57
3 Burladés Burladés 30 57 33 55
4 Avance Ezcabarte Avance 30 63 44 51
5 Subiza Subiza 30 56 49 50
6 Infanzones Infanzones 30 48 48 43
7 Aurrera De Leitza Aurrera 30 41 43 43
8 Gazte Berriak Gazte 30 48 52 39
9 Lagunak Lagunak 30 41 56 39
10 Cantolagua Cantolagua 30 52 46 38
11 Mutilvera B Mutilvera B 30 48 47 38
12 Amaya Amaya 30 51 52 38
13 Cp San Cristóbal Cristóbal 30 48 50 37
14 JD San Jorge Jorge 30 46 62 32
15 Amigó Amigó 30 31 50 28
16 Baztan Baztan 30 28 78 17
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 CD Pamplona CD Pamplona 30 47 19 66
2 Cantolagua Cantolagua 30 53 32 59
3 JD San Jorge Jorge 30 63 36 58
4 Amigó Amigó 30 60 38 55
5 Burladés Burladés 30 41 34 45
6 Lagun Artea Lagun Artea 30 42 40 45
7 Cp San Cristóbal Cristóbal 30 50 33 44
8 Aurrera De Leitza Aurrera 30 35 41 40
9 Amaya Amaya 30 40 40 35
10 Gazte Berriak Gazte 30 36 42 35
11 Subiza Subiza 30 44 61 34
12 Avance Ezcabarte Avance 30 39 53 33
13 Baztan Baztan 30 41 58 33
14 Osasuna Magna Osasuna 30 44 58 32
15 San Ignacio San Ignacio 30 30 55 28
16 Gares Gares 30 28 53 24
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,476,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1974
Total Execution Time  0.1994
  CADENA URL  
/navarra2022/grupo1/historico
  GET DATOS  
$_GET['/navarra2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0034  SELECT type FROM routes WHERE alias = 'navarra2022'
0.0071  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'navarra' 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.0034  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=83 AND type_rel = 3
0.0037  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 83 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0042  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 (985318,329001,49188) ORDER BY n.cover_points DESC, update_date DESC
0.0034  SELECT id,name,alias,stepParent FROM categories WHERE parentId=83 ORDER BY order_id ASC
0.0036  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 = 63827 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 83 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0038  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 = 63827 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.0040  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 = 61240 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.0039  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 = 51280 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.0039  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 = 44767 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 = 39330 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 = 34178 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 = 16760 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 4093 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 2692 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 2079 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 1474 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 1192 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 946 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 = 297 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 09:03:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 09:03:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 09:03:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 09:03:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'navarra' 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.0092  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 = 63827 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63827 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.0143  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 = 63827 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63827 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0048  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 = 63827 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63827 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0047  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 = 63827 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