Publicidad 600x120.gif
FA Cup
 
06 Ene 24
13:30 Finalizado
Maidstone United Maidstone United 1-0 Stevenage Stevenage más información Jugadas destacadas 74
47' Sam Corne 1-0
 
06 Ene 24
16:00 Finalizado
Newport County Newport County 1-1 Eastleigh Eastleigh más información Jugadas destacadas 24
38' G. Langston
56' James Clarke 1-0
1-1 82' C. Maguire
 
16 Ene 24
20:45 Finalizado
Eastleigh Eastleigh 1-3 Newport County Newport County más información Jugadas destacadas 31
0-1 3' A. Wildig
48' P. Mccallum 1-1
1-2 60' James Clarke
1-3 79' W. Evans
Global
Newport 4 - 2 Eastleigh
 
07 Ene 24
15:00 Finalizado
Shrewsbury Town Shrewsbury Town 0-1 Wrexham AFC Wrexham AFC más información Jugadas destacadas 27
0-1 72' Thomas O'connor
 
06 Ene 24
16:00 Finalizado
Watford Watford 2-1 Chesterfield Chesterfield más información Jugadas destacadas 210
0-1 28' J. Quigley
76' Mileta Rajovic 1-1
95' A. Dele-Bashiru 2-1
 
06 Ene 24
16:00 Finalizado
Blackburn Rovers Blackburn Rovers 5-2 Cambridge United Cambridge United más información Jugadas destacadas 23
0-1 6' J. Lankester
23' Samuel Szmodics 1-1
1-2 26' S. Kaikai
37' Samuel Szmodics 2-2
48' Samuel Szmodics 3-2
66' A. Sigurðsson 4-2
81' Harry Leonard 5-2
 
07 Ene 24
15:00 Finalizado
Luton Town Luton Town 0-0 Bolton Wanderers Bolton Wanderers más información 303
 
16 Ene 24
20:45 Finalizado
Bolton Wanderers Bolton Wanderers 1-2 Luton Town Luton Town más información Jugadas destacadas 81
11' Dion Charles 1-0
1-1 15' Tahith Chong
1-2 57' C. Ogbene
Global
Luton Town 2 - 1 Bolton
 
06 Ene 24
16:00 Finalizado
Gillingham Gillingham 0-4 Sheffield United Sheffield United más información Jugadas destacadas 10
0-1 14' William Osula
0-2 39' William Osula
0-3 83' James Mcatee
0-4 87' James Mcatee
 
06 Ene 24
13:30 Finalizado
Coventry City Coventry City 6-2 Oxford United Oxford United más información Jugadas destacadas 26
8' J. Latibeaudiere 1-0
1-1 10' M. Harris
11' Ben Sheaf 2-1
17' K. Palmer 3-1
50' C. O'Hare 4-1
4-2 79' T. Goodrham
84' M. Godden 5-2
88' M. Godden 6-2
08 Ene 24
21:15 Finalizado
Wigan Athletic Wigan Athletic 0-2 Manchester United Manchester United más información Jugadas destacadas 500
0-1 22' Diogo Dalot
0-2 74' Bruno Fernandes
 
07 Ene 24
15:00 Finalizado
Peterborough United Peterborough United 0-3 Leeds United Leeds United más información Jugadas destacadas 81
0-1 34' Ethan Ampadu
0-2 47' Patrick Bamford
0-3 90' Ethan Ampadu
 
06 Ene 24
18:30 Finalizado
Swansea City Swansea City 2-0 Morecambe Morecambe más información Jugadas destacadas 28
47' Charlie Patiño 1-0
87' J. Yates 2-0
 
06 Ene 24
16:00 Finalizado
Plymouth Argyle Plymouth Argyle 3-1 Sutton United Sutton United más información Jugadas destacadas 17
18' Luke Cundle 1-0
1-1 50' L. Angol
68' Ryan Hardie 2-1
91' M. Whittaker 3-1
06 Ene 24
13:30 Finalizado
AFC Wimbledon AFC Wimbledon 1-3 Ipswich Town Ipswich Town más información Jugadas destacadas 35
8' J. Davison
17' J. Reeves 2-0
2-1 40' Axel Tuanzebe
59' H. Pell
2-2 90' Jack Taylor
 
07 Ene 24
15:00 Finalizado
West Bromwich Albion West Bromwich Albion 4-1 Aldershot Town Aldershot Town más información Jugadas destacadas 17
7' N. Chalobah 1-0
15' Jovan Malcolm 2-0
27' Daryl Dike 3-0
88' Tom Fellows 4-0
4-1 95' Ollie Bray
 
06 Ene 24
16:00 Finalizado
Southampton Southampton 4-0 Walsall Walsall más información Jugadas destacadas 21
6' Ryan Fraser 1-0
58' Sékou Mara 2-0
68' Ryan Fraser 3-0
78' Ché Adams 4-0
 
06 Ene 24
16:00 Finalizado
Norwich City Norwich City 1-1 Bristol Rovers Bristol Rovers más información Jugadas destacadas 78
12' Ashley Barnes 1-0
1-1 17' G. Ward
 
17 Ene 24
20:45 Finalizado
Bristol Rovers Bristol Rovers 1-3 Norwich City Norwich City más información Jugadas destacadas 195
20' Luke Mccormick 1-0
1-1 53' Gabriel Sara
1-2 59' Adam Idah
1-3 87' Kenny Mclean
Global
Norwich City 4 - 2 Bristol
 
07 Ene 24
15:00 Finalizado
Nottingham Forest Nottingham Forest 2-2 Blackpool Blackpool más información Jugadas destacadas 400
0-1 25' Jordan Gabriel
0-2 27' A. Morgan
39' N. Domínguez 1-2
56' M. Gibbs-White 2-2
 
17 Ene 24
20:45 Finalizado
Blackpool Blackpool 2-3 Nottingham Forest Nottingham Forest más información Jugadas destacadas 333
0-1 16' A. Omobamidele
0-2 46' Danilo
61' A. Morgan 1-2
78' K. Joseph 2-2
2-3 110' Chris Wood
Global Pr.
Nottingham 5 - 4 Blackpool
07 Ene 24
17:30 Finalizado
Arsenal Arsenal 0-2 Liverpool Liverpool más información Jugadas destacadas 833
80' Jakub Kiwior
1-1 95' Luis Díaz
 
05 Ene 24
20:15 Finalizado
Brentford Brentford 1-1 Wolves Wolves más información Jugadas destacadas 969
9' João Gomes
41' Neal Maupay 1-0
1-1 64' Tommy Doyle
 
16 Ene 24
20:30 Finalizado
Wolves Wolves 3-2 Brentford Brentford más información Jugadas destacadas 1k
0-1 13' Nathan Collins
36' Nélson Semedo 1-1
1-2 52' Neal Maupay
72' Nathan Fraser 2-2
110' Matheus Cunha 3-2
Global Pr.
Brentford 3 - 4 Wolves
06 Ene 24
18:30 Finalizado
Chelsea Chelsea 4-0 Preston North End Preston North End más información Jugadas destacadas 276
58' A. Broja 1-0
66' Thiago Silva 2-0
69' R. Sterling 3-0
85' E. Fernández 4-0
04 Ene 24
21:00 Finalizado
Crystal Palace Crystal Palace 0-0 Everton Everton más información Jugadas destacadas 993
79' D. Calvert-Lewin
 
17 Ene 24
20:45 Finalizado
Everton Everton 1-0 Crystal Palace Crystal Palace más información Jugadas destacadas 804
42' André Gomes 1-0
Global
Crystal 0 - 1 Everton
 
05 Ene 24
20:30 Finalizado
Fulham Fulham 1-0 Rotherham United Rotherham United más información Jugadas destacadas 266
24' Bobby Reid 1-0
 
06 Ene 24
16:00 Finalizado
Hull City Hull City 1-1 Birmingham City Birmingham City más información Jugadas destacadas 117
0-1 18' L. Jutkiewicz
87' M. Jacob 1-1
 
16 Ene 24
20:45 Finalizado
Birmingham City Birmingham City 2-1 Hull City Hull City más información Jugadas destacadas 104
0-1 12' J. Lokilo
66' J. Stansfield 1-1
93' K. Miyoshi 2-1
Global
Hull City 2 - 3 Birmingham
07 Ene 24
15:00 Finalizado
Manchester City Manchester City 5-0 Huddersfield Town Huddersfield Town más información Jugadas destacadas 228
33' Phil Foden 1-0
37' Julián Álvarez 2-0
58' B. Jackson
65' Phil Foden 4-0
74' Jérémy Doku 5-0
06 Ene 24
18:30 Finalizado
Middlesbrough Middlesbrough 0-1 Aston Villa Aston Villa más información Jugadas destacadas 643
0-1 87' Matty Cash
 
06 Ene 24
13:30 Finalizado
Millwall Millwall 2-3 Leicester Leicester más información Jugadas destacadas 108
0-1 16' C. Casadei
0-2 39' Ricardo Pereira
56' Duncan Watmore 1-2
1-3 61' Thomas Cannon
86' Zian Flemming 2-3
 
06 Ene 24
16:00 Finalizado
Queens Park Rangers Queens Park Rangers 2-3 AFC Bournemouth AFC Bournemouth más información Jugadas destacadas 149
40' S. Armstrong 1-0
42' Lyndon Dykes 2-0
2-1 48' M. Tavernier
2-2 58' Kieffer Moore
2-3 69' Justin Kluivert
 
06 Ene 24
18:30 Finalizado
Sheffield Wednesday Sheffield Wednesday 4-0 Cardiff City Cardiff City más información Jugadas destacadas 39
2' Josh Windass 1-0
4' Ryan Wintle
7' Callum Robinson
38' R. Sawyers
40' Liam Palmer 3-0
91' Mallik Wilks 4-0
 
06 Ene 24
16:00 Finalizado
Stoke City Stoke City 2-4 Brighton & Hove Albion Brighton & Hove Albion más información Jugadas destacadas 156
16' J. Van Hecke
1-1 51' P. Estupiñán
1-2 52' Lewis Dunk
63' Lewis Baker 2-2
2-3 71' João Pedro
2-4 80' João Pedro
06 Ene 24
13:45 Finalizado
Sunderland Sunderland 0-3 Newcastle Newcastle más información Jugadas destacadas 176
35' D. Ballard
1-1 46' Alexander Isak
1-2 90' Alexander Isak
05 Ene 24
21:00 Finalizado
Tottenham Hotspur Tottenham Hotspur 1-0 Burnley Burnley más información Jugadas destacadas 447
78' Pedro Porro 1-0
 
07 Ene 24
15:00 Finalizado
West Ham West Ham 1-1 Bristol City Bristol City más información Jugadas destacadas 329
4' Jarrod Bowen 1-0
1-1 61' T. Conway
 
16 Ene 24
20:45 Finalizado
Bristol City Bristol City 1-0 West Ham West Ham más información Jugadas destacadas 828
3' T. Conway 1-0
51' S. Benrahma
Global
West Ham 1 - 2 Bristol City

INFORMACIÓN
La FA Cup (Football Association Challenge Cup), o la Copa de Inglaterra es una competición anual de fútbol de Inglaterra, en la que participan actualmente más de 700 equipos. Es considerada como la copa doméstica más prestigiosa del mundo. La primera vez que se disputó la FA Cup fue en 1871. Es la competición futbolística más antigua del mundo.
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,993,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4623
Total Execution Time  0.4642
  CADENA URL  
/fa_cup/grupo0/jornada9
  GET DATOS  
$_GET['/fa_cup/grupo0/jornada9']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0018  SELECT type FROM routes WHERE alias = 'fa_cup'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'fa_cup' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=139 AND type_rel = 3
0.0036  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 139 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1306985,1306895,1306821,1306831,1306788) ORDER BY n.cover_points DESC, update_date DESC
0.0046  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 = 72728 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 07:04:30' 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 07:04:30' 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 07:04:30' 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 07:04:30' 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 = 'fa_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.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 2024
0.0028  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72728) 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.0031  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 (72728) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (206116,326208,427681,474838,711855,838122,246526,276437,293923,3728,68716,126886,139482,192089,209959,247614,287241,312464,353087,366112) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 2024
0.0025  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72728) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0026  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 (72728) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (205025,372642,443554,919213,27125,42921,46887,70617,86046,100786,137949,138775,191340,199600,204722,209557,209897,244140,245174,247614) ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 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 (72728) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0029  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 (72728) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (47562,100786,193747,209874,251613,292534,303500,304210,318871,372642,373673,427682,455592,557566,588357,693114,839573,889241,900917,978557) ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 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 (72728) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0026  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 (72728) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (69174,106034,191712,274722,335442,346982,428278,518770,878191,879202,30654,38717,44129,67022,70617,118827,205651,206428,214957,243396) ORDER BY rp.in_squad = 1 DESC
0.1187  SELECT SUM(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.category_id = 139 AND rp.year = 2024 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.1805  SELECT SUM(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.category_id = 139 AND rp.year = 2024 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0048  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=72728 AND rel.round=9
0.0019  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 = 72728 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
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 = 72728 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` = 72728 ORDER BY creation_date DESC LIMIT 0, 10
0.0028  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` = 72728
0.0077  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` = 72728 AND c.`round` = 9 ORDER BY c.type ASC,((c.team1*c.team1)+(c.team2*c.team2)) ASC,shedule ASC LIMIT 200
0.0071  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 = 72728 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 (641029,641030,664071,635967,635968,635773,635781,664068,635779,635776,635794,635785,635791,635786,636465,642846,641032,641031,664070,646209,664067,635772,635774,664072,635775,635777,662753,635778,635780,664066,635782,635783,635784,635787,635788,635789,635790,635792,635793,664069) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0028  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 = 9 AND e.real_date IS NOT NULL AND e.league_id = 72728 ORDER BY total DESC LIMIT 40
0.0026  SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 72728 AND shedule >= '2024/01/01' AND shedule < '2024/02/01' ORDER BY shedule ASC
0.0018  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 = 72728 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=139
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=139 AND year=2024