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

Premier League 2 Division One

  • Tottenham Hotspur Sub 21
  • West Ham Sub 21
  • Fulham Sub 21
  • Arsenal Sub 21
  • Brighton & Hove Sub 21
  • Reading Sub 21
  • Middlesbrough Sub 21
  • Chelsea Sub 21
  • Sunderland Sub 21
  • Liverpool Sub 21
  • Norwich City Sub 21
  • Wolves Sub 21
  • Stoke City Sub 21
  • Man. Utd Sub 21
  • Crystal Palace Sub 21
  • West Bromwich Sub 21
  • Nottingham Forest Sub 21
  • Southampton Sub 21
  • Leeds United Sub 21
  • Aston Villa Sub 21
  • Newcastle Sub 21
  • Leicester Sub 21
  • Everton Sub 21
  • Blackburn Rovers Sub 21
  • Derby County Sub 21
  • Man. City Sub 21
 
12 Ene 24
20:00 Finalizado
Arsenal Sub 21 Arsenal Sub 21 1-0 Middlesbrough Sub 21 Middlesbrough Sub 21 más información Jugadas destacadas 11
52' Ismael Kabia 1-0
 
12 Ene 24
20:00 Finalizado
Chelsea Sub 21 Chelsea Sub 21 3-2 Man. Utd Sub 21 Man. Utd Sub 21 más información Jugadas destacadas 1
32' D. Mcneilly 1-0
50' D. Mcneilly 2-0
2-1 54' Shola Shoretire
2-2 60' Shola Shoretire
91' T. George 3-2
 
12 Ene 24
20:00 Finalizado
Fulham Sub 21 Fulham Sub 21 2-1 Derby County Sub 21 Derby County Sub 21 más información Jugadas destacadas 28
0-1 66' D. Brown
92' Callum Mcfarlane 1-1
97' Sam Amissah 2-1
 
12 Ene 24
20:00 Finalizado
Norwich City Sub 21 Norwich City Sub 21 3-4 Wolves Sub 21 Wolves Sub 21 más información Jugadas destacadas 3
0-1 18' Owen Farmer
30' Kenneth Aboh 1-1
1-2 39' Tyler Roberts
50' Jaden Warner 2-2
57' Charlie Wilson
2-3 67' F. Holman
71' Pedro Lima 3-3
3-4 80' Owen Farmer
 
12 Ene 24
20:00 Finalizado
Nottingham Forest Sub 21 Nottingham Forest 0-5 Sunderland Sub 21 Sunderland Sub 21 más información Jugadas destacadas 8
0-1 19' Eliezer Mayenda
0-2 26' Thomas Watson
0-3 29' Michael Spellman
0-4 31' Eliezer Mayenda
0-5 91' Caden Kelly
 
12 Ene 24
20:00 Finalizado
Southampton Sub 21 Southampton Sub 21 2-3 Tottenham Hotspur Sub 21 Tottenham Hotspur más información Jugadas destacadas 1
0-1 33' Max Robson
47' Cam Bragg 1-1
1-2 57' Will Lankshear
80' A. Gomes 2-2
2-3 81' Will Lankshear
 
13 Ene 24
17:00 Finalizado
Brighton & Hove Sub 21 Brighton & Hove Sub 21 4-2 Liverpool Sub 21 Liverpool Sub 21 más información Jugadas destacadas 10
8' Harry Howell 1-0
1-1 13' Jayden Danns
1-2 33' L. Koumas
50' Louis Flower 2-2
58' Harry Howell 3-2
97' Jamie Mullins 4-2
 
14 Ene 24
14:00 Finalizado
Blackburn Rovers Sub 21 Blackburn Rovers Sub 21 3-3 Crystal Palace Sub 21 Crystal Palace Sub 21 más información Jugadas destacadas ...
3' Dilan Markanday 1-0
1-1 3' J. Raymond
48' Niall Ennis
58' Dilan Markanday 2-1
2-2 86' Franco Umeh
94' Semir Telalović 3-2
3-3 96' Franco Umeh
 
15 Ene 24
14:00 Finalizado
West Bromwich Sub 21 West Bromwich Sub 21 2-4 West Ham Sub 21 West Ham Sub 21 más información Jugadas destacadas 13
0-1 3' Kamarai Simon
0-2 24' George Earthy
0-3 73' Luizão
75' Layton Love 1-3
76' Akeel Higgins 2-3
2-4 84' Daniel Rigge
 
