Escudo del SFC Kalinkovo

¿Falta algún dato de este equipo?

Si tienes datos del equipo que no se encuentran en la página nos encantaría que los compartas con nosotros. Un editor de la página validará los datos y en el plazo de tiempo más breve posible completarán los datos actuales con los enviados.

Información sobre SFC Kalinkovo

Enviar Datos
Información

Partidos del SFC Kalinkovo

Ir al LIVESCORE

Últimas noticias

Ver últimas noticias

Simeone, autocrítico: "Estamos en una etapa de hablar poco"

BeSoccer - Sábado, 20 Abril 2024
0 0

El entrenador del Atlético de Madrid, Diego Pablo Simeone, compareció en sala de prensa en la previa al partido frente el Alavés. El técnico argentino admitió que no están para hablar mucho, sino para "ir partido a partido".

El Dibu no se libró del castigo: se pierde por sanción la ida de 'semis'

BeSoccer - Sábado, 20 Abril 2024
0 13

El Dibu Martínez, protagonista en la tanda de penaltis ante el Lille, finalmente se perderá la ida de semifinales de la Conference League frente al Olympiacos. El guardameta, que vio una amarilla durante el partido y otra en la tanda, no estará en la cita porque llegó a las 3 amonestaciones en dicha competición y eso acarrea suspensión.

El City-Chelsea, EN DIRECTO: igualdad máxima en los 2 duelos ligueros

Juanma Velasco - Sábado, 20 Abril 2024
0 758

Vive con nosotros todas las incidencias del Manchester City-Chelsea, partido correspondiente a las semifinales de la FA Cup 2023-24 que se va a disputar en Wembley.

El Chelsea anula al Barça a su mínima expresión

BeSoccer - Sábado, 20 Abril 2024
0 474

El Barcelona dejó de ser el Barcelona en el peor momento de la temporada y perdió en la ida de semifinales de la Champions League Femenina ante un Chelsea que se lleva una mínima ventaja a Londres (0-1) gracias al gol de Erin Cuthbert.

Xavi va ganando 6-5 contra Ancelotti... o perdiendo 4-5, según se mire

David Caravaca - Sábado, 20 Abril 2024
0 8

Por cantidad absoluta, es decir, contando los partidos amistosos de pretemporada, Xavi Hernández presume de un 6-5 en victorias favorable en sus duelos con Carlo Ancelotti. Si se apartan las citas del Soccer Champions Tour, que se ha acostumbrado a alojar 'Clásicos' de verano, la nómina es de 4-5 para el estratega italiano. Antes de que el egarense deje su puesto el 30 de junio, tiene la oportunidad, este domingo, de decorar su balance ante un homólogo al que le tiene un gran respeto.

Ver más noticias del equipo»



  USO DE MEMORIA  
4,736,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2303
Total Execution Time  0.2323
  CADENA URL  
/Sfc-Kalinkovo
  GET DATOS  
$_GET['/Sfc-Kalinkovo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65854 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1209 AND type_rel = 3
0.0108  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 = '65854' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  (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 = 65854 or c.datateam2 = 65854) 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.0108  (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 = 65854 or c.datateam2 = 65854) 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.0107  (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 = 65854 or c.datateam2 = 65854) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0107  (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_base as c ON c.league_id = l.id WHERE (c.datateam1 = 65854 or c.datateam2 = 65854) 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.0108  (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_base 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 = 65854 or c.datateam2 = 65854) 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.0108  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024_base as c ON c.league_id = l.id INNER JOIN events2024_base as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players_base 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 = 65854 or c.datateam2 = 65854) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0108  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=65854 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0110  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 (72674,70546) 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.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 70546 AND teamId = 65854
0.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 72674 AND teamId = 65854
0.0112  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 = 72674 AND t.round = 9 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC