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

Histórico de participación

Partidos del Aresimi

Ir al LIVESCORE
18 May 24  en 21 días Belasica
17:00
Aresimi 0
11 May 24  en 14 días Aresimi
17:00
Osogovo 0
04 May 24  en 7 días FK Pobeda Prilep
17:00
Aresimi 0
30 Abr 24  en 3 días Aresimi
16:00
Bashkimi 1
27 Abr 24  en 5 h Teteks
16:00
Aresimi 0
20 Abr 24  Finalizado Aresimi
0 - 2
KF Besa 0
13 Abr 24  Finalizado Pelister
3 - 0
Aresimi 0
06 Abr 24  Finalizado Aresimi
0 - 0
FK Ohrid 0
30 Mar 24  Finalizado Aresimi
1 - 1
FK Skopje 0
17 Mar 24  Finalizado Vardar Negotino
0 - 0
Aresimi 0
09 Mar 24  Finalizado Aresimi
3 - 0
Karaorman Struga 0
05 Mar 24  Finalizado Kozuv Gevgelija
0 - 2
Aresimi 0
02 Mar 24  Finalizado Aresimi
2 - 1
Detonit Plachkovica 0
24 Feb 24  Finalizado Sasa
2 - 3
Aresimi 0
17 Feb 24  Finalizado Aresimi
2 - 0
Novaci 0

Últimas noticias

Ver últimas noticias

La conexión Málaga-Mánchester que ha devuelto al Leicester a la Premier

Tras solo una temporada en el Championship, el Leicester City vuelve a ser de Premier League. El equipo de los ex malaguistas (y 'citizens') Enzo Maresca y Willy Caballero logró el ascenso matemático sin tener que jugar, ya que su perseguidor, el Leeds United, perdió con el QPR (4-0).

"La Real siempre se ha clasificado a Europa en el último momento"

Imanol Alguacil lamentó la derrota de la Real Sociedad frente al Real Madrid (0-1) e hizo hincapié en la falta de gol de su equipo. Aun así, el técnico 'txuri-urdin' lanzó un mensaje tranquilizador y dijo tener "claro" que lograrán "cumplir con el objetivo".

Kubo, mosqueado: "El jugador se duerme, en la Champions creo que no lo van a pitar"

Fastidiado por el gol que le anuló Munuera Montero, Takefusa Kubo dio su versión de esa jugada y subrayó la superioridad que, a su juicio, tuvo la Real Sociedad para merecerse los tres puntos.

El Real Madrid no quiere un culebrón: "Arda Güler seguirá el próximo año"

Tras el triunfo del Real Madrid en el Reale Arena, Carlo Ancelotti compareció en rueda de prensa y dio valor a la actuación de Arda Güler, así como a otros menos habituales que sí pudieron tener minutos en San Sebastián.

Un empate y el espeluznante 'remake' de Xabi Alonso y Nigel de Jong

Montpellier y Nantes empataron a uno en un partido que dejó una de las imágenes de la jornada: la peligrosísima patada casi a la altura del cuello de Arnaud Nordin, que fue expulsado.




  USO DE MEMORIA  
4,840,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2985
Total Execution Time  0.3004
  CADENA URL  
/Kf-Aresimi-1973
  GET DATOS  
$_GET['/Kf-Aresimi-1973']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0294  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 = 73465
0.0151  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 = 73924
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=152485 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=374 AND type_rel = 3
0.0146  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 = '152485' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 73924 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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 = 73465 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  (SELECT cat.id as category_id, cat.logo, 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 calendars2024 as c ON c.league_id = l.id WHERE (c.datateam1 = 152485 or c.datateam2 = 152485) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0152  (SELECT cat.id as category_id, 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 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 (c.datateam1 = 152485 or c.datateam2 = 152485) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0148  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 152485 or c.datateam2 = 152485) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73465 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148  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 = 152485 AND rp.league_id = 73465 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1