15 Ene 24
20:00 Finalizado
Reading Sub 21 Reading Sub 21 2-1 Leicester Sub 21 Leicester Sub 21 más información Jugadas destacadas 20
0-1 68' T. Maswanhise
74' K. Ehibhatiomhan 1-1
88' C. Vickers 2-1
 
15 Ene 24
20:00 Finalizado
Stoke City Sub 21 Stoke City Sub 21 5-1 Man. City Sub 21 Man. City Sub 21 más información Jugadas destacadas 26
12' William Smith 1-0
52' Nathan Lowe 2-0
2-1 78' Kane Taylor
83' Nathan Lowe 3-1
93' M. Susoho
94' Liam Mccarron 4-1
97' Nathan Lowe 5-1
 
22 Abr 24
Sin comenzar
Leeds United Sub 21 Leeds United Sub 21
14:30
Everton Sub 21 Everton Sub 21 más información 6
 
29 Abr 24
Sin comenzar
Newcastle Sub 21 Newcastle Sub 21
20:00
Aston Villa Sub 21 Aston Villa Sub 21 más información 2
Equipos Puntos J. G. E. P. F. C. Forma
1 Tottenham Hotspur Sub 21 Tottenham 30 10 10 0 0 33 10
  • VICTORIA
  • Tottenham Hotspur. 4
  • Chelsea Sub 21 2
  • VICTORIA
  • Sunderland Sub 21 2
  • Tottenham Hotspur. 4
  • VICTORIA
  • Norwich City Sub 2. 3
  • Tottenham Hotspur. 4
  • VICTORIA
  • Tottenham Hotspur. 1
  • Leeds United Sub 2. 0
  • VICTORIA
  • Southampton Sub 21 2
  • Tottenham Hotspur. 3
2 West Ham Sub 21 West Ham Sub 21 26 11 8 2 1 36 15
  • VICTORIA
  • West Ham Sub 21 5
  • Middlesbrough Sub. 0
  • VICTORIA
  • Liverpool Sub 21 0
  • West Ham Sub 21 4
  • VICTORIA
  • West Ham Sub 21 3
  • Nottingham Forest. 1
  • VICTORIA
  • Crystal Palace Sub. 1
  • West Ham Sub 21 5
  • VICTORIA
  • West Bromwich Sub. 2
  • West Ham Sub 21 4
3 Fulham Sub 21 Fulham Sub 21 24 11 7 3 1 28 14
  • EMPATE
  • Fulham Sub 21 1
  • Man. Utd Sub 21 1
  • EMPATE
  • Chelsea Sub 21 2
  • Fulham Sub 21 2
  • VICTORIA
  • Fulham Sub 21 3
  • Brighton & Hove Su. 0
  • EMPATE
  • Aston Villa Sub 21 1
  • Fulham Sub 21 1
  • VICTORIA
  • Fulham Sub 21 2
  • Derby County Sub 2. 1
4 Arsenal Sub 21 Arsenal Sub 21 23 11 7 2 2 27 16
  • VICTORIA
  • Arsenal Sub 21 6
  • Brighton & Hove Su. 3
  • EMPATE
  • Arsenal Sub 21 3
  • Man. City Sub 21 3
  • VICTORIA
  • Sunderland Sub 21 1
  • Arsenal Sub 21 2
  • VICTORIA
  • Arsenal Sub 21 1
  • Middlesbrough Sub. 0
  • DERROTA
  • West Bromwich Sub. 3
  • Arsenal Sub 21 0
5 Brighton & Hove Sub 21 Brighton Hove 20 11 6 2 3 23 21
  • DERROTA
  • Arsenal Sub 21 6
  • Brighton & Hove Su. 3
  • VICTORIA
  • Brighton & Hove Su. 2
  • Aston Villa Sub 21 1
  • DERROTA
  • Fulham Sub 21 3
  • Brighton & Hove Su. 0
  • EMPATE
  • Brighton & Hove Su. 0
  • Leicester Sub 21 0
  • VICTORIA
  • Brighton & Hove Su. 4
  • Liverpool Sub 21 2
6 Reading Sub 21 Reading Sub 21 20 11 6 2 3 20 21
  • VICTORIA
  • Reading Sub 21 7
  • Blackburn Rovers S. 2
  • EMPATE
  • West Bromwich Sub. 0
  • Reading Sub 21 0
  • DERROTA
  • Derby County Sub 2. 5
  • Reading Sub 21 1
  • EMPATE
  • Reading Sub 21 2
  • Middlesbrough Sub. 2
  • VICTORIA
  • Reading Sub 21 2
  • Leicester Sub 21 1
