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

LIVESCORE / Partidos de Guatemala del Domingo, 28 Noviembre 2021

TODO ESPAÑA TOP EUROPA AMERICA ASIA Y OCEANIA AFRICA AYER HOY MAÑANA 28 NOV
Argentina Chile Uruguay Estados Unidos Bolivia Haití

Partidos Domingo, 28 Noviembre 2021

Lo sentimos...

No hay partidos programados para este día



  USO DE MEMORIA  
4,088,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.2319
Total Execution Time  0.2328
  CADENA URL  
/livescore/dia/28112021/pais/guatemala
  GET DATOS  
$_GET['/livescore/dia/28112021/pais/guatemala']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0108  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 = 'guatemala' AND c.troncal = 1 GROUP BY c.CountryCode ORDER BY cuenta DESC
0.0108  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.continent = 'am' AND lm.creation_date > '2024-04-15 21:05:31' ORDER BY lm.creation_date DESC LIMIT 8
0.0108  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.continent = 'am' AND lm.creation_date > '2024-04-09 21:05:31' ORDER BY lm.creation_date DESC LIMIT 15
0.0108  SELECT z.name,z.alias,cat.location,SUM(cat.coefficient) as coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars_all as c ON c.league_id = l.id LEFT JOIN zones z ON z.location = cat.location WHERE cat.continent = 'am' AND c.date = '2021-11-28' GROUP BY cat.location ORDER BY coefficient DESC
0.0108  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 = 'gt' AND c.date = '2021-11-28' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 70
0.0109  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 = 'gt' AND cat.ctype IN (1,3,12,34,36) AND c.shedule >= '2021-11-28 00:00:00' AND c.shedule < '2021-11-28 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0299  SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN () AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0299  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.0299  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.0299  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.0299  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.0299  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.0299  (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 calendars2022 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 = 'gt' AND c.shedule >= '2021-11-28 00:00:00' AND c.shedule < '2021-11-28 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 calendars2021 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 = 'gt' AND c.shedule >= '2021-11-28 00:00:00' AND c.shedule < '2021-11-28 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC