4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

LIVESCORE / Partidos de Rumania del Sábado, 27 Mayo 2023 - Ligas de Europa

TODO ESPAÑA TOP EUROPA AMERICA ASIA Y OCEANIA AFRICA AYER HOY MAÑANA 27 MAY
Portugal Italia Irlanda Bielorusia Hungría Azerbaiyán

Partidos Sábado, 27 Mayo 2023

Alemania Francia Holanda Rusia Suiza República Checa Polonia Italia Suecia Portugal Croacia Bielorusia Rumania Bulgaria Austria Serbia Bosnia y Herzegovina Letonia Georgia Finlandia Dinamarca Escocia Eslovaquia Reino Unido Hungría Eslovenia Bélgica Estonia Noruega Lituania Ucrania Moldavia Grecia Kazakstán Competiciones Europeas Azerbaiyán Uzbekistán Chipre Irlanda Islandia Islas Feroe Armenia Andorra Luxemburgo San Marino
Tercera Rumanía Tercera Rumanía »
16:30
  Finalizado Bihor Oradea
2 - 3
 		Unirea Ungheni 1
16:30
  Finalizado CS Hunedoara
2 - 1
 		Gloria Bistriţa 1
16:30
  Finalizado Tunari
4 - 0
 		Farul Constanţa 1
16:30
  Finalizado Municipal Reşiţa
5 - 0
 		Filiaşi 0
16:30
  Finalizado Blejoi Vispeşti
2 - 6
 		Viitorul Dăești 0
16:30
  Finalizado Metalul Buzău
1 - 2
 		Ceahlaul Piatra N. 0
16:30
  Finalizado CSM Deva
2 - 2
 		Șoimii Lipova 0
16:30
  Finalizado Afumati
1 - 1
 		Popesti Leordeni 0
16:30
  Finalizado Foresta Suceava
2 - 0
 		Râmnicu Sarat 1
16:30
  Finalizado Alexandria
1 - 0
 		Plopeni 0


  USO DE MEMORIA  
4,612,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Livescore / Index )  0.1381
Total Execution Time  0.1391
  CADENA URL  
/livescore/dia/27052023/zona/futbol_europa/pais/rumania
  GET DATOS  
$_GET['/livescore/dia/27052023/zona/futbol_europa/pais/rumania']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0026  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 = 'rumania' AND c.troncal = 1 GROUP BY c.CountryCode ORDER BY cuenta DESC
0.0031  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_history 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.location != 'es' AND c.continent = 'eu' AND lm.creation_date > '2024-04-27 04:17:56' ORDER BY lm.creation_date DESC LIMIT 8
0.0028  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_history 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.location != 'es' AND c.continent = 'eu' AND lm.creation_date > '2024-04-21 04:17:56' ORDER BY lm.creation_date DESC LIMIT 15
0.0070  SELECT l.id FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE c.active_year = l.year AND c.CountryCode = 'ro' ORDER BY c.coefficient
0.0070  SELECT c.troncal,l.id,c.name,l.group_code,l.total_group,c.location,c.CountryCode,c.logo,l.current_round,l.start_date,l.end_date,l.total_rounds,l.next_shedule,c.alias,l.categoryId FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.start_date<'2024-05-08' AND l.end_date >'2024-05-03' AND c.active_year = l.year AND c.CountryCode = 'ro' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.coefficient DESC
0.0028  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-04-27' AND categoryId = 20
0.0023  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-04-27' AND categoryId = 242
0.0033  SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-04-27' AND categoryId = 284
0.0055  SELECT c.troncal,l.id,c.name,l.group_code,l.total_group,c.location,c.CountryCode,c.logo,l.current_round,l.start_date,l.end_date,l.total_rounds,l.next_shedule,c.alias,l.categoryId FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.end_date <'2024-05-03' AND c.active_year = l.year AND c.CountryCode = 'ro' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.coefficient DESC
0.0059  SELECT c.troncal,l.id,c.name,l.group_code,l.total_group,c.location,c.CountryCode,c.logo,l.current_round,l.start_date,l.end_date,l.total_rounds,l.next_shedule,c.alias,l.categoryId FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.start_date >'2024-05-03' AND c.active_year = l.year AND c.CountryCode = 'ro' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.coefficient DESC
0.0198  SELECT z.name,z.alias,cat.location,SUM(cat.coefficient) as coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars_all as c ON c.league_id = l.id LEFT JOIN zones z ON z.location = cat.location WHERE cat.continent = 'eu' AND cat.location!='es' AND c.date = '2023-05-27' GROUP BY cat.location ORDER BY coefficient DESC
0.0100  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.CountryCode = 'ro' AND c.date = '2023-05-27' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 70
0.0101  SELECT c.id AS mid, l.year,cat.coefficient,l.id 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 WHERE cat.CountryCode = 'ro' AND cat.ctype IN (1,3,12,34,36) AND c.shedule >= '2023-05-27 00:00:00' AND c.shedule < '2023-05-27 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0029  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.betId_bwin,c.betId_marca,c.betId_888,c.betId_sportium, c.betId_marathon, 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 calendars2023 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.CountryCode = 'ro' AND cat.ctype IN (1,3,12,34,36) AND c.id IN (775808,842380,842381,842382,842383,842384,842385,842386,842387,842388,842389,801477,801246,801478,801248,801526,801296,801574,801315,801620,801344,801621,801345,801622,801374,801375,801376,801476) AND c.shedule >= '2023-05-27 00:00:00' AND c.shedule < '2023-05-27 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0018  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (138247948) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0124  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN () AND typeId=40 AND site='bwin' ORDER BY eventId ASC
0.0124  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN () AND typeId=40 AND site='marca' ORDER BY eventId ASC
0.0124  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN () AND typeId=40 AND site='b888sport' ORDER BY eventId ASC
0.0124  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN () AND typeId=40 AND site='sportium' ORDER BY eventId ASC
0.0124  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN () AND typeId=40 AND site='mbet' ORDER BY eventId ASC
0.0124  (SELECT c.id,rel.media_id,rel.data,c.shedule, med.lang 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.CountryCode = 'ro' AND c.shedule >= '2023-05-27 00:00:00' AND c.shedule < '2023-05-27 23:59:59') UNION (SELECT c.id,rel.media_id,rel.data,c.shedule, med.lang FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2023 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.CountryCode = 'ro' AND c.shedule >= '2023-05-27 00:00:00' AND c.shedule < '2023-05-27 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC