4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
MLS - Liga USA 2019
2018/2019

MLS - Liga USA 2019

  • New York City
  • Atlanta United
  • Philadelphia Union
  • DC United
  • New York RB
  • Toronto FC
  • New England Revolution
  • Chicago Fire
  • CF Montréal
  • Orlando City
  • Columbus Crew
  • Cincinnati
  • Los Angeles FC
  • Minnesota United
  • Seattle Sounders
  • LA Galaxy
  • Real Salt Lake
  • FC Dallas
  • Portland Timbers
  • San Jose Earthquakes
  • Colorado Rapids
  • Houston Dynamo
  • Sporting Kansas City
  • Vancouver Whitecaps

MLS - Liga USA 2019

La temporada finalizó el Domingo, 06 Octubre 2019.
22 Sep 19
02:30 Finalizado
Houston Dynamo Houston Dynamo 2-1 Orlando City Orlando City más información Jugadas destacadas Vídeos del Houston Dynamo-Orlando City 4
0-1 6' D. Dwyer
70' A. Elis 1-1
73' C. Ramirez 2-1
22 Sep 19
02:30 Finalizado
Sporting Kansas City Sporting Kansas City 2-3 Colorado Rapids Colorado Rapids más información Jugadas destacadas Vídeos del Sporting Kansas City-Colorado Rapids 15
3' Gerso 1-0
14' Tommy Smith
20' M. Besler
2-1 42' K. Kamara
2-2 76' D. Rubio
2-3 85' Tommy Smith
22 Sep 19
04:30 Finalizado
LA Galaxy LA Galaxy 2-1 CF Montréal CF Montréal más información Jugadas destacadas Vídeos del LA Galaxy-CF Montréal 8
31' Z. Ibrahimovic 1-0
1-1 48' L. Lappalainen
50' Uriel Antuna 2-1
22 Sep 19
04:30 Finalizado
Los Angeles FC Los Angeles FC 1-1 Toronto FC Toronto FC más información Jugadas destacadas Vídeos del Los Angeles FC-Toronto FC 24
0-1 19' T. Endoh
90' C. Vela 1-1
22 Sep 19
21:55 Finalizado
Portland Timbers Portland Timbers 0-0 Minnesota United Minnesota United más información 15
23 Sep 19
00:00 Finalizado
FC Dallas FC Dallas 1-1 New York City New York City más información Jugadas destacadas Vídeos del FC Dallas-New York City 25
0-1 1' Taty Castellanos
66' Z. Ondrasek 1-1
23 Sep 19
00:30 Finalizado
New York RB New York RB 2-0 Philadelphia Union Philadelphia Union más información Jugadas destacadas Vídeos del New York RB-Philadelphia Union 12
32' T. Barlow 1-0
90' D. Royer 2-0
23 Sep 19
02:00 Finalizado
DC United DC United 2-0 Seattle Sounders Seattle Sounders más información Jugadas destacadas Vídeos del DC United-Seattle Sounders 13
14' L. Rodríguez 1-0
54' F. Brillant 2-0
26 Sep 19
01:00 Finalizado
New York City New York City 4-1 Atlanta United Atlanta United más información Jugadas destacadas Vídeos del New York City-Atlanta United 39
14' A. Mitrita 1-0
23' A. Mitrita 2-0
34' A. Mitrita 3-0
43' M. Moralez
3-1 53' Pity Martínez
87' Heber 4-1
26 Sep 19
02:00 Finalizado
Minnesota United Minnesota United 2-1 Sporting Kansas City Sporting Kansas City más información Jugadas destacadas Vídeos del Minnesota United-Sporting Kansas City 22
0-1 7' B. Baráth
70' O. Alonso 1-1
90' H. Dotson 2-1
90' Chase Gasper
Conferencia del Este Puntos J. G. E. P. F. C.
1 New York City New York City 61 32 17 10 5 61 39
  • VICTORIA
  • New York City 2
  • New England Revolu. 1
  • EMPATE
  • New York City 1
  • Toronto FC 1
  • VICTORIA
  • New York City 2
  • San Jose Earthquak. 1
  • EMPATE
  • FC Dallas 1
  • New York City 1
  • VICTORIA
  • New York City 4
  • Atlanta United 1
2 Atlanta United Atlanta United 54 32 17 3 12 54 41
  • DERROTA
  • Philadelphia Union 3
  • Atlanta United 1
  • DERROTA
  • Atlanta United 1
  • Columbus Crew 3
  • VICTORIA
  • Cincinnati 0
  • Atlanta United 2
  • VICTORIA
  • Atlanta United 3
  • San Jose Earthquak. 1
  • DERROTA
  • New York City 4
  • Atlanta United 1
3 Philadelphia Union Philadelphia 52 31 15 7 9 55 45
  • DERROTA
  • Chicago Fire 2
  • Philadelphia Union 0
  • VICTORIA
  • Philadelphia Union 3
  • DC United 1
  • VICTORIA
  • Philadelphia Union 3
  • Atlanta United 1
  • EMPATE
  • Philadelphia Union 1
  • Los Angeles FC 1
  • DERROTA
  • New York RB 2
  • Philadelphia Union 0
4 DC United DC United 48 32 13 9 10 42 38
  • DERROTA
  • DC United 1
  • New York RB 2
  • DERROTA
  • Philadelphia Union 3
  • DC United 1
  • VICTORIA
  • CF Montréal 0
  • DC United 3
  • VICTORIA
  • Portland Timbers 0
  • DC United 1
  • VICTORIA
  • DC United 2
  • Seattle Sounders 0
5 New York RB New York RB 47 32 14 5 13 53 48
  • DERROTA
  • New York City 2
  • New York RB 1
  • DERROTA
  • New York RB 0
  • Colorado Rapids 2
  • DERROTA
  • Seattle Sounders 4
  • New York RB 2
  • VICTORIA
  • Portland Timbers 0
  • New York RB 2
  • VICTORIA
  • New York RB 2
  • Philadelphia Union 0
6 Toronto FC Toronto FC 46 32 12 10 10 54 50
  • EMPATE
  • New England Revolu. 1
  • Toronto FC 1
  • VICTORIA
  • Cincinnati 1
  • Toronto FC 5
  • EMPATE
  • New York City 1
  • Toronto FC 1
  • VICTORIA
  • Toronto FC 3
  • Colorado Rapids 2
  • EMPATE
  • Los Angeles FC 1
  • Toronto FC 1
7 New England Revolution England 41 31 10 11 10 45 52
  • VICTORIA
  • New England Revolu. 2
  • Chicago Fire 1
  • EMPATE
  • New England Revolu. 1
  • Toronto FC 1
  • DERROTA
  • New York City 2
  • New England Revolu. 1
  • EMPATE
  • Orlando City 3
  • New England Revolu. 3
  • EMPATE
  • New England Revolu. 0
  • Real Salt Lake 0
8 Chicago Fire Chicago Fire 38 32 9 11 12 48 43
  • VICTORIA
  • Chicago Fire 2
  • Philadelphia Union 0
  • DERROTA
  • New England Revolu. 2
  • Chicago Fire 1
  • EMPATE
  • Columbus Crew 1
  • Chicago Fire 1
  • VICTORIA
  • Chicago Fire 4
  • FC Dallas 0
  • EMPATE
  • Cincinnati 0
  • Chicago Fire 0
9 CF Montréal CF Montréal 37 32 11 4 17 43 59
  • DERROTA
  • Toronto FC 2
  • CF Montréal 1
  • VICTORIA
  • CF Montréal 2
  • Vancouver Whitecap. 1
  • DERROTA
  • CF Montréal 0
  • DC United 3
  • DERROTA
  • CF Montréal 0
  • Cincinnati 1
  • DERROTA
  • LA Galaxy 2
  • CF Montréal 1
10 Orlando City Orlando City 36 32 9 9 14 41 46
  • DERROTA
  • Orlando City 0
  • Atlanta United 1
  • DERROTA
  • San Jose Earthquak. 3
  • Orlando City 0
  • EMPATE
  • Orlando City 2
  • Los Angeles FC 2
  • EMPATE
  • Orlando City 3
  • New England Revolu. 3
  • DERROTA
  • Houston Dynamo 2
  • Orlando City 1
11 Columbus Crew Columbus Crew 35 32 9 8 15 37 46
  • DERROTA
  • New York City 1
  • Columbus Crew 0
  • VICTORIA
  • Cincinnati 1
  • Columbus Crew 3
  • EMPATE
  • Columbus Crew 1
  • Chicago Fire 1
  • VICTORIA
  • Atlanta United 1
  • Columbus Crew 3
  • EMPATE
  • Vancouver Whitecap. 1
  • Columbus Crew 1
