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

Partidos del Club Calor

Ir al LIVESCORE
28 Abr 24  Finalizado Tritones Vallarta Tritones Vallarta
1 - 1
Club Calor Club Calor 0
20 Abr 24  Finalizado Club Calor Club Calor
2 - 0
Colima Colima 2
13 Abr 24  Finalizado Tecos Tecos
6 - 0
Club Calor Club Calor 4
06 Abr 24  Finalizado Club Calor Club Calor
1 - 3
UA Tamaulipas UA Tamaulipas 0
02 Abr 24  Finalizado Gavilanes FC Gavilanes FC
1 - 0
Club Calor Club Calor 4
23 Mar 24  Aplazado Club Calor Club Calor
-
Chihuahua FC Chihuahua FC 15
16 Mar 24  Finalizado Orgullo de Reynosa Orgullo de Reynosa
0 - 0
Club Calor Club Calor 12
10 Mar 24  Finalizado Club Calor Club Calor
2 - 0
Coras de Nayarit Coras de NayaritTarjeta Roja 0
06 Mar 24  Finalizado Real Apodaca Real Apodaca
2 - 2
Club Calor Club Calor 2
03 Mar 24  Finalizado UA Zacatecas UA Zacatecas
0 - 1
Club Calor Club Calor 0
24 Feb 24  Finalizado Club Calor Tarjeta RojaClub Calor
0 - 0
Saltillo FC Saltillo FC 7
17 Feb 24  Finalizado Cimarrones II Cimarrones II
1 - 0
Club Calor Club CalorTarjeta RojaTarjeta Roja 17
10 Feb 24  Finalizado Club Calor Club Calor
0 - 1
Durango Durango 10
04 Feb 24  Finalizado Los Cabos Los Cabos
1 - 1
Club Calor Club Calor 31
27 Ene 24  Finalizado Club Calor Club Calor
4 - 2
Mexicali FC Mexicali FC 3
21 Ene 24  Finalizado Mineros de Fresnillo Mineros de Fresnillo
3 - 1
Club Calor Club Calor 0
13 Ene 24  Finalizado Club Calor Club Calor
2 - 1
Leones Negros II Leones Negros IITarjeta Roja 17

Plantilla del Club Calor Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
23 mx 180 79 - - -
- mx 179 77 - - -
21 mx 172 68 - - -
Defensa
20 mx 185 74 - - 1
23 mx 182 72 - - 3
23 mx 177 79 - - -
21 mx 165 65 - - 2
25 mx 185 83 1 - 5
20 mx 185 70 - - 1
19 mx 168 69 - - -
26 mx 189 72 1 - 4
25 mx - - 3 - 8
24 mx 169 67 2 - 4
Centrocampista
23 mx 174 65 - - 1
18 mx 170 70 - - -
21 mx 168 69 - 3 6
26 mx 175 63 - - -
25 mx - - 3 1 2
23 mx 177 61 - - -
25 mx 183 75 - - -
21 mx 180 70 2 - 1
19 mx 174 63 - - -
18 mx 172 - - - -
24 mx 173 69 - - -
25 co 175 72 - - -
28 mx 175 73 - - 1
22 mx 173 69 - - -
21 mx 174 70 - - 1
23 mx 176 67 1 - 1
17 mx 169 68 - - -
17 mx 167 65 1 1 1
25 mx 168 65 2 - 5
22 mx 177 63 1 1 3
Delantero
17 mx 180 59 - - -
22 mx 180 - - 1 -
22 mx 174 68 - - -
17 mx 174 65 - - -
22 co - - 3 - 4
23 mx 175 65 8 - 3
23 mx 175 71 2 - 2
23 co 187 - 4 - 5
27 ar 183 - 1 - 2
17 mx 180 71 - - -

Noticias de Liga Premier Serie A

Ver últimas noticias

Maleck encuentra equipo en México tras salir de prisión

Joao Maleck, que pasó un tiempo en la cárcel, firmó por Cafessa Jalisco, de la Tercera División de México. En el pasado pasó por los filiales de Oporto o Sevilla Atlético.

El modesto Tlaxcala se ofrece a fichar a Cristiano Ronaldo

No ha pasado ni una semana de la eliminación de la Juventus en la Champions League y a Cristiano Ronaldo ya le han ofrecido fichar por un equipo. En este caso, un ofrecimiento en tono de broma, pues el equipo es Coyotes de Tlaxcala, de la Tercera División de México.

El hijo de Palermo cambia México por Honduras

CD Marathón confirmó la llegada de Ryduan Palermo, que abandona la disciplina de Coyotes de Tlaxcala, de México, para recalar en la Liga Hondureña.

La insólita celebración en medio de la crisis del COVID-19

El jugador del Club Tepatitlán Humberto González fue el protagonista de la celebración más insólita en medio de la crisis del coronavirus.

Un portero se marcó el autogol más rápido de la historia del fútbol mexicano

Estudiantes de Tecos tardó apenas diez segundos en verse por debajo en el marcador. Eduardo Santana se marcó en su propia portería de forma inexplicable a los diez segundos de partido ante Atlético Reynosa.




  USO DE MEMORIA  
5,456,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3277
Total Execution Time  0.3295
  CADENA URL  
/Calor-De-San-Pedro
  GET DATOS  
$_GET['/Calor-De-San-Pedro']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
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 = 73350
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59969 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2163 AND type_rel = 3
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2163 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (947042,872027,869482,809171,801563) ORDER BY n.cover_points DESC, update_date DESC
0.0149  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '59969' ORDER BY l.year DESC,cat.coefficient DESC
0.0148  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '59969' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '59969' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 73350 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  (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 = 59969 or c.datateam2 = 59969) 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.0159  (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 = 59969 or c.datateam2 = 59969) 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.0170  (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 = 59969 or c.datateam2 = 59969) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0167  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 = 73350 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC