Publicidad 600x120.gif
Premier League 2 Division One
2023/2024

Premier League 2 Division One

  • Tottenham Hotspur Sub 21
  • West Ham Sub 21
  • Arsenal Sub 21
  • Fulham Sub 21
  • Chelsea Sub 21
  • Liverpool Sub 21
  • Sunderland Sub 21
  • Wolves Sub 21
  • Brighton & Hove Sub 21
  • Middlesbrough Sub 21
  • Reading Sub 21
  • Man. Utd Sub 21
  • Crystal Palace Sub 21
  • Stoke City Sub 21
  • Aston Villa Sub 21
  • Norwich City Sub 21
  • Blackburn Rovers Sub 21
  • Nottingham Forest Sub 21
  • West Bromwich Sub 21
  • Southampton Sub 21
  • Derby County Sub 21
  • Leicester Sub 21
  • Everton Sub 21
  • Leeds United Sub 21
  • Man. City Sub 21
  • Newcastle Sub 21
 
01 Mar 24
20:00 Finalizado
Chelsea Sub 21 Chelsea Sub 21 2-4 Arsenal Sub 21 Arsenal Sub 21 más información Jugadas destacadas 3
12' E. Nwaneri
22' D. Washington 1-0
1-1 33' Taylor Foran
1-2 54' James Sweet
1-3 64' E. Nwaneri
1-4 84' Nathan Butler
91' Jimmy Morgan 2-4
 
01 Mar 24
20:00 Finalizado
Fulham Sub 21 Fulham Sub 21 7-1 Reading Sub 21 Reading Sub 21 más información Jugadas destacadas 6
7' K. Sekularac 1-0
26' Terrell Works 2-0
35' Adrion Pajaziti 3-0
42' Adrion Pajaziti 4-0
46' Adrion Pajaziti 5-0
46' Terrell Works 6-0
56' Devan Tanton 7-0
7-1 82' Okine-Peters
 
01 Mar 24
20:00 Finalizado
Norwich City Sub 21 Norwich City Sub 21 2-3 Middlesbrough Sub 21 Middlesbrough Sub 21 más información Jugadas destacadas 2
0-1 14' Pharrell Willis
0-2 23' Sonny Finch
47' Elliot Myles 1-2
49' Joe Duffy 2-2
2-3 76' Joe Gibson
 
01 Mar 24
20:00 Finalizado
Sunderland Sub 21 Sunderland Sub 21 1-1 Brighton & Hove Sub 21 Brighton & Hove Sub 21 más información Jugadas destacadas 1
0-1 38' C. Vickers
65' Tom Chiabi 1-1
76' Luke Bell
77' Luca Barrington
 
01 Mar 24
20:00 Finalizado
Man. Utd Sub 21 Man. Utd Sub 21 2-4 Derby County Sub 21 Derby County Sub 21 más información Jugadas destacadas 5
0-1 23' Tony Weston
31' Zachary Baumann 1-1
1-2 38' Tony Weston
1-3 44' Cruz Allen
1-4 47' Adebayo Fapetu
68' Ethan Williams 2-4
 
02 Mar 24
14:00 Finalizado
Blackburn Rovers Sub 21 Blackburn Rovers Sub 21 1-3 West Ham Sub 21 West Ham Sub 21 más información Jugadas destacadas ...
21' Dominik Biniek 1-0
1-1 34' Luizão
1-2 40' Lewis Orford
1-3 91' George Earthy
 
02 Mar 24
14:00 Finalizado
Tottenham Hotspur Sub 21 Tottenham Hotspur 1-2 Everton Sub 21 Everton Sub 21 más información Jugadas destacadas ...
4' Will Lankshear 1-0
1-1 36' Tyler Onyango
60' Aaron Maguire
1-2 70' Omari Benjamin
 
03 Mar 24
15:00 Finalizado
Liverpool Sub 21 Liverpool Sub 21 0-2 Aston Villa Sub 21 Aston Villa Sub 21 más información Jugadas destacadas 8
0-1 5' O. Kellyman
0-2 76' Kobei Moore
 
04 Mar 24
19:00 Finalizado
West Bromwich Sub 21 West Bromwich Sub 21 1-1 Southampton Sub 21 Southampton Sub 21 más información Jugadas destacadas 15
63' Layton Love 1-0
1-1 66' Zach Awe
 
04 Mar 24
20:00 Finalizado
Man. City Sub 21 Man. City Sub 21 2-0 Nottingham Forest Sub 21 Nottingham Forest más información Jugadas destacadas 24
38' Nico O'reilly 1-0
88' Nico O'reilly 2-0
 
04 Mar 24
20:00 Finalizado
Leicester Sub 21 Leicester Sub 21 2-0 Leeds United Sub 21 Leeds United Sub 21 más información Jugadas destacadas 1
14' Silko Thomas 1-0
46' Silko Thomas 2-0
 
04 Mar 24
20:00 Finalizado
Stoke City Sub 21 Stoke City Sub 21 1-3 Crystal Palace Sub 21 Crystal Palace Sub 21 más información Jugadas destacadas ...
0-1 2' Daniel Imray
40' William Smith 1-1
1-2 61' Franco Umeh
1-3 69' Dylan Reid
 
04 Mar 24
20:00 Finalizado
Wolves Sub 21 Wolves Sub 21 2-2 Newcastle Sub 21 Newcastle Sub 21 más información Jugadas destacadas 10
8' Temple Ojinnaka
47' Tom Edozie 2-0
62' Tom Edozie 3-0
3-1 90' Anthony Munda
Equipos Puntos J. G. E. P. F. C.
1 Tottenham Hotspur Sub 21 Tottenham 34 13 11 1 1 40 16
  • VICTORIA
  • Tottenham Hotspur. 1
  • Leeds United Sub 2. 0
  • VICTORIA
  • Southampton Sub 21 2
  • Tottenham Hotspur. 3
  • VICTORIA
  • Tottenham Hotspur. 5
  • Aston Villa Sub 21 3
  • EMPATE
  • Tottenham Hotspur. 1
  • West Ham Sub 21 1
  • DERROTA
  • Tottenham Hotspur. 1
  • Everton Sub 21 2
2 West Ham Sub 21 West Ham Sub 21 33 15 10 3 2 43 20
  • VICTORIA
  • West Bromwich Sub. 2
  • West Ham Sub 21 4
  • VICTORIA
  • West Ham Sub 21 3
  • Stoke City Sub 21 1
  • DERROTA
  • West Ham Sub 21 0
  • Chelsea Sub 21 2
  • EMPATE
  • Tottenham Hotspur. 1
  • West Ham Sub 21 1
  • VICTORIA
  • Blackburn Rovers S. 1
  • West Ham Sub 21 3
3 Arsenal Sub 21 Arsenal Sub 21 30 15 9 3 3 37 23
  • DERROTA
  • Wolves Sub 21 2
  • Arsenal Sub 21 1
  • EMPATE
  • Arsenal Sub 21 1
  • Leeds United Sub 2. 1
  • VICTORIA
  • Arsenal Sub 21 4
  • Southampton Sub 21 2
  • DERROTA
  • West Bromwich Sub. 3
  • Arsenal Sub 21 0
  • VICTORIA
  • Chelsea Sub 21 2
  • Arsenal Sub 21 4
4 Fulham Sub 21 Fulham Sub 21 28 15 8 4 3 39 22
  • VICTORIA
  • Fulham Sub 21 2
  • Derby County Sub 2. 1
  • DERROTA
  • Liverpool Sub 21 2
  • Fulham Sub 21 0
  • DERROTA
  • Fulham Sub 21 1
  • Blackburn Rovers S. 2
  • EMPATE
  • Norwich City Sub 2. 3
  • Fulham Sub 21 3
  • VICTORIA
  • Fulham Sub 21 7
  • Reading Sub 21 1
5 Chelsea Sub 21 Chelsea Sub 21 26 15 8 2 5 36 26
  • VICTORIA
  • Chelsea Sub 21 3
  • Reading Sub 21 2
  • VICTORIA
  • West Ham Sub 21 0
  • Chelsea Sub 21 2
  • VICTORIA
  • Leeds United Sub 2. 0
  • Chelsea Sub 21 2
  • VICTORIA
  • Middlesbrough Sub. 1
  • Chelsea Sub 21 3
  • DERROTA
  • Chelsea Sub 21 2
  • Arsenal Sub 21 4
6 Liverpool Sub 21 Liverpool 26 14 8 2 4 28 22
  • DERROTA
  • Brighton & Hove Su. 4
  • Liverpool Sub 21 2
  • VICTORIA
  • Liverpool Sub 21 2
  • Fulham Sub 21 0
  • VICTORIA
  • Liverpool Sub 21 3
  • Stoke City Sub 21 1
  • VICTORIA
  • Newcastle Sub 21 1
  • Liverpool Sub 21 2
  • DERROTA
  • Liverpool Sub 21 0
  • Aston Villa Sub 21 2
7 Sunderland Sub 21 Sunderland 24 14 7 3 4 32 23
  • VICTORIA
  • Nottingham Forest. 0
  • Sunderland Sub 21 5
  • VICTORIA
  • Leeds United Sub 2. 1
  • Sunderland Sub 21 3
  • DERROTA
  • Reading Sub 21 2
  • Sunderland Sub 21 1
  • EMPATE
  • Sunderland Sub 21 1
  • Brighton & Hove Su. 1
  • VICTORIA
  • Sunderland Sub 21 4
  • Leicester Sub 21 2
8 Wolves Sub 21 Wolves Sub 21 24 15 7 3 5 32 27
  • VICTORIA
  • Norwich City Sub 2. 3
  • Wolves Sub 21 4
  • VICTORIA
  • Wolves Sub 21 2
  • Arsenal Sub 21 1
  • EMPATE
  • Man. City Sub 21 3
  • Wolves Sub 21 3
  • VICTORIA
  • Wolves Sub 21 3
  • West Bromwich Sub. 0
  • EMPATE
  • Wolves Sub 21 2
  • Newcastle Sub 21 2
9 Brighton & Hove Sub 21 Brighton Hove 24 15 7 3 5 30 28
  • VICTORIA
  • Brighton & Hove Su. 4
  • Liverpool Sub 21 2
  • DERROTA
  • Crystal Palace Sub. 2
  • Brighton & Hove Su. 1
  • VICTORIA
  • Brighton & Hove Su. 2
  • Norwich City Sub 2. 0
  • DERROTA
  • Stoke City Sub 21 4
  • Brighton & Hove Su. 3
  • EMPATE
  • Sunderland Sub 21 1
  • Brighton & Hove Su. 1
10 Middlesbrough Sub 21 Middlesbrough 24 15 7 3 5 28 29
  • DERROTA
  • Middlesbrough Sub. 0
  • West Bromwich Sub. 1
  • DERROTA
  • Aston Villa Sub 21 4
  • Middlesbrough Sub. 0
  • DERROTA
  • Middlesbrough Sub. 1
  • Chelsea Sub 21 3
  • VICTORIA
  • Norwich City Sub 2. 2
  • Middlesbrough Sub. 3
  • VICTORIA
  • Middlesbrough Sub. 3
  • Newcastle Sub 21 2
11 Reading Sub 21 Reading Sub 21 23 14 7 2 5 25 32
  • EMPATE
  • Reading Sub 21 2
  • Middlesbrough Sub. 2
  • VICTORIA
  • Reading Sub 21 2
  • Leicester Sub 21 1
  • DERROTA
  • Chelsea Sub 21 3
  • Reading Sub 21 2
  • VICTORIA
  • Reading Sub 21 2
  • Sunderland Sub 21 1
  • DERROTA
  • Fulham Sub 21 7
  • Reading Sub 21 1
12 Man. Utd Sub 21 Man. Utd Sub 21 20 13 6 2 5 42 31
  • VICTORIA
  • Man. Utd Sub 21 3
  • Newcastle Sub 21 2
  • DERROTA
  • Chelsea Sub 21 3
  • Man. Utd Sub 21 2
  • VICTORIA
  • Man. Utd Sub 21 4
  • Norwich City Sub 2. 2
  • VICTORIA
  • Man. Utd Sub 21 2
  • Man. City Sub 21 1
  • DERROTA
  • Man. Utd Sub 21 2
  • Derby County Sub 2. 4
13 Crystal Palace Sub 21 Crystal Palace 20 14 6 2 6 35 32
  • DERROTA
  • Crystal Palace Sub. 1
  • West Ham Sub 21 5
  • EMPATE
  • Blackburn Rovers S. 3
  • Crystal Palace Sub. 3
  • VICTORIA
  • Crystal Palace Sub. 2
  • Brighton & Hove Su. 1
  • EMPATE
  • Leicester Sub 21 1
  • Crystal Palace Sub. 1
  • VICTORIA
  • Stoke City Sub 21 1
  • Crystal Palace Sub. 3
14 Stoke City Sub 21 Stoke City 19 15 6 1 8 32 42
  • DERROTA
  • West Ham Sub 21 3
  • Stoke City Sub 21 1
  • DERROTA
  • Liverpool Sub 21 3
  • Stoke City Sub 21 1
  • VICTORIA
  • Stoke City Sub 21 4
  • Brighton & Hove Su. 3
  • EMPATE
  • Aston Villa Sub 21 2
  • Stoke City Sub 21 2
  • DERROTA
  • Stoke City Sub 21 1
  • Crystal Palace Sub. 3