12 Cincinnati Cincinnati 22 32 6 4 22 30 74
  • DERROTA
  • FC Dallas 3
  • Cincinnati 1
  • DERROTA
  • Cincinnati 1
  • Toronto FC 5
  • VICTORIA
  • CF Montréal 0
  • Cincinnati 1
  • DERROTA
  • Cincinnati 0
  • Atlanta United 2
  • EMPATE
  • Cincinnati 0
  • Chicago Fire 0
Conferencia del Oeste Puntos J. G. E. P. F. C.
1 Los Angeles FC Los Angeles FC 65 31 19 8 4 78 34
  • EMPATE
  • Los Angeles FC 3
  • LA Galaxy 3
  • DERROTA
  • Los Angeles FC 0
  • Minnesota United 2
  • EMPATE
  • Orlando City 2
  • Los Angeles FC 2
  • EMPATE
  • Philadelphia Union 1
  • Los Angeles FC 1
  • EMPATE
  • Los Angeles FC 1
  • Toronto FC 1
2 Minnesota United Minnesota United 52 32 15 7 10 51 41
  • VICTORIA
  • Los Angeles FC 0
  • Minnesota United 2
  • DERROTA
  • Houston Dynamo 2
  • Minnesota United 0
  • VICTORIA
  • Minnesota United 3
  • Real Salt Lake 1
  • EMPATE
  • Portland Timbers 0
  • Minnesota United 0
  • VICTORIA
  • Minnesota United 2
  • Sporting Kansas Ci. 1
3 Seattle Sounders Seattle Sounders 50 32 14 8 10 50 49
  • VICTORIA
  • Portland Timbers 1
  • Seattle Sounders 2
  • VICTORIA
  • Seattle Sounders 4
  • LA Galaxy 3
  • VICTORIA
  • Seattle Sounders 4
  • New York RB 2
  • EMPATE
  • Seattle Sounders 0
  • FC Dallas 0
  • DERROTA
  • DC United 2
  • Seattle Sounders 0
4 LA Galaxy LA Galaxy 48 31 15 3 13 51 50
  • EMPATE
  • Los Angeles FC 3
  • LA Galaxy 3
  • DERROTA
  • Seattle Sounders 4
  • LA Galaxy 3
  • DERROTA
  • Colorado Rapids 2
  • LA Galaxy 1
  • VICTORIA
  • LA Galaxy 7
  • Sporting Kansas Ci. 2
  • VICTORIA
  • LA Galaxy 2
  • CF Montréal 1
5 Real Salt Lake Real Salt Lake 47 31 14 5 12 42 38
  • VICTORIA
  • Real Salt Lake 2
  • Colorado Rapids 0
  • DERROTA
  • Portland Timbers 1
  • Real Salt Lake 0
  • VICTORIA
  • Real Salt Lake 1
  • San Jose Earthquak. 0
  • DERROTA
  • Minnesota United 3
  • Real Salt Lake 1
  • EMPATE
  • New England Revolu. 0
  • Real Salt Lake 0
6 FC Dallas FC Dallas 45 32 12 9 11 48 43
  • VICTORIA
  • FC Dallas 5
  • Houston Dynamo 1
  • VICTORIA
  • FC Dallas 3
  • Cincinnati 1
  • DERROTA
  • Chicago Fire 4
  • FC Dallas 0
  • EMPATE
  • Seattle Sounders 0
  • FC Dallas 0
  • EMPATE
  • FC Dallas 1
  • New York City 1
7 Portland Timbers Portland Timbers 44 31 13 5 13 45 44
  • VICTORIA
  • Portland Timbers 1
  • Real Salt Lake 0
  • VICTORIA
  • Portland Timbers 2
  • Sporting Kansas Ci. 1
  • DERROTA
  • Portland Timbers 0
  • DC United 1
  • DERROTA
  • Portland Timbers 0
  • New York RB 2
  • EMPATE
  • Portland Timbers 0
  • Minnesota United 0
8 San Jose Earthquakes Jose Earthquakes 44 31 13 5 13 50 49
  • VICTORIA
  • San Jose Earthquak. 3
  • Vancouver Whitecap. 1
  • VICTORIA
  • San Jose Earthquak. 3
  • Orlando City 0
  • DERROTA
  • Real Salt Lake 1
  • San Jose Earthquak. 0
  • DERROTA
  • New York City 2
  • San Jose Earthquak. 1
  • DERROTA
  • Atlanta United 3
  • San Jose Earthquak. 1
9 Colorado Rapids Colorado Rapids 39 32 11 6 15 54 60
  • DERROTA
  • Real Salt Lake 2
  • Colorado Rapids 0
  • VICTORIA
  • New York RB 0
  • Colorado Rapids 2
  • VICTORIA
  • Colorado Rapids 2
  • LA Galaxy 1
  • DERROTA
  • Toronto FC 3
  • Colorado Rapids 2
  • VICTORIA
  • Sporting Kansas Ci. 2
  • Colorado Rapids 3
10 Houston Dynamo Houston Dynamo 37 31 11 4 16 43 52
  • DERROTA
  • FC Dallas 5
  • Houston Dynamo 1
  • DERROTA
  • Sporting Kansas Ci. 1
  • Houston Dynamo 0
  • VICTORIA
  • Houston Dynamo 2
  • Minnesota United 0
  • DERROTA
  • Vancouver Whitecap. 2
  • Houston Dynamo 1
  • VICTORIA
  • Houston Dynamo 2
  • Orlando City 1
11 Sporting Kansas City Sporting Kansas 37 32 10 7 15 47 59
  • VICTORIA
  • Sporting Kansas Ci. 1
  • Houston Dynamo 0
  • DERROTA
  • Portland Timbers 2
  • Sporting Kansas Ci. 1
  • DERROTA
  • LA Galaxy 7
  • Sporting Kansas Ci. 2
  • DERROTA
  • Sporting Kansas Ci. 2
  • Colorado Rapids 3
  • DERROTA
  • Minnesota United 2
  • Sporting Kansas Ci. 1
12 Vancouver Whitecaps Vancouver 31 32 7 10 15 33 55
  • DERROTA
  • San Jose Earthquak. 3
  • Vancouver Whitecap. 1
  • DERROTA
  • CF Montréal 2
  • Vancouver Whitecap. 1
  • DERROTA
  • Vancouver Whitecap. 1
  • New York City 3
  • VICTORIA
  • Vancouver Whitecap. 2
  • Houston Dynamo 1
  • EMPATE
  • Vancouver Whitecap. 1
  • Columbus Crew 1
Series Finales : New York City, Los Angeles FC
Playoffs : Atlanta United, Philadelphia, DC United, New York RB, Toronto FC, England, Minnesota United, Seattle Sounders, LA Galaxy, Real Salt Lake, FC Dallas, Portland Timbers

La Major League Soccer (MLS) es la máxima división del fútbol en los Estados Unidos y Canadá. El torneo es organizado por la Federación de Fútbol de los Estados Unidos (U.S. Soccer), que es miembro de la FIFA.

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,129,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.1150
Total Execution Time  0.1184
  CADENA URL  
/usa2019/grupo1/jornada38
  GET DATOS  
$_GET['/usa2019/grupo1/jornada38']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0018  SELECT type FROM routes WHERE alias = 'usa2019'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'usa' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=69 AND type_rel = 3
0.0086  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 69 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 (1308425,1308316,1308292,1308200,1308181) ORDER BY n.cover_points DESC, update_date DESC
0.0021  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='2019' WHERE c.parentId=69 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 69 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 11:47:27' 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 11:47:27' 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 11:47:27' 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 11:47:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'usa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0025  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=48587 AND rel.round=38
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 = 48587 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 = 48587 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` = 48587 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` = 48587
0.0043  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 `calendars2019` 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` = 48587 AND c.`round` = 38 ORDER BY shedule ASC LIMIT 200
0.0053  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 events2019 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2019 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 48587 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 (351954,351955,351956,351957,351959,351958,351961,351960,351962,351963) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0050  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 `events2019` e INNER JOIN calendars2019 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 = 38 AND e.real_date IS NOT NULL AND e.league_id = 48587 ORDER BY total DESC LIMIT 40
0.0023  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 48587 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT distinct(shedule), round FROM `calendars2019` as c WHERE c.`league_id` = 48587 AND shedule >= '2019/09/01' AND shedule < '2019/10/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 = 48587 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=69
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=69 AND year=2019