7 Middlesbrough Sub 21 Middlesbrough 18 11 5 3 3 22 20
  • DERROTA
  • West Ham Sub 21 5
  • Middlesbrough Sub. 0
  • VICTORIA
  • Middlesbrough Sub. 1
  • Derby County Sub 2. 0
  • EMPATE
  • Reading Sub 21 2
  • Middlesbrough Sub. 2
  • DERROTA
  • Arsenal Sub 21 1
  • Middlesbrough Sub. 0
  • DERROTA
  • Middlesbrough Sub. 1
  • Chelsea Sub 21 3
8 Chelsea Sub 21 Chelsea Sub 21 17 11 5 2 4 27 20
  • EMPATE
  • Chelsea Sub 21 1
  • Leicester Sub 21 1
  • EMPATE
  • Chelsea Sub 21 2
  • Fulham Sub 21 2
  • DERROTA
  • Liverpool Sub 21 2
  • Chelsea Sub 21 1
  • VICTORIA
  • Chelsea Sub 21 3
  • Man. Utd Sub 21 2
  • VICTORIA
  • Middlesbrough Sub. 1
  • Chelsea Sub 21 3
9 Sunderland Sub 21 Sunderland 17 10 5 2 3 23 17
  • VICTORIA
  • Aston Villa Sub 21 2
  • Sunderland Sub 21 3
  • DERROTA
  • Sunderland Sub 21 2
  • Tottenham Hotspur. 4
  • VICTORIA
  • Southampton Sub 21 1
  • Sunderland Sub 21 2
  • DERROTA
  • Sunderland Sub 21 1
  • Arsenal Sub 21 2
  • VICTORIA
  • Nottingham Forest. 0
  • Sunderland Sub 21 5
10 Liverpool Sub 21 Liverpool 17 10 5 2 3 21 18
  • VICTORIA
  • Crystal Palace Sub. 2
  • Liverpool Sub 21 4
  • EMPATE
  • Leeds United Sub 2. 2
  • Liverpool Sub 21 2
  • DERROTA
  • Liverpool Sub 21 0
  • West Ham Sub 21 4
  • VICTORIA
  • Liverpool Sub 21 2
  • Chelsea Sub 21 1
  • DERROTA
  • Brighton & Hove Su. 4
  • Liverpool Sub 21 2
11 Norwich City Sub 21 Norwich City 16 11 5 1 5 29 23
  • DERROTA
  • Norwich City Sub 2. 3
  • Tottenham Hotspur. 4
  • VICTORIA
  • Norwich City Sub 2. 4
  • Blackburn Rovers S. 0
  • VICTORIA
  • Man. City Sub 21 0
  • Norwich City Sub 2. 6
  • DERROTA
  • Stoke City Sub 21 4
  • Norwich City Sub 2. 2
  • DERROTA
  • Norwich City Sub 2. 3
  • Wolves Sub 21 4
12 Wolves Sub 21 Wolves Sub 21 16 11 5 1 5 22 21
  • VICTORIA
  • Wolves Sub 21 2
  • Southampton Sub 21 1
  • EMPATE
  • Nottingham Forest. 2
  • Wolves Sub 21 2
  • VICTORIA
  • Leicester Sub 21 1
  • Wolves Sub 21 3
  • DERROTA
  • Wolves Sub 21 1
  • Blackburn Rovers S. 2
  • VICTORIA
  • Norwich City Sub 2. 3
  • Wolves Sub 21 4
13 Stoke City Sub 21 Stoke City 16 11 5 1 5 25 30
  • VICTORIA
  • Blackburn Rovers S. 3
  • Stoke City Sub 21 6
  • VICTORIA
  • Stoke City Sub 21 3
  • Nottingham Forest. 1
  • VICTORIA
  • Stoke City Sub 21 4
  • Norwich City Sub 2. 2
  • VICTORIA
  • Stoke City Sub 21 5
  • Man. City Sub 21 1
  • EMPATE
  • Aston Villa Sub 21 2
  • Stoke City Sub 21 2
