4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
Crea o gestiona tus widgets
ya hemos servido 18.787.894.312 peticiones este mes desde nuestra API
Partidos destacados
Parc Des Princes
07/05/2024 - 21:00
Estadio Subotica City
07/05/2024 - 18:00
Kiryat Shmona Municipal Stadium
07/05/2024 - 18:00
Bloomfield Stadium
07/05/2024 - 18:00
Stadion Voždovac
07/05/2024 - 19:00
LIGAS / COMPETICIONES
Nombre Datos
LIGAS
es Primera División 35/38 En 3 días
es Segunda División 38/42 Ahora
es Primera Federación 2 gr Ahora
es Primera Femenina 27/30 Ahora
mur Murcia 32/34 Ahora
gal Galicia 2 gr Ahora
can Cantabria 32/34 Ahora
man C. La Mancha 3 gr Ahora
cat Liga Élite Catalana 28/30 Ahora
val Lliga Comunitat FFCV 2 gr Ahora
mad Madrid 2 gr 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
rio La Rioja 5 gr Ahora
ES Ceuta 12/14 Ahora
can 1ª Regional Cantabria 32/34 Ahora
gal Primera Galicia 5 gr Ahora
mur 1ª Regional Murcia 2 gr Ahora
cat Primera Catalana 3 gr Ahora
val Primera FFCV 4 gr Ahora
ica 1ª Regional Canarias 6 gr Ahora
mad 1ª Regional Madrid 4 gr Ahora
nav Regional Navarra 2 gr Ahora
ara 1ª Regional Aragón 4 gr Ahora
leo 1ª Castilla y León 9 gr Ahora
and 2ª Andaluza Cádiz 28/30 Ahora
can 2ª Regional Cantabria 2 gr Ahora
val Segunda FFCV 8 gr Ahora
man 2ª Auto. Castilla-La Man. 6 gr Ahora
gal Segunda Galicia 14 gr Ahora
ara 2ª Regional Aragón 9 gr Ahora
mad 2ª Regional Madrid 8 gr Ahora
es Segunda Femenino Futsal 3 gr Ahora
es Primera Femenino Futsal 27/30 Ahora
cat 2ª Catalana 6 gr Ahora
and 3ª Andaluza Sevilla 5 gr Ahora
mad 3ª Regional Madrid 20 gr Ahora
val Tercera FFCV 15 gr Ahora
cat 3ª Catalana 18 gr Ahora
gal Tercera Galicia 17 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
pva Liga Vasca Juvenil 32/34 Ahora
es Liga Nacional 17 gr 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
rio 1ª Juvenil La Rioja 24/26 Ahora
mad 1ª Auto. Madrid Juvenil 18 gr Ahora
val Valencia Juvenil 4 gr Ahora
ara 1ª Aragón Juvenil 2 gr Ahora
ast 1ª Asturias Juvenil 31/34 Ahora
mad Madrid Juvenil Femenina 31/34 Ahora
ara Aragón Juvenil 2 gr Ahora
and 3ª Andaluza Cádiz Juveni. 2 gr Ahora
cat 1ª Catalana Juvenil Feme. 2 gr Ahora
and 2ª Andaluza Málaga Cadet. 28/30 Ahora
cat Honor Catalana Cadete 28/30 Ahora
cat Catalana Cadete 4 gr Ahora
ara Honor Aragón Cadete 27/30 Ahora
and 4ª Andaluza Málaga Cadet. 9 gr Ahora
mad Superliga Madrid Cadete 27/30 Ahora
mad Honor Madrid Cadete 2 gr Ahora
and de Honor Cadete Andaluza 27/30 Ahora
val Valencia Cadete 4 gr Ahora
and 1ª Andaluza Cadete 2 gr Ahora
ara 1ª Aragón Cadete 2 gr Ahora
ast 2ª Asturias Cadete 2 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
val Liga Auto. Valencia Cade. 29/34 Ahora
and 1ª Andaluza Cadete Femen. 24/29 Ahora
can 1ª Cantabria Infantil 28/30 Ahora
cat Honor Catalana Infantil 28/30 Ahora
can 2ª Cantabria Infantil 2 gr Ahora
and 2ª Andaluza Málaga Infan. 28/30 Ahora
cat Catalana Infantil 4 gr Ahora
cat Catalana Infantil Femeni. 28/30 Ahora
val Valencia Infantil 4 gr Ahora
cat 1ª Catalana Infantil 27/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
mad Honor Madrid Infantil 2 gr Ahora
and 1ª Andaluza Infantil 2 gr Ahora
ast 2ª Asturias Infantil 2 gr Ahora
mad Superliga Madrid Infanti. 26/30 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 2ª Andaluza Málaga Aleví. 28/30 Ahora
cat Catalana Alevin Sub 11 6 gr Ahora
cat Catalana Alevin Sub 12 6 gr Ahora
mad Honor Madrid Alevín F7 24/26 Ahora
cat 1ª Catalana Alevín Sub 1. 14 gr Ahora
mad Honor Madrid Alevín F11 27/30 Ahora
cat 1ª Catalana Alevín Femen. 4 gr Ahora
and 3ª Andaluza Sevilla Alev. 5 gr Ahora
mad Superliga Madrid Alevín 27/30 Ahora
and 3ª Andaluza Málaga Aleví. 2 gr Ahora
cat 2ª Catalana Alevin 5 gr Ahora
cat Catalana Benjamin Sub 10 6 gr Ahora
cat Catalana Benjamin Sub 9 6 gr Ahora
and 2ª Andaluza Málaga Benja. 28/30 Ahora
and 3ª Andaluza Sevilla Benj. 4 gr Ahora
mad 1ª Auto. Madrid Benjamín. 24/26 Ahora
and 3ª Andaluza Málaga Benja. 2 gr Ahora
mad Madrid Cadete Femenino 27/30 Ahora
and 3ª Andaluza Sevilla Preb. 3 gr Ahora
mad Madrid Prebenjamín F7 2 gr Ahora
cat Pref. Femenina Catalana 29/34 Ahora
cat 2ª Catalana Femenina 6 gr Ahora
mad 1ª Madrid Cadete Femenin. 25/26 Ahora
COMPETICIONES
es Segunda Federación - Pla. 1/1 Ahora
es Segunda Federación - Pla. 1/2 Ahora
es Copa del Rey Futsal 7/8 Ahora
es Copa de la Reina 7/7 En 10 días
es Copa de Campeones de Hon. 1/3 Ahora

  USO DE MEMORIA  
