Web
            Analytics
  • Dom 09 Sep 22:00finalizado1
  • 1

GOLES

48
Gol

J. Gaete

J. Gaete
R. Holgado
56

TARJETAS

D. González
T. Amarilla

D. González

32
77
T. Amarilla

F. Rojas

F. Rojas
A. Delgado
T. Amarilla

A. Delgado

78
90
T. Amarilla

I. Sandoval

I. Sandoval

SUSTITUCIONES

63
Sale del partido

M. Filla

M. Filla
63
Entra

D. Céspedes

D. Céspedes
68
Sale del partido

N. Sepúlveda

N. Sepúlveda
68
Juan Gutierrez
D. González
Sale del partido

D. González

71
S. Galani
Entra

S. Galani

71
J. Orellana
Entra

J. Orellana

76
B. Ferreira
Sale del partido

B. Ferreira

76
78
Entra

I. Sandoval

I. Sandoval
78
Sale del partido

M. Orlando

M. Orlando
R. Holgado
Sale del partido

R. Holgado

85
S. Martelli
Entra

S. Martelli

85

TABLAS | Jornada 23

Equipo Pts G W E P GF GC
1 Coquimbo Uni.
Coquimbo Uni.
  • w
  • w
  • d
  • w
  • d
45 23 14 3 6 37 26
2 Cobresal
Cobresal
  • w
  • w
  • l
  • w
  • d
40 23 12 4 7 34 23
3 Deportes Val.
Deportes Val.
  • w
  • w
  • l
  • w
  • w
40 23 12 4 7 37 28
4 Cobreloa
Cobreloa
  • w
  • d
  • d
  • l
  • w
38 23 11 5 7 36 28
5 Santiago Mor.
Santiago Mor.
  • l
  • l
  • w
  • l
  • l
37 23 11 4 8 30 30
6 Rangers Talc.
Rangers Talc.
  • w
  • d
  • l
  • l
  • w
33 23 9 6 8 28 26
7 Unión San Fe.
Unión San Fe.
  • l
  • l
  • l
  • d
  • l
32 23 9 5 9 22 19
8 Santiago Wan.
Santiago Wan.
  • w
  • w
  • w
  • w
  • w
32 23 10 2 11 28 35
9 Magallanes
Magallanes
  • w
  • w
  • w
  • l
  • w
31 23 8 7 8 33 29
10 CD Melipilla
CD Melipilla
  • l
  • w
  • l
  • w
  • w
30 23 8 6 9 29 32
11 D. Copiapo
D. Copiapo
  • l
  • l
  • d
  • w
  • l
29 23 8 5 10 31 33
12 Ñublense
Ñublense
  • l
  • l
  • w
  • d
  • l
27 23 7 6 10 23 27
13 La Serena
La Serena
  • l
  • l
  • d
  • l
  • w
26 23 6 8 9 31 34
14 Barnechea
Barnechea
  • l
  • l
  • w
  • l
  • l
25 23 6 7 10 29 33
15 Puerto Montt
Puerto Montt
  • l
  • w
  • l
  • w
  • l
25 23 7 4 12 22 28
16 San Marcos A.
San Marcos A.
  • w
  • l
  • w
  • l
  • l
22 23 6 4 13 22 41

Ascenso

Coquimbo Unido

Playoff de ascenso

Cobresal,Deportes Valdivia,Cobreloa,Santiago Morning,Rangers Talca

Descenso

San Marcos Arica


  USO DE MEMORIA  
4,304,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0030
Controller Execution Time ( Match / Index )  0.0902
Total Execution Time  0.0933
  CADENA URL  
/match/coquimbo-unido/cobresal/2018
  GET DATOS  
$_GET['/match/coquimbo-unido/cobresal/2018']  
$_GET['completed']  
$_GET['clang']  
$_GET['isocode']  
$_GET['group']  
$_GET['v']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (2)  
0.0027   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 = 'coquimbo-unido' AND dt2.basealias = 'cobresal'
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=818945 AND extraId = 42541 AND type_rel = 4