4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Thiers - Besancon FC
Jornada 11
FINALIZADO
20
31
93 Pts. Elo
12º

102 Pts. Elo
9º

3-0
Sábado, 12 Diciembre 2015, 18:00
A. Carmo 22'
1 - 0
J. Kassa 65'
2 - 0
F. Champeix 67'
3 - 0

Eventos del partido

Goles

A. CarmoGol de
A. Carmo
minuto 22'
J. KassaGol de
J. Kassa
minuto 65'
F. ChampeixGol de
F. Champeix
minuto 67'

Tarjetas

minuto 43'E. TroudartT. Amarilla E. Troudart
minuto 50'S. El AchakT. Amarilla S. El Achak
minuto 56'E. Troudart2a Amarilla y Roja E. Troudart
A. RibouletT. Amarilla
A. Riboulet
minuto 58'
W. MarimoutouT. Amarilla
W. Marimoutou
minuto 75'

Cambios

minuto 53'V. RevoySale del partido V. Revoy
minuto 53'D. DiotEntra en el partido D. Diot
B. BelmadiEntra en el partido
B. Belmadi
minuto 63'
B. SidibéSale del partido
B. Sidibé
minuto 63'
minuto 71'N. HakkarEntra en el partido N. Hakkar
minuto 71'A. HakkarSale del partido A. Hakkar
minuto 71'Ousmane SySale del partido Ousmane Sy
minuto 71'J. SchulzendorfEntra en el partido J. Schulzendorf
A. DiabyEntra en el partido
A. Diaby
minuto 79'
L. AndraudEntra en el partido
L. Andraud
minuto 79'
A. CarmoSale del partido
A. Carmo
minuto 79'
Z. LaissaouiSale del partido
Z. Laissaoui
minuto 79'

Alineaciones

Thiers

Thiers

4-4-2
Alineación Inicial
Suplentes
Besancon FC

Besancon FC

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,867,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.0933
Total Execution Time  0.0942
  CADENA URL  
/partido/Thiers/Besancon-Fc/2016
  GET DATOS  
$_GET['/partido/Thiers/Besancon-Fc/2016']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0078   SELECT c.*, c.stadium as real_stadium, 2016 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 calendars2016 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.extra != 1 AND dt1.basealias = 'Thiers' AND dt2.basealias = 'Besancon-Fc'
0.0026  SELECT c.*, 2016 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 calendars2016 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.extra != 1 AND dt1.basealias = 'Thiers' AND dt2.basealias = 'Besancon-Fc'
0.0018  SELECT data1 FROM stats2016 t WHERE league_id = 15902 AND teamId = 579044 and type = 33
0.0017  SELECT data1 FROM stats2016 t WHERE league_id = 15902 AND teamId = 289421 and type = 33
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '445578' and rp.type = 2016 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 445578 AND year = 2016 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 445578 AND year = 2016 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='445578' AND `active` = 1 AND year = 2016
0.0038  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='15902' AND relp.team_id=579044 WHERE relp.in_squad=1 and mp.`match_id` = '445578' AND mp.year='2016' ORDER BY mp.`team` ASC, p.`role` ASC
0.0043  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='15902' AND relp.team_id=289421 WHERE relp.in_squad=1 and mp.`match_id` = '445578' AND mp.year='2016' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=445578 AND extraId = 15902 AND type_rel = 4
0.0018  SELECT rating1, rating2 FROM calendars_elo WHERE id=445578 AND league_id=15902 AND year=2016
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 445578 AND league_id = 15902 AND year = 2016