4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Partidos Domingo, 21 Abril 2024 IR AL LIVESCORE
14:00  en 13 h Getafe
14:00
Real Sociedad 49
16:15  en 15 h Almería
16:15
Villarreal 27
18:30  en 17 h Deportivo Alavés
18:30
Atlético 102
21:00  en 20 h Real Madrid
21:00
Barcelona 2771
14:30  en 13 h Everton
14:30
Nottingham Forest 16
16:00  en 15 h Aston Villa
16:00
AFC Bournemouth 26
16:00  en 15 h Crystal Palace
16:00
West Ham 16
17:30  en 16 h Fulham
17:30
Liverpool 37
12:30  en 11 h Sassuolo
12:30
Lecce 16
15:00  en 14 h Torino
15:00
Frosinone 8
18:00  en 17 h Salernitana
18:00
Fiorentina 10
20:45  en 20 h AC Monza
20:45
Atalanta 15
16:30  en 15 h Coventry City
16:30
Manchester United 45
14:00  en 13 h Espanyol
14:00
FC Andorra 34
16:15  en 15 h Eibar
16:15
Alcorcón 57
16:15  en 15 h Eldense
16:15
Albacete 61
18:30  en 17 h Mirandés
18:30
Burgos 97
15:30  en 14 h Werder Bremen
15:30
Stuttgart 16
17:30  en 16 h B. Dortmund
17:30
B. Leverkusen 57
19:30  en 18 h SC Freiburg
19:30
Mainz 05 13
15:00  en 14 h Lille
15:00
Strasbourg 15
15:00  en 14 h Stade de Reims
15:00
Montpellier 4
15:00  en 14 h Le Havre
15:00
Metz 4
17:05  en 16 h Stade Brestois
17:05
Monaco 6
19:00  en 18 h Toulouse
19:00
Olympique 7
21:00  en 20 h PSG
21:00
Olympique Lyonnais 22
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 17.780.282.644 peticiones este mes desde nuestra API
Partidos destacados
Stadio Georgios Karaiskakis
21/04/2024 - 19:30
Stadio Harilaou Kleánthis Vikelídis
21/04/2024 - 18:30
Netanya Stadium
21/04/2024 - 18:00
Dimotiko Athlitiko Kentro Lamias
21/04/2024 - 16:00
Petah Tikva Municipal
21/04/2024 - 19:15
LIGAS / COMPETICIONES
Nombre Datos
LIGAS
es Primera División 32/38 Ahora
gb Premier League 33/38 Ahora
it Serie A 33/38 Ahora
es Segunda División 36/42 Ahora
de Bundesliga 30/34 Ahora
fr Ligue 1 30/34 Ahora
es Primera Federación 2 gr Ahora
pt Liga Portuguesa 30/34 Ahora
nl Eredivisie 30/34 Ahora
es Segunda Federación 5 gr Ahora
br Liga Brasileña 3/38 Ahora
nl Eerste Divisie 35/38 Ahora
es Primera Femenina 24/30 Ahora
cat Liga Élite Catalana 26/30 Ahora
and Primera Andaluza 8 gr Ahora
gb Premier League 2 One 19/20 Ahora
mx Liga MX Femenil - Clausu. 15/17 Ahora
es de Honor 7 gr Ahora
es Liga Nacional 17 gr Ahora
co Liga Profesional Femenin. 8/15 Ahora
COMPETICIONES
ue Champions League 8 gr Ahora
ue Europa League 8 gr Ahora
ue Conference League 8 gr Ahora
n2 Copa Libertadores 8 gr Ahora
ue Champions League Femenin. 2/3 Ahora
ue Clasificación Europeo Su. 9 gr Ahora
n2 Conmebol Sudamericana 8 gr Ahora
wo Amistosos Selecciones 73/84 En 40 días
ue Clasificación Eurocopa F. 3 gr Ahora
es Copa de la Reina 7/7 En 26 días
wo Amistosos Selecciones Su. 3/12 Ahora
wo Amistosos Selecciones Su. 4/12 Ahora
wo Amistosos Selecciones Fe. 10/100 Ahora
wo Amistosos Selecciones Su. 4/12 Ahora
wo Amistosos Selecciones No. 4/5 Ahora

  USO DE MEMORIA  
11,629,512 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0008
Controller Execution Time ( Home / Index )  6.2233
Total Execution Time  6.2241
  CADENA URL  
No hay datos de URL
  GET DATOS  
$_GET['/']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (153)  
0.0116  SELECT l.id,l.group_code,l.total_group,l.current_round,l.year,c.alias,c.name,l.categoryId,l.tables FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.categoryId = 136 AND l.year = 2014 AND l.group_code >= 1 ORDER BY l.group_code ASC
0.0108  SELECT t.gf,t.ga,t.points,t.round,t.team,t.round,tea.teamId,dt.nameShow,dt.short_name,dt.basealias FROM tables2014 t INNER JOIN teams tea ON tea.id = t.team INNER JOIN datateams dt ON dt.id = tea.teamId WHERE t.round = 3 AND t.league_id = 3381 ORDER BY t.round ASC, t.points DESC, cast(t.gf as signed) - cast(t.ga as signed) DESC, t.ga DESC
0.0107  SELECT t.gf,t.ga,t.points,t.round,t.team,t.round,tea.teamId,dt.nameShow,dt.short_name,dt.basealias FROM tables2014 t INNER JOIN teams tea ON tea.id = t.team INNER JOIN datateams dt ON dt.id = tea.teamId WHERE t.round = 3 AND t.league_id = 3382 ORDER BY t.round ASC, t.points DESC, cast(t.gf as signed) - cast(t.ga as signed) DESC, t.ga DESC
0.0107  SELECT t.gf,t.ga,t.points,t.round,t.team,t.round,tea.teamId,dt.nameShow,dt.short_name,dt.basealias FROM tables2014 t INNER JOIN teams tea ON tea.id = t.team INNER JOIN datateams dt ON dt.id = tea.teamId WHERE t.round = 3 AND t.league_id = 3384 ORDER BY t.round ASC, t.points DESC, cast(t.gf as signed) - cast(t.ga as signed) DESC, t.ga DESC
0.0109  SELECT t.gf,t.ga,t.points,t.round,t.team,t.round,tea.teamId,dt.nameShow,dt.short_name,dt.basealias FROM tables2014 t INNER JOIN teams tea ON tea.id = t.team INNER JOIN datateams dt ON dt.id = tea.teamId WHERE t.round = 3 AND t.league_id = 3385 ORDER BY t.round ASC, t.points DESC, cast(t.gf as signed) - cast(t.ga as signed) DESC, t.ga DESC
0.0108  SELECT t.gf,t.ga,t.points,t.round,t.team,t.round,tea.teamId,dt.nameShow,dt.short_name,dt.basealias FROM tables2014 t INNER JOIN teams tea ON tea.id = t.team INNER JOIN datateams dt ON dt.id = tea.teamId WHERE t.round = 3 AND t.league_id = 3386 ORDER BY t.round ASC, t.points DESC, cast(t.gf as signed) - cast(t.ga as signed) DESC, t.ga DESC
0.0107  SELECT t.gf,t.ga,t.points,t.round,t.team,t.round,tea.teamId,dt.nameShow,dt.short_name,dt.basealias FROM tables2014 t INNER JOIN teams tea ON tea.id = t.team INNER JOIN datateams dt ON dt.id = tea.teamId WHERE t.round = 3 AND t.league_id = 3387 ORDER BY t.round ASC, t.points DESC, cast(t.gf as signed) - cast(t.ga as signed) DESC, t.ga DESC
0.0107  SELECT t.gf,t.ga,t.points,t.round,t.team,t.round,tea.teamId,dt.nameShow,dt.short_name,dt.basealias FROM tables2014 t INNER JOIN teams tea ON tea.id = t.team INNER JOIN datateams dt ON dt.id = tea.teamId WHERE t.round = 3 AND t.league_id = 3388 ORDER BY t.round ASC, t.points DESC, cast(t.gf as signed) - cast(t.ga as signed) DESC, t.ga DESC
0.0106  SELECT t.gf,t.ga,t.points,t.round,t.team,t.round,tea.teamId,dt.nameShow,dt.short_name,dt.basealias FROM tables2014 t INNER JOIN teams tea ON tea.id = t.team INNER JOIN datateams dt ON dt.id = tea.teamId WHERE t.round = 3 AND t.league_id = 3389 ORDER BY t.round ASC, t.points DESC, cast(t.gf as signed) - cast(t.ga as signed) DESC, t.ga DESC
0.0109  SELECT t.id,dt.nameShow,dt.basealias,dt.short_name,t.teamId,t.league_id,dt.location FROM teams t INNER JOIN datateams dt ON dt.id = t.teamId WHERE t.league_id IN (3381,3382,3384,3385,3386,3387,3388,3389) ORDER BY dt.pod DESC
0.0107  SELECT team_id,league_id,txt FROM rel_teams_text WHERE team_id IN (64694,64709,64702,64698,64696,64693,64695,64701,64699,64715,64700,64705,64697,64708,64707,64712,64706,64724,64704,64720,64723,64718,64721,64711,64722,64703,64717,64716,64713,64710,64714,64719) AND type = 1
0.0375  SELECT dp.age,dp.role,rel.id,dp.nick,rel.team_id,rel.league_id,rel.squadNumber,dp.last_name,dp.name,dp.alias,dp.birthdate,rel.player_id FROM rel_players rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_id IN (64694,64709,64702,64698,64696,64693,64695,64701,64699,64715,64700,64705,64697,64708,64707,64712,64706,64724,64704,64720,64723,64718,64721,64711,64722,64703,64717,64716,64713,64710,64714,64719) ORDER BY dp.qod DESC
0.0112  SELECT c.team1,c.team2,c.finished,c.minute,c.prorroga,c.status,c.r1,c.r2,c.penaltis1,c.penaltis2,c.round,c.shedule,c.league_id,c.datateam1,c.datateam2,c.comments,c.extra, dt1.basealias AS basealias1, dt2.basealias AS basealias2, dt1.nameShow AS nameShow1, dt2.nameShow as nameShow2,dt1.short_name as short_name1,dt2.short_name as short_name2 FROM calendars2014 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id IN (3381,3382,3384,3385,3386,3387,3388,3389) ORDER BY c.shedule ASC
0.0111  SELECT c.codematch,c.team1,c.team2,c.finished,c.minute,c.prorroga,c.status,c.r1,c.r2,c.penaltis1,c.penaltis2,c.round,c.shedule,c.league_id,c.datateam1,c.datateam2,c.comments,c.extra, dt1.basealias AS basealias1, dt2.basealias AS basealias2, dt1.nameShow AS nameShow1, dt2.nameShow as nameShow2,dt1.short_name as short_name1,dt2.short_name as short_name2 FROM calendars2014 c INNER JOIN leagues l ON c.league_id=l.id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE l.categoryId=136 AND l.group_code=0 AND c.codematch>=1 ORDER BY c.codematch ASC
0.0168  SELECT total FROM totals ORDER BY id ASC
0.0108  SELECT g.name,g.id,g.members FROM groups g ORDER BY g.members DESC LIMIT 0,12
0.0109  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.0107  SELECT gt.*,fa.user_name ,fa.changeA FROM g_totals gt INNER JOIN fa_user fa ON fa.id = gt.userId WHERE fa.language = "spanish" ORDER BY current ASC LIMIT 0,3
0.0109  SELECT url,page_views,page_title,last_page_views FROM rf_statcounter_popular_pages ORDER BY page_views DESC LIMIT 10
0.0106  SELECT url,page_views,page_title,last_page_views FROM rf_statcounter_popular_pages ORDER BY page_views DESC LIMIT 10,10
0.0106  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.0108  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.0659  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 z.level=1 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
0.0107  SELECT fau.id,fau.user_name,fau.changeA FROM user_stats us INNER JOIN fa_user fau ON fau.id = us.id WHERE fau.language = "spanish" AND fau.active = 1 AND fau.banned = 0 ORDER BY fau.karma DESC LIMIT 15
0.0105  SELECT id,user_name,changeA FROM fa_user WHERE language = "spanish" ORDER BY id DESC LIMIT 15
1.3022   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.6974  SELECT SUM(total) AS total FROM api_requests_stats WHERE creation_date > NOW() - INTERVAL 1 MONTH
0.0117  SELECT fau.id,fau.user_name,stats.points as cuenta, fau.changeA FROM fa_user as fau INNER JOIN editor_stats as stats ON stats.id = fau.id WHERE fau.language = 'spanish' AND fau.active = 1 AND fau.banned_editor = 0 AND fau.banned = 0 ORDER BY stats.points DESC LIMIT 5
0.0130  (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-04-17' 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-04-17' AND p.cover = 1 GROUP BY p.id) ORDER BY pub_date DESC,totalcomments DESC LIMIT 0, 14
0.0250  (SELECT 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-04-17' GROUP BY p.id) UNION (SELECT 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-04-17' GROUP BY p.id) ORDER BY creation_date>='2024-04-20' DESC,karma DESC LIMIT 0, 14
0.0144  (SELECT 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-04-17' GROUP BY p.id) UNION (SELECT 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-04-17' GROUP BY p.id) ORDER BY creation_date>='2024-04-20' DESC,creation_date>='2024-04-20' DESC,karma DESC LIMIT 0, 14
0.3776   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 1 DAY ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0, 12
0.0104  SELECT id, year FROM leagues WHERE id IN (39)
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 calendars2004 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 (684)
0.0105  SELECT id, comment_id, comment, author_name, author_id, votes_up, COUNT(id) AS responses FROM comments WHERE comment_id IN (921235) GROUP BY comment_id
0.0792   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-04-21 00:00:00' AND c.`shedule` < '2024-04-21 23:59:59' ORDER BY fcoef DESC LIMIT 5
0.0117   SELECT c.*,l.year,cat.id as categoryId,cat.name,s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id as dt1id,dt2.id as dt2id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments as totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId = dt1.id AND rs.active = 1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 709863
0.0118   SELECT c.*,l.year,cat.id as categoryId,cat.name,s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id as dt1id,dt2.id as dt2id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments as totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId = dt1.id AND rs.active = 1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 709862
0.0120   SELECT c.*,l.year,cat.id as categoryId,cat.name,s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id as dt1id,dt2.id as dt2id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments as totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId = dt1.id AND rs.active = 1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 721551
0.0119   SELECT c.*,l.year,cat.id as categoryId,cat.name,s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id as dt1id,dt2.id as dt2id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments as totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId = dt1.id AND rs.active = 1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 709861
0.0120   SELECT c.*,l.year,cat.id as categoryId,cat.name,s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id as dt1id,dt2.id as dt2id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments as totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId = dt1.id AND rs.active = 1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 721552
0.0299  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 c.date = '2024-04-21' GROUP BY cat.location ORDER BY coefficient DESC
0.0262  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 c.date = '2024-04-21' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 100
0.0861  (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 c.shedule >= '2024-04-21 00:00:00' AND c.shedule < '2024-04-21 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 c.shedule >= '2024-04-21 00:00:00' AND c.shedule < '2024-04-21 23:59:59' GROUP BY c.id) ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0869  (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 c.shedule >= '2024-04-21 00:00:00' AND c.shedule < '2024-04-21 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 c.shedule >= '2024-04-21 00:00:00' AND c.shedule < '2024-04-21 23:59:59' GROUP BY c.id) ORDER BY coefficient DESC,shedule ASC LIMIT 100,200
0.0447  (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 c.shedule >= '2024-04-21 00:00:00' AND c.shedule < '2024-04-21 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 c.shedule >= '2024-04-21 00:00:00' AND c.shedule < '2024-04-21 23:59:59') ORDER BY shedule ASC
0.0125  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (153234082,153234084,153234086,153234088,153233573,153233576,153233582,153233590,153234234,153234249,153234252,153234262,152643891,153783028,153783032,153783030,153783035,153233809,153233811,153233814,153234319,153234321,153234324,153234327,153234330,154214721,154214730,153751896,153751971,153751902,153751900,153751907,153783091,153783079,153783089,153783081,153783085,153783093,153783095,153783073,153783071,153783069,153791144,153791146,153791149,153791152,153234443,153234445,153234447,153234449,153782637,153783642,153783648,153783651,153783655,153194494,154100377,154126514,153791109) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0105  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.1753  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 c.`shedule` > '2024-04-20 11:00:29' AND c.`shedule` < '2024-04-21 11:00:29' GROUP BY ct.location,DAY( c.`shedule`) ORDER BY DAY( c.`shedule`) = 21 DESC,coefficient DESC,location ASC
0.3384  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 c.`shedule` >= '2024-04-20 00:00:00' AND c.`shedule` <= '2024-04-22 23:59:59' GROUP BY ct.location,DAY( c.`shedule`) ORDER BY DAY( c.`shedule`) = 21 DESC, ct.coefficient DESC,location ASC
0.0400  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-04-20 22:45:29' AND c.`shedule`< '2024-04-21 01:15:29' 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 c.`shedule` > '2024-04-20 11:00:29' AND c.`shedule` < '2024-04-21 11:00:29' AND (c.r1<99 OR c.shedule>='2024-04-20 22:30:29') GROUP BY c.id ORDER BY fcoef DESC LIMIT 9
0.0117  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,208.1885 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 = 721524
0.0106  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 = 721524 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0105  SELECT r.showName FROM calendars2024 as c INNER JOIN referees as r ON c.referee = r.id WHERE c.team1 = 6635498 AND c.team2 = 6635501 AND c.league_id = 75691 LIMIT 1
0.0105  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 75691 AND id_match = 721524
0.0112  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='75691' AND relp.team_id = drea.team_id WHERE rel.team_number=5350330 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='75691' AND relp.team_id = drea.team_id WHERE rel.team_number=5350310 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0110   SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` WHERE mp.`match_id` = '721524' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` 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 = 6635498 AND ev.team2id = 6635501 AND ev.league_id = 75691 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.0118  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,196.3802 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 = 715417
0.0108  SELECT c.*, l.year, cat.id AS categoryId, cat.name, ds.name AS stadium, 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,196.3802 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 datastadiums ds ON ds.id=c.stadium WHERE c.id = 715417
0.0106  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 = 715417 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0106  SELECT r.showName FROM calendars as c INNER JOIN referees as r ON c.referee = r.id WHERE c.team1 = AND c.team2 = AND c.league_id = LIMIT 1
0.0120  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = AND id_match =
0.0106   SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` WHERE mp.`match_id` = '' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0109   SELECT *, pl.nick AS player_name FROM events AS ev INNER JOIN dataplayers as pl ON ev.player_id=pl.id WHERE ev.team1id = AND ev.team2id = AND ev.league_id = 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.0107  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,189.0041 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 = 727168
0.0123  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 = 727168 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0124  SELECT r.showName FROM calendars2024 as c INNER JOIN referees as r ON c.referee = r.id WHERE c.team1 = 6637281 AND c.team2 = 6637282 AND c.league_id = 75862 LIMIT 1
0.0130  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 75862 AND id_match = 727168
0.0126  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='75862' AND relp.team_id = drea.team_id WHERE rel.team_number=5350180 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0175  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='75862' AND relp.team_id = drea.team_id WHERE rel.team_number=5349986 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0116   SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` WHERE mp.`match_id` = '727168' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` 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 = 6637281 AND ev.team2id = 6637282 AND ev.league_id = 75862 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.0113  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,182.6113 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 = 721525
0.0139  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 = 721525 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0130  SELECT r.showName FROM calendars2024 as c INNER JOIN referees as r ON c.referee = r.id WHERE c.team1 = 6635496 AND c.team2 = 6635499 AND c.league_id = 75691 LIMIT 1
0.0130  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 75691 AND id_match = 721525
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='75691' AND relp.team_id = drea.team_id WHERE rel.team_number=5349712 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0178  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='75691' AND relp.team_id = drea.team_id WHERE rel.team_number=5349677 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0114   SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` WHERE mp.`match_id` = '721525' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` 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 = 6635496 AND ev.team2id = 6635499 AND ev.league_id = 75691 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.0115  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,170.6074 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 = 651195
0.0133  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 = 651195 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0152  SELECT r.showName FROM calendars2024 as c INNER JOIN referees as r ON c.referee = r.id WHERE c.team1 = 6624804 AND c.team2 = 6624808 AND c.league_id = 74955 LIMIT 1
0.0114  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 74955 AND id_match = 651195
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='74955' AND relp.team_id = drea.team_id WHERE rel.team_number=5350694 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0152  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='74955' AND relp.team_id = drea.team_id WHERE rel.team_number=5350706 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0109   SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` WHERE mp.`match_id` = '651195' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0105   SELECT *, pl.nick AS player_name FROM events2024 AS ev INNER JOIN dataplayers as pl ON ev.player_id=pl.id WHERE ev.team1id = 6624804 AND ev.team2id = 6624808 AND ev.league_id = 74955 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.0105  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,169.3021 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 = 727381
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 = 727381 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0117  SELECT r.showName FROM calendars2024 as c INNER JOIN referees as r ON c.referee = r.id WHERE c.team1 = 6637353 AND c.team2 = 6637354 AND c.league_id = 75870 LIMIT 1
0.0112  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 75870 AND id_match = 727381
0.0112  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='75870' AND relp.team_id = drea.team_id WHERE rel.team_number=5350743 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0145  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='75870' AND relp.team_id = drea.team_id WHERE rel.team_number=5350737 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0119   SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` WHERE mp.`match_id` = '727381' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` 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 = 6637353 AND ev.team2id = 6637354 AND ev.league_id = 75870 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.0122  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,163.1648 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 = 12957
0.0145  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 = 12957 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0144  SELECT r.showName FROM calendars2024 as c INNER JOIN referees as r ON c.referee = r.id WHERE c.team1 = 6578403 AND c.team2 = 6578394 AND c.league_id = 71849 LIMIT 1
0.0120  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 71849 AND id_match = 12957
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='71849' AND relp.team_id = drea.team_id WHERE rel.team_number=5350554 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0129  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='71849' AND relp.team_id = drea.team_id WHERE rel.team_number=5350400 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0110   SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` WHERE mp.`match_id` = '12957' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0107   SELECT *, pl.nick AS player_name FROM events2024 AS ev INNER JOIN dataplayers as pl ON ev.player_id=pl.id WHERE ev.team1id = 6578403 AND ev.team2id = 6578394 AND ev.league_id = 71849 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.0107  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,139.0212 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 = 30562
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 = 30562 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0109  SELECT r.showName FROM calendars2024 as c INNER JOIN referees as r ON c.referee = r.id WHERE c.team1 = 6583650 AND c.team2 = 6583646 AND c.league_id = 72116 LIMIT 1
0.0110  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30562
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='72116' AND relp.team_id = drea.team_id WHERE rel.team_number=5350065 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0117  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='72116' AND relp.team_id = drea.team_id WHERE rel.team_number=5350673 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0107   SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` WHERE mp.`match_id` = '30562' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0105   SELECT *, pl.nick AS player_name FROM events2024 AS ev INNER JOIN dataplayers as pl ON ev.player_id=pl.id WHERE ev.team1id = 6583650 AND ev.team2id = 6583646 AND ev.league_id = 72116 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.0105  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,130.5612 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 = 721526
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 = 721526 AND rel.language = 'spanish' GROUP BY rel.media_id
0.0109  SELECT r.showName FROM calendars2024 as c INNER JOIN referees as r ON c.referee = r.id WHERE c.team1 = 6635497 AND c.team2 = 6635500 AND c.league_id = 75691 LIMIT 1
0.0110  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 75691 AND id_match = 721526
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='75691' AND relp.team_id = drea.team_id WHERE rel.team_number=5349680 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0961  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='75691' AND relp.team_id = drea.team_id WHERE rel.team_number=5349969 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0107   SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` WHERE mp.`match_id` = '721526' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0108   SELECT *, pl.nick AS player_name FROM events2024 AS ev INNER JOIN dataplayers as pl ON ev.player_id=pl.id WHERE ev.team1id = 6635497 AND ev.team2id = 6635500 AND ev.league_id = 75691 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.0107  SELECT l.id FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND l.year = c.active_year ORDER BY l.start_date<'2024-05-06' AND l.end_date>='2024-04-06' 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.0110  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-04-20 21:10' AND (0 OR l.id = 72116 OR l.id = 71849 OR l.id = 72044 OR l.id = 72177 OR l.id = 72031 OR l.id = 72046 OR l.id = 74880 OR l.id = 74881 OR l.id = 72358 OR l.id = 72359 OR l.id = 74955 OR l.id = 72053) AND c.shedule < '2024-04-21 00:30' GROUP BY l.id ORDER BY cat.coefficient DESC,l.group_code ASC LIMIT 12
0.0105  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 = 72116 OR l.id = 71849 OR l.id = 72044 OR l.id = 72177 OR l.id = 72031 OR l.id = 72046 OR l.id = 74880 OR l.id = 74881 OR l.id = 72358 OR l.id = 72359 OR l.id = 74955 OR l.id = 72053) AND c.shedule != '2024/04/21 00:00:00' AND c.shedule != '2024/04/21 00:00:00' AND c.shedule > '2024/04/21 00:30' AND c.shedule < '2024/04/21 12:27' GROUP BY l.id ORDER BY cat.coefficient DESC,l.group_code ASC LIMIT 12
0.0105  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 = 72116 OR l.id = 71849 OR l.id = 72044 OR l.id = 72177 OR l.id = 72031 OR l.id = 72046 OR l.id = 74880 OR l.id = 74881 OR l.id = 72358 OR l.id = 72359 OR l.id = 74955 OR l.id = 72053) ORDER BY l.total_num_matchs = l.total_num_matchsR DESC,l.group_code>0 DESC,c.coefficient DESC,l.group_code ASC
0.0105  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 >= 32 AND c.round <= 33 AND c.league_id = 72116 ORDER BY c.shedule ASC
0.0105  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30554
0.0106  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30559
0.0105  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30558
0.0105  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30562
0.0105  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30557
0.0105  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30556
0.0105  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30561
0.0105  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30555
0.0105  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 29273
0.0106  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30560
0.0106  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30568
0.0108  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30570
0.0109  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30569
0.0109  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30565
0.0107  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30563
0.0107  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30564
0.0105  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30567
0.0112  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30571
0.0108  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 29271
0.0106  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30566
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 >= 32 AND c.round <= 33 AND c.league_id = 72116 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 = 72116 WHERE l.status = 1 AND c.round >= 32 AND c.round <= 33
0.0106  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.coefficient >= 10 AND lm.creation_date > '2024-04-21 00:20:30' ORDER BY lm.creation_date DESC LIMIT 20