4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 19 40 3 51
2 Saint-Eloi Lupopo Saint-Eloi 20 33 9 49
3 AS Vita Club Vita Club 19 44 13 48
4 Maniema Union Maniema 18 28 10 38
5 Groupe Bazano Groupe 20 24 16 33
6 Don Bosco Lubumbashi Bosco 20 21 16 33
7 Motema Pembe Motema Pembe 19 23 15 29
8 Rangers Rangers 19 18 19 28
9 Panda 05 Panda 05 19 17 19 24
10 Sanga Balende Sanga 21 18 26 23
11 Etoile de Kivu Etoile Kivu 19 13 15 22
12 Lubumbashi Sport Lubumbashi 19 19 23 22
13 Dauphins Noirs Dauphins 19 15 20 20
14 Blessing Blessing 19 13 16 19
15 Kuya Sport Kuya Sport 19 18 28 19
16 Renaissance Renaissance 19 17 27 18
17 Tshinkunku Tshinkunku 19 11 26 15
18 Simba Simba 19 10 29 14
19 JSK JSK 19 6 36 8
20 RCK RCK 19 10 32 7
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 29 54 14 66
2 Maniema Union Maniema 29 43 16 66
3 AS Vita Club Vita Club 29 45 15 61
4 Saint-Eloi Lupopo Saint-Eloi 30 31 19 52
5 Sanga Balende Sanga 30 30 24 50
6 Motema Pembe Motema Pembe 30 31 24 46
7 Blessing Blessing 30 25 27 39
8 Rangers Rangers 29 23 41 34
9 Don Bosco Lubumbashi Bosco 30 28 32 33
10 Dauphins Noirs Dauphins 30 28 34 32
11 Renaissance Renaissance 30 27 42 31
12 Simba Simba 30 29 45 31
13 JSK JSK 29 22 27 29
14 Groupe Bazano Groupe 29 19 28 26
15 RCK RCK 30 25 45 24
16 Lubumbashi Sport Lubumbashi 28 18 45 19
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 20 48 9 53
2 AS Vita Club Vita Club 23 40 12 48
3 Maniema Union Maniema 20 41 15 43
4 Motema Pembe Motema Pembe 20 37 16 39
5 Renaissance Renaissance 23 32 26 37
6 Groupe Bazano Groupe 19 21 11 37
7 Rangers Rangers 25 27 28 29
8 Don Bosco Lubumbashi Bosco 23 26 23 28
9 RCK RCK 23 25 22 28
10 Lubumbashi Sport Lubumbashi 23 18 20 27
11 Saint-Eloi Lupopo Saint-Eloi 22 24 25 24
12 Simba Simba 22 15 31 22
13 Sanga Balende Sanga 19 17 35 17
14 Dauphins Noirs Dauphins 22 12 35 15
15 Bukavu Bukavu 22 15 48 14
16 Nyuki De Butembo Nyuki 22 15 57 12
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 30 82 11 83
2 AS Vita Club Vita Club 30 60 15 74
3 Motema Pembe Motema Pembe 30 47 25 63
4 Maniema Union Maniema 28 40 20 56
5 Sanga Balende Sanga 30 36 30 42
6 Nyuki De Butembo Nyuki 31 31 32 41
7 Saint-Eloi Lupopo Saint-Eloi 29 25 25 40
8 Dauphins Noirs Dauphins 30 30 40 40
9 Rangers Rangers 28 30 30 36
10 Don Bosco Lubumbashi Bosco 29 34 36 35
11 Renaissance Renaissance 28 25 37 35
12 Groupe Bazano Groupe 30 25 30 34
13 Lubumbashi Sport Lubumbashi 30 35 42 32
14 Mont Bleu Mont Bleu 28 22 44 24
15 Dragons Dragons 29 12 50 14
16 Muungano Muungano 30 7 74 4
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Renaissance Renaissance 7 8 4 15
2 AS Vita Club Vita Club 6 8 2 12
3 Motema Pembe Motema Pembe 5 7 3 11
4 RCK RCK 6 6 6 7
5 Dragons Dragons 5 5 6 6
6 FC MK FC MK 4 6 6 4
7 Nord Sport Nord Sport 4 3 5 4
8 Rangers Rangers 5 5 9 4
9 Molunge Molunge 4 0 7 1
10 Shark XI Shark XI 0 0 0 0
11 Mont Bleu Mont Bleu 6 10 8 11
12 Maniema Union Maniema 4 6 2 8
13 Virunga Virunga 5 7 4 8
14 Bukavu Bukavu 6 3 4 8
15 Dauphins Noirs Dauphins 4 5 3 7
16 Muungano Muungano 6 3 7 4
17 CS Makiso CS Makiso 3 3 5 3
18 Etoile de Kivu Etoile Kivu 4 3 7 3
19 TP Mazembe TP Mazembe 9 20 3 21
20 Saint-Eloi Lupopo Saint-Eloi 7 10 5 14
21 Sanga Balende Sanga 7 9 7 10
22 Dibumba Dibumba 8 6 8 8
23 Ecofoot Katumbi Ecofoot 6 4 6 8
24 Don Bosco Lubumbashi Bosco 5 3 3 6
25 Tshinkunku Tshinkunku 6 5 8 6
26 Groupe Bazano Groupe 4 2 4 4
27 Lubumbashi Sport Lubumbashi 5 3 6 4
28 Ocean Pacifique Ocean 7 3 15 2
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 18 36 5 42
2 Sanga Balende Sanga 18 31 8 42
3 Don Bosco Lubumbashi Bosco 18 27 13 37
4 Saint-Eloi Lupopo Saint-Eloi 18 18 18 25
5 Groupe Bazano Groupe 18 13 19 22
6 Lubumbashi Sport Lubumbashi 18 13 19 21
7 Simba Simba 18 17 22 19
8 Ocean Pacifique Ocean 18 16 27 19
9 Dibumba Dibumba 18 13 27 17
10 New Soger New Soger 18 8 34 5
11 Dauphins Noirs Dauphins 14 19 9 29
12 Bukavu Bukavu 12 16 7 26
13 Muungano Muungano 10 12 3 20
14 Virunga Virunga 11 8 15 10
15 Nkoyi Bilombe Nkoyi 10 9 14 7
16 CS Makiso CS Makiso 10 8 17 6
17 Nika Nika 0 0 0 0
18 Capaco Capaco 3 1 8 0
19 AS Vita Club Vita Club 18 37 9 43
20 Motema Pembe Motema Pembe 17 34 8 38
21 Renaissance Renaissance 21 30 17 34
22 RCK RCK 17 27 22 29
23 Dragons Dragons 18 16 20 26
24 Shark XI Shark XI 18 24 17 25
25 FC MK FC MK 18 18 23 21
26 Veti Club Veti Club 17 11 23 18
27 Rojolu Rojolu 17 11 26 9
28 Ndombe Ndombe 17 12 55 4
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 AS Vita Club Vita Club 18 38 6 45
2 TP Mazembe TP Mazembe 18 44 7 42
3 Sanga Balende Sanga 18 23 6 41
4 Motema Pembe Motema Pembe 18 30 12 38
5 Shark XI Shark XI 18 24 11 38
6 Saint-Eloi Lupopo Saint-Eloi 18 29 9 34
7 Don Bosco Lubumbashi Bosco 18 26 14 27
8 Muungano Muungano 14 22 12 26
9 Dauphins Noirs Dauphins 14 16 10 24
10 Mk Etanchéité Etanchéité 18 18 19 23
11 RCK RCK 18 11 15 22
12 Nkoyi Bilombe Nkoyi 13 12 9 21
13 Capaco Capaco 12 14 8 20
14 Lubumbashi Sport Lubumbashi 17 15 21 20
15 Groupe Bazano Groupe 17 15 20 18
16 Dragons Dragons 16 17 23 17
17 Rojolu Rojolu 17 17 26 16
18 Nord Sport Nord Sport 17 15 28 16
19 New Soger New Soger 17 8 23 16
20 Nika Nika 12 10 14 15
21 Ocean Pacifique Ocean 18 14 33 15
22 Tshinkunku Tshinkunku 17 6 27 15
23 CS Makiso CS Makiso 11 10 16 13
24 Elima Elima 15 10 22 12
25 El Dorado El Dorado 13 10 14 11
26 Bantous Bantous 16 6 26 7
27 Socozaki Socozaki 13 10 21 6
28 Vutuka Vutuka 15 6 24 5
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 9 19 5 20
2 Sanga Balende Sanga 9 9 4 19
3 Lubumbashi Sport Lubumbashi 9 17 8 17
4 Saint-Eloi Lupopo Saint-Eloi 9 11 3 16
5 Don Bosco Lubumbashi Bosco 9 13 4 14
6 Muungano Muungano 9 6 5 11
7 Bantous Bantous 9 7 15 11
8 Tshinkunku Tshinkunku 9 5 10 8
9 Dauphins Noirs Dauphins 9 6 14 8
10 Capaco Capaco 9 1 26 0
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 14 31 3 31
2 Don Bosco Lubumbashi Bosco 14 30 10 31
3 Saint-Eloi Lupopo Saint-Eloi 14 22 8 29
4 Mk Etanchéité Etanchéité 14 15 21 18
5 Dauphins Noirs Dauphins 14 12 19 15
6 Nika Nika 14 13 23 14
7 Elima Elima 14 8 27 11
8 CS Makiso CS Makiso 14 3 23 6
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 13 38 4 35
2 AS Vita Club Vita Club 13 28 5 32
3 Motema Pembe Motema Pembe 13 20 7 24
4 Don Bosco Don Bosco 13 25 14 24
5 Sanga Balende Sanga 13 18 11 24
6 Saint-Eloi Lupopo Saint-Eloi 13 17 10 24
7 Tshinkunku Tshinkunku 13 13 23 16
8 Dauphins Noirs Dauphins 13 16 17 15
9 Rojolu Rojolu 13 12 22 15
10 Muungano Muungano 13 11 13 12
11 CS Makiso CS Makiso 13 7 19 12
12 Molunge Molunge 13 14 28 9
13 Virunga Virunga 13 11 26 8
14 Elima Elima 13 1 32 0
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 23 65 6 64
2 AS Vita Club Vita Club 23 56 12 62
3 Motema Pembe Motema Pembe 23 42 6 55
4 Sanga Balende Sanga 23 33 17 39
5 Molunge Molunge 23 23 25 34
6 Elima Elima 23 25 28 33
7 Muungano Muungano 23 26 26 32
8 Saint-Eloi Lupopo Saint-Eloi 23 20 15 31
9 Virunga Virunga 23 22 35 25
10 Tshinkunku Tshinkunku 23 14 39 20
11 CS Makiso CS Makiso 23 16 36 18
12 Vutuka Vutuka 23 9 42 16
13 Saint Luc Saint Luc 23 17 40 14
14 Nkoy De Kindu Nkoy Kindu 23 10 51 12
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 RCK RCK 6 12 2 15
2 Veti Club Veti Club 6 7 2 13
3 Lupopo Kikwit Lupopo 6 7 7 7
4 Molunge Molunge 6 0 15 0
5 Nyuki De Butembo Nyuki 6 9 3 11
6 Bukavu Bukavu 6 8 4 10
7 Malekesa Malekesa 6 7 5 10
8 Nkoy De Kindu Nkoy Kindu 6 3 15 3
9 Don Bosco Lubumbashi Bosco 6 7 4 11
10 Bantous Bantous 6 9 4 9
11 Shark XI Shark XI 6 8 4 9
12 Tshinkunku Tshinkunku 6 3 15 3
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Malekesa Malekesa 4 5 2 9
2 Virunga Virunga 4 3 3 7
3 Muungano Muungano 4 2 5 1
4 AS Vita Club Vita Club 6 24 0 16
5 Veti Club Veti Club 6 12 5 13
6 Molunge Molunge 6 5 13 6
7 Matiti Mabe Matiti Mabe 6 1 24 0
8 Nika Nika 6 20 5 18
9 FC Ajax FC Ajax 5 9 7 7
10 AS Kabasha AS Kabasha 6 15 13 6
11 Ndjadi Ndjadi 5 3 22 1
12 Saint-Eloi Lupopo Saint-Eloi 4 13 0 12
13 Likasi Likasi 4 4 5 4
14 Bantous Bantous 4 2 14 1
15 Elima Elima 6 11 2 18
16 Motema Pembe Motema Pembe 6 13 6 12
17 Vutuka Vutuka 6 7 11 6
18 Babeti AS Babeti AS 6 3 15 0
19 Sanga Balende Sanga 6 7 3 13
20 New Soger New Soger 6 4 3 8
21 Olympic Kinshasa Olympic 6 4 5 8
22 Tshinkunku Tshinkunku 6 2 6 4