15 Aston Villa Sub 21 Aston Villa 18 13 5 3 5 29 28
  • DERROTA
  • Tottenham Hotspur. 5
  • Aston Villa Sub 21 3
  • VICTORIA
  • Aston Villa Sub 21 2
  • Everton Sub 21 1
  • VICTORIA
  • Aston Villa Sub 21 4
  • Middlesbrough Sub. 0
  • EMPATE
  • Aston Villa Sub 21 2
  • Stoke City Sub 21 2
  • VICTORIA
  • Liverpool Sub 21 0
  • Aston Villa Sub 21 2
16 Norwich City Sub 21 Norwich City 17 15 5 2 8 36 35
  • DERROTA
  • Norwich City Sub 2. 3
  • Wolves Sub 21 4
  • DERROTA
  • Man. Utd Sub 21 4
  • Norwich City Sub 2. 2
  • DERROTA
  • Brighton & Hove Su. 2
  • Norwich City Sub 2. 0
  • EMPATE
  • Norwich City Sub 2. 3
  • Fulham Sub 21 3
  • DERROTA
  • Norwich City Sub 2. 2
  • Middlesbrough Sub. 3
17 Blackburn Rovers Sub 21 Blackburn Rovers 17 15 5 2 8 30 49
  • EMPATE
  • Blackburn Rovers S. 3
  • Crystal Palace Sub. 3
  • VICTORIA
  • Blackburn Rovers S. 2
  • Newcastle Sub 21 1
  • VICTORIA
  • Fulham Sub 21 1
  • Blackburn Rovers S. 2
  • VICTORIA
  • Derby County Sub 2. 1
  • Blackburn Rovers S. 3
  • DERROTA
  • Blackburn Rovers S. 1
  • West Ham Sub 21 3
18 Nottingham Forest Sub 21 Nottingham 16 13 4 4 5 18 25
  • DERROTA
  • Stoke City Sub 21 3
  • Nottingham Forest. 1
  • DERROTA
  • Nottingham Forest. 0
  • Sunderland Sub 21 5
  • VICTORIA
  • Derby County Sub 2. 0
  • Nottingham Forest. 1
  • VICTORIA
  • Everton Sub 21 1
  • Nottingham Forest. 2
  • DERROTA
  • Man. City Sub 21 2
  • Nottingham Forest. 0
19 West Bromwich Sub 21 West Bromwich 16 15 4 4 7 17 24
  • VICTORIA
  • Middlesbrough Sub. 0
  • West Bromwich Sub. 1
  • DERROTA
  • West Bromwich Sub. 0
  • Derby County Sub 2. 1
  • DERROTA
  • Wolves Sub 21 3
  • West Bromwich Sub. 0
  • VICTORIA
  • West Bromwich Sub. 3
  • Arsenal Sub 21 0
  • EMPATE
  • West Bromwich Sub. 1
  • Southampton Sub 21 1
20 Southampton Sub 21 Southampton 14 14 4 2 8 28 37
  • VICTORIA
  • Southampton Sub 21 2
  • Derby County Sub 2. 1
  • DERROTA
  • Southampton Sub 21 2
  • Tottenham Hotspur. 3
  • VICTORIA
  • Leicester Sub 21 1
  • Southampton Sub 21 2
  • DERROTA
  • Arsenal Sub 21 4
  • Southampton Sub 21 2
  • EMPATE
  • West Bromwich Sub. 1
  • Southampton Sub 21 1
21 Derby County Sub 21 Derby County 13 15 4 1 10 23 28
  • DERROTA
  • Fulham Sub 21 2
  • Derby County Sub 2. 1
  • DERROTA
  • Derby County Sub 2. 0
  • Nottingham Forest. 1
  • VICTORIA
  • West Bromwich Sub. 0
  • Derby County Sub 2. 1
  • DERROTA
  • Derby County Sub 2. 1
  • Blackburn Rovers S. 3
  • VICTORIA
  • Man. Utd Sub 21 2
  • Derby County Sub 2. 4
22 Leicester Sub 21 Leicester 13 15 3 4 8 21 31
  • DERROTA
  • Reading Sub 21 2
  • Leicester Sub 21 1
  • DERROTA
  • Leicester Sub 21 1
  • Southampton Sub 21 2
  • EMPATE
  • Leicester Sub 21 1
  • Crystal Palace Sub. 1
  • VICTORIA
  • Leicester Sub 21 2
  • Leeds United Sub 2. 0
  • DERROTA
  • Sunderland Sub 21 4
  • Leicester Sub 21 2
23 Everton Sub 21 Everton Sub 21 12 14 3 3 8 18 28
  • DERROTA
  • Everton Sub 21 1
  • West Bromwich Sub. 3
  • EMPATE
  • Everton Sub 21 1
  • Man. City Sub 21 1
  • DERROTA
  • Aston Villa Sub 21 2
  • Everton Sub 21 1
  • DERROTA
  • Everton Sub 21 1
  • Nottingham Forest. 2
  • VICTORIA
  • Tottenham Hotspur. 1
  • Everton Sub 21 2
24 Leeds United Sub 21 Leeds United 11 13 3 2 8 17 32
  • DERROTA
  • Tottenham Hotspur. 1
  • Leeds United Sub 2. 0
  • DERROTA
  • Leeds United Sub 2. 1
  • Sunderland Sub 21 3
  • EMPATE
  • Arsenal Sub 21 1
  • Leeds United Sub 2. 1
  • DERROTA
  • Leeds United Sub 2. 0
  • Chelsea Sub 21 2
  • DERROTA
  • Leicester Sub 21 2
  • Leeds United Sub 2. 0
25 Man. City Sub 21 Man. City 11 15 2 5 8 25 42
  • DERROTA
  • Stoke City Sub 21 5
  • Man. City Sub 21 1
  • EMPATE
  • Everton Sub 21 1
  • Man. City Sub 21 1
  • EMPATE
  • Man. City Sub 21 3
  • Wolves Sub 21 3
  • DERROTA
  • Man. Utd Sub 21 2
  • Man. City Sub 21 1
  • VICTORIA
  • Man. City Sub 21 2
  • Nottingham Forest. 0
26 Newcastle Sub 21 Newcastle 10 13 2 4 7 19 28
  • EMPATE
  • Leicester Sub 21 2
  • Newcastle Sub 21 2
  • DERROTA
  • Blackburn Rovers S. 2
  • Newcastle Sub 21 1
  • DERROTA
  • Newcastle Sub 21 1
  • Liverpool Sub 21 2
  • EMPATE
  • Wolves Sub 21 2
  • Newcastle Sub 21 2
  • DERROTA
  • Middlesbrough Sub. 3
  • Newcastle Sub 21 2
Series Finales : Tottenham, West Ham Sub 21, Arsenal Sub 21, Fulham Sub 21, Chelsea Sub 21, Liverpool, Sunderland, Wolves Sub 21, Brighton Hove, Middlesbrough, Reading Sub 21, Man. Utd Sub 21, Crystal Palace, Stoke City, Aston Villa, Norwich City

Premier League 2 Division One
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,366,064 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1104
Total Execution Time  0.1123
  CADENA URL  
/premier_league_2_division_one/grupo1/jornada15
  GET DATOS  
$_GET['/premier_league_2_division_one/grupo1/jornada15']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0020  SELECT type FROM routes WHERE alias = 'premier_league_2_division_one'
0.0042  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_2_division_one' 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.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1977 AND type_rel = 3
0.0025  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1977 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1268809,1235957,1235428,1230545,1228001) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = 73415 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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=1977 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 1977 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 12:38:14' 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-03-29 12:38:14' 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-03-29 12:38:14' 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-03-29 12:38:14' 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 = 'premier_league_2_division_one' 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.0021  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=73415 AND rel.round=15
0.0018  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 = 73415 AND esl.points > 0
0.0018  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-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 73415 ORDER BY creation_date DESC LIMIT 0, 10
0.0023  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-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 73415
0.0053  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` = 73415 AND c.`round` = 15 ORDER BY shedule ASC LIMIT 200
0.0050  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 = 73415 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 (457322,457323,457324,457325,457330,457326,457328,457329,457333,457327,457331,457332,457334) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0030  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 = 15 AND e.real_date IS NOT NULL AND e.league_id = 73415 ORDER BY total DESC LIMIT 40
0.0050  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 = 73415 AND t.round = 14 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 *,(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 = 73415 AND t.round = 15 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 distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 73415 AND shedule >= '2024/03/01' AND shedule < '2024/04/01' ORDER BY shedule ASC
0.0032  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-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 73415 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0017  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 457299
0.0020  SELECT data1, data2 FROM services_tags WHERE categoryId=1977
0.0020  SELECT group_code, extraName from `leagues` WHERE categoryId=1977 AND year=2024