Partido Libertad FC - Universidad Católica

Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

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

Libertad FC - Universidad Católica Libertad FC - Universidad Católica

Jornada 2

FINALIZADO

885 Pts. Elo

39%

16º

Libertad FC

1495 Pts. Elo

60%

2º

Universidad Católica

0-1

Martes, 12 Marzo 2024, 01:00

0 - 1

18'

L. Nieto

Eventos del partido

Goles

minuto 18'

Gol de L. Nieto

Tarjetas

T. Amarilla

L. Disanto

minuto 38'

minuto 62'

T. Amarilla Jhon Cifuente

minuto 74'

T. Amarilla F. Martínez

T. Amarilla

I. Zambrano

minuto 81'

T. Amarilla

L. Basán

minuto 89'

minuto 96'

T. Amarilla L. Castillo

minuto 98'

T. Amarilla J. Fajardo

Cambios

Sale del partido

J. Hernández

minuto 46'

Entra en el partido

Jose Caicedo

minuto 46'

Entra en el partido

I. Zambrano

minuto 46'

Sale del partido

A. Ávila

minuto 46'

Sale del partido

R. Farias

minuto 60'

Sale del partido

P. Larrea

minuto 60'

Entra en el partido

J. Martinez

minuto 60'

Entra en el partido

D. Ávila

minuto 60'

minuto 69'

Sale del partido L. Nieto

minuto 69'

Sale del partido K. Quevedo

minuto 69'

Entra en el partido J. Fajardo

minuto 69'

Entra en el partido D. Clavijo

Sale del partido

N. Molina

minuto 75'

Entra en el partido

G. Valenzuela

minuto 75'

minuto 79'

Sale del partido Jhon Cifuente

minuto 79'

Entra en el partido L. Castillo

minuto 79'

Sale del partido I. Diaz

minuto 79'

Entra en el partido A. Rodríguez

Otros

minuto 18'

Asistencia F. Martínez

Alineaciones

Libertad FC

4-3-3

Alineación Inicial

1

J. Bolado
27

J. Alvacete
33

C. Enciso
15
46'

J. Hernández
25

J. Bolaños
11

L. Disanto
32
60'

R. Farias
5
60'

P. Larrea
8
46'

A. Ávila
26
75'

N. Molina
29

L. Basán

Suplentes

90

E. Bores
16
46'

Jose Caicedo
6

B. Caicedo
4

C. Obando
12
75'

G. Valenzuela
7
46'

I. Zambrano
13

L. Angulo
70

John Huilca
77
60'

J. Martinez
9
60'

D. Ávila

Universidad Católica

4-5-1

Alineación Inicial

22

R. Romo
37

F. Grillo
15

G. Vallecilla
18

L. Loor
29

G. Anangonó
10

F. Martínez
4

K. Minda
21
69'

L. Nieto
30
79'

I. Diaz
27
69'

K. Quevedo
16
79'

Jhon Cifuente

Suplentes

1

Elias Valencia
20
79'

L. Castillo
25

I. Mosquera
3

J. Quiñónez
55

Rooney Troya
53

D. Mejia
52

L. Moreno
7
79'

A. Rodríguez
9
69'

J. Fajardo
11

J. Vivar
8
69'

D. Clavijo

Estadísticas del partido

Libertad FC		Universidad
39%	Posesión del balón	60%
0	Goles	1
2	Tiros a puerta	7
4	Tiros fuera	4
8	Total tiros	17
5	Paradas del portero	2
3	Saques de esquina	11
2	Fueras de juego	1
0	Tarjetas Rojas	0
0	Asistencias	1
3	Sustituciones	3
14	Faltas	16

0 Comentarios

No hay comentarios

Partido televisado en...

Canal	Medio	Idioma	País
GolTV Play	TV	Castellano
Star+	TV	-

NOTICIAS RELACIONADAS

Ver otras noticias destacadas »

Otros partidos

CS Emelec 0-0 Mushuc Runa 283

Macará 1-0 CD El Nacional 74

Imbabura 3-0 Delfín 57

Independiente del Valle 3-1 Barcelona SC 159

Aucas 3-1 Técnico Universitario 36

Orense 1-1 Deportivo Cuenca 22

Cumbayá 1-3 Liga de Quito 65

Clasificación | Jornada 2

USO DE MEMORIA

6,906,768 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Match / Index )	1.3391
Total Execution Time	1.3403

CADENA URL

/partido/Club-Atletico-Libertad/Universidad-Catolica-Ecuador/2024

GET DATOS

$_GET['/partido/Club-Atletico-Libertad/Universidad-Catolica-Ecuador/2024']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0031	SELECT 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` = '75066' AND c.`match_id` = '678303'
0.0165	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.extra != 1 AND dt1.basealias = 'Club-Atletico-Libertad' AND dt2.basealias = 'Universidad-Catolica-Ecuador'
0.0131	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.extra != 1 AND dt1.basealias = 'Club-Atletico-Libertad' AND dt2.basealias = 'Universidad-Catolica-Ecuador'
0.0125	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=678303 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.0133	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=75066 WHERE dp.id IN (72071,376778,319143,119382,369418,473487,862952,393894,314427,3377172,274628,644798,78637,333159,319798,335846,425178,644341,3245762,283011,896781) AND (rp.team_id=6626463 OR rp.team_id=6626469)
0.0126	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=678303 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0153	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=75066 WHERE dp.id IN (72071,119382,376778,314427,3377172,369418,274628,644798,78637,333159,319798,319143,335846,393894,425178,644341,3245762,862952,283011,896781,473487) AND (rp.team_id=6626463 OR rp.team_id=6626469)
0.0128	SELECT data1 FROM stats2024 t WHERE league_id = 75066 AND teamId = 6626463 and type = 33
0.0127	SELECT data1 FROM stats2024 t WHERE league_id = 75066 AND teamId = 6626469 and type = 33
0.0131	SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 75066 AND id_match = 678303
0.0155	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='75066' AND relp.team_id = drea.team_id WHERE rel.team_number=5277221 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0144	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='75066' AND relp.team_id = drea.team_id WHERE rel.team_number=5277202 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0175	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='75066' AND relp.team_id=6626463 WHERE mp.`match_id` = '678303' AND mp.year='2024' AND p.id NOT IN (339268,116235,251286,314427,862628,376778,644798,78637,274628,644341,473487,28831,215240,480448,3245993,695265,119382,295865,72071,283011,335846,319143) ORDER BY mp.`team` ASC, p.`role` ASC
0.0133	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='75066' AND relp.team_id=6626469 WHERE mp.`match_id` = '678303' AND mp.year='2024' AND p.id NOT IN (339268,116235,251286,314427,862628,376778,644798,78637,274628,644341,473487,28831,215240,480448,3245993,695265,119382,295865,72071,283011,335846,319143) ORDER BY mp.`team` ASC, p.`role` ASC
0.0126	SELECT kit FROM kit_data_real WHERE league_id = 75066 AND id_match = 678303
0.0126	SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '678303' and rp.type = 2024 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127	SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '678303' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0130	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 = 75066 AND rel.team1 = 6626463 AND rel.team2 = 6626469 ORDER BY FIELD(m.location,'es','en') DESC
0.0125	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 678303 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0126	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 678303 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0132	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 = 75066 AND rel.team1 = 6626463 AND rel.team2 = 6626469 ORDER BY FIELD(m.location,'es','en') DESC
0.0136	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 75066 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128	SELECT teamId FROM teams WHERE id = 6626469
0.0127	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 = 5292 OR c.datateam2 = 5292) ORDER BY shedule DESC LIMIT 10
0.0136	SELECT teamId FROM teams WHERE id = 6626469
0.0141	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 = 5292 OR c.datateam2 = 5292) ORDER BY shedule ASC LIMIT 10
0.0130	SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2, c.shedule,c.id, c.r1, c.r2, c.round, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments,c.league_id FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 75066 AND c.`round` = 2 ORDER BY shedule ASC LIMIT 12
0.0141	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* `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 = 75066 AND t.round = 2 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2024` WHERE league_id = 75066 AND round >= 11 AND round <= 11 AND team = 6626463 ORDER BY round ASC
0.0126	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* `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 = 75066 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125	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 = 6626463 AND c.team2 = 6626469 AND c.league_id = 75066
0.0158	SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='678303' AND `active` = 1 AND year = 2024
0.0151	SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='678303' AND `active` = 1 AND year = 2024
0.0126	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='75066' AND relp.team_id=6626463 WHERE relp.in_squad=1 and mp.`match_id` = '678303' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0126	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='75066' AND relp.team_id=6626469 WHERE relp.in_squad=1 and mp.`match_id` = '678303' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0131	SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '75066' AND id_match = '678303'
0.0128	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 = '5277221' ORDER BY rating DESC LIMIT 1
0.0129	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 = '5277202' ORDER BY rating DESC LIMIT 1
0.0215	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=678303 AND extraId = 75066 AND type_rel = 4
0.0133	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=43 AND type_rel = 3
0.0125	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 43 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0125	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 (1297904,1299685,1289627,1269214,1269123) ORDER BY n.cover_points DESC, update_date DESC
0.0125	SELECT rating1, rating2 FROM calendars_elo WHERE id=678303 AND league_id=75066 AND year=2024
0.0125	SELECT position FROM tables2024 WHERE team=6626463 AND league_id=75066 AND round=2
0.0125	SELECT position FROM tables2024 WHERE team=6626469 AND league_id=75066 AND round=2
0.0125	SELECT * FROM futbol.calendars_lineups WHERE id = 678303 AND league_id = 75066 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:

A PHP Error was encountered

A PHP Error was encountered

Eventos del partido

Goles

Tarjetas

Cambios

Otros

Alineaciones

Alineación Inicial

Suplentes

Alineación Inicial

Suplentes

Estadísticas del partido

Posesión del balón

Goles

Tiros a puerta

Tiros fuera

Total tiros

Paradas del portero

Saques de esquina

Fueras de juego

Tarjetas Rojas

Asistencias

Sustituciones

Faltas

NOTICIAS RELACIONADAS

Otros partidos

Clasificación | Jornada 2

LIGAS RELACIONADAS