JUGADORES DESTACADOS


  USO DE MEMORIA  
6,839,648 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1102
Total Execution Time  0.1123
  CADENA URL  
/super_liga_republica_congo2022/grupo1/historico
  GET DATOS  
$_GET['/super_liga_republica_congo2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0019  SELECT type FROM routes WHERE alias = 'super_liga_republica_congo2022'
0.0043  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'super_liga_republica_congo' 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.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1420 AND type_rel = 3
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1420 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0026  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 (1285662,892035,572818,186234,155657) ORDER BY n.cover_points DESC, update_date DESC
0.0021  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1420 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 = 64302 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1420 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 64302 AND t.round = 19 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 = 60011 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.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 `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 = 51154 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.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 `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 = 46941 AND t.round = 30 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 `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 = 42099 AND t.round = 8 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 `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 = 36097 AND t.round = 18 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 `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 = 22959 AND t.round = 18 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 = 9494 AND t.round = 9 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 `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 = 9490 AND t.round = 14 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 `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 = 3250 AND t.round = 14 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 `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 = 16169 AND t.round = 26 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 = 16170 AND t.round = 6 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 = 16172 AND t.round = 5 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 05:33:36' 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 05:33:36' 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 05:33:36' 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 05:33:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'super_liga_republica_congo' 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.0025  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 = 64302 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64302 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 events2022 e ON e.player_id = p.id AND e.league_id = 64302 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64302 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 = 64302 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64302 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0048  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 = 64302 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC