Web
            Analytics
  • Dom 11 Feb 22:00finalizado2
  • 1

GOLES

23
Gol

N. Rojas

N. Rojas
É. Cantero
Gol de penalti

É. Cantero

55
J. Gaete
Gol

J. Gaete

68

TARJETAS

8
T. Amarilla

C. Villagrán

C. Villagrán
A. Corro
T. Amarilla

A. Corro

39
44
T. Amarilla

N. Rojas

N. Rojas
54
T. Amarilla

D. Tapia

D. Tapia
F. Rojas
T. Amarilla

F. Rojas

66

SUSTITUCIONES

46
Entra

M. Sánchez

M. Sánchez
46
Sale del partido

N. Rojas

N. Rojas
F. Rojas
Entra

F. Rojas

46
D. Céspedes
Sale del partido

D. Céspedes

46
A. Corro
Sale del partido

A. Corro

50
V. Sarabia
Entra

V. Sarabia

50
60
Sale del partido

E. Valencia

E. Valencia
60
Entra

J. Durán

J. Durán
C. Oyaneder
Sale del partido

C. Oyaneder

62
J. Gaete
Entra

J. Gaete

62
74
Entra

J. Lobos

J. Lobos
74
Sale del partido

A. Vega

A. Vega

TABLAS | Jornada 2

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

Ascenso

Rangers Talca

Playoff de ascenso

Barnechea,Magallanes,Santiago Wanderers,Cobreloa,Ñublense

Descenso

Puerto Montt


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