14 Man. Utd Sub 21 Man. Utd Sub 21 14 10 4 2 4 34 24
  • VICTORIA
  • Blackburn Rovers S. 2
  • Man. Utd Sub 21 5
  • EMPATE
  • Fulham Sub 21 1
  • Man. Utd Sub 21 1
  • VICTORIA
  • Man. Utd Sub 21 3
  • Everton Sub 21 1
  • VICTORIA
  • Man. Utd Sub 21 3
  • Newcastle Sub 21 2
  • DERROTA
  • Chelsea Sub 21 3
  • Man. Utd Sub 21 2
15 Crystal Palace Sub 21 Crystal Palace 13 11 4 1 6 29 29
  • VICTORIA
  • Crystal Palace Sub. 3
  • West Bromwich Sub. 0
  • VICTORIA
  • Leeds United Sub 2. 1
  • Crystal Palace Sub. 7
  • VICTORIA
  • Man. City Sub 21 0
  • Crystal Palace Sub. 3
  • DERROTA
  • Crystal Palace Sub. 1
  • West Ham Sub 21 5
  • EMPATE
  • Blackburn Rovers S. 3
  • Crystal Palace Sub. 3
16 West Bromwich Sub 21 West Bromwich 12 11 3 3 5 15 19
  • DERROTA
  • Crystal Palace Sub. 3
  • West Bromwich Sub. 0
  • EMPATE
  • West Bromwich Sub. 0
  • Reading Sub 21 0
  • VICTORIA
  • Everton Sub 21 1
  • West Bromwich Sub. 3
  • DERROTA
  • West Bromwich Sub. 2
  • West Ham Sub 21 4
  • VICTORIA
  • West Bromwich Sub. 3
  • Arsenal Sub 21 0
17 Nottingham Forest Sub 21 Nottingham 10 10 2 4 4 15 22
  • EMPATE
  • Newcastle Sub 21 1
  • Nottingham Forest. 1
  • EMPATE
  • Nottingham Forest. 2
  • Wolves Sub 21 2
  • DERROTA
  • West Ham Sub 21 3
  • Nottingham Forest. 1
  • DERROTA
  • Stoke City Sub 21 3
  • Nottingham Forest. 1
  • DERROTA
  • Nottingham Forest. 0
  • Sunderland Sub 21 5
18 Southampton Sub 21 Southampton 10 11 3 1 7 23 31
  • DERROTA
  • Wolves Sub 21 2
  • Southampton Sub 21 1
  • DERROTA
  • Southampton Sub 21 1
  • Sunderland Sub 21 2
  • DERROTA
  • Everton Sub 21 5
  • Southampton Sub 21 0
  • VICTORIA
  • Southampton Sub 21 2
  • Derby County Sub 2. 1
  • DERROTA
  • Southampton Sub 21 2
  • Tottenham Hotspur. 3
19 Leeds United Sub 21 Leeds United 10 9 3 1 5 15 24
  • DERROTA
  • Reading Sub 21 3
  • Leeds United Sub 2. 2
  • DERROTA
  • Wolves Sub 21 2
  • Leeds United Sub 2. 0
  • EMPATE
  • Leeds United Sub 2. 2
  • Liverpool Sub 21 2
  • DERROTA
  • Leeds United Sub 2. 1
  • Crystal Palace Sub. 7
  • DERROTA
  • Tottenham Hotspur. 1
  • Leeds United Sub 2. 0
20 Aston Villa Sub 21 Aston Villa 9 9 2 3 4 18 22
  • VICTORIA
  • Blackburn Rovers S. 2
  • Aston Villa Sub 21 3
  • DERROTA
  • Aston Villa Sub 21 2
  • Sunderland Sub 21 3
  • DERROTA
  • Brighton & Hove Su. 2
  • Aston Villa Sub 21 1
  • EMPATE
  • Aston Villa Sub 21 1
  • Fulham Sub 21 1
  • EMPATE
  • Aston Villa Sub 21 2
  • Stoke City Sub 21 2
21 Newcastle Sub 21 Newcastle 9 9 2 3 4 13 19
  • EMPATE
  • Brighton & Hove Su. 1
  • Newcastle Sub 21 1
  • EMPATE
  • Newcastle Sub 21 1
  • Nottingham Forest. 1
  • VICTORIA
  • Newcastle Sub 21 1
  • Everton Sub 21 0
  • DERROTA
  • Man. Utd Sub 21 3
  • Newcastle Sub 21 2
  • EMPATE
  • Leicester Sub 21 2
  • Newcastle Sub 21 2
22 Leicester Sub 21 Leicester 9 11 2 3 6 15 24
  • EMPATE
  • Chelsea Sub 21 1
  • Leicester Sub 21 1
  • DERROTA
  • Leicester Sub 21 1
  • Wolves Sub 21 3
  • EMPATE
  • Brighton & Hove Su. 0
  • Leicester Sub 21 0
  • EMPATE
  • Leicester Sub 21 2
  • Newcastle Sub 21 2
  • DERROTA
  • Reading Sub 21 2
  • Leicester Sub 21 1
23 Everton Sub 21 Everton Sub 21 8 10 2 2 6 13 22
  • EMPATE
  • Everton Sub 21 1
  • Arsenal Sub 21 1
  • DERROTA
  • Newcastle Sub 21 1
  • Everton Sub 21 0
  • DERROTA
  • Man. Utd Sub 21 3
  • Everton Sub 21 1
  • VICTORIA
  • Everton Sub 21 5
  • Southampton Sub 21 0
  • DERROTA
  • Everton Sub 21 1
  • West Bromwich Sub. 3
24 Blackburn Rovers Sub 21 Blackburn Rovers 8 11 2 2 7 22 43
  • DERROTA
  • Reading Sub 21 7
  • Blackburn Rovers S. 2
  • DERROTA
  • Blackburn Rovers S. 3
  • Stoke City Sub 21 6
  • DERROTA
  • Norwich City Sub 2. 4
  • Blackburn Rovers S. 0
  • VICTORIA
  • Wolves Sub 21 1
  • Blackburn Rovers S. 2
  • EMPATE
  • Blackburn Rovers S. 3
  • Crystal Palace Sub. 3
25 Derby County Sub 21 Derby County 7 11 2 1 8 17 22
  • VICTORIA
  • Derby County Sub 2. 4
  • Man. City Sub 21 2
  • DERROTA
  • Middlesbrough Sub. 1
  • Derby County Sub 2. 0
  • VICTORIA
  • Derby County Sub 2. 5
  • Reading Sub 21 1
  • DERROTA
  • Southampton Sub 21 2
  • Derby County Sub 2. 1
  • DERROTA
  • Fulham Sub 21 2
  • Derby County Sub 2. 1
26 Man. City Sub 21 Man. City 6 11 1 3 7 18 36
  • DERROTA
  • Derby County Sub 2. 4
  • Man. City Sub 21 2
  • EMPATE
  • Arsenal Sub 21 3
  • Man. City Sub 21 3
  • DERROTA
  • Man. City Sub 21 0
  • Crystal Palace Sub. 3
  • DERROTA
  • Man. City Sub 21 0
  • Norwich City Sub 2. 6
  • DERROTA
  • Stoke City Sub 21 5
  • Man. City Sub 21 1
Series Finales : Tottenham, West Ham Sub 21, Fulham Sub 21, Arsenal Sub 21, Brighton Hove, Reading Sub 21, Middlesbrough, Chelsea Sub 21, Sunderland, Liverpool, Norwich City, Wolves Sub 21, Stoke City, Man. Utd Sub 21, Crystal Palace, West Bromwich

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,093,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1966
Total Execution Time  0.1985
  CADENA URL  
/premier_league_2_division_one/grupo1/jornada11
  GET DATOS  
$_GET['/premier_league_2_division_one/grupo1/jornada11']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0034  SELECT type FROM routes WHERE alias = 'premier_league_2_division_one'
0.0074  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.0034  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1977 AND type_rel = 3
0.0042  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.0041  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.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=1977 GROUP BY c.id ORDER BY c.order_id ASC
0.0034  SELECT type,rule FROM rules WHERE categoryId = 1977 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 06:27:04' 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-29 06:27:04' 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-29 06:27:04' 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-29 06:27:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0038  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=11
0.0036  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 = 73415 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0036  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.0034  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.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-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 73415
0.0078  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` = 11 ORDER BY shedule ASC LIMIT 200
0.0233  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 (457270,457272,457273,457274,457275,457276,457271,457277,457282,457280,457281,457278,457279) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0055  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 = 73415 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0097  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 = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 73415 AND shedule >= '2024/01/01' AND shedule < '2024/02/01' ORDER BY shedule ASC
0.0049  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.0034  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.0036  SELECT data1, data2 FROM services_tags WHERE categoryId=1977
0.0036  SELECT group_code, extraName from `leagues` WHERE categoryId=1977 AND year=2024