¿Eres mayor de edad?

SI NO

Confirma si tienes 18 años

Faldón apuestas
4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
US Cosne - Châteauneuf-sur-Loire
Jornada 5
FINALIZADO
30
40
120 Pts. Elo
5º

91 Pts. Elo
10º

2-0
Sábado, 05 Octubre 2024, 18:00
K. Lecomte-Soukhotine 30'
1 - 0
J. Grebert 68'
2 - 0

Eventos del partido

Goles

K. Lecomte-SoukhotineGol de
K. Lecomte-Soukhotine
minuto 30'
J. GrebertGol de
J. Grebert
minuto 68'

Tarjetas

minuto 17'Aymeric ZoumaT. Amarilla Aymeric Zouma
minuto 23'Q. AzevedoT. Amarilla Q. Azevedo
J. GrebertT. Amarilla
J. Grebert
minuto 33'
N. VannierT. Amarilla
N. Vannier
minuto 45'
minuto 48'B. CoulibalyT. Amarilla B. Coulibaly
minuto 59'M. Da Silva MendonçaT. Amarilla M. Da Silva Mendonça
L. AdoulT. Amarilla
L. Adoul
minuto 64'

Cambios

M. KolazafyEntra en el partido
M. Kolazafy
minuto 68'
J. GrebertSale del partido
J. Grebert
minuto 68'
N. VannierSale del partido
N. Vannier
minuto 75'
M. BertheEntra en el partido
M. Berthe
minuto 75'
L. AdoulSale del partido
L. Adoul
minuto 75'
H. SavaneEntra en el partido
H. Savane
minuto 75'
minuto 76'O- DiedhiouEntra en el partido O- Diedhiou
minuto 76'N. CaloieroSale del partido N. Caloiero
minuto 84'Y. Le BrisEntra en el partido Y. Le Bris
minuto 84'R. GhaouiEntra en el partido R. Ghaoui
minuto 84'J. BoyerSale del partido J. Boyer
minuto 84'Aymeric ZoumaSale del partido Aymeric Zouma
Esteban CanuEntra en el partido
Esteban Canu
minuto 88'
A. MondesirSale del partido
A. Mondesir
minuto 88'

Alineaciones

US Cosne

US Cosne

4-4-2
Alineación Inicial
Suplentes
Châteauneuf-sur-Loire

Châteauneuf-sur-Loire

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,906,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  1.0026
Total Execution Time  1.0036
  CADENA URL  
/partido/Union-Cosnoise/Chateauneuf-Sur-Loire
  GET DATOS  
$_GET['/partido/Union-Cosnoise/Chateauneuf-Sur-Loire']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0107  SELECT data1 FROM stats2025 t WHERE league_id = 77010 AND teamId = 6655026 and type = 33
0.0107  SELECT data1 FROM stats2025 t WHERE league_id = 77010 AND teamId = 6655034 and type = 33
0.0106  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '77336' and rp.type = 2025 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 77336 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 77336 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0109  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2025` 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 = 77010 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='77336' AND `active` = 1 AND year = 2025
0.0165  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='77010' AND relp.team_id=6655026 WHERE relp.in_squad=1 and mp.`match_id` = '77336' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0149  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='77010' AND relp.team_id=6655034 WHERE relp.in_squad=1 and mp.`match_id` = '77336' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=77336 AND extraId = 77010 AND type_rel = 4
0.0106  SELECT * FROM futbol.calendars_lineups WHERE id = 77336 AND league_id = 77010 AND year = 2025