Web
            Analytics
  • Dom 25 Feb 22:00finalizado2
  • 0

GOLES

É. Cantero
80
É. Cantero
86

TARJETAS

43
T. Amarilla

B. Pérez

B. Pérez
M. Jorquera
T. Amarilla

M. Jorquera

65
74
T. Amarilla

F. Levipán

F. Levipán
É. Cantero
T. Amarilla

É. Cantero

75

SUSTITUCIONES

38
Sale del partido

F. Bahamondes

F. Bahamondes
38
Entra

B. Viveros

B. Viveros
V. Sarabia
Sale del partido

V. Sarabia

55
N. Sepúlveda
55
70
Sale del partido

C. Vilches

C. Vilches
70
Entra

F. Levipán

F. Levipán
L. Maldonado
Entra

L. Maldonado

76
J. Gaete
Sale del partido

J. Gaete

76
77
Sale del partido

I. Mesías

I. Mesías
77
Entra

S. Cordero

S. Cordero
C. Mesías
Entra

C. Mesías

90
É. Cantero
Sale del partido

É. Cantero

90

TABLAS | Jornada 4

Equipo Pts G W E P GF GC
1 Cobresal
Cobresal
  • l
  • w
  • w
  • w
9 4 3 0 1 6 3
2 Santiago Mor.
Santiago Mor.
  • l
  • w
  • w
  • w
9 4 3 0 1 8 6
3 Ñublense
Ñublense
  • w
  • d
  • d
  • w
8 4 2 2 0 3 1
4 D. Copiapo
D. Copiapo
  • l
  • d
  • w
  • w
7 4 2 1 1 7 4
5 Magallanes
Magallanes
  • d
  • w
  • l
  • w
7 4 2 1 1 6 3
6 Cobreloa
Cobreloa
  • w
  • d
  • w
  • l
7 4 2 1 1 5 3
7 La Serena
La Serena
  • l
  • w
  • d
  • w
7 4 2 1 1 3 3
8 CD Melipilla
CD Melipilla
  • w
  • l
  • w
  • l
6 4 2 0 2 8 7
9 Coquimbo Uni.
Coquimbo Uni.
  • w
  • l
  • w
  • l
6 4 2 0 2 5 5
10 Deportes Val.
Deportes Val.
  • l
  • w
  • l
  • w
6 4 2 0 2 5 5
11 Rangers Talc.
Rangers Talc.
  • w
  • d
  • l
  • l
4 4 1 1 2 4 4
12 Barnechea
Barnechea
  • w
  • d
  • l
  • l
4 4 1 1 2 4 5
13 Santiago Wan.
Santiago Wan.
  • w
  • d
  • l
  • l
4 4 1 1 2 3 6
14 San Marcos A.
San Marcos A.
  • l
  • l
  • l
  • w
3 4 1 0 3 5 9
15 Puerto Montt
Puerto Montt
  • l
  • l
  • w
  • l
3 4 1 0 3 1 5
16 Unión San Fe.
Unión San Fe.
  • d
  • l
  • l
  • l
1 4 0 1 3 3 7

Ascenso

Cobresal

Playoff de ascenso

Santiago Morning,Ñublense,D. Copiapo,Magallanes,Cobreloa

Descenso

Unión San Felipe


  USO DE MEMORIA  
4,310,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.0636
Total Execution Time  0.0648
  CADENA URL  
/match/cobresal/union-san-felipe/2018
  GET DATOS  
$_GET['/match/cobresal/union-san-felipe/2018']  
$_GET['completed']  
$_GET['clang']  
$_GET['isocode']  
$_GET['group']  
$_GET['v']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (2)  
0.0028   SELECT c.*, 2018 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.stadium, dt1.seats, dt1.size, dt1.yearBuilt,dt1.short_name AS local_abbr, dt2.short_name AS visitor_abbr, 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, s.team_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 FROM calendars2018 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 stadiums AS s ON c.stadium=s.id WHERE c.extra != 1 AND dt1.basealias = 'cobresal' AND dt2.basealias = 'union-san-felipe'
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=723620 AND extraId = 42541 AND type_rel = 4