4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Partidos Viernes, 29 Marzo 2024 IR AL LIVESCORE
00:01  Descanso Rosario Central
0-2
Barracas Central 257
01:00  en 1 min Instituto
01:00
Argentinos Juniors 41
22:00  en 21 h Tigre
22:00
Belgrano 11
22:00  en 21 h Defensa Justicia
22:00
Estudiantes Plata 6
23:00  en 22 h Alianza FC
23:00
Deportes Tolima 3
00:30  ► 27' O'Higgins
0-1
Deportes Iquique 54
16:30  en 15 h Cerro Largo
16:30
Racing Montevideo 2
20:00  en 19 h Peñarol
20:00
Nacional 19
19:00  en 18 h Guillermo Brown
19:00
Talleres Escalada 0
23:05  en 22 h Argentino
23:05
Quilmes 0
01:00  en 1 min Blooming
01:00
Aurora 17
22:00  en 21 h Unión San Felipe
22:00
Deportes Limache 0
API
  • Resultados de fútbol donde tú quieras
¿Quieres tener los datos de Resultados-Fútbol en tu web?
Ahora puedes hacerlo
de la forma mas sencilla
ya hemos servido 16.538.528.408 peticiones este mes desde nuestra API
Partidos destacados
Estadio Franz Horr (Generali Arena)
29/03/2024 - 19:30
LIGAS / COMPETICIONES
Nombre Datos
LIGAS
ar Copa Liga Profesional Ar. 12/14 Ahora
ar Primera Nacional 9/38 Ahora
ar Primera B 10/21 Ahora
ar Torneo Federal A Transic. 4 gr Ahora
ar Primera C - Apertura 9/25 Ahora
ar Divisiones Inferiores Ar. 2 gr Ahora
ar Primera A Femenino - Arg. 2 gr Ahora
aw Liga Aruba 3 gr Ahora
bo Primera Bolivia - Apertu. 7/8 Ahora
br Campeonato Brasileiro Fe. 4/15 Ahora
bz Liga Belice - Clausura 11/14 En 2 días
cl Primera Chile 6/30 Ahora
cl Primera B Chile 6/30 Ahora
cl Segunda Chile 5/26 Ahora
cl Tercera A Chile 1/14 Ahora
co Apertura Colombia 14/19 Ahora
co Apertura Primera B Colom. 9/16 Ahora
co Liga Profesional Femenin. 5/15 Ahora
cr Primera Costa Rica - Cla. 14/22 Ahora
cr Ascenso Costa Rica - Cla. 17/18 Ahora
do Liga Dominicana de Fútbo. 3/21 Ahora
ec Serie A - Primera Etapa 6/15 Ahora
ec Serie B - Ecuador 3/36 Ahora
gf Liga Guayana Francesa 20/26 Ahora
gp Liga Guadalupe 23/30 Ahora
gt Liga Guatemala - Clausur. 13/16 Ahora
gt Primera Guatemala - Clau. 15/16 Ahora
gy Superliga Guyana 1/3 Ahora
hn Liga Honduras - Clausura 11/18 Ahora
jm Liga Jamaica 25/26 Ahora
kn Liga San Cristóbal y Nie. 5/18 Ahora
ky Liga Islas Caimán 11/14 Ahora
mq Liga Martinica 20/26 Ahora
mx Liga MX - Clausura 13/17 Ahora
mx Liga de Expansión MX - C. 13/15 Ahora
mx Liga Premier Serie A 2 gr Ahora
mx Liga de Balompié Mexican. 6/10 Ahora
mx Liga MX Sub 23 - Clausur. 13/17 Ahora
mx Liga MX Femenil - Clausu. 13/17 Ahora
mx Liga MX Sub 18 - Clausur. 13/17 Ahora
mx Liga MX Sub 16 - Clausur. 16/18 Ahora
mx Liga MX Sub 14 - Clausur. 14/18 Ahora
pa LPF Panamá - Apertura 10/16 Ahora
pa Liga de Ascenso Panamá -. 2 gr Ahora
pe Perú - Liga 1 Fase 1 9/17 Ahora
pe Perú - Liga 2 2 gr Ahora
py Apertura Paraguay 11/22 Ahora
py Paraguay - Intermedia 1/30 Ahora
sv Clausura Primera El Salv. 14/22 Ahora
tt Professional League Trin. 17/22 Ahora
us MLS - Liga USA 6/36 Ahora
us USL Championship - USA 3/34 Ahora
us USL League One 3/22 Ahora
us NISA 3/27 Ahora
us NPSL - USA 4 gr Ahora
us NWSL 1/8 Ahora
us MLS Next Pro 3/30 Ahora
uy Apertura Uruguay 6/15 Ahora
uy Segunda Uruguay 3/7 Ahora
ve Apertura Venezuela 10/15 Ahora
COMPETICIONES
ar Copa Argentina 1/6 Ahora
ar Copa Proyección 6/14 Ahora
br Carioca 2 gr Ahora
br Brasiliense 2/2 Ahora
br Catarinense 1 3/3 Ahora
br Pernambucano 1 3/3 Ahora
br Mineiro 1 3 gr Ahora
br Baiano 1 2/2 Ahora
br Tocantinense 2/2 Ahora
br Piauiense 2/2 Ahora
br Alagoano 2/2 Ahora
br Matogrossense 3/3 Ahora
br Cearense 1 2 gr Ahora
br Amapaense 6/7 Ahora
br Acreano 2 gr Ahora
br Potiguar 3 gr Ahora
br Sul-Matogrossense 2/3 Ahora
br Rondoniense 6/10 Ahora
br Paraibano 1/2 Ahora
br Roraimense 2 gr Ahora
br Copa Verde 3/5 Ahora
br Paulista A3 1/3 Ahora
br Goiano Sub 20 5/11 Ahora
br Paranaense Sub 20 4 gr Ahora
br Baiano Sub 20 3/14 Ahora
br Catarinense Sub 20 2/22 Ahora
br Goiano Sub 17 5/11 Ahora
br Paranaense Sub 17 4/10 Ahora
br Cearense Sub 17 5/13 Ahora
br Gaucho Sub 17 2/7 Ahora
br Copa Rio Sub 17 3/11 Ahora
co Copa Colombia 2/7 Ahora
mx Liga Premier Serie B 27/30 Ahora
n2 Kings League Américas 7/11 Ahora
n1 CONCACAF Champions Cup 2/5 Ahora
n2 Copa Libertadores 8 gr Ahora
n2 Conmebol Sudamericana 8 gr Ahora
us US Open Cup 2/8 Ahora
uy Copa Uruguay 8/9 Ahora
wo Clasificación Mundial Su. 6/18 Ahora
us Copa SheBelieves 1/2 Ahora
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  
9,889,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Home / Index )  5.1825
Total Execution Time  5.1834
  CADENA URL  
/futbol_america
  GET DATOS  
$_GET['/futbol_america']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (122)  
0.0113  SELECT a.*,fa.last_activity,fa.user_name,fa.karma FROM activity a INNER JOIN fa_user fa ON fa.id = a.userId INNER JOIN fa_user_profile fap ON fap.id = a.userId WHERE fap.publicActivity = 1 ORDER BY datetime DESC LIMIT 0,14
0.0109  SELECT url,page_views,page_title,last_page_views FROM rf_statcounter_popular_pages ORDER BY page_views DESC LIMIT 10
0.0109  SELECT url,page_views,page_title,last_page_views FROM rf_statcounter_popular_pages ORDER BY page_views DESC LIMIT 10,10
0.0108  SELECT url,page_views,page_title,last_page_views FROM rf_statcounter_popular_pages ORDER BY page_views DESC LIMIT 20,10
0.0113  SELECT hits,page_url,keyword FROM rf_statcounter_keyword_recent WHERE type = '15m' ORDER BY hits DESC LIMIT 20
0.0106  SELECT hits,page_url,keyword FROM rf_statcounter_keyword_recent WHERE type = '1h' ORDER BY hits DESC LIMIT 20
0.0106  SELECT hits,page_url,keyword FROM rf_statcounter_keyword_recent WHERE type = '1d' ORDER BY hits DESC LIMIT 20
0.0485  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories c ON c.id = l.categoryId WHERE dt.main_image = 1 AND c.troncal = 1 AND l.year=c.active_year AND c.continent = 'am' GROUP BY t.teamId ORDER BY c.coefficient*dt.relations DESC LIMIT 30
0.0211  SELECT z.name,z.alias,c.CountryCode,SUM(c.coefficient) as cuenta FROM categories c INNER JOIN leagues l ON l.categoryId = c.id INNER JOIN zones z ON z.location = c.CountryCode WHERE c.continent = 'am' AND c.troncal = 1 AND c.active_year = l.year AND l.total_num_matchs = l.total_num_matchsR GROUP BY c.CountryCode ORDER BY cuenta DESC LIMIT 40
1.2076   SELECT n.title, n.alias, rel.valor, rel.player_id, rel.official_budget, rel.budget_type, rel.date, dp.nick, dp.role, dp.alias as player_alias, dp.id as player_id, dt1.nameShow as nameShow1, dt1.basealias as basealias1, dt1.id as datateam1, dt2.nameShow as nameShow2, dt2.basealias as basealias2, dt2.id as datateam2 FROM rel_budgets AS rel INNER JOIN dataplayers AS dp ON dp.id=rel.player_id INNER JOIN datateams AS dt1 ON rel.origin_team_id=dt1.id INNER JOIN datateams AS dt2 ON rel.destination_team_id=dt2.id INNER JOIN news AS n ON n.id=rel.new_id WHERE rel.cover=1 and rel.active=1 and rel.certified=1 ORDER BY rel.id DESC LIMIT 7
1.5434  SELECT SUM(total) AS total FROM api_requests_stats WHERE creation_date > NOW() - INTERVAL 1 MONTH
0.0129  (SELECT p.last_pub_date,p.content_type,p.id,p.title,p.body,p.author_id,p.pub_date,p.votes_up,p.creation_date,p.karma,p.alias,p.totalcomments,p.picture_content_id,p.video_content_id,u.user_name,pic.author_id as pauthor_id,v.author_id as vauthor_id,0 as post,t.title as title_c,t.alias alias_c,t.total as total_c,'' as blog_name,'' as blog_alias,'' as followers FROM `news` AS p INNER JOIN rel_news rn ON rn.type=5 AND rn.id_new = p.id INNER JOIN topics t ON t.id = rn.id_content INNER JOIN `fa_user` AS u ON u.id = p.author_id LEFT JOIN `pictures` as pic ON p.picture_content_id = pic.id LEFT JOIN `videos` as v ON p.video_content_id = v.id WHERE p.creation_date > '2024-03-25' AND p.cover = 1 and p.revised != 2 GROUP BY p.id) UNION (SELECT p.last_pub_date,p.content_type,p.id,p.title,p.body,p.author_id,p.pub_date,p.votes_up,p.creation_date,p.karma,p.alias,p.totalcomments,p.picture_content_id,p.video_content_id,u.user_name,pic.author_id as pauthor_id,v.author_id as vauthor_id,1 as post,'' as title_c,'' as alias_c,'' as total_c,b.name as blog_name,b.alias as blog_alias,b.followers FROM `blog_posts` AS p INNER JOIN blogs b ON b.id = p.blog_id INNER JOIN `fa_user` AS u ON u.id = p.author_id LEFT JOIN `pictures` as pic ON p.picture_content_id = pic.id LEFT JOIN `videos` as v ON p.video_content_id = v.id WHERE p.creation_date > '2024-03-25' AND p.cover = 1 GROUP BY p.id) ORDER BY pub_date DESC,totalcomments DESC LIMIT 0, 14
0.5710   SELECT u.user_name, u.karma, u.last_activity, u.changeA, c.comment, c.last_update, c.creation_date, c.url, c.author_name, c.id, c.votes_up, c.votes_down, c.author_id, NOW() as difference_time, c.video_content_id, c.picture_content_id, c.new_content_id, c.post_content_id, c.league_id, c.playerId, c.match_id FROM comments AS c INNER JOIN fa_user_mini AS u ON c.author_id=u.id WHERE c.comment_id=0 AND c.active=1 AND lang='1' AND device='web' AND c.last_update > NOW() - INTERVAL 7 DAY ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0, 12
0.0105  SELECT id, year FROM leagues WHERE id IN (1899,1078,278,967)
0.0105   SELECT c.id, c.league_id, dt1.nameShow AS team1_name, dt2.nameShow AS team2_name, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.extra FROM calendars2012 AS c INNER JOIN datateams AS dt1 ON c.datateam1=dt1.id INNER JOIN datateams AS dt2 ON c.datateam2=dt2.id WHERE c.id IN (145968)
0.0106   SELECT c.id, c.league_id, dt1.nameShow AS team1_name, dt2.nameShow AS team2_name, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.extra FROM calendars2010 AS c INNER JOIN datateams AS dt1 ON c.datateam1=dt1.id INNER JOIN datateams AS dt2 ON c.datateam2=dt2.id WHERE c.id IN (93884,72287)
0.0105   SELECT c.id, c.league_id, dt1.nameShow AS team1_name, dt2.nameShow AS team2_name, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.extra FROM calendars2009 AS c INNER JOIN datateams AS dt1 ON c.datateam1=dt1.id INNER JOIN datateams AS dt2 ON c.datateam2=dt2.id WHERE c.id IN (8988)
0.0107  SELECT id, comment_id, comment, author_name, author_id, votes_up, COUNT(id) AS responses FROM comments WHERE comment_id IN (1661161,385181,25348,157254) GROUP BY comment_id
0.0138  SELECT z.name,z.alias,cat.location,SUM(cat.coefficient) as coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars_all as c ON c.league_id = l.id LEFT JOIN zones z ON z.location = cat.location WHERE cat.continent = 'am' AND c.date = '2024-03-29' GROUP BY cat.location ORDER BY coefficient DESC
0.0128  SELECT z.name as zname,z.alias as zalias,cat.location,l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars_all as c ON c.league_id = l.id LEFT JOIN zones z ON z.location = cat.location WHERE cat.continent = 'am' AND c.date = '2024-03-29' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 100
0.0162  (SELECT l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments,c.betId,c.penaltis1,c.penaltis2,c.prorroga,c.status,c.minute,c.finished FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2025 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE cat.continent = 'am' AND c.shedule >= '2024-03-29 00:00:00' AND c.shedule < '2024-03-29 23:59:59' GROUP BY c.id) UNION (SELECT l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments,c.betId,c.penaltis1,c.penaltis2,c.prorroga,c.status,c.minute,c.finished FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE cat.continent = 'am' AND c.shedule >= '2024-03-29 00:00:00' AND c.shedule < '2024-03-29 23:59:59' GROUP BY c.id) ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0157  (SELECT l.year,cat.coefficient,c.id as mid,c.r1,c.r2,c.shedule,l.id,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2025 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE cat.continent = 'am' AND c.shedule >= '2024-03-29 00:00:00' AND c.shedule < '2024-03-29 23:59:59' GROUP BY c.id) UNION (SELECT l.year,cat.coefficient,c.id as mid,c.r1,c.r2,c.shedule,l.id,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE cat.continent = 'am' AND c.shedule >= '2024-03-29 00:00:00' AND c.shedule < '2024-03-29 23:59:59' GROUP BY c.id) ORDER BY coefficient DESC,shedule ASC LIMIT 100,200
0.0156  (SELECT c.id,rel.media_id,rel.data,c.shedule FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2025 as c ON c.league_id = l.id INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.team2 = c.team2 AND (rel.media_id < 90000 OR rel.media_id = 99001) INNER JOIN media AS med ON rel.media_id=med.id WHERE (med.lang='es' OR med.language='spanish') AND cat.continent = 'am' AND c.shedule >= '2024-03-29 00:00:00' AND c.shedule < '2024-03-29 23:59:59') UNION (SELECT c.id,rel.media_id,rel.data,c.shedule FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.team2 = c.team2 AND (rel.media_id < 90000 OR rel.media_id = 99001) INNER JOIN media AS med ON rel.media_id=med.id WHERE (med.lang='es' OR med.language='spanish') AND cat.continent = 'am' AND c.shedule >= '2024-03-29 00:00:00' AND c.shedule < '2024-03-29 23:59:59') ORDER BY shedule ASC
0.0111  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (152639687,152639662,152639701,152639681,152720941,152639713,153037521,153037526,153036012,153036014,152720939,152720941,153082589,152639803,152956233) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0106  SELECT * FROM calendars_all WHERE shedule>NOW()+INTERVAL 1 DAY AND shedule<NOW()+INTERVAL 1 MONTH AND extra_coefficient>5 ORDER BY extra_coefficient DESC, shedule ASC LIMIT 3
0.0107  SELECT update_date FROM editor_stats ORDER BY update_date DESC LIMIT 1
0.0372  SELECT ct.location AS location,DAY( c.`shedule`) as day, cr.Name AS name, COUNT(ct.coefficient) as coefficient FROM `calendars_all` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` INNER JOIN country AS cr ON cr.Code2=UPPER(ct.location) WHERE ct.continent = 'am' AND c.`shedule` > '2024-03-28 11:28:31' AND c.`shedule` < '2024-03-29 11:28:31' GROUP BY ct.location,DAY( c.`shedule`) ORDER BY DAY( c.`shedule`) = 29 DESC,coefficient DESC,location ASC
0.1172  SELECT ct.location AS location,DAY( c.`shedule`) as day FROM `calendars_all` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` INNER JOIN country AS cr ON cr.Code2=UPPER(ct.location) WHERE ct.continent = 'am' AND c.`shedule` >= '2024-03-28 00:00:00' AND c.`shedule` <= '2024-03-30 23:59:59' GROUP BY ct.location,DAY( c.`shedule`) ORDER BY DAY( c.`shedule`) = 29 DESC, ct.coefficient DESC,location ASC
0.0131  SELECT c.id, l.year AS year, (IF(l.tables = 1 AND (t1.points + t2.points >0), (t1.points + t2.points)/(IF(l.current_round-1 > 0,l.current_round-1,1)*6) * ct.coefficient, 0.9 * ct.coefficient) + (IF(c.comments>1000,200,c.comments*0.2)) + (IF(c.`shedule`> '2024-03-28 23:13:31' AND c.`shedule`< '2024-03-29 01:43:31' AND c.r1<90 AND c.r2<90 ,ct.coefficient*2,0)))*((1-ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())/86400)) as fcoef FROM `calendars_all` 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 AND t1.league_id = c.league_id LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round AND t2.league_id = c.league_id WHERE ct.continent = 'am' AND c.`shedule` > '2024-03-28 11:28:31' AND c.`shedule` < '2024-03-29 11:28:31' AND (c.r1<99 OR c.shedule>='2024-03-28 22:58:31') GROUP BY c.id ORDER BY fcoef DESC LIMIT 9
0.0116  SELECT c.*, l.year, cat.id AS categoryId, cat.name, ds.name AS stadium, ds.name AS stadium_name, c.stadium AS real_stadium, ds.seats, ds.yearBuilt, ds.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,179.6185 as fcoef 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=t1.teamId AND rs.active=1 LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id WHERE c.id = 658408
0.0107  SELECT rel.media_id,c.id FROM calendars2024 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 658408 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0105  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 74880 AND id_match = 658408
0.0109  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='74880' AND relp.team_id = drea.team_id WHERE rel.team_number=5301001 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0109  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='74880' AND relp.team_id = drea.team_id WHERE rel.team_number=5300991 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0109   SELECT *, pl.nick AS player_name FROM events2024 AS ev INNER JOIN dataplayers as pl ON ev.player_id=pl.id WHERE ev.team1id = 6623590 AND ev.team2id = 6623602 AND ev.league_id = 74880 AND ( ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13 OR ev.action = 3 OR ev.action = 4 OR ev.action = 20 ) ORDER BY ev.minute ASC
0.0120  SELECT c.*, l.year, cat.id AS categoryId, cat.name, ds.name AS stadium, ds.name AS stadium_name, c.stadium AS real_stadium, ds.seats, ds.yearBuilt, ds.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,106.0328 as fcoef 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=t1.teamId AND rs.active=1 LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id WHERE c.id = 673154
0.0107  SELECT rel.media_id,c.id FROM calendars2024 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 673154 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0106  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 75067 AND id_match = 673154
0.0109  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='75067' AND relp.team_id = drea.team_id WHERE rel.team_number=5301015 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0111  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='75067' AND relp.team_id = drea.team_id WHERE rel.team_number=5301000 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0110   SELECT *, pl.nick AS player_name FROM events2024 AS ev INNER JOIN dataplayers as pl ON ev.player_id=pl.id WHERE ev.team1id = 6626480 AND ev.team2id = 6626476 AND ev.league_id = 75067 AND ( ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13 OR ev.action = 3 OR ev.action = 4 OR ev.action = 20 ) ORDER BY ev.minute ASC
0.0129  SELECT c.*, l.year, cat.id AS categoryId, cat.name, ds.name AS stadium, ds.name AS stadium_name, c.stadium AS real_stadium, ds.seats, ds.yearBuilt, ds.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,78.0192 as fcoef 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=t1.teamId AND rs.active=1 LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id WHERE c.id = 673149
0.0110  SELECT rel.media_id,c.id FROM calendars2024 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 673149 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0112  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 75067 AND id_match = 673149
0.0122  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='75067' AND relp.team_id = drea.team_id WHERE rel.team_number=5300976 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0109  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='75067' AND relp.team_id = drea.team_id WHERE rel.team_number=5300977 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0111   SELECT *, pl.nick AS player_name FROM events2024 AS ev INNER JOIN dataplayers as pl ON ev.player_id=pl.id WHERE ev.team1id = 6626472 AND ev.team2id = 6626474 AND ev.league_id = 75067 AND ( ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13 OR ev.action = 3 OR ev.action = 4 OR ev.action = 20 ) ORDER BY ev.minute ASC
0.0126  SELECT c.*, l.year, cat.id AS categoryId, cat.name, ds.name AS stadium, ds.name AS stadium_name, c.stadium AS real_stadium, ds.seats, ds.yearBuilt, ds.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,77.8707 as fcoef 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=t1.teamId AND rs.active=1 LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id WHERE c.id = 703874
0.0111  SELECT rel.media_id,c.id FROM calendars2024 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 703874 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0109  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 74999 AND id_match = 703874
0.0141  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='74999' AND relp.team_id = drea.team_id WHERE rel.team_number=5300968 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0139  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='74999' AND relp.team_id = drea.team_id WHERE rel.team_number=5300970 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0139   SELECT *, pl.nick AS player_name FROM events2024 AS ev INNER JOIN dataplayers as pl ON ev.player_id=pl.id WHERE ev.team1id = 6625391 AND ev.team2id = 6625386 AND ev.league_id = 74999 AND ( ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13 OR ev.action = 3 OR ev.action = 4 OR ev.action = 20 ) ORDER BY ev.minute ASC
0.0175  SELECT c.*, l.year, cat.id AS categoryId, cat.name, ds.name AS stadium, ds.name AS stadium_name, c.stadium AS real_stadium, ds.seats, ds.yearBuilt, ds.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,40.2657 as fcoef 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=t1.teamId AND rs.active=1 LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id WHERE c.id = 691472
0.0115  SELECT rel.media_id,c.id FROM calendars2024 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 691472 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0109  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 75089 AND id_match = 691472
0.0124  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='75089' AND relp.team_id = drea.team_id WHERE rel.team_number=5301014 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0120  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='75089' AND relp.team_id = drea.team_id WHERE rel.team_number=5300995 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0116   SELECT *, pl.nick AS player_name FROM events2024 AS ev INNER JOIN dataplayers as pl ON ev.player_id=pl.id WHERE ev.team1id = 6626787 AND ev.team2id = 6626790 AND ev.league_id = 75089 AND ( ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13 OR ev.action = 3 OR ev.action = 4 OR ev.action = 20 ) ORDER BY ev.minute ASC
0.0151  SELECT c.*, l.year, cat.id AS categoryId, cat.name, ds.name AS stadium, ds.name AS stadium_name, c.stadium AS real_stadium, ds.seats, ds.yearBuilt, ds.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,39.4205 as fcoef 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=t1.teamId AND rs.active=1 LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id WHERE c.id = 658405
0.0111  SELECT rel.media_id,c.id FROM calendars2024 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 658405 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0108  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 74880 AND id_match = 658405
0.0130  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='74880' AND relp.team_id = drea.team_id WHERE rel.team_number=5301013 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0122  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='74880' AND relp.team_id = drea.team_id WHERE rel.team_number=5301012 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0119   SELECT *, pl.nick AS player_name FROM events2024 AS ev INNER JOIN dataplayers as pl ON ev.player_id=pl.id WHERE ev.team1id = 6623603 AND ev.team2id = 6623583 AND ev.league_id = 74880 AND ( ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13 OR ev.action = 3 OR ev.action = 4 OR ev.action = 20 ) ORDER BY ev.minute ASC
0.0167  SELECT c.*, l.year, cat.id AS categoryId, cat.name, ds.name AS stadium, ds.name AS stadium_name, c.stadium AS real_stadium, ds.seats, ds.yearBuilt, ds.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,30.6318 as fcoef 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=t1.teamId AND rs.active=1 LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id WHERE c.id = 643144
0.0113  SELECT rel.media_id,c.id FROM calendars2024 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 643144 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0111  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 74629 AND id_match = 643144
0.0127  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='74629' AND relp.team_id = drea.team_id WHERE rel.team_number=5300998 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0133  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='74629' AND relp.team_id = drea.team_id WHERE rel.team_number=5300999 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0122   SELECT *, pl.nick AS player_name FROM events2024 AS ev INNER JOIN dataplayers as pl ON ev.player_id=pl.id WHERE ev.team1id = 6619854 AND ev.team2id = 6619859 AND ev.league_id = 74629 AND ( ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13 OR ev.action = 3 OR ev.action = 4 OR ev.action = 20 ) ORDER BY ev.minute ASC
0.0172  SELECT c.*, l.year, cat.id AS categoryId, cat.name, ds.name AS stadium, ds.name AS stadium_name, c.stadium AS real_stadium, ds.seats, ds.yearBuilt, ds.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,26.1713 as fcoef 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=t1.teamId AND rs.active=1 LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id WHERE c.id = 717325
0.0109  SELECT rel.media_id,c.id FROM calendars2024 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 717325 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0106  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 75560 AND id_match = 717325
0.0108  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='75560' AND relp.team_id = drea.team_id WHERE rel.team_number=5301002 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0109  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='75560' AND relp.team_id = drea.team_id WHERE rel.team_number=5301007 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0110   SELECT *, pl.nick AS player_name FROM events2024 AS ev INNER JOIN dataplayers as pl ON ev.player_id=pl.id WHERE ev.team1id = 6634073 AND ev.team2id = 6634075 AND ev.league_id = 75560 AND ( ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13 OR ev.action = 3 OR ev.action = 4 OR ev.action = 20 ) ORDER BY ev.minute ASC
0.0120  SELECT c.*, l.year, cat.id AS categoryId, cat.name, ds.name AS stadium, ds.name AS stadium_name, c.stadium AS real_stadium, ds.seats, ds.yearBuilt, ds.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,25.9238 as fcoef 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=t1.teamId AND rs.active=1 LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id WHERE c.id = 687896
0.0107  SELECT rel.media_id,c.id FROM calendars2024 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 687896 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0106  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 75125 AND id_match = 687896
0.0115  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='75125' AND relp.team_id = drea.team_id WHERE rel.team_number=5300913 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0118  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='75125' AND relp.team_id = drea.team_id WHERE rel.team_number=5300953 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0112   SELECT *, pl.nick AS player_name FROM events2024 AS ev INNER JOIN dataplayers as pl ON ev.player_id=pl.id WHERE ev.team1id = 6627397 AND ev.team2id = 6627390 AND ev.league_id = 75125 AND ( ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13 OR ev.action = 3 OR ev.action = 4 OR ev.action = 20 ) ORDER BY ev.minute ASC
0.0218  SELECT l.id FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE c.continent='am' AND c.troncal = 1 AND l.year = c.active_year ORDER BY l.start_date<'2024-04-13' AND l.end_date>='2024-03-14' DESC,l.total_num_matchs = l.total_num_matchsR DESC,l.group_code>0 DESC,c.coefficient DESC,l.group_code ASC LIMIT 12
0.0108  SELECT l.id FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id AND l.current_round = c.round WHERE l.status = 1 AND c.r1 < 95 AND c.r2 < 95 AND c.shedule > '2024-03-28 21:38' AND (0 OR l.id = 74880 OR l.id = 74881 OR l.id = 74955 OR l.id = 74856 OR l.id = 75067 OR l.id = 75068 OR l.id = 74956 OR l.id = 75057 OR l.id = 74958 OR l.id = 75125 OR l.id = 73350 OR l.id = 73351) AND c.shedule < '2024-03-29 00:58' GROUP BY l.id ORDER BY cat.coefficient DESC,l.group_code ASC LIMIT 12
0.0110  SELECT l.id FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2009 as c ON c.league_id = l.id AND l.current_round = c.round WHERE l.status = 1 AND c.r1 > 95 AND c.r2 > 95 AND (0 OR l.id = 74880 OR l.id = 74881 OR l.id = 74955 OR l.id = 74856 OR l.id = 75067 OR l.id = 75068 OR l.id = 74956 OR l.id = 75057 OR l.id = 74958 OR l.id = 75125 OR l.id = 73350 OR l.id = 73351) AND c.shedule != '2024/03/29 00:00:00' AND c.shedule != '2024/03/29 00:00:00' AND c.shedule > '2024/03/29 00:58' AND c.shedule < '2024/03/29 12:55' GROUP BY l.id ORDER BY cat.coefficient DESC,l.group_code ASC LIMIT 12
0.0107  SELECT l.year,c.alias,c.name,l.group_code,l.id,l.current_round,l.total_group,c.location,c.CountryCode FROM `leagues` as l INNER JOIN `categories` as c ON c.id = l.categoryId WHERE l.year = c.active_year AND (0 OR l.id = 74880 OR l.id = 74881 OR l.id = 74955 OR l.id = 74856 OR l.id = 75067 OR l.id = 75068 OR l.id = 74956 OR l.id = 75057 OR l.id = 74958 OR l.id = 75125 OR l.id = 73350 OR l.id = 73351) ORDER BY l.total_num_matchs = l.total_num_matchsR DESC,l.group_code>0 DESC,c.coefficient DESC,l.group_code ASC
0.0107  SELECT c.id as mid,c.r1,c.r2,c.shedule,c.datateam1,c.datateam2,c.team1,c.round,c.team2,l.year,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE l.status = 1 AND c.round >= 12 AND c.round <= 13 AND c.league_id = 74880 ORDER BY c.shedule ASC
0.0106  SELECT c.id,rel.media_id,rel.data,c.round FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.team2 = c.team2 AND (rel.media_id < 90000 OR rel.media_id = 99001) WHERE rel.language = 'spanish' AND l.status = 1 AND c.round >= 12 AND c.round <= 13 AND c.league_id = 74880 ORDER BY c.shedule ASC
0.0106  SELECT c.id,rel.team_id,c.round FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.league_id = l.id AND l.id = 74880 WHERE l.status = 1 AND c.round >= 12 AND c.round <= 13
0.0111  SELECT lm.action_name,lm.creation_date,lm.dt1,lm.dt2,c.CountryCode,lm.minute,c.coefficient,c.top,dt1.basealias as basealias1,dt2.basealias as basealias2 FROM live_matches lm INNER JOIN leagues l ON lm.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId INNER JOIN datateams dt1 ON dt1.id = lm.dt1 INNER JOIN datateams dt2 ON dt2.id = lm.dt2 WHERE c.continent = 'am' AND lm.creation_date > '2024-03-28 23:58:32' ORDER BY lm.creation_date DESC LIMIT 20
0.0305  SELECT l.id FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE c.active_year = l.year AND c.continent = 'am' ORDER BY c.coefficient
0.0165  SELECT c.troncal,l.id,c.name,l.group_code,l.total_group,c.location,c.CountryCode,c.logo,l.current_round,l.start_date,l.end_date,l.total_rounds,l.next_shedule,c.alias,l.categoryId FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.start_date<'2024-04-08' AND l.end_date >'2024-04-03' AND c.active_year = l.year AND c.continent = 'am' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.location ASC,c.coefficient DESC
0.0109  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-03-28' AND categoryId = 1724
0.0109  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-03-28' AND categoryId = 2896
0.0106  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-03-28' AND categoryId = 1909
0.0106  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-03-28' AND categoryId = 1546
0.0106  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-03-28' AND categoryId = 2163
0.0110  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-03-28' AND categoryId = 1445
0.0113  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-03-28' AND categoryId = 193
0.0106  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-03-28' AND categoryId = 2038
0.0106  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-03-28' AND categoryId = 556
0.0106  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-03-28' AND categoryId = 567
0.0106  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-03-28' AND categoryId = 568
0.0105  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-03-28' AND categoryId = 1729
0.0106  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-03-28' AND categoryId = 580
0.0109  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-03-28' AND categoryId = 1752
0.0109  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-03-28' AND categoryId = 2657
0.0111  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-03-28' AND categoryId = 204
0.0106  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-03-28' AND categoryId = 304
0.0527  SELECT c.troncal,l.id,c.name,l.group_code,l.total_group,c.location,c.CountryCode,c.logo,l.current_round,l.start_date,l.end_date,l.total_rounds,l.next_shedule,c.alias,l.categoryId FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.end_date <'2024-04-03' AND c.active_year = l.year AND c.continent = 'am' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.location ASC,c.coefficient DESC
0.0404  SELECT c.troncal,l.id,c.name,l.group_code,l.total_group,c.location,c.CountryCode,c.logo,l.current_round,l.start_date,l.end_date,l.total_rounds,l.next_shedule,c.alias,l.categoryId FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.start_date >'2024-04-03' AND c.active_year = l.year AND c.continent = 'am' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.location ASC,c.coefficient DESC
0.0106  SELECT MIN(start_date) as start_date FROM leagues WHERE start_date > '2024-03-28' AND categoryId = 512
0.0106  SELECT MIN(start_date) as start_date FROM leagues WHERE start_date > '2024-03-28' AND categoryId = 671
0.0106  SELECT MIN(start_date) as start_date FROM leagues WHERE start_date > '2024-03-28' AND categoryId = 1752
0.0107  SELECT MIN(start_date) as start_date FROM leagues WHERE start_date > '2024-03-28' AND categoryId = 561
0.0107  SELECT MIN(start_date) as start_date FROM leagues WHERE start_date > '2024-03-28' AND categoryId = 1727
0.0106  SELECT MIN(start_date) as start_date FROM leagues WHERE start_date > '2024-03-28' AND categoryId = 2149
0.0109  SELECT MIN(start_date) as start_date FROM leagues WHERE start_date > '2024-03-28' AND categoryId = 177
0.0117  SELECT MIN(start_date) as start_date FROM leagues WHERE start_date > '2024-03-28' AND categoryId = 204
0.0107  SELECT MIN(start_date) as start_date FROM leagues WHERE start_date > '2024-03-28' AND categoryId = 304
0.0107  SELECT MIN(start_date) as start_date FROM leagues WHERE start_date > '2024-03-28' AND categoryId = 124