Web
            Analytics
  • Dom 02 Sep 20:30finalizado3
  • 1

GOLES

9
Gol

L. Cano

L. Cano
M. Jorquera
21
M. Orlando
58
N. Sepúlveda
88

TARJETAS

18
T. Amarilla

V. Durán

V. Durán
J. Gaete
T. Amarilla

J. Gaete

37
83
T. Amarilla

J. Montecinos

J. Montecinos

SUSTITUCIONES

57
Sale del partido

J. García

J. García
57
Entra

F. Segovia

F. Segovia
V. Sarabia
Sale del partido

V. Sarabia

59
Juan Gutierrez
59
C. Oyaneder
Entra

C. Oyaneder

59
F. Castro
Sale del partido

F. Castro

59
60
J. Montecinos
60
Sale del partido

M. Ramírez

M. Ramírez
73
Sale del partido

F. Carmona

F. Carmona
73
F. Fernández
J. Gaete
Sale del partido

J. Gaete

73
R. Ureña
Entra

R. Ureña

73

TABLAS | Jornada 22

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

Ascenso

Coquimbo Unido

Playoff de ascenso

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

Descenso

San Marcos Arica


  USO DE MEMORIA  
4,340,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0025
Controller Execution Time ( Match / Index )  0.0991
Total Execution Time  0.1016
  CADENA URL  
/match/cobresal/cd-serena/2018
  GET DATOS  
$_GET['/match/cobresal/cd-serena/2018']  
$_GET['completed']  
$_GET['clang']  
$_GET['isocode']  
$_GET['group']  
$_GET['v']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (2)  
0.0026   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 = 'cd-serena'
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=818939 AND extraId = 42541 AND type_rel = 4