4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Kick4Life
Información

Histórico de participación

Partidos del Kick4Life

Ir al LIVESCORE
07 May 22  Finalizado LCS
3 - 0
Kick4Life 0
05 May 22  Finalizado Manonyane
0 - 1
Kick4Life 0
30 Abr 22  Finalizado Kick4Life
0 - 3
Mazenod Swallows 0
23 Abr 22  Finalizado Liphakoe FC
0 - 0
Kick4Life 0
02 Abr 22  Finalizado Kick4Life
0 - 0
Lija-Batho 0
12 Mar 22  Finalizado Kick4Life
2 - 0
CCX 0
05 Mar 22  Finalizado Kick4Life
3 - 2
Sefotha-fotha 0
27 Feb 22  Finalizado Bantu United
2 - 2
Kick4Life 0
20 Feb 22  Finalizado Lifofane
2 - 0
Kick4Life 0
12 Feb 22  Finalizado Kick4Life
0 - 1
Lioli 0
05 Feb 22  Finalizado Kick4Life
0 - 0
LMPS 0
22 Ene 22  Finalizado Lesotho Defense Force
1 - 0
Kick4Life 0
15 Ene 22  Finalizado LMPS
0 - 1
Kick4Life 0
15 Ene 22  Finalizado Kick4Life
2 - 1
Likhopo 0
18 Dic 21  Finalizado Matlama
2 - 0
Kick4Life 0
11 Jul 21  Finalizado Kick4Life
1 - 0
Linare 0
30 Jun 21  Finalizado Kick4Life
0 - 1
Matlama 0
23 Jun 21  Finalizado Kick4Life
2 - 1
Manonyane 0
20 Jun 21  Finalizado Lija-Batho
1 - 1
Kick4Life 0
17 Jun 21  Finalizado Kick4Life
0 - 0
Lifofane 0
13 Jun 21  Finalizado Lioli
0 - 1
Kick4Life 0
10 Jun 21  Finalizado Kick4Life
1 - 3
Liphakoe FC 0
06 Jun 21  Finalizado Sefotha-fotha
0 - 1
Kick4Life 0
30 May 21  Finalizado Mazenod Swallows
1 - 2
Kick4Life 0
22 May 21  Finalizado Kick4Life
0 - 1
LCS 0
15 May 21  Finalizado CCX
1 - 0
Kick4Life 0
23 Dic 20  Finalizado Linare
0 - 0
Kick4Life 0
19 Dic 20  Finalizado Kick4Life
2 - 1
Lesotho Defense Force 0
16 Dic 20  Finalizado Likhopo
0 - 1
Kick4Life 0
12 Dic 20  Finalizado Kick4Life
0 - 3
Bantu United 0

Últimas noticias

Ver últimas noticias

André Villas-Boas vuelve al Oporto... ¡como presidente!

Muchos recordarán al André Villas-Boas entrenador. Pues bien, tras varios años de ausencia de los banquillos, el luso ha conseguido regresar al Oporto tras ganarle las elecciones presidenciales a Pinto da Costa, quien había ejercido el cargo durante 42 años. En su directiva le acompañará Andoni Zubizarrera.

Portadas de la prensa deportiva del 28-04-24

La victoria del Atlético de Madrid sobre el Athletic Club o el pase del FC Barcelona a la final de la Women's Champions League protagonizan las portadas de los principales medios deportivos españoles.

Difícil, pero no imposible

El Benfica remontó al Sporting Braga (3-1) en la jornada 31 de la Liga Portuguesa. En el mejor de los casos, el cuadro de Roger Schmidt se quedará a 4 puntos del Sporting CP con 9 por disputar. En el peor, a 7 en la carrera final por el título.

"Mucho ánimo a Nico, gente así no tiene cabida ni en la sociedad ni en el fútbol"

Jorge Resurrección 'Koke', capitán del Atlético de Madrid, fue cuestionado por los insultos racistas recibidos por Nico Williams al término del encuentro, que acabó con victoria local por 3-1. El centrocampista mandó "mucho ánimo y fuerza" al atacante del Athletic y dijo que "gente así no tiene cabida" en la sociedad ni en el fútbol.

Luis Alberto se quiere ir, pero por la puerta grande

La Lazio se impuso este sábado al Hellas Verona (1-0) gracias a una nueva exhibición del español Luis Alberto, que asistió a Mattia Zaccagni para mantener vivas las opciones de los suyos de disputar la Liga de Campeones la próxima campaña.




  USO DE MEMORIA  
4,818,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0715
Total Execution Time  0.0734
  CADENA URL  
/kick4life
  GET DATOS  
$_GET['/kick4life']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0022  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'kick4life' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0028  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'kick4life' ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=25073 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=25073 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=25073 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=25073 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=25073 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=25073 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=25073 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=25073 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 60769
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25073 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=497 AND type_rel = 3
0.0020  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '25073' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '25073' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 60769 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=25073 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0018  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (60769) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 60769 AND teamId = 25073
0.0018  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 25073 AND rp.league_id = 60769 AND l.year= 2021 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1