4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Championship 2020
  • Leeds United
  • West Bromwich Albion
  • Brentford
  • Fulham
  • Cardiff City
  • Swansea City
  • Nottingham Forest
  • Millwall
  • Preston North End
  • Derby County
  • Blackburn Rovers
  • Bristol City
  • Queens Park Rangers
  • Reading
  • Stoke City
  • Sheffield Wednesday
  • Middlesbrough
  • Huddersfield Town
  • Luton Town
  • Birmingham City
  • Barnsley
  • Charlton Athletic
  • Wigan Athletic
  • Hull City

Championship 2020

La temporada finalizó el Miércoles, 22 Julio 2020.
 
22 Jul 20
20:30 Finalizado
Birmingham City Birmingham City 1-3 Derby County Derby County más información Jugadas destacadas Vídeos del Birmingham City-Derby County 12
0-1 6' G. Shinnie
56' Ivan Šunjić 1-1
1-2 87' M. Whittaker
1-3 91' L. Sibley
22 Jul 20
20:30 Finalizado
Brentford Brentford 1-2 Barnsley Barnsley más información Jugadas destacadas Vídeos del Brentford-Barnsley 147
0-1 41' C. Styles
73' Josh Dasilva 1-1
1-2 91' C. Oduor
 
22 Jul 20
20:30 Finalizado
Bristol City Bristol City 1-1 Preston North End Preston North End más información Jugadas destacadas Vídeos del Bristol City-Preston North End 1
0-1 16' S. Maguire
48' F. Diédhiou 1-1
 
22 Jul 20
20:30 Finalizado
Cardiff City Cardiff City 3-0 Hull City Hull City más información Jugadas destacadas Vídeos del Cardiff City-Hull City 24
20' J. Hoilett 1-0
34' S. Morrison 2-0
83' D. Ward 3-0
 
22 Jul 20
20:30 Finalizado
Leeds United Leeds United 4-0 Charlton Athletic Charlton Athletic más información Jugadas destacadas Vídeos del Leeds United-Charlton Athletic 40
13' Ben White 1-0
28' S. Dallas 2-0
51' Tyler Roberts 3-0
66' J. Shackelton 4-0
 
22 Jul 20
20:30 Finalizado
Luton Town Luton Town 3-2 Blackburn Rovers Blackburn Rovers más información Jugadas destacadas Vídeos del Luton Town-Blackburn Rovers 17
0-1 10' A. Armstrong
28' Hayden Carter
35' Bradley Johnson
60' J. Collins 3-1
3-2 75' Sam Gallagher
 
22 Jul 20
20:30 Finalizado
Millwall Millwall 4-1 Huddersfield Town Huddersfield Town más información Jugadas destacadas Vídeos del Millwall-Huddersfield Town 4
4' C. Mahoney 1-0
1-1 36' Karlan Grant
47' Jake Cooper 2-1
63' Jirí Skalák 3-1
79' J. Bödvarsson 4-1
 
22 Jul 20
20:30 Finalizado
Nottingham Forest Nottingham Forest 1-4 Stoke City Stoke City más información Jugadas destacadas Vídeos del Nottingham Forest-Stoke City 62
0-1 19' Danny Batth
61' Tobias Figueiredo 1-1
1-2 73' J. Mcclean
1-3 78' Lee Gregory
96' Nuno Da Costa
 
22 Jul 20
20:30 Finalizado
Reading Reading 1-4 Swansea City Swansea City más información Jugadas destacadas Vídeos del Reading-Swansea City 6
0-1 17' R. Brewster
40' Yakou Meïté
43' George Puşcaş 1-1
1-2 66' Wayne Routledge
1-3 84' Liam Cullen
1-4 91' Wayne Routledge
 
22 Jul 20
20:30 Finalizado
Sheffield Wednesday Sheffield Wednesday 1-2 Middlesbrough Middlesbrough más información Jugadas destacadas Vídeos del Sheffield Wednesday-Middlesbrough 6
10' Jacob Murphy 1-0
1-1 22' Paddy Mcnair
1-2 93' B. Assombalonga
22 Jul 20
20:30 Finalizado
West Bromwich Albion West Bromwich Albion 2-2 Queens Park Rangers Queens Park Rangers más información Jugadas destacadas Vídeos del West Bromwich Albion-Queens Park Rangers 24
0-1 34' Ryan Manning
44' G. Diangana 1-1
49' Callum Robinson 2-1
2-2 61' E. Eze
 
22 Jul 20
20:30 Finalizado
Wigan Athletic Wigan Athletic 1-1 Fulham Fulham más información Jugadas destacadas Vídeos del Wigan Athletic-Fulham 46
32' Kieffer Moore 1-0
1-1 49' N. Kebano
Equipos Puntos J. G. E. P. F. C. Forma
1 Leeds United Leeds United 93 46 28 9 9 77 35
  • VICTORIA
  • Leeds United 5
  • Stoke City 0
  • VICTORIA
  • Swansea City 0
  • Leeds United 1
  • VICTORIA
  • Leeds United 1
  • Barnsley 0
  • VICTORIA
  • Derby County 1
  • Leeds United 3
  • VICTORIA
  • Leeds United 4
  • Charlton Athletic 0
2 West Bromwich Albion West Bromwich A. 83 46 22 17 7 77 45
  • VICTORIA
  • West Bromwich Albi. 2
  • Derby County 0
  • EMPATE
  • Blackburn Rovers 1
  • West Bromwich Albi. 1
  • EMPATE
  • West Bromwich Albi. 0
  • Fulham 0
  • DERROTA
  • Huddersfield Town 2
  • West Bromwich Albi. 1
  • EMPATE
  • West Bromwich Albi. 2
  • Queens Park Ranger. 2
3 Brentford Brentford 81 46 24 9 13 80 38
  • VICTORIA
  • Brentford 2
  • Charlton Athletic 1
  • VICTORIA
  • Derby County 1
  • Brentford 3
  • VICTORIA
  • Brentford 1
  • Preston North End 0
  • DERROTA
  • Stoke City 1
  • Brentford 0
  • DERROTA
  • Brentford 1
  • Barnsley 2
4 Fulham Fulham 81 46 23 12 11 64 48
  • VICTORIA
  • Nottingham Forest 0
  • Fulham 1
  • VICTORIA
  • Fulham 2
  • Cardiff City 0
  • EMPATE
  • West Bromwich Albi. 0
  • Fulham 0
  • VICTORIA
  • Fulham 5
  • Sheffield Wednesda. 3
  • EMPATE
  • Wigan Athletic 1
  • Fulham 1
5 Cardiff City Cardiff City 73 46 19 16 11 68 58
  • DERROTA
  • Cardiff City 2
  • Blackburn Rovers 3
  • DERROTA
  • Fulham 2
  • Cardiff City 0
  • VICTORIA
  • Cardiff City 2
  • Derby County 1
  • VICTORIA
  • Middlesbrough 1
  • Cardiff City 3
  • VICTORIA
  • Cardiff City 3
  • Hull City 0
6 Swansea City Swansea City 70 46 18 16 12 62 53
  • VICTORIA
  • Birmingham City 1
  • Swansea City 3
  • DERROTA
  • Swansea City 0
  • Leeds United 1
  • EMPATE
  • Nottingham Forest 2
  • Swansea City 2
  • VICTORIA
  • Swansea City 1
  • Bristol City 0
  • VICTORIA
  • Reading 1
  • Swansea City 4
7 Nottingham Forest Nottingham 70 46 18 16 12 58 50
  • DERROTA
  • Nottingham Forest 0
  • Fulham 1
  • EMPATE
  • Preston North End 1
  • Nottingham Forest 1
  • EMPATE
  • Nottingham Forest 2
  • Swansea City 2
  • DERROTA
  • Barnsley 1
  • Nottingham Forest 0
  • DERROTA
  • Nottingham Forest 1
  • Stoke City 4
8 Millwall Millwall 68 46 17 17 12 57 51
  • DERROTA
  • Millwall 0
  • Middlesbrough 2
  • VICTORIA
  • Hull City 0
  • Millwall 1
  • VICTORIA
  • Millwall 1
  • Blackburn Rovers 0
  • DERROTA
  • Queens Park Ranger. 4
  • Millwall 3
  • VICTORIA
  • Millwall 4
  • Huddersfield Town 1
9 Preston North End Preston North 66 46 18 12 16 59 54
  • VICTORIA
  • Sheffield Wednesda. 1
  • Preston North End 3
  • EMPATE
  • Preston North End 1
  • Nottingham Forest 1
  • DERROTA
  • Brentford 1
  • Preston North End 0
  • VICTORIA
  • Preston North End 2
  • Birmingham City 0
  • EMPATE
  • Bristol City 1
  • Preston North End 1
10 Derby County Derby County 64 46 17 13 16 62 64
  • DERROTA
  • West Bromwich Albi. 2
  • Derby County 0
  • DERROTA
  • Derby County 1
  • Brentford 3
  • DERROTA
  • Cardiff City 2
  • Derby County 1
  • DERROTA
  • Derby County 1
  • Leeds United 3
  • VICTORIA
  • Birmingham City 1
  • Derby County 3
11 Blackburn Rovers Blackburn Rovers 63 46 17 12 17 66 63
  • VICTORIA
  • Cardiff City 2
  • Blackburn Rovers 3
  • EMPATE
  • Blackburn Rovers 1
  • West Bromwich Albi. 1
  • DERROTA
  • Millwall 1
  • Blackburn Rovers 0
  • VICTORIA
  • Blackburn Rovers 4
  • Reading 3
  • DERROTA
  • Luton Town 3
  • Blackburn Rovers 2
12 Bristol City Bristol City 63 46 17 12 17 60 65
  • VICTORIA
  • Bristol City 2
  • Hull City 1
  • VICTORIA
  • Middlesbrough 1
  • Bristol City 3
  • EMPATE
  • Bristol City 1
  • Stoke City 1
  • DERROTA
  • Swansea City 1
  • Bristol City 0
  • EMPATE
  • Bristol City 1
  • Preston North End 1
13 Queens Park Rangers Queens Park Ran. 58 46 16 10 20 67 76
  • DERROTA
  • Wigan Athletic 1
  • Queens Park Ranger. 0
  • DERROTA
  • Queens Park Ranger. 0
  • Sheffield Wednesda. 3
  • EMPATE
  • Luton Town 1
  • Queens Park Ranger. 1
  • VICTORIA
  • Queens Park Ranger. 4
  • Millwall 3
  • EMPATE
  • West Bromwich Albi. 2
  • Queens Park Ranger. 2
14 Reading Reading 56 46 15 11 20 59 58
  • EMPATE
  • Reading 0
  • Huddersfield Town 0
  • VICTORIA
  • Charlton Athletic 0
  • Reading 1
  • DERROTA
  • Reading 1
  • Middlesbrough 2
  • DERROTA
  • Blackburn Rovers 4
  • Reading 3
  • DERROTA
  • Reading 1
  • Swansea City 4
15 Stoke City Stoke City 56 46 16 8 22 62 68
  • DERROTA
  • Leeds United 5
  • Stoke City 0
  • VICTORIA
  • Stoke City 2
  • Birmingham City 0
  • EMPATE
  • Bristol City 1
  • Stoke City 1
  • VICTORIA
  • Stoke City 1
  • Brentford 0
  • VICTORIA
  • Nottingham Forest 1
  • Stoke City 4
16 Sheffield Wednesday Sheffield 56 46 15 11 20 58 66
  • DERROTA
  • Sheffield Wednesda. 1
  • Preston North End 3
  • VICTORIA
  • Queens Park Ranger. 0
  • Sheffield Wednesda. 3
  • EMPATE
  • Sheffield Wednesda. 0
  • Huddersfield Town 0
  • DERROTA
  • Fulham 5
  • Sheffield Wednesda. 3
  • DERROTA
  • Sheffield Wednesda. 1
  • Middlesbrough 2
17 Middlesbrough Middlesbrough 53 46 13 14 19 48 61
  • VICTORIA
  • Millwall 0
  • Middlesbrough 2
  • DERROTA
  • Middlesbrough 1
  • Bristol City 3
  • VICTORIA
  • Reading 1
  • Middlesbrough 2
  • DERROTA
  • Middlesbrough 1
  • Cardiff City 3
  • VICTORIA
  • Sheffield Wednesda. 1
  • Middlesbrough 2
18 Huddersfield Town Huddersfield 51 46 13 12 21 52 70
  • EMPATE
  • Reading 0
  • Huddersfield Town 0
  • DERROTA
  • Huddersfield Town 0
  • Luton Town 2
  • EMPATE
  • Sheffield Wednesda. 0
  • Huddersfield Town 0
  • VICTORIA
  • Huddersfield Town 2
  • West Bromwich Albi. 1
  • DERROTA
  • Millwall 4
  • Huddersfield Town 1
19 Luton Town Luton Town 51 46 14 9 23 54 82
  • EMPATE
  • Luton Town 1
  • Barnsley 1
  • VICTORIA
  • Huddersfield Town 0
  • Luton Town 2
  • EMPATE
  • Luton Town 1
  • Queens Park Ranger. 1
  • VICTORIA
  • Hull City 0
  • Luton Town 1
  • VICTORIA
  • Luton Town 3
  • Blackburn Rovers 2
20 Birmingham City Birmingham City 50 46 12 14 20 54 75
  • DERROTA
  • Birmingham City 1
  • Swansea City 3
  • DERROTA
  • Stoke City 2
  • Birmingham City 0
  • EMPATE
  • Birmingham City 1
  • Charlton Athletic 1
  • DERROTA
  • Preston North End 2
  • Birmingham City 0
  • DERROTA
  • Birmingham City 1
  • Derby County 3
21 Barnsley Barnsley 49 46 12 13 21 49 69
  • EMPATE
  • Luton Town 1
  • Barnsley 1
  • EMPATE
  • Barnsley 0
  • Wigan Athletic 0
  • DERROTA
  • Leeds United 1
  • Barnsley 0
  • VICTORIA
  • Barnsley 1
  • Nottingham Forest 0
  • VICTORIA
  • Brentford 1
  • Barnsley 2
22 Charlton Athletic Charlton 48 46 12 12 22 50 65
  • DERROTA
  • Brentford 2
  • Charlton Athletic 1
  • DERROTA
  • Charlton Athletic 0
  • Reading 1
  • EMPATE
  • Birmingham City 1
  • Charlton Athletic 1
  • EMPATE
  • Charlton Athletic 2
  • Wigan Athletic 2
  • DERROTA
  • Leeds United 4
  • Charlton Athletic 0
23 Wigan Athletic Wigan Athletic * 47 46 15 14 17 57 56
  • VICTORIA
  • Wigan Athletic 1
  • Queens Park Ranger. 0
  • EMPATE
  • Barnsley 0
  • Wigan Athletic 0
  • VICTORIA
  • Wigan Athletic 8
  • Hull City 0
  • EMPATE
  • Charlton Athletic 2
  • Wigan Athletic 2
  • EMPATE
  • Wigan Athletic 1
  • Fulham 1
24 Hull City Hull City 45 46 12 9 25 57 87
  • DERROTA
  • Bristol City 2
  • Hull City 1
  • DERROTA
  • Hull City 0
  • Millwall 1
  • DERROTA
  • Wigan Athletic 8
  • Hull City 0
  • DERROTA
  • Hull City 0
  • Luton Town 1
  • DERROTA
  • Cardiff City 3
  • Hull City 0
Ascenso : Leeds United, West Bromwich A.
Playoff Ascenso : Brentford, Fulham, Cardiff City, Swansea City
Descenso : Charlton, Wigan Athletic, Hull City

Penalizaciones de la competición

-12 Puntos: Wigan Athletic

La Football League Championship, o The Championship (que por razones de patrocinio es llamada en el Reino Unido NPower Football
League Championship
) es la máxima competición futbolística de la Football League, y la segunda de la Liga inglesa de fútbol (por debajo de la FA Premier League

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  
7,113,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.3548
Total Execution Time  0.3579
  CADENA URL  
/championship2020/grupo0/info
  GET DATOS  
$_GET['/championship2020/grupo0/info']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0105  SELECT type FROM routes WHERE alias = 'championship2020'
0.0214  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'championship' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0107  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 = 49880 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=10 ORDER BY l.group_code ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 21:08:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 21:08:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 21:08:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 21:08:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0116  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=49880 AND rel.round=46
0.0106  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 = 49880 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0105  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 = 49880 AND esl.points > 0
0.0105  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` = 49880 ORDER BY creation_date DESC LIMIT 0, 10
0.0113  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` = 49880
0.0122  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 `calendars2020` 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` = 49880 AND c.`round` = 46 ORDER BY shedule ASC LIMIT 200
0.0148  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 events2020 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2020 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 49880 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 (17711,17712,17713,17714,17715,17716,17717,17718,17719,17720,17721,17722) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0114  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 `events2020` e INNER JOIN calendars2020 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 = 46 AND e.real_date IS NOT NULL AND e.league_id = 49880 ORDER BY total DESC LIMIT 40
0.0120  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 = 49880 AND t.round = 45 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  SELECT *,(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 = 49880 AND t.round = 46 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  SELECT distinct(shedule), round FROM `calendars2020` as c WHERE c.`league_id` = 49880 AND shedule >= '2020/07/01' AND shedule < '2020/08/01' ORDER BY shedule ASC
0.0105  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-02 23:59:59' AND l.id = 49880 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0116  SELECT data1, data2 FROM services_tags WHERE categoryId=25
0.0116  SELECT group_code, extraName from `leagues` WHERE categoryId=25 AND year=2020