4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Calamonte - Villanovense
Jornada 9
FINALIZADO
20
30
349 Pts. Elo

478 Pts. Elo

2-1
Domingo, 20 Octubre 2019, 12:00
Jose Ecija 66'
1 - 0
1 - 1
 82' J. Tapia
Pity 88'
2 - 1

Eventos del partido

Goles

Jose EcijaGol de
Jose Ecija
minuto 66'
minuto 82'J. TapiaGol de J. Tapia
PityGol de penalti
Pity
minuto 88'

Tarjetas

PityT. Amarilla
Pity
minuto 20'
minuto 53'BeginesT. Amarilla Begines
minuto 76'GregoriT. Amarilla Gregori
ParraT. Amarilla
Parra
minuto 83'
minuto 87'I. De NovaT. Amarilla I. De Nova

Cambios

O. KelaartSale del partido
O. Kelaart
minuto 68'
MecheritoEntra en el partido
Mecherito
minuto 68'
minuto 75'BeginesSale del partido Begines
minuto 75'JuanpeSale del partido Juanpe
minuto 75'José AngelEntra en el partido José Angel
minuto 75'Javi SánchezEntra en el partido Javi Sánchez
minuto 83'J. TapiaSale del partido J. Tapia
minuto 83'F. ViñuelaEntra en el partido F. Viñuela
EnriqueSale del partido
Enrique
minuto 89'
HeoEntra en el partido
Heo
minuto 89'
TroiteiroSale del partido
Troiteiro
minuto 90'
ZoritaEntra en el partido
Zorita
minuto 90'

Alineaciones

Calamonte

Calamonte

4-4-2
Alineación Inicial
Suplentes
Villanovense

Villanovense

4-4-2
Alineación Inicial
Suplentes

Estadísticas del partido

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: comment/main_view.php

Line Number: 2065

Calamonte Calamonte Villanovense Villanovense
1 Comentarios + 1 respuestas
  • javi64
    Hace 4 años javi64 dice: 0 7


  USO DE MEMORIA  
6,742,520 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.2148
Total Execution Time  0.2158
  CADENA URL  
/partido/Calamonte/Cf-Villanovense/2020
  GET DATOS  
$_GET['/partido/Calamonte/Cf-Villanovense/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0010   SELECT c.comment_id, COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`league_id` = '50282' AND c.`match_id` = '93138' AND c.comment_id IN (27085646) GROUP BY c.comment_id
0.0018  SELECT data1 FROM stats2020 t WHERE league_id = 50282 AND teamId = 6291932 and type = 33
0.0019  SELECT data1 FROM stats2020 t WHERE league_id = 50282 AND teamId = 6291938 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 = '93138' and rp.type = 2020 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 = 93138 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 93138 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0020   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '27085646' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='93138' AND `active` = 1 AND year = 2020
0.0031  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='50282' AND relp.team_id=6291932 WHERE relp.in_squad=1 and mp.`match_id` = '93138' AND mp.year='2020' ORDER BY mp.`team` ASC, p.`role` ASC
0.0026  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='50282' AND relp.team_id=6291938 WHERE relp.in_squad=1 and mp.`match_id` = '93138' AND mp.year='2020' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=93138 AND extraId = 50282 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 93138 AND league_id = 50282 AND year = 2020