4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Mouloudia Oujda Mouloudia 30 48 27 60
2 Youssoufia Berrechid Youssoufia 30 43 21 56
3 Raja Beni Mellal Raja Beni M. 30 38 23 56
4 Chabab Benguerir Chabab 30 32 26 47
5 Olympique Dcheïra Olympique 30 27 28 42
6 Wydad Fès Wydad Fès 30 26 22 41
7 Maghreb Fes Maghreb Fes 30 38 29 40
8 JSM Laayoune Laayoune 30 29 31 39
9 Sidi Kacem Sidi Kacem 30 27 33 34
10 AS Salé AS Salé 30 33 32 33
11 KAC Kenitra KAC Kenitra 30 19 29 32
12 Ittihad Khemisset Ittihad 30 29 36 31
13 Widad Temara Widad Temara 30 23 32 31
14 Kasba Tadla Kasba Tadla 30 23 38 29
15 Rachad Bernoussi Rachad 30 24 38 27
16 USM Oujda USM Oujda 30 23 37 24
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Racing de Casablanca Racing 26 33 27 43
2 Rapide Oued Zem Rapide Oued 26 29 22 40
3 Mouloudia Oujda Mouloudia 26 29 22 38
4 JSM Laayoune Laayoune 26 24 21 38
5 AS Salé AS Salé 26 34 36 37
6 Maghreb Fes Maghreb Fes 26 34 26 37
7 Youssoufia Berrechid Youssoufia 26 26 25 36
8 Ittihad Khemisset Ittihad 26 27 25 35
9 Raja Beni Mellal Raja Beni M. 26 20 25 33
10 Widad Temara Widad Temara 26 19 20 32
11 USM Ait Melloul Melloul 26 20 21 30
12 Olympique Dcheïra Olympique 26 26 29 30
13 Sidi Kacem Sidi Kacem 26 20 26 30
14 Rachad Bernoussi Rachad 26 29 34 28
15 Wydad Fès Wydad Fès 26 28 34 27
16 US Temara US Temara 26 22 27 27
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Chabab Atlas Khenifra Chabab Atlas 30 30 21 49
2 Kasba Tadla Kasba Tadla 30 24 20 49
3 AS Salé AS Salé 30 32 29 42
4 Rachad Bernoussi Rachad 30 31 27 41
5 US Temara US Temara 30 31 29 41
6 Youssoufia Berrechid Youssoufia 30 27 25 41
7 Racing de Casablanca Racing 30 37 38 41
8 Olympique Dcheïra Olympique 30 20 21 39
9 Raja Beni Mellal Raja Beni M. 30 24 29 39
10 JSM Laayoune Laayoune 30 35 32 38
11 Ittihad Khemisset Ittihad 30 23 22 38
12 Widad Temara Widad Temara 30 26 22 37
13 USM Ait Melloul Melloul 30 29 28 37
14 Wydad Fès Wydad Fès 30 28 32 37
15 Olympique Marrakech Olympique 30 24 28 37
16 CODM Meknes CODM Meknes 30 24 42 31
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Ittihad Tanger Ittihad 30 22 11 54
2 Mouloudia Oujda Mouloudia 30 32 22 49
3 USM Ait Melloul Melloul 30 39 24 48
4 Kasba Tadla Kasba Tadla 30 29 22 48
5 Youssoufia Berrechid Youssoufia 30 34 25 46
6 Raja Beni Mellal Raja Beni M. 30 21 16 39
7 JSM Laayoune Laayoune 30 24 24 37
8 AS Salé AS Salé 30 23 26 37
9 US Temara US Temara 30 33 37 36
10 CODM Meknes CODM Meknes 30 28 29 35
11 Widad Temara Widad Temara 30 23 26 35
12 Racing de Casablanca Racing 30 27 35 35
13 Olympique Dcheïra Olympique 30 24 32 33
14 Wydad Fès Wydad Fès 30 19 28 33
15 Chabab Houara Chabab 30 23 31 31
16 Union Mohammedia Union 30 22 35 28
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Ittihad Khemisset Ittihad 30 34 13 57
2 Chabab Atlas Khenifra Chabab Atlas 30 36 13 53
3 Ittihad Tanger Ittihad 30 33 21 48
4 CODM Meknes CODM Meknes 30 34 31 46
5 Tihad Temara Tihad Temara 30 26 25 44
6 Raja Beni Mellal Raja Beni M. 30 38 33 41
7 Union Mohammedia Union 30 23 27 39
8 Kasba Tadla Kasba Tadla 30 31 29 36
9 Youssoufia Berrechid Youssoufia 30 24 28 36
10 Mouloudia Oujda Mouloudia 30 25 30 35
11 Chabab Houara Chabab 30 30 37 35
12 JSM Laayoune Laayoune 30 23 34 35
13 Racing de Casablanca Racing 30 25 28 34
14 USM Ait Melloul Melloul 30 23 33 30
15 Rachad Bernoussi Rachad 30 21 31 29
16 USM Oujda USM Oujda 30 23 36 28
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Kawkab Marrakech Kawkab 30 44 12 65
2 AS Salé AS Salé 30 30 13 57
3 Ittihad Khemisset Ittihad 30 25 26 50
4 Mouloudia Oujda Mouloudia 30 30 20 49
5 Rachad Bernoussi Rachad 30 27 22 45
6 USM Ait Melloul Melloul 30 26 25 44
7 Youssoufia Berrechid Youssoufia 30 34 38 39
8 USM Oujda USM Oujda 30 29 32 36
9 Union Mohammedia Union 30 27 28 35
10 Kasba Tadla Kasba Tadla 30 19 22 35
11 Racing de Casablanca Racing 30 26 33 35
12 JSM Laayoune Laayoune 30 26 32 34
13 Ittihad Tanger Ittihad 30 28 35 33
14 US Temara US Temara 30 23 31 32
15 TAS Casablanca Casablanca 30 17 27 32
16 Olympique Marrakech Olympique 30 25 40 22
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Raja Beni Mellal Raja Beni M. 30 25 15 48
2 RSB Berkane RSB Berkane 30 29 27 47
3 TAS Casablanca Casablanca 30 32 27 46
4 Union Mohammedia Union 30 38 27 43
5 Kawkab Marrakech Kawkab 30 29 19 42
6 AS Salé AS Salé 30 32 24 41
7 USM Ait Melloul Melloul 30 37 40 40
8 Racing de Casablanca Racing 30 27 24 39
9 Youssoufia Berrechid Youssoufia 30 33 34 39
10 Mouloudia Oujda Mouloudia 30 26 31 39
11 Kasba Tadla Kasba Tadla 30 22 27 35
12 Ittihad Tanger Ittihad 30 21 26 34
13 Rachad Bernoussi Rachad 30 26 33 33
14 US Temara US Temara 30 15 20 32
15 Chabab Houara Chabab 30 22 32 31
16 Stade Marocain Stade 30 26 34 29
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 CODM Meknes CODM Meknes 34 35 10 64
2 Ittihad Khemisset Ittihad 34 43 29 61
3 USM Ait Melloul Melloul 34 42 24 61
4 Youssoufia Berrechid Youssoufia 34 33 20 59
5 TAS Casablanca Casablanca 34 26 25 50
6 Mouloudia Oujda Mouloudia 34 29 29 47
7 Union Mohammedia Union 34 28 28 46
8 Chabab Houara Chabab 34 28 29 46
9 Rachad Bernoussi Rachad 34 27 29 43
10 Racing de Casablanca Racing 34 38 36 42
11 Ittihad Tanger Ittihad 34 28 33 40
12 AS Salé AS Salé 34 38 39 39
13 US Temara US Temara 34 25 26 39
14 Stade Marocain Stade 34 18 24 39
15 Raja Al Hoceima Raja Hoceima 34 18 29 35
16 Fkih Ben Salah Fkih Salah 34 27 39 35
17 SCCM Mohamedia SCCM 34 25 33 33
18 Hilal Nador Hilal Nador 34 18 44 25
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Kasba Tadla Kasba Tadla 36 34 23 65
2 Chabab Rif Hoceima Chabab 36 32 23 61
3 Union Mohammedia Union 36 38 25 58
4 CODM Meknes CODM Meknes 36 38 26 58
5 US Temara US Temara 36 39 35 56
6 Chabab Houara Chabab 36 38 28 53
7 Stade Marocain Stade 36 36 33 52
8 Racing de Casablanca Racing 36 36 36 52
9 Raja Al Hoceima Raja Hoceima 36 37 36 48
10 Youssoufia Berrechid Youssoufia 36 39 35 43
11 Mouloudia Oujda Mouloudia 36 30 34 43
12 TAS Casablanca Casablanca 36 28 28 42
13 Ittihad Tanger Ittihad 36 28 33 42
14 Rachad Bernoussi Rachad 36 26 37 42
15 Fkih Ben Salah Fkih Salah 36 29 36 41
16 SCCM Mohamedia SCCM 36 26 37 41
17 Chabab Atlas Khenifra Chabab Atlas 36 31 46 40
18 Settat Settat 36 29 40 38
19 Sidi Kacem Sidi Kacem 36 33 36 36
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 FUS Rabat FUS Rabat 34 43 13 66
2 Wydad Fès Wydad Fès 34 39 22 61
3 Stade Marocain Stade 34 34 28 60
4 Chabab Rif Hoceima Chabab 34 37 30 51
5 Chabab Houara Chabab 34 42 31 50
6 Racing de Casablanca Racing 34 37 36 50
7 Union Mohammedia Union 34 32 27 47
8 CODM Meknes CODM Meknes 34 31 30 44
9 Ittihad Tanger Ittihad 34 27 26 44
10 Fkih Ben Salah Fkih Salah 34 34 34 44
11 Youssoufia Berrechid Youssoufia 34 31 32 43
12 Sidi Kacem Sidi Kacem 34 25 39 38
13 US Temara US Temara 34 23 35 36
14 TAS Casablanca Casablanca 34 19 23 35
15 Settat Settat 34 27 40 35
16 Rachad Bernoussi Rachad 34 31 34 34
17 Olympique Marrakech Olympique 34 24 36 34
18 CWW Casablanca Casablanca 34 26 46 26
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 AS Salé AS Salé 29 40 17 51
2 SCCM Mohamedia SCCM 28 31 21 45
3 US Temara US Temara 29 26 19 44
4 Ittihad Tanger Ittihad 29 17 15 42
5 Sidi Kacem Sidi Kacem 29 28 19 39
6 Chabab Houara Chabab 28 37 34 39
7 TAS Casablanca Casablanca 29 24 22 38
8 CWW Casablanca Casablanca 29 29 27 37
9 Union Mohammedia Union 29 20 22 37
10 Chabab Rif Hoceima Chabab 29 20 19 36
11 Settat Settat 28 20 19 35
12 Racing de Casablanca Racing 29 18 23 34
13 Rachad Bernoussi Rachad 28 30 30 33
14 Youssoufia Berrechid Youssoufia 29 22 22 32
15 UTS Rabat UTS Rabat 29 25 36 28
16 Hilal Nador Hilal Nador 29 15 57 19
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 FUS Rabat FUS Rabat 30 32 14 55
2 KAC Kenitra KAC Kenitra 30 37 21 53
3 Chabab Houara Chabab 30 26 18 47
4 UTS Rabat UTS Rabat 30 27 21 43
5 Sidi Kacem Sidi Kacem 30 27 27 42
6 Rachad Bernoussi Rachad 30 22 14 41
7 SCCM Mohamedia SCCM 30 20 24 39
8 US Temara US Temara 30 30 27 37
9 Racing de Casablanca Racing 30 27 27 37
10 Youssoufia Berrechid Youssoufia 30 18 21 36
11 Union Mohammedia Union 30 23 28 36
12 Settat Settat 30 25 30 35
13 CWW Casablanca Casablanca 30 26 38 33
14 Hilal Nador Hilal Nador 30 19 29 32
15 Stade Marocain Stade 30 19 28 31
16 RSB Berkane RSB Berkane 30 22 33 28