10,466,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Home / Index )  3.2127
Total Execution Time  3.2136
  CADENA URL  
/zona/islas-canarias
  GET DATOS  
$_GET['/zona/islas-canarias']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0018  SELECT url,page_views,page_title,last_page_views FROM rf_statcounter_popular_pages ORDER BY page_views DESC LIMIT 10
0.0018  SELECT url,page_views,page_title,last_page_views FROM rf_statcounter_popular_pages ORDER BY page_views DESC LIMIT 10,10
0.0018  SELECT url,page_views,page_title,last_page_views FROM rf_statcounter_popular_pages ORDER BY page_views DESC LIMIT 20,10
0.0024  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-canarias' AND c.troncal = 1 GROUP BY c.CountryCode ORDER BY cuenta DESC
0.0072  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 = 'ica' GROUP BY t.teamId ORDER BY c.coefficient*dt.relations DESC LIMIT 30
1.3353   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.4611  SELECT SUM(total) AS total FROM api_requests_stats WHERE creation_date > NOW() - INTERVAL 1 MONTH
0.0042  (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-05-03' 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-05-03' AND p.cover = 1 GROUP BY p.id) ORDER BY pub_date DESC,totalcomments DESC LIMIT 0, 14
0.0039  (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-05-03' 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-05-03' GROUP BY p.id) ORDER BY creation_date>='2024-05-06' DESC,karma DESC LIMIT 0, 14
0.0036  (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-05-03' 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-05-03' GROUP BY p.id) ORDER BY creation_date>='2024-05-06' DESC,creation_date>='2024-05-07' DESC,karma DESC LIMIT 0, 14
0.0018  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.0471  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-22' AND l.end_date>='2024-04-22' DESC,l.total_num_matchs = l.total_num_matchsR DESC,l.group_code>0 DESC,c.coefficient DESC,l.group_code ASC LIMIT 12