4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 USM Alger USM Alger 6 8 3 13
2 Future FC Future FC 6 9 3 11
3 Al Hilal Al Hilal 6 6 13 6
4 SuperSport United SuperSport 6 5 9 4
5 Zamalek Zamalek 6 11 1 16
6 Abu Salim Abu Salim 6 5 6 9
7 Sagrada Esperança Sagrada 6 5 2 8
8 CO Coyah CO Coyah 6 0 12 1
9 Dreams FC Dreams FC 6 11 7 12
10 Rivers United Rivers 6 10 8 12
11 Club Africain Club 6 9 4 10
12 Academica do Lobito Academica 6 6 17 1
13 RSB Berkane RSB Berkane 6 10 2 14
14 Stade Malien Stade Malien 6 6 6 10
15 Sekhukhune United FC Sekhukhune 6 2 4 6
16 Diables Noirs Diables 6 3 9 2
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Marumo Gallants FC Marumo 6 12 10 12
2 USM Alger USM Alger 6 11 5 11
3 Al-Akhdar Al-Akhdar 6 8 12 5
4 Saint-Eloi Lupopo Saint-Eloi 6 6 10 5
5 ASEC Mimosas ASEC Mimosas 6 6 4 13
6 Rivers United Rivers 6 9 7 10
7 Diables Noirs Diables 6 5 5 6
8 Motema Pembe Motema Pembe 6 2 6 3
9 FAR Rabat FAR Rabat 6 11 6 11
10 Pyramids Pyramids 6 10 6 11
11 Future FC Future FC 6 8 6 8
12 ASKO de Kara ASKO Kara 6 4 15 2
13 Young Africans Young 6 9 4 13
14 Monastir Monastir 6 8 4 13
15 Real Bamako Real Bamako 6 6 10 5
16 TP Mazembe TP Mazembe 6 5 10 3
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Al Ahli Tripoli Ahli Tripoli 6 9 5 13
2 Pyramids Pyramids 6 7 3 13
3 CS Sfaxien CS Sfaxien 6 3 5 5
4 Zanaco Zanaco 6 3 9 3
5 Orlando Pirates Orlando 6 15 5 13
6 Al-Ittihad Al-Ittihad 6 9 7 11
7 JS Saoura JS Saoura 6 6 5 10
8 Royal Leopards Royal 6 5 18 0
9 TP Mazembe TP Mazembe 6 8 6 11
10 Al-Masry Al-Masry 6 5 3 10
11 Otôho d'Oyo Otôho d'Oyo 6 5 5 8
12 Cotonsport Cotonsport 6 3 7 3
13 RSB Berkane RSB Berkane 6 11 9 10
14 Simba SC Simba SC 6 9 7 10
15 ASEC Mimosas ASEC Mimosas 6 9 8 9
16 USGN USGN 6 9 14 5
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Orlando Pirates Orlando 6 5 2 9
2 Enyimba Enyimba 6 6 8 9
3 ES Setif ES Setif 6 5 3 8
4 Al Ahly Benghazi Ahly 6 3 6 7
5 JS Kabylie JS Kabylie 6 7 4 12
6 Cotonsport Cotonsport 6 10 6 9
7 RSB Berkane RSB Berkane 6 4 4 8
8 NAPSA Stars FC NAPSA Stars 6 5 12 4
9 Jaraaf Jaraaf 6 5 3 11
10 CS Sfaxien CS Sfaxien 6 6 3 10
11 Etoile Sahel Etoile Sahel 6 6 5 8
12 Salitas Salitas 6 2 8 3
13 Raja Casablanca Raja 6 13 0 18
14 Pyramids Pyramids 6 7 5 12
15 Nkana FC Nkana FC 6 2 8 6
16 Namungo Namungo 6 0 9 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Pyramids Pyramids 6 14 3 15
2 Al-Masry Al-Masry 6 10 9 10
3 Enugu Rangers Enugu 6 6 9 6
4 Nouadhibou Nouadhibou 6 3 12 2
5 RSB Berkane RSB Berkane 6 13 4 11
6 Zanaco Zanaco 6 8 4 10
7 Motema Pembe Motema Pembe 6 6 6 10
8 ESAE ESAE 6 1 14 1
9 Horoya AC Horoya AC 6 8 1 14
10 Djoliba AC Djoliba AC 6 4 3 8
11 Al Nasr Benghazi Nasr 6 4 7 8
12 Bidvest Wits Bidvest Wits 6 2 7 2
13 Hassania Agadir Hassania 6 9 5 11
14 Enyimba Enyimba 6 11 7 10
15 Paradou Paradou 6 5 6 8
16 San-Pédro San-Pédro 6 3 10 3
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 RSB Berkane RSB Berkane 6 10 5 11
2 Hassania Agadir Hassania 6 5 5 8
3 Raja Casablanca Raja 6 7 6 7
4 Otôho d'Oyo Otôho d'Oyo 6 4 10 5
5 CS Sfaxien CS Sfaxien 6 5 2 12
6 Etoile Sahel Etoile Sahel 6 6 4 10
7 Enugu Rangers Enugu 6 5 7 5
8 Salitas Salitas 6 1 4 4
9 Al-Hilal Omdurman Al-Hilal 6 11 6 11
10 Nkana FC Nkana FC 6 9 11 9
11 Asante Kotoko Asante 6 8 8 7
12 Zesco United Zesco United 6 7 10 7
13 Zamalek Zamalek 6 9 6 9
14 Gor Mahia Gor Mahia 6 8 9 9
15 NA Hussein Dey Hussein 6 4 6 8
16 Petro de Luanda Petro Luanda 6 6 6 7
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Raja Casablanca Raja 6 14 5 11
2 AS Vita Club Vita Club 6 8 5 10
3 ASEC Mimosas ASEC Mimosas 6 6 8 9
4 Aduana Stars Aduana Stars 6 5 15 4
5 RSB Berkane RSB Berkane 6 7 2 13
6 Al-Masry Al-Masry 6 7 2 12
7 UDS Songo UDS Songo 6 5 10 3
8 Al-Hilal Omdurman Al-Hilal 6 4 9 3
9 Enyimba Enyimba 6 5 5 12
10 CARA Brazzaville CARA 6 7 5 9
11 WAC WAC 6 5 5 8
12 Djoliba AC Djoliba AC 6 3 5 5
13 USM Alger USM Alger 6 10 5 11
14 Rayon Sport Rayon Sport 6 6 5 9
15 Gor Mahia Gor Mahia 6 10 7 8
16 Young Africans Young 6 4 13 4
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Club Africain Club 6 13 6 12
2 FUS Rabat FUS Rabat 6 9 8 9
3 KCCA FC KCCA FC 6 8 12 9
4 Rivers United Rivers 6 6 10 6
5 CS Sfaxien CS Sfaxien 6 13 4 13
6 MC Alger MC Alger 6 7 7 11
7 Mbabane Swallows Mbabane 6 8 10 5
8 Platinum Stars Platinum 6 6 13 3
9 Hilal Obayed Hilal Obayed 5 6 3 10
10 Recreativo do Libolo Recreativo 6 4 5 7
11 Zesco United Zesco United 5 3 5 7
12 Smouha SC Smouha SC 6 5 5 6
13 TP Mazembe TP Mazembe 6 8 4 12
14 SuperSport United SuperSport 6 13 8 10
15 Horoya AC Horoya AC 6 6 5 9
16 CF Mounana CF Mounana 6 4 14 0
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 6 10 5 13
2 Medeama Medeama 6 8 8 8
3 MO Béjaïa MO Béjaïa 6 2 2 8
4 Young Africans Young 6 4 9 4
5 FUS Rabat FUS Rabat 6 9 4 12
6 Etoile Sahel Etoile Sahel 6 9 4 11
7 Kawkab Marrakech Kawkab 6 9 13 7
8 Al Ahli Tripoli Ahli Tripoli 6 4 10 2
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 6 6 1 13
2 Etoile Sahel Etoile Sahel 6 6 3 13
3 Stade Malien Stade Malien 6 3 5 5
4 ES Tunis ES Tunis 6 3 9 3
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 CS Sfaxien CS Sfaxien 6 8 3 14
2 Stade Malien Stade Malien 6 3 4 8
3 Etoile Sahel Etoile Sahel 6 3 4 6
4 Kedus St George Kedus George 6 4 7 4
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Al-Merreikh SC Al-Merreikh 6 8 3 14
2 Al-Hilal Omdurman Al-Hilal 6 11 6 11
3 Interclube Interclube 6 3 7 5
4 Al Ahly Shendi Ahly Shendi 6 3 9 3
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Club Africain Club 6 6 3 11
2 Interclube Interclube 6 8 6 10
3 ASEC Mimosas ASEC Mimosas 6 5 6 7
4 Kaduna United FC Kaduna 6 5 9 5
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Al-Hilal Omdurman Al-Hilal 6 10 6 13
2 Al-Ittihad Al-Ittihad 6 11 5 12
3 Djoliba AC Djoliba AC 6 4 5 7
4 ASFAN ASFAN 6 3 12 2
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 ES Setif ES Setif 6 14 9 9
2 ENPPI ENPPI 6 13 10 9
3 AS Vita Club Vita Club 6 7 7 9
4 Engen Santos Engen Santos 6 3 11 9
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 CS Sfaxien CS Sfaxien 6 11 6 13
2 Haras El-Hodood Haras 6 10 6 10
3 Club Africain Club 6 7 6 8
4 Interclube Interclube 6 6 16 3
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 CS Sfaxien CS Sfaxien 6 13 4 13
2 TP Mazembe TP Mazembe 6 11 9 12
3 Mamelodi Sundowns Mamelodi 6 7 13 6
4 Les Astres Les Astres 6 5 10 4
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 FAR Rabat FAR Rabat 6 9 5 13
2 Olympique Khouribga Olympique 6 6 4 10
3 Petro Atletico Petro 6 10 7 8
4 Interclube Interclube 6 3 12 3
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 FAR Rabat FAR Rabat 6 7 2 16
2 King Faisal King Faisal 6 8 5 12
3 Marsa Marsa 6 6 6 7
4 Fello Star Fello Star 6 2 10 0
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Enugu Rangers Enugu 6 12 6 10
2 Asante Kotoko Asante 6 10 7 10
3 Al-Hilal Omdurman Al-Hilal 6 6 11 9
4 Petro Atletico Petro 6 5 9 5

  USO DE MEMORIA  
6,196,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.1463
Total Execution Time  0.1490
  CADENA URL  
/caf_confederation_cup2024/grupo1/historico
  GET DATOS  
$_GET['/caf_confederation_cup2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0019  SELECT type FROM routes WHERE alias = 'caf_confederation_cup2024'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'caf_confederation_cup' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0020  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 = 74279 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 850 AND group_code = 1 and tables = 1 AND year <= 2024 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 `tables2024` 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 = 74279 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables2023` 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 = 70741 AND t.round = 6 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 `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 = 66254 AND t.round = 6 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 = 61487 AND t.round = 6 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 `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 = 51789 AND t.round = 6 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 `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 = 48727 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 `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 = 43319 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 38345 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 29521 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 15080 AND t.round = 6 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 `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 = 27282 AND t.round = 6 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 = 27379 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 27384 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 27388 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 27393 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 `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 = 27398 AND t.round = 6 ORDER BY team.conference 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 `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 = 27402 AND t.round = 6 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 `tables2006` 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 = 27409 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 `tables2005` 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 = 27413 AND t.round = 6 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 `tables2004` 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 = 27419 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 09:10:55' 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-28 09:10:55' 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-28 09:10:55' 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-28 09:10:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'caf_confederation_cup' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0023  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 850 AND l.year = 2024
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74279,75624) 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, e.player_id ASC LIMIT 10
0.0025  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (74279,75624) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (275540,297502,844167,1015933,3313541,288448,480373,481650,3373859,3444988) ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 850 AND l.year = 2024
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74279,75624) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0025  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (74279,75624) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (426323,60209,246122,385529,426416,676777,843951,916554,3224102,3334888) ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 850 AND l.year = 2024
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74279,75624) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0036  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (74279,75624) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (154371,197962,245004,380144,426323,676777,798652,844006,908382,3322688) ORDER BY rp.in_squad = 1 DESC
0.0028  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 74279 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC