4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Liga Benín
2023/2024

Liga Benín

  • Damissa FC
  • Bani Gansè
  • Cavaliers
  • Tukunnin
  • Buffles de Borgou
  • Dynamique FC
  • Panthères
  • Dynamo Unacob
  • Béké Bembèrèkè
  • Dadje FC
  • Loto Popo
  • Dynamo Abomey
  • Espoir FC
  • Tonnerre FC
  • Abeilles FC
  • Soleil FC
  • Hodio FC
  • Réal Sport
  • Coton Sport FC
  • AS Cotonou
  • ASPAC
  • Requins de l'Atlantique
  • Adjidja FC
  • Etoile Filante
  • AS Police
  • Aïnonvi
  • Aziza
  • Ayema
  • AS Sobemap
  • Dragons de l'Ouémé
  • JSP
  • ASVO
  • Jeunesse Athletique De Keto

Liga Benín

La temporada finalizó el Domingo, 14 Enero 2024.
 
13 Ene 24
16:00 Finalizado
AS Cotonou AS Cotonou 1-1 Aziza Aziza más información ...
 
13 Ene 24
16:00 Finalizado
ASPAC ASPAC 3-2 AS Police AS Police más información ...
 
13 Ene 24
16:00 Finalizado
Coton Sport FC Coton Sport FC 3-0 Aïnonvi Aïnonvi más información ...
 
13 Ene 24
16:00 Finalizado
Etoile Filante Etoile Filante 3-1 Adjidja FC Adjidja FC más información ...
 
13 Ene 24
16:00 Finalizado
ASVO ASVO 0-0 Jeunesse Athletique De Keto Jeunesse Athletique Keto más información ...
 
13 Ene 24
16:00 Finalizado
Avrankou Omnisport Avrankou Omnisport 1-2 JSP JSP más información ...
 
13 Ene 24
16:00 Finalizado
Ayema Ayema 2-1 Djeffa FC Djeffa FC más información ...
 
13 Ene 24
16:00 Finalizado
Dragons de l'Ouémé Dragons de l'Ouémé 3-0 AS Sobemap AS Sobemap más información ...
 
14 Ene 24
16:00 Finalizado
Bani Gansè Bani Gansè 1-1 Dynamo Unacob Dynamo Unacob más información ...
 
14 Ene 24
16:00 Finalizado
Buffles de Borgou Buffles de Borgou 0-0 Cavaliers Cavaliers más información ...
 
14 Ene 24
16:00 Finalizado
Damissa FC Damissa FC 2-0 Béké Bembèrèkè Béké Bembèrèkè más información ...
 
14 Ene 24
16:00 Finalizado
Panthères Panthères 1-3 Tukunnin Tukunnin más información ...
 
14 Ene 24
16:00 Finalizado
Abeilles FC Abeilles FC 0-3 Loto Popo Loto Popo más información ...
 
14 Ene 24
16:00 Finalizado
Dadje FC Dadje FC 1-1 Réal Sport Réal Sport más información ...
 
14 Ene 24
16:00 Finalizado
Dynamo Abomey Dynamo Abomey 1-0 Hodio FC Hodio FC más información ...
 
14 Ene 24
16:00 Finalizado
Espoir FC Espoir FC 1-0 Tonnerre FC Tonnerre FC más información ...
Grupo A Puntos J. G. E. P. F. C.
1 Damissa FC Damissa FC 32 16 9 5 2 25 8
  • EMPATE
  • Damissa FC 0
  • Dynamique FC 0
  • VICTORIA
  • Buffles de Borgou 0
  • Damissa FC 1
  • VICTORIA
  • Damissa FC 2
  • Panthères 1
  • EMPATE
  • Bani Gansè 0
  • Damissa FC 0
  • VICTORIA
  • Damissa FC 2
  • Béké Bembèrèkè 0
2 Bani Gansè Bani Gansè 30 16 8 6 2 22 10
  • VICTORIA
  • Bani Gansè 2
  • Buffles de Borgou 1
  • EMPATE
  • Panthères 1
  • Bani Gansè 1
  • EMPATE
  • Bani Gansè 0
  • Damissa FC 0
  • VICTORIA
  • Béké Bembèrèkè 0
  • Bani Gansè 2
  • EMPATE
  • Bani Gansè 1
  • Dynamo Unacob 1
3 Cavaliers Cavaliers 24 16 6 6 4 15 8
  • VICTORIA
  • Béké Bembèrèkè 1
  • Cavaliers 2
  • VICTORIA
  • Cavaliers 3
  • Dynamo Unacob 0
  • EMPATE
  • Tukunnin 1
  • Cavaliers 1
  • VICTORIA
  • Cavaliers 4
  • Dynamique FC 0
  • EMPATE
  • Buffles de Borgou 0
  • Cavaliers 0
4 Tukunnin Tukunnin 24 16 6 6 4 16 16
  • EMPATE
  • Dynamo Unacob 1
  • Tukunnin 1
  • EMPATE
  • Tukunnin 1
  • Cavaliers 1
  • VICTORIA
  • Dynamique FC 0
  • Tukunnin 1
  • EMPATE
  • Tukunnin 1
  • Buffles de Borgou 1
  • VICTORIA
  • Panthères 1
  • Tukunnin 3
5 Buffles de Borgou Buffles Borgou 22 16 5 7 4 14 10
  • DERROTA
  • Buffles de Borgou 0
  • Damissa FC 1
  • VICTORIA
  • Béké Bembèrèkè 0
  • Buffles de Borgou 1
  • VICTORIA
  • Buffles de Borgou 3
  • Dynamo Unacob 1
  • EMPATE
  • Tukunnin 1
  • Buffles de Borgou 1
  • EMPATE
  • Buffles de Borgou 0
  • Cavaliers 0
6 Dynamique FC Dynamique FC 16 16 3 7 6 8 15
  • EMPATE
  • Damissa FC 0
  • Dynamique FC 0
  • EMPATE
  • Dynamique FC 1
  • Béké Bembèrèkè 1
  • EMPATE
  • Dynamo Unacob 0
  • Dynamique FC 0
  • DERROTA
  • Dynamique FC 0
  • Tukunnin 1
  • DERROTA
  • Cavaliers 4
  • Dynamique FC 0
7 Panthères Panthères 15 16 3 6 7 9 17
  • EMPATE
  • Panthères 1
  • Bani Gansè 1
  • DERROTA
  • Damissa FC 2
  • Panthères 1
  • DERROTA
  • Panthères 1
  • Béké Bembèrèkè 2
  • EMPATE
  • Dynamo Unacob 0
  • Panthères 0
  • DERROTA
  • Panthères 1
  • Tukunnin 3
8 Dynamo Unacob Dynamo Unacob 13 16 1 10 5 7 20
  • DERROTA
  • Cavaliers 3
  • Dynamo Unacob 0
  • EMPATE
  • Dynamo Unacob 0
  • Dynamique FC 0
  • DERROTA
  • Buffles de Borgou 3
  • Dynamo Unacob 1
  • EMPATE
  • Dynamo Unacob 0
  • Panthères 0
  • EMPATE
  • Bani Gansè 1
  • Dynamo Unacob 1
9 Béké Bembèrèkè Béké 11 16 2 5 9 13 25
  • EMPATE
  • Dynamique FC 1
  • Béké Bembèrèkè 1
  • DERROTA
  • Béké Bembèrèkè 0
  • Buffles de Borgou 1
  • VICTORIA
  • Panthères 1
  • Béké Bembèrèkè 2
  • DERROTA
  • Béké Bembèrèkè 0
  • Bani Gansè 2
  • DERROTA
  • Damissa FC 2
  • Béké Bembèrèkè 0
Grupo B Puntos J. G. E. P. F. C.
1 Dadje FC Dadje FC 35 16 11 2 3 29 15
  • VICTORIA
  • Dadje FC 4
  • Abeilles FC 1
  • DERROTA
  • Dynamo Abomey 1
  • Dadje FC 0
  • VICTORIA
  • Dadje FC 2
  • Hodio FC 0
  • VICTORIA
  • Loto Popo 1
  • Dadje FC 6
  • EMPATE
  • Dadje FC 1
  • Réal Sport 1
2 Loto Popo Loto Popo 31 16 9 4 3 28 16
  • EMPATE
  • Tonnerre FC 1
  • Loto Popo 1
  • VICTORIA
  • Loto Popo 4
  • Soleil FC 2
  • DERROTA
  • Espoir FC 2
  • Loto Popo 0
  • DERROTA
  • Loto Popo 1
  • Dadje FC 6
  • VICTORIA
  • Abeilles FC 0
  • Loto Popo 3
3 Dynamo Abomey Dynamo Abomey 30 16 9 3 4 17 14
  • VICTORIA
  • Dynamo Abomey 2
  • Soleil FC 1
  • DERROTA
  • Espoir FC 2
  • Dynamo Abomey 1
  • VICTORIA
  • Dynamo Abomey 1
  • Dadje FC 0
  • EMPATE
  • Abeilles FC 2
  • Dynamo Abomey 2
  • VICTORIA
  • Dynamo Abomey 1
  • Hodio FC 0
4 Espoir FC Espoir FC 26 16 8 2 6 15 11
  • VICTORIA
  • Espoir FC 2
  • Dynamo Abomey 1
  • VICTORIA
  • Hodio FC 0
  • Espoir FC 1
  • VICTORIA
  • Espoir FC 2
  • Loto Popo 0
  • VICTORIA
  • Réal Sport 0
  • Espoir FC 2
  • VICTORIA
  • Espoir FC 1
  • Tonnerre FC 0
5 Tonnerre FC Tonnerre FC 22 16 6 4 6 15 18
  • VICTORIA
  • Hodio FC 1
  • Tonnerre FC 2
  • EMPATE
  • Tonnerre FC 1
  • Loto Popo 1
  • VICTORIA
  • Réal Sport 1
  • Tonnerre FC 2
  • VICTORIA
  • Tonnerre FC 2
  • Soleil FC 0
  • DERROTA
  • Espoir FC 1
  • Tonnerre FC 0
6 Abeilles FC Abeilles FC 21 16 5 6 5 16 17
  • EMPATE
  • Abeilles FC 0
  • Espoir FC 0
  • DERROTA
  • Dadje FC 4
  • Abeilles FC 1
  • EMPATE
  • Abeilles FC 2
  • Dynamo Abomey 2
  • VICTORIA
  • Hodio FC 0
  • Abeilles FC 1
  • DERROTA
  • Abeilles FC 0
  • Loto Popo 3
7 Soleil FC Soleil FC 14 16 3 5 8 13 22
  • DERROTA
  • Dynamo Abomey 2
  • Soleil FC 1
  • EMPATE
  • Soleil FC 1
  • Hodio FC 1
  • DERROTA
  • Loto Popo 4
  • Soleil FC 2
  • VICTORIA
  • Soleil FC 2
  • Réal Sport 0
  • DERROTA
  • Tonnerre FC 2
  • Soleil FC 0
8 Hodio FC Hodio FC 11 16 2 5 9 10 19
  • EMPATE
  • Soleil FC 1
  • Hodio FC 1
  • DERROTA
  • Hodio FC 0
  • Espoir FC 1
  • DERROTA
  • Dadje FC 2
  • Hodio FC 0
  • DERROTA
  • Hodio FC 0
  • Abeilles FC 1
  • DERROTA
  • Dynamo Abomey 1
  • Hodio FC 0
9 Réal Sport Réal Sport 8 16 1 5 10 8 19
  • EMPATE
  • Loto Popo 0
  • Réal Sport 0
  • DERROTA
  • Réal Sport 1
  • Tonnerre FC 2
  • DERROTA
  • Soleil FC 2
  • Réal Sport 0
  • DERROTA
  • Réal Sport 0
  • Espoir FC 2
  • EMPATE
  • Dadje FC 1
  • Réal Sport 1
Grupo C Puntos J. G. E. P. F. C.
1 Coton Sport FC Coton Sport FC 33 16 10 3 3 26 12
  • VICTORIA
  • Coton Sport FC 1
  • ASPAC 0
  • VICTORIA
  • AS Police 0
  • Coton Sport FC 2
  • VICTORIA
  • Coton Sport FC 2
  • Aziza 1
  • VICTORIA
  • Adjidja FC 1
  • Coton Sport FC 2
  • VICTORIA
  • Coton Sport FC 3
  • Aïnonvi 0
2 AS Cotonou AS Cotonou 30 16 8 6 2 17 10
  • EMPATE
  • AS Cotonou 1
  • Coton Sport FC 1
  • EMPATE
  • Etoile Filante 1
  • AS Cotonou 1
  • DERROTA
  • AS Cotonou 2
  • ASPAC 4
  • VICTORIA
  • AS Police 0
  • AS Cotonou 1
  • EMPATE
  • AS Cotonou 1
  • Aziza 1
3 ASPAC ASPAC 30 16 9 3 4 20 15
  • DERROTA
  • ASPAC 1
  • Requins de l'Atlan. 3
  • DERROTA
  • Coton Sport FC 1
  • ASPAC 0
  • EMPATE
  • ASPAC 0
  • Etoile Filante 0
  • VICTORIA
  • AS Cotonou 2
  • ASPAC 4
  • VICTORIA
  • ASPAC 3
  • AS Police 2
4 Requins de l'Atlantique Requins 29 16 8 5 3 18 10
  • VICTORIA
  • ASPAC 1
  • Requins de l'Atlan. 3
  • VICTORIA
  • Requins de l'Atlan. 3
  • AS Police 2
  • VICTORIA
  • Aziza 0
  • Requins de l'Atlan. 1
  • VICTORIA
  • Requins de l'Atlan. 1
  • Adjidja FC 0
  • EMPATE
  • Aïnonvi 0
  • Requins de l'Atlan. 0
5 Adjidja FC Adjidja FC 21 16 7 0 9 18 16
  • VICTORIA
  • Aziza 1
  • Adjidja FC 2
  • VICTORIA
  • Adjidja FC 3
  • Aïnonvi 0
  • DERROTA
  • Requins de l'Atlan. 1
  • Adjidja FC 0
  • DERROTA
  • Adjidja FC 1
  • Coton Sport FC 2
  • DERROTA
  • Etoile Filante 3
  • Adjidja FC 1
6 Etoile Filante Etoile Filante 18 16 5 3 8 11 19
  • EMPATE
  • Etoile Filante 1
  • AS Cotonou 1
  • EMPATE
  • ASPAC 0
  • Etoile Filante 0
  • DERROTA
  • Etoile Filante 1
  • AS Police 2
  • VICTORIA
  • Aziza 1
  • Etoile Filante 2
  • VICTORIA
  • Etoile Filante 3
  • Adjidja FC 1
7 AS Police AS Police 15 16 4 3 9 15 24
  • DERROTA
  • Requins de l'Atlan. 3
  • AS Police 2
  • DERROTA
  • AS Police 0
  • Coton Sport FC 2
  • VICTORIA
  • Etoile Filante 1
  • AS Police 2
  • DERROTA
  • AS Police 0
  • AS Cotonou 1
  • DERROTA
  • ASPAC 3
  • AS Police 2
8 Aïnonvi Aïnonvi 13 16 2 7 7 8 17
  • EMPATE
  • AS Police 0
  • Aïnonvi 0
  • EMPATE
  • Aïnonvi 0
  • Aziza 0
  • DERROTA
  • Adjidja FC 3
  • Aïnonvi 0
  • EMPATE
  • Aïnonvi 0
  • Requins de l'Atlan. 0
  • DERROTA
  • Coton Sport FC 3
  • Aïnonvi 0
9 Aziza Aziza 10 16 2 4 10 11 21
  • EMPATE
  • Aïnonvi 0
  • Aziza 0
  • DERROTA
  • Aziza 0
  • Requins de l'Atlan. 1
  • DERROTA
  • Coton Sport FC 2
  • Aziza 1
  • DERROTA
  • Aziza 1
  • Etoile Filante 2
  • EMPATE
  • AS Cotonou 1
  • Aziza 1
Grupo D Puntos J. G. E. P. F. C.
1 Ayema Ayema 32 16 9 5 2 14 7
  • EMPATE
  • Ayema 1
  • ASVO 1
  • VICTORIA
  • Avrankou Omnisport 0
  • Ayema 1
  • VICTORIA
  • Ayema 1
  • JSP 0
  • DERROTA
  • Jeunesse Athletiqu. 2
  • Ayema 0
  • VICTORIA
  • Ayema 2
  • Djeffa FC 1
2 AS Sobemap AS Sobemap 28 16 8 4 4 17 11
  • VICTORIA
  • JSP 0
  • AS Sobemap 1
  • VICTORIA
  • AS Sobemap 5
  • Jeunesse Athletiqu. 0
  • VICTORIA
  • Djeffa FC 1
  • AS Sobemap 2
  • EMPATE
  • AS Sobemap 0
  • JSO 0
  • DERROTA
  • Dragons de l'Ouémé 3
  • AS Sobemap 0
3 Dragons de l'Ouémé Dragons 27 16 7 6 3 21 9
  • VICTORIA
  • Dragons de l'Ouémé 1
  • Avrankou Omnisport 0
  • EMPATE
  • JSP 0
  • Dragons de l'Ouémé 0
  • VICTORIA
  • Dragons de l'Ouémé 1
  • Jeunesse Athletiqu. 0
  • VICTORIA
  • Djeffa FC 0
  • Dragons de l'Ouémé 2
  • VICTORIA
  • Dragons de l'Ouémé 3
  • AS Sobemap 0
4 JSP JSP 27 16 8 3 5 19 14
  • VICTORIA
  • JSO 0
  • JSP 3
  • EMPATE
  • JSP 0
  • Dragons de l'Ouémé 0
  • DERROTA
  • Ayema 1
  • JSP 0
  • VICTORIA
  • JSP 1
  • ASVO 0
  • VICTORIA
  • Avrankou Omnisport 1
  • JSP 2
5 ASVO ASVO 22 16 5 7 4 13 12
  • EMPATE
  • ASVO 0
  • Dragons de l'Ouémé 0
  • EMPATE
  • Ayema 1
  • ASVO 1
  • VICTORIA
  • ASVO 2
  • Avrankou Omnisport 0
  • DERROTA
  • JSP 1
  • ASVO 0
  • EMPATE
  • ASVO 0
  • Jeunesse Athletiqu. 0
6 Jeunesse Athletique De Keto Jeunesse 21 16 5 6 5 21 25
  • DERROTA
  • AS Sobemap 5
  • Jeunesse Athletiqu. 0
  • EMPATE
  • Jeunesse Athletiqu. 1
  • JSO 1
  • DERROTA
  • Dragons de l'Ouémé 1
  • Jeunesse Athletiqu. 0
  • VICTORIA
  • Jeunesse Athletiqu. 2
  • Ayema 0
  • EMPATE
  • ASVO 0
  • Jeunesse Athletiqu. 0
7 JSO JSO 16 16 3 7 6 14 16
  • DERROTA
  • Avrankou Omnisport 1
  • JSO 0
  • DERROTA
  • JSO 0
  • JSP 3
  • EMPATE
  • Jeunesse Athletiqu. 1
  • JSO 1
  • EMPATE
  • JSO 1
  • Djeffa FC 1
  • EMPATE
  • AS Sobemap 0
  • JSO 0
8 Avrankou Omnisport Avrankou 14 16 3 5 8 15 22
  • VICTORIA
  • Avrankou Omnisport 1
  • JSO 0
  • DERROTA
  • Dragons de l'Ouémé 1
  • Avrankou Omnisport 0
  • DERROTA
  • Avrankou Omnisport 0
  • Ayema 1
  • DERROTA
  • ASVO 2
  • Avrankou Omnisport 0
  • DERROTA
  • Avrankou Omnisport 1
  • JSP 2
9 Djeffa FC Djeffa FC 6 16 1 3 12 10 28
  • DERROTA
  • Jeunesse Athletiqu. 3
  • Djeffa FC 2
  • DERROTA
  • Djeffa FC 1
  • AS Sobemap 2
  • EMPATE
  • JSO 1
  • Djeffa FC 1
  • DERROTA
  • Djeffa FC 0
  • Dragons de l'Ouémé 2
  • DERROTA
  • Ayema 2
  • Djeffa FC 1
Siguiente Ronda : Damissa FC, Bani Gansè, Cavaliers, Tukunnin, Dadje FC, Loto Popo, Dynamo Abomey, Espoir FC, Coton Sport FC, AS Cotonou, ASPAC, Requins, Ayema, AS Sobemap, Dragons, JSP
Playoff Descenso : Buffles Borgou, Dynamique FC, Panthères, Dynamo Unacob, Béké, Tonnerre FC, Abeilles FC, Soleil FC, Hodio FC, Réal Sport, Adjidja FC, Etoile Filante, AS Police, Aïnonvi, Aziza, ASVO, Jeunesse, JSO, Avrankou, Djeffa FC

INFORMACIÓN
La Benin Premier League, también llamada Championnat National du Bénin en francés, es la mayor división de fútbol de Benín. La liga fue fundada en 1969. Actualmente, esta compuesta por 14 clubes que participan en un torneo de dos ruedas. El campeón de la Premier League logra un puesto en la Liga de Campeones de la CAF. Los últimos 2 clubes sufren el descenso a la Segunda División que está formada por 11 equipos.
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,282,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1940
Total Execution Time  0.1959
  CADENA URL  
/liga_benin
  GET DATOS  
$_GET['/liga_benin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0034  SELECT type FROM routes WHERE alias = 'liga_benin'
0.0072  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_benin' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) 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=328 AND type_rel = 3
0.0037  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 = 74380 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='2024' WHERE c.parentId=328 GROUP BY c.id ORDER BY c.order_id ASC
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 18:35:27' 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 18:35:27' 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 18:35:27' 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=3 AND last_update > '2024-03-28 18:35:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_benin' 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.0035  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74380) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
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 (74380) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0035  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74380) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0035  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 (74380) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0037  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74380) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
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 (74380) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0037  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74380) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0035  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 (74380) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0035  SELECT rp.lineup 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,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74380 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0035  SELECT rp.events 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,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74380 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0043  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=74380 AND rel.round=18
0.0038  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 74380 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0037  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 74380 AND esl.points > 0
0.0037  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-02-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 74380 ORDER BY creation_date DESC LIMIT 0, 10
0.0048  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-02-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 74380
0.0097  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 74380 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0040  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2024 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2024 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 74380 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (603148,603149,603150,603151,603152,603153,603154,603155,603140,603141,603142,603143,603144,603145,603146,603147) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0040  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 18 AND e.real_date IS NOT NULL AND e.league_id = 74380 ORDER BY total DESC LIMIT 40
0.0034  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 74380 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
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 `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 = 74380 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 74380 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.0038  SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 74380 AND shedule >= '2024/01/01' AND shedule < '2024/02/01' ORDER BY shedule ASC
0.0038  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-03-28 00:00:00' AND c.`shedule` < '2024-04-01 23:59:59' AND l.id = 74380 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0038  SELECT data1, data2 FROM services_tags WHERE categoryId=328
0.0038  SELECT group_code, extraName from `leagues` WHERE categoryId=328 AND year=2024