4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Partidos Sábado, 04 Mayo 2024 IR AL LIVESCORE
14:00  en 4 h Real Sociedad
14:00
Las Palmas 52
16:15  en 7 h Real Madrid
16:15
Cádiz 287
18:30  en 9 h Girona
18:30
Barcelona 350
21:00  en 11 h Mallorca
21:00
Atlético 65
17:00  en 7 h Real Sociedad B
17:00
Celta Fortuna 7
18:00  en 8 h Barça Atlètic
18:00
SD Tarazona 18
18:00  en 8 h CD Teruel
18:00
Unionistas CF 20
18:00  en 8 h Sestao River
18:00
RC Deportivo 135
19:00  en 9 h Real Unión Club
19:00
Cultural Leonesa 30
20:00  en 10 h SD Logroñés
20:00
Fuenlabrada 10
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 18.606.591.473 peticiones este mes desde nuestra API
Partidos destacados
Fortuna Arena
04/05/2024 - 18:00
Stadio Comunale Di Cornaredo
04/05/2024 - 20:30
Stade De Genève
04/05/2024 - 18:00
Celtic Park
04/05/2024 - 16:00
LIGAS / COMPETICIONES
Nombre Datos
LIGAS
es Primera División 34/38 Hoy
es Segunda División 38/42 Ahora
es Primera Federación 2 gr Ahora
es Tercera Federación 18 gr Ahora
es Primera Futsal 29/30 Ahora
es Segunda Futsal 29/30 Ahora
es Primera Femenina 26/30 Ahora
leo C. León 2 gr Ahora
mur Murcia 32/34 Ahora
gal Galicia 2 gr Ahora
can Cantabria 32/34 Ahora
man C. La Mancha 3 gr Ahora
val Lliga Comunitat FFCV 2 gr Ahora
cat Liga Élite Catalana 28/30 Ahora
ara Aragón 2 gr Ahora
nav Autonómica Navarra 31/34 Ahora
pva Honor País Vasco 3 gr Ahora
ast Primera RFFPA 34/38 Ahora
ica Canarias 3 gr Ahora
mad Madrid 2 gr Ahora
rio La Rioja 5 gr Ahora
ES Ceuta 12/14 Ahora
bal Baleares 9 gr Ahora
ast Segunda RFFPA 2 gr Ahora
es Segunda B Futsal 6 gr Ahora
and Primera Andaluza 10 gr Ahora
gal Primera Galicia 5 gr Ahora
can 1ª Regional Cantabria 32/34 Ahora
cat Primera Catalana 3 gr Ahora
val Primera FFCV 4 gr Ahora
mur 1ª Regional Murcia 2 gr Ahora
ica 1ª Regional Canarias 6 gr Ahora
nav Regional Navarra 2 gr Ahora
ara 1ª Regional Aragón 4 gr Ahora
mad 1ª Regional Madrid 4 gr Ahora
leo 1ª Castilla y León 9 gr Ahora
and 2ª Andaluza Sevilla 2 gr Ahora
leo 2ª Castilla y León 4 gr Ahora
can 2ª Regional Cantabria 2 gr Ahora
val Segunda FFCV 8 gr Ahora
man 2ª Auto. Castilla-La Man. 6 gr Ahora
ara 2ª Regional Aragón 9 gr Ahora
gal Segunda Galicia 13 gr Ahora
es Segunda Femenino Futsal 3 gr Ahora
and 2ª Andaluza Cádiz 27/30 Ahora
es Primera Femenino Futsal 27/30 Ahora
mad 2ª Regional Madrid 8 gr Ahora
cat 2ª Catalana 6 gr Ahora
and 3ª Andaluza Granada 2 gr Ahora
leo 3ª Castilla y León 2 gr Ahora
mad 3ª Regional Madrid 20 gr Ahora
gal Tercera Galicia 17 gr Ahora
cat 3ª Catalana 18 gr Ahora
val Tercera FFCV 15 gr Ahora
and 3ª Andaluza Sevilla 5 gr Ahora
ara 2ª Regional B Aragón 31/34 Ahora
ara 3ª Regional Aragón 6 gr Ahora
cat 4ª Catalana 33 gr Ahora
gal Liga Gallega Juvenil 2 gr Ahora
and 4ª Andaluza Málaga Juven. 7 gr Ahora
and 2ª Andaluza Córdoba Juve. 29/30 Ahora
and 2ª Andaluza Sevilla Juve. 29/30 Ahora
leo 1ª Regional C. León Juve. 2 gr Ahora
pva Liga Vasca Juvenil 32/34 Ahora
cat Catalana Juvenil 4 gr Ahora
and 2ª Andaluza Almería Juve. 28/30 Ahora
and 2ª Andaluza Cádiz Juveni. 28/30 Ahora
cat Pref. Catalana Juvenil F. 28/30 Ahora
es Liga Nacional 17 gr Ahora
rio 1ª Juvenil La Rioja 24/26 Ahora
ara Aragón Juvenil 2 gr Ahora
ara 1ª Aragón Juvenil 2 gr Ahora
val Valencia Juvenil 4 gr Ahora
ast 1ª Asturias Juvenil 31/34 Ahora
and 3ª Andaluza Cádiz Juveni. 2 gr Ahora
cat 1ª Catalana Juvenil Feme. 2 gr Ahora
mad Madrid Juvenil Femenina 30/34 Ahora
mad 1ª Auto. Madrid Juvenil 18 gr Ahora
gal Liga Gallega Cadete 2 gr Ahora
leo 2ª Regional C. León Cade. 29/30 Ahora
leo 1ª Regional C. León Cade. 29/30 Ahora
nav Liga Navarra Cadete 33/34 Ahora
cat Honor Catalana Cadete 28/30 Ahora
and 2ª Andaluza Málaga Cadet. 28/30 Ahora
cat Catalana Cadete 4 gr Ahora
mad Honor Madrid Cadete 2 gr Ahora
val Valencia Cadete 4 gr Ahora
and 1ª Andaluza Cadete 2 gr Ahora
ara 1ª Aragón Cadete 2 gr Ahora
ara Honor Aragón Cadete 27/30 Ahora
and 4ª Andaluza Málaga Cadet. 9 gr Ahora
can 2ª Cantabria Cadete 30/34 Ahora
gal Honor Galicia Cadete 30/34 Ahora
pva Liga Vasca Cadete 30/34 Ahora
can 1ª Cantabria Cadete 30/34 Ahora
ast 1ª Asturias Cadete 26/30 Ahora
and de Honor Cadete Andaluza 27/30 Ahora
mad Superliga Madrid Cadete 27/30 Ahora
ast 2ª Asturias Cadete 2 gr Ahora
val Liga Auto. Valencia Cade. 29/34 Ahora
and 1ª Andaluza Cadete Femen. 24/29 Ahora
gal Liga Gallega Infantil 29/30 Ahora
leo 1ª Regional C. León Infa. 29/30 Ahora
leo 2ª Regional C. León Infa. 29/30 Ahora
es Tercera Federación Femen. 6 gr Ahora
cat Catalana Infantil Femeni. 28/30 Ahora
cat Honor Catalana Infantil 28/30 Ahora
can 1ª Cantabria Infantil 28/30 Ahora
cat Catalana Infantil 4 gr Ahora
can 2ª Cantabria Infantil 2 gr Ahora
and 2ª Andaluza Málaga Infan. 28/30 Ahora
and 4ª Andaluza Sevilla Infa. 13 gr Ahora
and de Honor Andaluza Infant. 27/30 Ahora
gal Honor Galicia Infantil 27/30 Ahora
and 3ª Andaluza Málaga Infan. 2 gr Ahora
cat 1ª Catalana Infantil Fem. 2 gr Ahora
and 1ª Andaluza Infantil 2 gr Ahora
val Valencia Infantil 4 gr Ahora
cat 1ª Catalana Infantil 27/30 Ahora
ast 2ª Asturias Infantil 2 gr Ahora
mad Superliga Madrid Infanti. 26/30 Ahora
mad Honor Madrid Infantil 2 gr Ahora
ast 1ª Asturias Infantil 26/30 Ahora
cat 2ª Catalana Infantil 2 gr Ahora
val Liga Auto. Valencia Infa. 29/34 Ahora
can 1ª Cantabria Juvenil 1/34 Ahora
and 1ª Andaluza Alevín 2 gr Ahora
and 2ª Andaluza Sevilla Alev. 2 gr Ahora
cat Catalana Alevin Sub 12 6 gr Ahora
cat Catalana Alevin Sub 11 6 gr Ahora
and 2ª Andaluza Málaga Aleví. 28/30 Ahora
cat 1ª Catalana Alevín Femen. 4 gr Ahora
and 3ª Andaluza Sevilla Alev. 5 gr Ahora
and 3ª Andaluza Málaga Aleví. 2 gr Ahora
cat 1ª Catalana Alevín Sub 1. 14 gr Ahora
mad Honor Madrid Alevín F7 24/26 Ahora
cat 2ª Catalana Alevin 5 gr Ahora
mad Honor Madrid Alevín F11 26/30 Ahora
mad Superliga Madrid Alevín 27/30 Ahora
and 2ª Andaluza Sevilla Benj. 2 gr Ahora
cat Catalana Benjamin Sub 9 6 gr Ahora
and 2ª Andaluza Málaga Benja. 28/30 Ahora
cat Catalana Benjamin Sub 10 6 gr Ahora
and 3ª Andaluza Málaga Benja. 2 gr Ahora
and 3ª Andaluza Sevilla Benj. 4 gr Ahora
mad 1ª Auto. Madrid Benjamín. 24/26 Ahora
and 3ª Andaluza Sevilla Preb. 3 gr Ahora
mad Madrid Cadete Femenino 26/30 Ahora
cat Pref. Femenina Catalana 29/34 Ahora
mad Madrid Prebenjamín F7 2 gr Ahora
cat 2ª Catalana Femenina 6 gr Ahora
mad 1ª Madrid Cadete Femenin. 24/26 Ahora
COMPETICIONES
es Copa del Rey Futsal 7/8 Ahora
es Copa de la Reina 7/7 En 13 días
es Copa de Campeones de Hon. 1/3 Ahora

  USO DE MEMORIA  
12,539,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Home / Index )  4.8448
Total Execution Time  4.8457
  CADENA URL  
/zona/islas-baleares
  GET DATOS  
$_GET['/zona/islas-baleares']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (70)  
0.0149  SELECT total FROM totals ORDER BY id ASC
0.0148  SELECT g.name,g.id,g.members FROM groups g ORDER BY g.members DESC LIMIT 0,12
0.0153  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.0147  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.0145  SELECT url,page_views,page_title,last_page_views FROM rf_statcounter_popular_pages ORDER BY page_views DESC LIMIT 10
0.0145  SELECT url,page_views,page_title,last_page_views FROM rf_statcounter_popular_pages ORDER BY page_views DESC LIMIT 10,10
0.0145  SELECT url,page_views,page_title,last_page_views FROM rf_statcounter_popular_pages ORDER BY page_views DESC LIMIT 20,10
0.0146  SELECT hits,page_url,keyword FROM rf_statcounter_keyword_recent WHERE type = '15m' ORDER BY hits DESC LIMIT 20
0.0145  SELECT hits,page_url,keyword FROM rf_statcounter_keyword_recent WHERE type = '1h' ORDER BY hits DESC LIMIT 20
0.0145  SELECT hits,page_url,keyword FROM rf_statcounter_keyword_recent WHERE type = '1d' ORDER BY hits DESC LIMIT 20
0.0146  SELECT z.name,z.alias,c.CountryCode,c.location,c.continent,c.top,SUM(c.coefficient) as cuenta FROM categories c INNER JOIN zones z ON z.location = c.CountryCode WHERE z.alias = 'islas-baleares' AND c.troncal = 1 GROUP BY c.CountryCode ORDER BY cuenta DESC
0.0232  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.CountryCode = 'bal' GROUP BY t.teamId ORDER BY c.coefficient*dt.relations DESC LIMIT 30
0.0661  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.location = 'es' 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.0146  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.0145  SELECT id,user_name,changeA FROM fa_user WHERE language = "spanish" ORDER BY id DESC LIMIT 15
1.2492   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.6001  SELECT SUM(total) AS total FROM api_requests_stats WHERE creation_date > NOW() - INTERVAL 1 MONTH
0.0149  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.0168  (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-30' 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-30' AND p.cover = 1 GROUP BY p.id) ORDER BY pub_date DESC,totalcomments DESC LIMIT 0, 14
0.0313  (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-30' 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-30' GROUP BY p.id) ORDER BY creation_date>='2024-05-03' DESC,karma DESC LIMIT 0, 14
0.0170  (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-30' 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-30' GROUP BY p.id) ORDER BY creation_date>='2024-05-03' DESC,creation_date>='2024-05-04' DESC,karma DESC LIMIT 0, 14
0.2915   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.0145  SELECT id, year FROM leagues WHERE id IN (893)
0.0146   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 (73672)
0.0148  SELECT id, comment_id, comment, author_name, author_id, votes_up, COUNT(id) AS responses FROM comments WHERE comment_id IN (274747) GROUP BY comment_id
0.0655   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-05-04 00:00:00' AND c.`shedule` < '2024-05-04 23:59:59' ORDER BY fcoef DESC LIMIT 5
0.0156   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 = 729404
0.0158   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 = 727850
0.0163   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 = 727849
0.0164   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 = 727353
0.0172   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 = 729422
0.0275  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.location = 'es' AND c.date = '2024-05-04' GROUP BY cat.location ORDER BY coefficient DESC
0.0224  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.location = 'es' AND c.date = '2024-05-04' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 100
0.0421  (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.location = 'es' AND c.shedule >= '2024-05-04 00:00:00' AND c.shedule < '2024-05-04 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.location = 'es' AND c.shedule >= '2024-05-04 00:00:00' AND c.shedule < '2024-05-04 23:59:59' GROUP BY c.id) ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0382  (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.location = 'es' AND c.shedule >= '2024-05-04 00:00:00' AND c.shedule < '2024-05-04 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.location = 'es' AND c.shedule >= '2024-05-04 00:00:00' AND c.shedule < '2024-05-04 23:59:59' GROUP BY c.id) ORDER BY coefficient DESC,shedule ASC LIMIT 100,200
0.0312  (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.location = 'es' AND c.shedule >= '2024-05-04 00:00:00' AND c.shedule < '2024-05-04 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.location = 'es' AND c.shedule >= '2024-05-04 00:00:00' AND c.shedule < '2024-05-04 23:59:59') ORDER BY shedule ASC
0.0150  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (154139260,154139262,154139264,154139266,154139260,154139266,154617130) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0146  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.0152  SELECT update_date FROM editor_stats ORDER BY update_date DESC LIMIT 1
0.0147  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.CountryCode = '' AND c.`shedule` > '2024-05-03 19:33:22' AND c.`shedule` < '2024-05-04 19:33:22' GROUP BY ct.location,DAY( c.`shedule`) ORDER BY DAY( c.`shedule`) = 4 DESC,coefficient DESC,location ASC
0.0148  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.CountryCode = '' AND c.`shedule` >= '2024-05-03 00:00:00' AND c.`shedule` <= '2024-05-05 23:59:59' GROUP BY ct.location,DAY( c.`shedule`) ORDER BY DAY( c.`shedule`) = 4 DESC, ct.coefficient DESC,location ASC
0.0155  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-05-04 07:18:22' AND c.`shedule`< '2024-05-04 09:48:22' 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.CountryCode = '' AND c.`shedule` > '2024-05-03 19:33:22' AND c.`shedule` < '2024-05-04 19:33:22' AND (c.r1<99 OR c.shedule>='2024-05-04 07:03:22') GROUP BY c.id ORDER BY fcoef DESC LIMIT 9
0.0147  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+c.extra_coefficient), 0.7 * (ct.coefficient+c.extra_coefficient)) + (IF(c.comments>4000,200,c.comments*0.05)) 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.CountryCode = '' AND c.`shedule` > '2024-05-03 19:33:22' AND c.`shedule` < '2024-05-04 19:33:22' GROUP BY c.id ORDER BY fcoef DESC LIMIT 9
0.0579  SELECT l.id FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE c.location='es' AND c.troncal = 1 AND l.year = c.active_year ORDER BY l.start_date<'2024-05-19' AND l.end_date>='2024-04-19' 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.0147  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-05-04 05:43' AND (0 OR l.id = 72116 OR l.id = 72177 OR l.id = 72358 OR l.id = 72359 OR l.id = 72362 OR l.id = 72363 OR l.id = 72364 OR l.id = 72365 OR l.id = 72366 OR l.id = 72260 OR l.id = 72261 OR l.id = 72262) AND c.shedule < '2024-05-04 09:03' GROUP BY l.id ORDER BY cat.coefficient DESC,l.group_code ASC LIMIT 12
0.0147  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 = 72177 OR l.id = 72358 OR l.id = 72359 OR l.id = 72362 OR l.id = 72363 OR l.id = 72364 OR l.id = 72365 OR l.id = 72366 OR l.id = 72260 OR l.id = 72261 OR l.id = 72262) AND c.shedule != '2024/05/04 00:00:00' AND c.shedule != '2024/05/04 00:00:00' AND c.shedule > '2024/05/04 09:03' AND c.shedule < '2024/05/04 21:00' GROUP BY l.id ORDER BY cat.coefficient DESC,l.group_code ASC LIMIT 12
0.0146  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 = 72177 OR l.id = 72358 OR l.id = 72359 OR l.id = 72362 OR l.id = 72363 OR l.id = 72364 OR l.id = 72365 OR l.id = 72366 OR l.id = 72260 OR l.id = 72261 OR l.id = 72262) ORDER BY l.total_num_matchs = l.total_num_matchsR DESC,l.group_code>0 DESC,c.coefficient DESC,l.group_code ASC
0.0155  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 >= 34 AND c.round <= 35 AND c.league_id = 72116 ORDER BY c.shedule ASC
0.0146  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30573
0.0148  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30579
0.0146  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30578
0.0148  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30574
0.0151  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30577
0.0151  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30572
0.0151  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30576
0.0151  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30581
0.0150  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30575
0.0151  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30580
0.0160  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30585
0.0149  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30589
0.0153  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30591
0.0155  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30587
0.0146  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30582
0.0146  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30584
0.0145  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30583
0.0147  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30590
0.0144  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30588
0.0145  SELECT id FROM dreamteam_data_real WHERE league_id = 72116 AND id_match = 30586
0.0150  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 >= 34 AND c.round <= 35 AND c.league_id = 72116 ORDER BY c.shedule ASC
0.0148  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 >= 34 AND c.round <= 35