JUGADORES DESTACADOS

Nombre Goles Equipo
K. Boua D. M. ci K. Boua D. M. 2 MAG Maghreb Fes
Bah ma Bah 2 MAG Maghreb Fes

  USO DE MEMORIA  
6,421,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1065
Total Execution Time  0.1084
  CADENA URL  
/elite_2_marruecos2018/grupo1/historico
  GET DATOS  
$_GET['/elite_2_marruecos2018/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0018  SELECT type FROM routes WHERE alias = 'elite_2_marruecos2018'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'elite_2_marruecos' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 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=409 AND type_rel = 3
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 409 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (975843,911464,803650,73999) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=409 ORDER BY order_id ASC
0.0019  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 409 GROUP BY l.categoryId
0.0019  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=409 GROUP BY l.year ORDER BY l.year DESC
0.0019  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 = 38717 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 409 AND group_code = 1 and tables = 1 AND year <= 2018 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 `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 = 38717 AND t.round = 30 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 `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 = 34135 AND t.round = 26 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 `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 = 15522 AND t.round = 30 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 = 4197 AND t.round = 30 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 = 2934 AND t.round = 30 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 = 8703 AND t.round = 30 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 `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 = 8702 AND t.round = 30 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 = 8700 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 `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 = 8697 AND t.round = 38 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 = 8693 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 `tables2008` 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 = 8691 AND t.round = 29 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 `tables2007` 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 = 8687 AND t.round = 30 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-05-08 11:58:05' 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-05-08 11:58:05' 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-05-08 11:58:05' 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-05-08 11:58:05' 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 = 'elite_2_marruecos' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0022  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 events2018 e ON e.player_id = p.id AND e.league_id = 38717 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 38717 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.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 events2018 e ON e.player_id = p.id AND e.league_id = 38717 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 38717 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 events2018 e ON e.player_id = p.id AND e.league_id = 38717 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 38717 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0044  SELECT *,(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 = 38717 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC