Partido Clermont - Montpellier | Partidos Amistosos 2024

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Clermont - Montpellier Clermont - Montpellier

Jornada 56

FINALIZADO

1213 Pts. Elo

50%

Clermont

1341 Pts. Elo

50%

Montpellier

1-1

Miércoles, 26 Julio 2023, 18:30

K. Andrić	48'		1 - 0
			1 - 1		55'	Sacha Delaye

Eventos del partido

Goles

Gol de

K. Andrić

minuto 48'

minuto 55'

Gol de penalti Sacha Delaye

Tarjetas

minuto 51'

Tarjeta Roja a Gabriel Barès

Cambios

minuto 46'

Entra en el partido Yanis Issoufou

minuto 46'

Entra en el partido Mama Baldé

minuto 46'

Sale del partido M. Al-Tamari

minuto 46'

Sale del partido Wahbi Khazri

minuto 46'

Entra en el partido Junior Ndiaye

Sale del partido

Jim Allevinah

minuto 46'

Entra en el partido

Alidu Seidu

minuto 46'

Sale del partido

M. Caufriez

minuto 46'

Entra en el partido

J. Béla

minuto 46'

Sale del partido Jordan Ferri

minuto 46'

Sale del partido T. Savanier

minuto 46'

Entra en el partido Sacha Delaye

minuto 46'

Entra en el partido M. Estève

minuto 46'

Entra en el partido Gabriel Barès

minuto 46'

Sale del partido Khalil Fayad

minuto 46'

Entra en el partido B. Omeragić

minuto 46'

Sale del partido Falaye Sacko

minuto 46'

Entra en el partido L. Mincarelli

minuto 46'

Sale del partido C. Jullien

minuto 46'

Entra en el partido M. Sakho

minuto 46'

Sale del partido Kiki Kouyaté

Entra en el partido

K. Andrić

minuto 46'

Sale del partido I. Sylla

minuto 46'

Entra en el partido Enzo Tchato

minuto 46'

Sale del partido Joris Chotard

Sale del partido

G. Kyei

minuto 46'

Sale del partido

M. Cham

minuto 55'

Entra en el partido

B. Boutobba

minuto 55'

Entra en el partido

Y. Armougom

minuto 55'

Sale del partido

Johan Gastien

minuto 55'

Entra en el partido

C. Keita

minuto 55'

Sale del partido

M. Gonalons

minuto 55'

Entra en el partido

Yohann Magnin

minuto 55'

Sale del partido

Mehdi Zeffane

minuto 55'

Sale del partido

Neto Borges

minuto 55'

Sale del partido

M. Wieteska

minuto 55'

Entra en el partido

Florent Ogier

minuto 55'

Sale del partido

Andy Pelmard

minuto 55'

Entra en el partido

C. Konaté

minuto 55'

Sale del partido

Mory Diaw

minuto 55'

Entra en el partido

Théo Borne

minuto 55'

Entra en el partido

Adam Mabrouk

minuto 55'

minuto 60'

Entra en el partido D. Bertaud

minuto 60'

Sale del partido B. Lecomte

Alineaciones

Clermont

4-4-2

Alineación Inicial

55'

Mory Diaw
5
46'

M. Caufriez
3
55'

Neto Borges
55'

Andy Pelmard
55'

M. Wieteska
55'

Mehdi Zeffane
25
55'

Johan Gastien
55'

M. Gonalons
55'

M. Cham
46'

Jim Allevinah
95
46'

G. Kyei

Suplentes

55'

Théo Borne
15
55'

C. Konaté
21
55'

Florent Ogier
46'

Alidu Seidu
55'

Y. Armougom
Stan Berkani
55'

Adam Mabrouk
55'

Yohann Magnin
12
55'

C. Keita
46'

K. Andrić
91
46'

J. Béla
10
55'

B. Boutobba

Montpellier

4-4-2

Alineación Inicial

40
60'

B. Lecomte
6
46'

C. Jullien
46'

Kiki Kouyaté
46'

Falaye Sacko
46'

I. Sylla
46'

Joris Chotard
22
46'

Khalil Fayad
12
46'

Jordan Ferri
11
46'

T. Savanier
46'

M. Al-Tamari
190
46'

Wahbi Khazri

Suplentes

16
60'

D. Bertaud
14
46'

M. Estève
46'

L. Mincarelli
46'

B. Omeragić
29
46'

Enzo Tchato
75
46'

M. Sakho
10
46'

Sacha Delaye
46'

Gabriel Barès
46'

Mama Baldé
46'

Yanis Issoufou
46'

Junior Ndiaye

Estadísticas del partido

Clermont		Montpellier
50%	Posesión del balón	50%
1	Goles	1
0	Tarjetas Rojas	0
3	Sustituciones	3

Otros partidos

Manchester United 1-3 Wrexham AFC 502

Concordia Chiajna 1-1 CSM Slatina 7

Slovan Liberec II 5-2 Dukla Praha II 1

Polet Dorćol 0-2 Prva Iskra 1

Mioveni 0-1 FC Arges 8

FC La Unión Atl. 3-0 Al Ain Sub 21 2

Triglav Kranj 0-4 Trabzonspor 6

Portosantense 2-0 Trofense 1

Omladinac NB 2-3 Inđija 1

AVS Futebol 2-1 Varzim 1

CD Ursaria 1-2 Deportivo Aragón 5

Rayo Cantabria 1-1 CD Vitoria 1

NOTICIAS RELACIONADAS

USO DE MEMORIA

7,151,344 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Match / Index )	2.2442
Total Execution Time	2.2453

CADENA URL

/partido_71432/Clermont-Foot/Montpellier-Hsc/2024

GET DATOS

$_GET['/partido_71432/Clermont-Foot/Montpellier-Hsc/2024']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0147	SELECT c., c.stadium as real_stadium, 2024 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM* calendars2024 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.league_id = 71432 AND dt1.basealias = 'Clermont-Foot' AND dt2.basealias = 'Montpellier-Hsc'
0.0114	SELECT c., 2024 AS year, dt1.id AS dteam1_id, dt1.nameShow AS team1_name, dt1.basealias AS team1_basealias, dt1.fullName AS team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow AS team2_name, dt2.basealias AS team2_basealias, dt2.fullName AS team2_fullName, dt2.color1 AS team2_color1, t1.name AS team1_Oname, t2.name AS team2_Oname, s.id AS stadium_id, dt1.id AS stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM* calendars2024 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.league_id = 71432 AND dt1.basealias = 'Clermont-Foot' AND dt2.basealias = 'Montpellier-Hsc'
0.0108	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2024 AS ev WHERE ev.match_id=8820 ORDER BY (ev.action=1 OR ev.action=2 OR ev.action=6 OR ev.action=11 OR ev.action=12 OR ev.action=13) DESC,(ev.action=3 OR ev.action=4 OR ev.action=5) DESC,(ev.action=14 OR ev.action=15 OR ev.action=16 OR ev.action=17 OR ev.action=21) DESC,(ev.action=18 OR ev.action=19) DESC,(ev.action=20 OR ev.action=22) DESC, minute ASC, ev.real_date ASC, ev.id DESC, ev.action DESC
0.0126	SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=71432 WHERE dp.id IN (280977,975322,705836,3214322,199081,369124,52470,3212745,466322,918121,280778,200982,141690,120725,897644,891667,474826,276832,3199771,182499,3095,316247,186636,883434,796466,224078,477477,245295,466790,118110,900069,34759,357339,141689,430921,240900,214640,369104,3365301,203824,3195206,907640,245973,70357) AND (rp.team_id=6583058 OR rp.team_id=6583077)
0.0107	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2024 AS ev WHERE ev.match_id=8820 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0116	SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=71432 WHERE dp.id IN (3214322,199081,369124,52470,3212745,466322,918121,280778,200982,141690,120725,975322,897644,705836,891667,474826,276832,3199771,182499,3095,316247,280977,186636,883434,796466,224078,477477,245295,466790,118110,900069,34759,357339,141689,430921,240900,214640,369104,3365301,203824,3195206,907640,245973,70357) AND (rp.team_id=6583058 OR rp.team_id=6583077)
0.0105	SELECT data1 FROM stats2024 t WHERE league_id = 71432 AND teamId = 6583058 and type = 33
0.0106	SELECT data1 FROM stats2024 t WHERE league_id = 71432 AND teamId = 6583077 and type = 33
0.0109	SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 71432 AND id_match = 8820
0.0133	SELECT rel.,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='71432' AND relp.team_id = drea.team_id WHERE rel.team_number=4800990 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0113	SELECT rel.,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='71432' AND relp.team_id = drea.team_id WHERE rel.team_number=4800991 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0153	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='71432' AND relp.team_id=6583058 WHERE mp.`match_id` = '8820' AND mp.year='2024' AND p.id NOT IN (203824,280778,430921,369104,240900,141689,118110,34759,477477,466322,224078,70357,182499,316247,276832,186636,796466,891667,141690,120725,369124,52470) 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='71432' AND relp.team_id=6583077 WHERE mp.`match_id` = '8820' AND mp.year='2024' AND p.id NOT IN (203824,280778,430921,369104,240900,141689,118110,34759,477477,466322,224078,70357,182499,316247,276832,186636,796466,891667,141690,120725,369124,52470) ORDER BY mp.`team` ASC, p.`role` ASC
0.0106	SELECT kit FROM kit_data_real WHERE league_id = 71432 AND id_match = 8820
0.0106	SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '8820' and rp.type = 2024 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0107	SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '8820' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0110	SELECT ,rel.id as rel_id FROM* `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='10' AND rel.active = 1 AND rel.league_id = 71432 AND rel.team1 = 6583058 AND rel.team2 = 6583077 ORDER BY FIELD(m.location,'es','en') DESC
0.0107	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 8820 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0108	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 8820 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0118	SELECT ,rel.id as rel_id FROM* `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='11' AND rel.active = 1 AND rel.league_id = 71432 AND rel.team1 = 6583058 AND rel.team2 = 6583077 ORDER BY FIELD(m.location,'es','en') DESC
0.0108	SELECT teamId FROM teams WHERE id = 6583058
0.0105	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 != 99 or c.r2 != 99) AND (c.datateam1 = 788 OR c.datateam2 = 788) ORDER BY shedule DESC LIMIT 10
0.0105	SELECT teamId FROM teams WHERE id = 6583077
0.0106	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 != 99 or c.r2 != 99) AND (c.datateam1 = 1728 OR c.datateam2 = 1728) ORDER BY shedule DESC LIMIT 10
0.0108	SELECT teamId FROM teams WHERE id = 6583058
0.0106	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 = 99 or c.r2 = 99) AND (c.datateam1 = 788 OR c.datateam2 = 788) ORDER BY shedule ASC LIMIT 10
0.0105	SELECT teamId FROM teams WHERE id = 6583077
0.0106	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 = 99 or c.r2 = 99) AND (c.datateam1 = 1728 OR c.datateam2 = 1728) ORDER BY shedule ASC LIMIT 10
0.0192	SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2024` WHERE league_id = 71432 AND round >= 366 AND round <= 366 AND team = 6583058 ORDER BY round ASC
0.0192	SELECT dr.name as showName, dr2.name as referee_var FROM calendars2024 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2024 and r.role=1 INNER JOIN datareferees dr on dr.id=r.referee_id INNER JOIN rel_calendars_referee as r2 ON c.id = r2.match_id and r2.year=2024 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 6583058 AND c.team2 = 6583077 AND c.league_id = 71432
0.0107	SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='8820' AND `active` = 1 AND year = 2024
0.0108	SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='8820' AND `active` = 1 AND year = 2024
0.0110	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='71432' AND relp.team_id=6583058 WHERE relp.in_squad=1 and mp.`match_id` = '8820' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0108	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='71432' AND relp.team_id=6583077 WHERE relp.in_squad=1 and mp.`match_id` = '8820' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0109	SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '71432' AND id_match = '8820'
0.0396	SELECT rel., dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '4800990' ORDER BY rating DESC LIMIT 1
0.0109	SELECT rel., dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '4800991' ORDER BY rating DESC LIMIT 1
0.0106	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8820 AND extraId = 71432 AND type_rel = 4
0.0104	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=153 AND type_rel = 3
0.0105	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 153 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0104	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 (1348207,1347212,1347002,1346512,1346307) ORDER BY n.cover_points DESC, update_date DESC
0.0105	SELECT rating1, rating2 FROM calendars_elo WHERE id=8820 AND league_id=71432 AND year=2024
0.0105	SELECT avg_rating FROM elo_teams WHERE id=1728
0.0105	SELECT position FROM tables2024 WHERE team=6583058 AND league_id=71432 AND round=56
0.0105	SELECT position FROM tables2024 WHERE team=6583077 AND league_id=71432 AND round=56
0.0105	SELECT * FROM futbol.calendars_lineups WHERE id = 8820 AND league_id = 71432 AND year = 2024


	¡Vas a denunciar un contenido! x Denuncia sólo contenidos que incumplan nuestras Normas de uso o conducta. Aunque revisamos todas las denuncias que nos llegan, sólo respondemos si procede. El uso indebido de esta herramienta también incumple las normas de conducta. Elige una de las siguientes opciones: Incumplimiento de las normas: Otra:

Eventos del partido

Goles

Tarjetas

Cambios

Alineaciones

Alineación Inicial

Suplentes

Alineación Inicial

Suplentes

Estadísticas del partido

Posesión del balón

Goles

Tarjetas Rojas

Sustituciones

Otros partidos

LIGAS RELACIONADAS

NOTICIAS RELACIONADAS