Web
            Analytics
  • Dom 12 Ago 20:30finalizado0
  • 2

GOLES

64
D. Portillo
70
N. Sepúlveda

TARJETAS

H. Bascuñán
T. Amarilla

H. Bascuñán

42
D. Tapia
T. Amarilla

D. Tapia

56

SUSTITUCIONES

52
Sale del partido

J. Gaete

J. Gaete
52
Entra

M. Orlando

M. Orlando
A. Fiorina
Sale del partido

A. Fiorina

68
F. Mateos
Entra

F. Mateos

68
J. Jiménez
Entra

J. Jiménez

68
E. Croce
Sale del partido

E. Croce

68
75
Sale del partido

L. Maldonado

L. Maldonado
75
Juan Gutierrez
75
Entra

F. Rojas

F. Rojas
75
Sale del partido

V. Sarabia

V. Sarabia
O. Pozo
Sale del partido

O. Pozo

84
E. Bullon
Entra

E. Bullon

84

TABLAS | Jornada 19

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

Ascenso

Coquimbo Unido

Playoff de ascenso

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

Descenso

San Marcos Arica


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