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

LIVESCORE / Partidos de Hoy - Livescore - Ligas de África

TODO ESPAÑA TOP EUROPA AMERICA ASIA Y OCEANIA AFRICA AYER HOY MAÑANA 29 ABR

Partidos Sábado, 27 Abril 2024

Argelia Sudáfrica Marruecos Túnez Nigeria Zambia Ghana Benin Sierra Leona Kenya Egipto Namibia Angola Burundi Burkina Faso Lesotho Congo, República Democrática del Gambia Rwanda Uganda Mauritania Botswana Zimbabwe Malawi Swazilandia Guinea Cabo Verde Tanzania Congo Mozambique Somalia Djibouti
Liga Argelia Liga Argelia »
17:00
  en 7 h Chlef
17:00
 		NC Magra 0
17:00
  en 7 h Ben Aknoun
17:00
 		JS Kabylie 0
21:00
  en 11 h MC Alger
21:00
 		Paradou 0
Segunda Sudáfrica Segunda Sudáfrica »
15:00
  en 5 h Venda
15:00
 		Pretoria 0
15:00
  en 5 h Magesi
15:00
 		Maritzburg United 0
15:00
  en 5 h Milford
15:00
 		NB La Masia 0
15:00
  en 5 h Hungry Lions
15:00
 		Baroka 0
NNL NNL »
14:00
  en 4 h Inter Lagos
14:00
 		Giant Brillars FC 0
16:00
  en 6 h Mighty Jets
16:00
 		Yobe Stars 0
16:00
  en 6 h Coal City
16:00
 		Beyond Limits 0
16:00
  en 6 h ABS FC
16:00
 		Nigeria Airforce 0
16:00
  en 6 h Zamfara United
16:00
 		Nasarawa United 0
16:00
  en 6 h Edel
16:00
 		Dakkada 0
16:00
  en 6 h EFCC
16:00
 		Wikki Tourist 0
16:00
  en 6 h Abia Comets
16:00
 		Madiba 0
17:00
  en 7 h Tradesafe
17:00
 		Ijebu 0
Copa Uganda Copa Uganda »
14:00
  en 4 h BUL FC
14:00
 		NEC FC 0
14:00
  en 4 h Kitara
14:00
 		Pajule Lions 0
Liga Burundi Liga Burundi »
15:00
  en 5 h Inter Star
15:00
 		Telaviv 0
15:00
  en 5 h Vital'O
15:00
 		Moso Sugar 0
15:00
  en 5 h Musongati
15:00
 		Rukinzo 0
15:00
  en 5 h Tigre Noir
15:00
 		Magara Young Boys 0
Premier League Zambia Premier League Zambia »
15:00
  en 5 h NAPSA Stars FC
15:00
 		Green Eagles 0
15:00
  Aplazado Kabwe Warriors
-
 		Red Arrows 0
15:00
  Aplazado Nkwazi
-
 		Mufulira Wanderers 0
15:00
  Aplazado Zesco United
-
 		MUZA 0
15:00
  Aplazado Green Buffaloes
-
 		Nkana FC 0
15:00
  Aplazado Kansanshi Dynamos
-
 		Mutondo Stars 0
15:00
  Aplazado Power Dynamos
-
 		Forest Rangers 0
15:00
  en 5 h Forest Rangers
15:00
 		Konkola Blades 0
15:00
  Aplazado Green Eagles
-
 		Zanaco 0
15:00
  Aplazado Konkola Blades
-
 		Trident 0
15:00
  Aplazado Prison Leopards
-
 		NAPSA Stars FC 0

LIGAS / COMPETICIONES

Nombre Datos
Publicidad 600x120.gif

PRENSA DEL DÍA

Ver toda la prensa de hoy

  USO DE MEMORIA  
6,254,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.1916
Total Execution Time  0.1925
  CADENA URL  
/livescore/dia/hoy/zona/futbol_africa
  GET DATOS  
$_GET['/livescore/dia/hoy/zona/futbol_africa']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0080  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.continent = 'af' 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 30
0.0018  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 = 'af' AND lm.creation_date > '2024-04-26 09:04:12' ORDER BY lm.creation_date DESC LIMIT 8
0.0019  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 = 'af' AND lm.creation_date > '2024-04-20 09:04:12' ORDER BY lm.creation_date DESC LIMIT 15
0.0160  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 = 'af' AND c.date = '2024-04-27' GROUP BY cat.location ORDER BY coefficient DESC
0.0209  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.continent = 'af' AND c.date = '2024-04-27' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 70
0.0262  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.continent = 'af' AND cat.ctype IN (1,3,12,34,36) AND c.shedule >= '2024-04-27 00:00:00' AND c.shedule < '2024-04-27 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100
0.0129  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 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.continent = 'af' AND cat.ctype IN (1,3,12,34,36) AND c.id IN (178428,178430,178432,727837,727838,727839,723349,723350,695062,617251,617254,617255,701496,701497,509724,509726,509722,509723,598088,598087,728664,728665,728666,728667,728660,728655,728661,728672,728662,728678,728663,728679,728648,728680,728649,728682,728650,728656,728651,728657,728652,728658,728653,728659,728654,495597,452417,452418,452422,452415,452416,452421,903400,903401,903402,903403,903361,725041,725042,722211,722209,729052,729043,729044,729045,729048,729049,729050,729042,729053,691970,691972,691971,691966,727893,728290,728291,729029,729030,729031,729028,728999,728998,729039,728707,729038,713494,713495,713496,422026,422027,422028,422029,422030,422031,422032,422017,422033,422021,422034) AND c.shedule >= '2024-04-27 00:00:00' AND c.shedule < '2024-04-27 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200
0.0028  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.continent = 'af' AND cat.ctype IN (1,3,12,34,36) AND c.id IN (178428,178430,178432,727837,727838,727839,723349,723350,695062,617251,617254,617255,701496,701497,509724,509726,509722,509723,598088,598087,728664,728665,728666,728667,728660,728655,728661,728672,728662,728678,728663,728679,728648,728680,728649,728682,728650,728656,728651,728657,728652,728658,728653,728659,728654,495597,452417,452418,452422,452415,452416,452421,903400,903401,903402,903403,903361,725041,725042,722211,722209,729052,729043,729044,729045,729048,729049,729050,729042,729053,691970,691972,691971,691966,727893,728290,728291,729029,729030,729031,729028,728999,728998,729039,728707,729038,713494,713495,713496,422026,422027,422028,422029,422030,422031,422032,422017,422033,422021,422034) AND c.shedule >= '2024-04-27 00:00:00' AND c.shedule < '2024-04-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 (153783109) AND typeId=40 AND site='bet365' ORDER BY eventId ASC
0.0306  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.0306  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.0306  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.0306  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.0306  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.0306  (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 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.continent = 'af' AND c.shedule >= '2024-04-27 00:00:00' AND c.shedule < '2024-04-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 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.continent = 'af' AND c.shedule >= '2024-04-27 00:00:00' AND c.shedule < '2024-04-27 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC