Web
            Analytics
  • Dom 19 Ago 20:30finalizado4
  • 0

GOLES

L. Maldonado
34
J. Gaete
Gol

J. Gaete

49
M. Orlando
77
M. Orlando
83

TARJETAS

D. Portillo
T. Amarilla

D. Portillo

19
19
T. Amarilla

D. Ceron

D. Ceron
38
T. Roja

F. Saavedra

F. Saavedra
41
T. Amarilla

R. Adé

R. Adé
M. Filla
T. Amarilla

M. Filla

45
76
T. Amarilla

S. Contreras

S. Contreras

SUSTITUCIONES

D. Portillo
Sale del partido

D. Portillo

23
F. Rojas
Entra

F. Rojas

23
M. Orlando
Entra

M. Orlando

35
L. Maldonado
Sale del partido

L. Maldonado

35
46
Entra

F. Nuñez

F. Nuñez
46
Sale del partido

C. Aravena

C. Aravena
J. Gaete
Sale del partido

J. Gaete

58
C. Oyaneder
Entra

C. Oyaneder

58
66
Sale del partido

N. Kimura

N. Kimura
66
Entra

C. Parry

C. Parry

TABLAS | Jornada 20

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

Ascenso

Coquimbo Unido

Playoff de ascenso

Cobresal,Deportes Valdivia,Cobreloa,Santiago Morning,Unión San Felipe

Descenso

San Marcos Arica


  USO DE MEMORIA  
4,306,152 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.0663
Total Execution Time  0.0674
  CADENA URL  
/match_42541/cobresal/santiago-morning/2018
  GET DATOS  
$_GET['/match_42541/cobresal/santiago-morning/2018']  
$_GET['completed']  
$_GET['clang']  
$_GET['isocode']  
$_GET['group']  
$_GET['v']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (2)  
0.0032   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.league_id = 42541 AND dt1.basealias = 'cobresal' AND dt2.basealias = 'santiago-morning'
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=818926 AND extraId = 42541 AND type_rel = 4