A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

Message: mysqli_error() expects parameter 1 to be mysqli, null given

Filename: ajax/db_link.php

Line Number: 42

Match Univ. Concepción - Unión La Calera - Resultados de Fútbol
  • Sáb 16 Novpostponed-
  • -

Pre-Partido

Array
(
    [type] => 5
    [isAfter] => 0
    [img] => 
    [date] => 2019-11-16 11:06:00
    [body] => 14 de las 55 (25%) sustituciones del Univ. Concepción se han realizado en los últimos 10 minutos del partido.
)

16 Nov

25 días

14 de las 55 (25%) sustituciones del Univ. Concepción se han realizado en los últimos 10 minutos del partido.

Array
(
    [type] => 4
    [isAfter] => 0
    [body] => P. Rubio es el máximo goleador y el mejor jugador de Univ. Concepción, anota el 25% de los goles del equipo (5 goles).
    [date] => 2019-11-16 20:30:00
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_asistencia@2x.png
    [img_player] => //resfu.thumbr.io/img_data/players/medium/192201.jpg?size=100x&ext=png&lossy=1
    [year] => 2019
    [player_id] => 192201
)

Jugador a tener en cuenta

P. Rubio es el máximo goleador y el mejor jugador de Univ. Concepción, anota el 25% de los goles del equipo (5 goles).

Array
(
    [type] => 5
    [isAfter] => 0
    [img] => 
    [date] => 2019-11-16 11:06:00
    [body] => El 22% de los goles (6) del Unión La Calera se han anotado entre los 5 últimos minutos de la primera parte y los 5 primeros minutos de la segunda parte.
)

16 Nov

25 días

El 22% de los goles (6) del Unión La Calera se han anotado entre los 5 últimos minutos de la primera parte y los 5 primeros minutos de la segunda parte.

Array
(
    [type] => 4
    [isAfter] => 0
    [body] => E. Isnaldo es sin lugar a dudas el mejor jugador de Unión La Calera y por lo tanto el jugador ofensivo más peligroso, 4 goles y 4 asistencias.
    [date] => 2019-11-16 20:30:00
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_asistencia@2x.png
    [img_player] => //resfu.thumbr.io/img_data/players/medium/164870.jpg?size=100x&ext=png&lossy=1
    [year] => 2019
    [player_id] => 164870
)

Jugador a tener en cuenta

E. Isnaldo es sin lugar a dudas el mejor jugador de Unión La Calera y por lo tanto el jugador ofensivo más peligroso, 4 goles y 4 asistencias.

Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => goles
    [date] => 2019-11-16 20:30:00
    [event] => Máximos goleadores
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_asistencia@2x.png
    [players] => Array
        (
        )

    [local_shield] => //resfu.thumbr.io/img_data/escudos/medium/2600.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/5587.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2019
                    [player_id] => 192201
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/192201.jpg?size=100x&ext=png&lossy=1
                    [name] => P. Rubio
                    [extra] => 5 goles
                    [player_url] => jugador/p-rubio-192201
                )

            [1] => Array
                (
                    [year] => 2019
                    [player_id] => 154607
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/154607.jpg?size=100x&ext=png&lossy=1
                    [name] => N. Orellana
                    [extra] => 4 goles
                    [player_url] => jugador/n-orellana-154607
                )

            [2] => Array
                (
                    [year] => 2019
                    [player_id] => 131599
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/131599.jpg?size=100x&ext=png&lossy=1
                    [name] => B. Rabello
                    [extra] => 3 goles
                    [player_url] => jugador/b-rabello-131599
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2019
                    [player_id] => 51895
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/51895.jpg?size=100x&ext=png&lossy=1
                    [name] => M. Larrondo
                    [extra] => 4 goles
                    [player_url] => jugador/marcelo-larrondo
                )

            [1] => Array
                (
                    [year] => 2019
                    [player_id] => 164870
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/164870.jpg?size=100x&ext=png&lossy=1
                    [name] => E. Isnaldo
                    [extra] => 4 goles
                    [player_url] => jugador/e-isnaldo-164870
                )

            [2] => Array
                (
                    [year] => 2019
                    [player_id] => 288732
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/288732.jpg?size=100x&ext=png&lossy=1
                    [name] => T. Rodriguez
                    [extra] => 3 goles
                    [player_url] => jugador/t-rodriguez-288732
                )

        )

)
Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => tarjetas
    [date] => 2019-11-16 06:24:00
    [event] => Tarjetas amarillas y rojas
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_silbato@2x.png
    [players] => Array
        (
        )

    [local_shield] => //resfu.thumbr.io/img_data/escudos/medium/2600.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/5587.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2019
                    [player_id] => 215772
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/215772.jpg?size=100x&ext=png&lossy=1
                    [name] => G. Mencia
                    [extra] => 9 tarjetas
                    [player_url] => jugador/g-mencia-215772
                )

            [1] => Array
                (
                    [year] => 2019
                    [player_id] => 192201
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/192201.jpg?size=100x&ext=png&lossy=1
                    [name] => P. Rubio
                    [extra] => 7 tarjetas
                    [player_url] => jugador/p-rubio-192201
                )

            [2] => Array
                (
                    [year] => 2019
                    [player_id] => 154607
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/154607.jpg?size=100x&ext=png&lossy=1
                    [name] => N. Orellana
                    [extra] => 5 tarjetas
                    [player_url] => jugador/n-orellana-154607
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2019
                    [player_id] => 16852
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/16852.jpg?size=100x&ext=png&lossy=1
                    [name] => P. Alvarado
                    [extra] => 8 tarjetas
                    [player_url] => jugador/p-alvarado-16852
                )

            [1] => Array
                (
                    [year] => 2019
                    [player_id] => 213025
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/213025.jpg?size=100x&ext=png&lossy=1
                    [name] => M. Laba
                    [extra] => 7 tarjetas
                    [player_url] => jugador/matias-laba-213025
                )

            [2] => Array
                (
                    [year] => 2019
                    [player_id] => 94927
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/94927.jpg?size=100x&ext=png&lossy=1
                    [name] => S. Zuñiga
                    [extra] => 5 tarjetas
                    [player_url] => jugador/sebastian-zuniga
                )

        )

)
Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => veces
    [date] => 2019-11-16 11:06:00
    [event] => Entra desde el banquillo
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_cambios@2x.png
    [players] => Array
        (
        )

    [local_shield] => //resfu.thumbr.io/img_data/escudos/medium/2600.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/5587.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2019
                    [player_id] => 317438
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/317438.jpg?size=100x&ext=png&lossy=1
                    [name] => S. Pino
                    [extra] => 8 veces
                    [player_url] => jugador/c-canio-manosalva-317438
                )

            [1] => Array
                (
                    [year] => 2019
                    [player_id] => 118524
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/118524.jpg?size=100x&ext=png&lossy=1
                    [name] => N. Maturana
                    [extra] => 7 veces
                    [player_url] => jugador/n-maturana-118524
                )

            [2] => Array
                (
                    [year] => 2019
                    [player_id] => 225983
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/225983.jpg?size=100x&ext=png&lossy=1
                    [name] => J. Huentelaf
                    [extra] => 6 veces
                    [player_url] => jugador/j-huentelaf-225983
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2019
                    [player_id] => 156655
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/156655.jpg?size=100x&ext=png&lossy=1
                    [name] => J. Monreal
                    [extra] => 11 veces
                    [player_url] => jugador/c-alvarez-156655
                )

            [1] => Array
                (
                    [year] => 2019
                    [player_id] => 94927
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/94927.jpg?size=100x&ext=png&lossy=1
                    [name] => S. Zuñiga
                    [extra] => 9 veces
                    [player_url] => jugador/sebastian-zuniga
                )

            [2] => Array
                (
                    [year] => 2019
                    [player_id] => 94620
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/94620.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Meneses
                    [extra] => 5 veces
                    [player_url] => jugador/c-meneses-94620
                )

        )

)
Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => veces
    [date] => 2019-11-16 11:06:00
    [event] => Veces sustituido
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_banquillo@2x.png
    [players] => Array
        (
        )

    [local_shield] => //resfu.thumbr.io/img_data/escudos/medium/2600.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/5587.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2019
                    [player_id] => 118524
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/118524.jpg?size=100x&ext=png&lossy=1
                    [name] => N. Maturana
                    [extra] => 8 veces
                    [player_url] => jugador/n-maturana-118524
                )

            [1] => Array
                (
                    [year] => 2019
                    [player_id] => 54706
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/54706.jpg?size=100x&ext=png&lossy=1
                    [name] => A. Camargo
                    [extra] => 6 veces
                    [player_url] => jugador/a-camargo-54706
                )

            [2] => Array
                (
                    [year] => 2019
                    [player_id] => 138304
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/138304.jpg?size=100x&ext=png&lossy=1
                    [name] => L. Figueroa
                    [extra] => 5 veces
                    [player_url] => jugador/l-figueroa-138304
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2019
                    [player_id] => 132165
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/132165.jpg?size=100x&ext=png&lossy=1
                    [name] => F. Lobos
                    [extra] => 12 veces
                    [player_url] => jugador/g-lorenzetti-132165
                )

            [1] => Array
                (
                    [year] => 2019
                    [player_id] => 288732
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/288732.jpg?size=100x&ext=png&lossy=1
                    [name] => T. Rodriguez
                    [extra] => 10 veces
                    [player_url] => jugador/t-rodriguez-288732
                )

            [2] => Array
                (
                    [year] => 2019
                    [player_id] => 213025
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/213025.jpg?size=100x&ext=png&lossy=1
                    [name] => M. Laba
                    [extra] => 5 veces
                    [player_url] => jugador/matias-laba-213025
                )

        )

)
Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => asistencias
    [date] => 2019-11-16 15:48:00
    [event] => Máximos asistentes
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_asistencia@2x.png
    [players] => Array
        (
        )

    [local_shield] => //resfu.thumbr.io/img_data/escudos/medium/2600.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/5587.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2019
                    [player_id] => 192201
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/192201.jpg?size=100x&ext=png&lossy=1
                    [name] => P. Rubio
                    [extra] => 3 asistencias
                    [player_url] => jugador/p-rubio-192201
                )

            [1] => Array
                (
                    [year] => 2019
                    [player_id] => 132046
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/132046.jpg?size=100x&ext=png&lossy=1
                    [name] => F. Cordero
                    [extra] => 3 asistencias
                    [player_url] => jugador/fernando-cordero-132046
                )

            [2] => Array
                (
                    [year] => 2019
                    [player_id] => 118524
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/118524.jpg?size=100x&ext=png&lossy=1
                    [name] => N. Maturana
                    [extra] => 2 asistencias
                    [player_url] => jugador/n-maturana-118524
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2019
                    [player_id] => 164870
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/164870.jpg?size=100x&ext=png&lossy=1
                    [name] => E. Isnaldo
                    [extra] => 4 asistencias
                    [player_url] => jugador/e-isnaldo-164870
                )

            [1] => Array
                (
                    [year] => 2019
                    [player_id] => 288732
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/288732.jpg?size=100x&ext=png&lossy=1
                    [name] => T. Rodriguez
                    [extra] => 3 asistencias
                    [player_url] => jugador/t-rodriguez-288732
                )

            [2] => Array
                (
                    [year] => 2019
                    [player_id] => 154751
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/154751.jpg?size=100x&ext=png&lossy=1
                    [name] => E. Wiemberg
                    [extra] => 2 asistencias
                    [player_url] => jugador/j-contreras-154751
                )

        )

)
Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => años
    [date] => 2019-11-16 11:06:00
    [event] => Jugadores más mayores
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_juegos@2x.png
    [players] => Array
        (
        )

    [local_shield] => //resfu.thumbr.io/img_data/escudos/medium/2600.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/5587.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2019
                    [player_id] => 94664
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/94664.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Muñoz
                    [extra] => 42 años
                    [player_url] => jugador/c-munoz-94664
                )

            [1] => Array
                (
                    [year] => 2019
                    [player_id] => 138304
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/138304.jpg?size=100x&ext=png&lossy=1
                    [name] => L. Figueroa
                    [extra] => 36 años
                    [player_url] => jugador/l-figueroa-138304
                )

            [2] => Array
                (
                    [year] => 2019
                    [player_id] => 92905
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/92905.jpg?size=100x&ext=png&lossy=1
                    [name] => F. Manríquez
                    [extra] => 35 años
                    [player_url] => jugador/f-manriquez-92905
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2019
                    [player_id] => 92801
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/92801.jpg?size=100x&ext=png&lossy=1
                    [name] => L. Giovini
                    [extra] => 38 años
                    [player_url] => jugador/l-giovini-92801
                )

            [1] => Array
                (
                    [year] => 2019
                    [player_id] => 131591
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/131591.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Vilches
                    [extra] => 36 años
                    [player_url] => jugador/c-vilches-131591
                )

            [2] => Array
                (
                    [year] => 2019
                    [player_id] => 16852
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/16852.jpg?size=100x&ext=png&lossy=1
                    [name] => P. Alvarado
                    [extra] => 33 años
                    [player_url] => jugador/p-alvarado-16852
                )

        )

)
Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => años
    [date] => 2019-11-16 11:06:00
    [event] => Jugadores más jóvenes
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_juegos@2x.png
    [players] => Array
        (
        )

    [local_shield] => //resfu.thumbr.io/img_data/escudos/medium/2600.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/5587.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2019
                    [player_id] => 865723
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => S. Elgueta
                    [extra] => 20 años
                    [player_url] => jugador/s-elgueta-865723
                )

            [1] => Array
                (
                    [year] => 2019
                    [player_id] => 694485
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/694485.jpg?size=100x&ext=png&lossy=1
                    [name] => L. Díaz
                    [extra] => 20 años
                    [player_url] => jugador/l-diaz-694485
                )

            [2] => Array
                (
                    [year] => 2019
                    [player_id] => 865721
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => J. González
                    [extra] => 20 años
                    [player_url] => jugador/j-gonzalez-865721
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2019
                    [player_id] => 864030
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/864030.jpg?size=100x&ext=png&lossy=1
                    [name] => V. Ramírez
                    [extra] => 19 años
                    [player_url] => jugador/v-ramirez-864030
                )

            [1] => Array
                (
                    [year] => 2019
                    [player_id] => 712685
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/712685.jpg?size=100x&ext=png&lossy=1
                    [name] => A. Cáceres
                    [extra] => 20 años
                    [player_url] => jugador/a-caceres-712685
                )

            [2] => Array
                (
                    [year] => 2019
                    [player_id] => 696768
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/696768.jpg?size=100x&ext=png&lossy=1
                    [name] => M. Álvarez
                    [extra] => 20 años
                    [player_url] => jugador/m-alvarez-696768
                )

        )

)
Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => cm
    [date] => 2019-11-16 11:06:00
    [event] => Jugadores más altos
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_juegos@2x.png
    [players] => Array
        (
        )

    [local_shield] => //resfu.thumbr.io/img_data/escudos/medium/2600.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/5587.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2019
                    [player_id] => 317438
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/317438.jpg?size=100x&ext=png&lossy=1
                    [name] => S. Pino
                    [extra] => 198 cm
                    [player_url] => jugador/c-canio-manosalva-317438
                )

            [1] => Array
                (
                    [year] => 2019
                    [player_id] => 93895
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/93895.jpg?size=100x&ext=png&lossy=1
                    [name] => A. Rolin
                    [extra] => 186 cm
                    [player_url] => jugador/a-rolin-93895
                )

            [2] => Array
                (
                    [year] => 2019
                    [player_id] => 140095
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/140095.jpg?size=100x&ext=png&lossy=1
                    [name] => Á. Salazar
                    [extra] => 185 cm
                    [player_url] => jugador/a-salazar-140095
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2019
                    [player_id] => 92801
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/92801.jpg?size=100x&ext=png&lossy=1
                    [name] => L. Giovini
                    [extra] => 192 cm
                    [player_url] => jugador/l-giovini-92801
                )

            [1] => Array
                (
                    [year] => 2019
                    [player_id] => 51895
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/51895.jpg?size=100x&ext=png&lossy=1
                    [name] => M. Larrondo
                    [extra] => 191 cm
                    [player_url] => jugador/marcelo-larrondo
                )

            [2] => Array
                (
                    [year] => 2019
                    [player_id] => 156655
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/156655.jpg?size=100x&ext=png&lossy=1
                    [name] => J. Monreal
                    [extra] => 191 cm
                    [player_url] => jugador/c-alvarez-156655
                )

        )

)
Array
(
    [type] => 12
    [isAfter] => 0
    [img] => 
    [date] => 2019-11-16 20:30:00
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_juegos@2x.png
    [img_team] => //resfu.thumbr.io/img_data/escudos/medium/5587.jpg?size=100x&ext=png&lossy=1
    [year] => 2019
    [team_id] => 5587
    [body] => Esta temporada parece que Unión La Calera estará en la lucha por las posiciones de cabeza gracias, en gran medida, a la buena racha de resultados que ha encadenado últimamente con 6 puntos en 4 partidos.
)

16 Nov

25 días

Esta temporada parece que Unión La Calera estará en la lucha por las posiciones de cabeza gracias, en gran medida, a la buena racha de resultados que ha encadenado últimamente con 6 puntos en 4 partidos.

Array
(
    [type] => 12
    [isAfter] => 0
    [img] => 
    [date] => 2019-11-16 20:30:00
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_juegos@2x.png
    [img_team] => //resfu.thumbr.io/img_data/escudos/medium/2600.jpg?size=100x&ext=png&lossy=1
    [year] => 2019
    [team_id] => 2600
    [body] => Aunque Los resultados no están acompañando este año a Univ. Concepción, su actual racha de 10 puntos en 7 jornadas les da un balón de oxigeno para intentar mantener la categoría.
)

16 Nov

25 días

Aunque Los resultados no están acompañando este año a Univ. Concepción, su actual racha de 10 puntos en 7 jornadas les da un balón de oxigeno para intentar mantener la categoría.

Array
(
    [type] => 2
    [isAfter] => 0
    [date] => 2019-11-16 20:30:00
    [title] => ¿Quién va a ganar la posesión?
    [data_1] => 48
    [data_2] => 52
)

16 Nov

25 días

¿Quién va a ganar la posesión?

timeline posesion
Univ. ConcepciónUDE
48%
//resfu.thumbr.io/img_data/escudos/medium/5587.jpg?size=100x&5ULC
52%
Array
(
    [type] => 12
    [isAfter] => 0
    [body] => Unión La Calera ha promediado un 56.3% de posesión en los últimos 24 partidos.
    [date] => 2019-11-16 20:30:00
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_asistencia@2x.png
    [img_team] => //resfu.thumbr.io/img_data/escudos/medium/5587.jpg?size=100x&ext=png&lossy=1
    [year] => 2019
    [team_id] => 5587
)

16 Nov

25 días

Unión La Calera ha promediado un 56.3% de posesión en los últimos 24 partidos.

Array
(
    [type] => 2
    [isAfter] => 0
    [date] => 2019-11-15 21:00:00
    [title] => ¿Quién caerá en más fueras de juego?
    [data_1] => 66
    [data_2] => 34
)

15 Nov

26 días

¿Quién caerá en más fueras de juego?

timeline posesion
Univ. ConcepciónUDE
66%
//resfu.thumbr.io/img_data/escudos/medium/5587.jpg?size=100x&5ULC
34%
Array
(
    [type] => 11
    [isAfter] => 0
    [key] => squad
    [date] => 2019-11-16 20:30:00
    [local] => Array
        (
            [0] => Array
                (
                    [nick] => D. Stuardo
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/d-stuardo-529305
                )

            [1] => Array
                (
                    [nick] => C. Muñoz
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/94664.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/c-munoz-94664
                )

            [2] => Array
                (
                    [nick] => Á. Salazar
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/140095.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/a-salazar-140095
                )

            [3] => Array
                (
                    [nick] => P. Benitez
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/248400.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/p-benitez-248400
                )

            [4] => Array
                (
                    [nick] => G. Voboril
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/16863.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/g-voboril-16863
                )

            [5] => Array
                (
                    [nick] => F. Cordero
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/132046.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/fernando-cordero-132046
                )

            [6] => Array
                (
                    [nick] => G. Pacheco
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/245425.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/g-pacheco-245425
                )

            [7] => Array
                (
                    [nick] => C. Navarrete
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/694385.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/c-navarrete-694385
                )

            [8] => Array
                (
                    [nick] => S. Elgueta
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/s-elgueta-865723
                )

            [9] => Array
                (
                    [nick] => A. Rolin
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/93895.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/a-rolin-93895
                )

            [10] => Array
                (
                    [nick] => H. Martinez
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/246253.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/hansley-martinez-246253
                )

            [11] => Array
                (
                    [nick] => V. Retamal
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/626732.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/v-retamal-626732
                )

            [12] => Array
                (
                    [nick] => G. Mencia
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/215772.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/g-mencia-215772
                )

            [13] => Array
                (
                    [nick] => J. Patiño
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/j-patino-881431
                )

            [14] => Array
                (
                    [nick] => F. Portillo
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/196003.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/francisco-portillo-196003
                )

            [15] => Array
                (
                    [nick] => J. Martínez
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/j-martinez-853871
                )

            [16] => Array
                (
                    [nick] => J. Ballón
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/71815.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/j-ballon-71815
                )

            [17] => Array
                (
                    [nick] => B. Rabello
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/131599.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/b-rabello-131599
                )

            [18] => Array
                (
                    [nick] => A. Camargo
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/54706.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/a-camargo-54706
                )

            [19] => Array
                (
                    [nick] => L. Figueroa
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/138304.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/l-figueroa-138304
                )

            [20] => Array
                (
                    [nick] => J. González
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/j-gonzalez-865721
                )

            [21] => Array
                (
                    [nick] => F. Manríquez
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/92905.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/f-manriquez-92905
                )

            [22] => Array
                (
                    [nick] => G. Asken
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/285612.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/g-asken-285612
                )

            [23] => Array
                (
                    [nick] => L. Díaz
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/694485.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/l-diaz-694485
                )

            [24] => Array
                (
                    [nick] => A. Ramírez
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/311940.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/ricardo-gonzalez-311940
                )

            [25] => Array
                (
                    [nick] => J. Huentelaf
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/225983.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/j-huentelaf-225983
                )

            [26] => Array
                (
                    [nick] => L. Riveros
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/362066.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/d-castillo-362066
                )

            [27] => Array
                (
                    [nick] => P. Rubio
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/192201.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/p-rubio-192201
                )

            [28] => Array
                (
                    [nick] => W. Ponce
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/295993.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/w-ponce-295993
                )

            [29] => Array
                (
                    [nick] => N. Muñoz
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/817278.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/n-munoz-817278
                )

            [30] => Array
                (
                    [nick] => N. Maturana
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/118524.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/n-maturana-118524
                )

            [31] => Array
                (
                    [nick] => S. Pino
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/317438.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/c-canio-manosalva-317438
                )

            [32] => Array
                (
                    [nick] => N. Orellana
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/154607.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/n-orellana-154607
                )

        )

    [visitor] => Array
        (
            [0] => Array
                (
                    [nick] => A. Batalla
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/198201.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/a-batalla-198201
                )

            [1] => Array
                (
                    [nick] => A. Rojo
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/881438.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/a-rojo-881438
                )

            [2] => Array
                (
                    [nick] => L. Giovini
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/92801.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/l-giovini-92801
                )

            [3] => Array
                (
                    [nick] => P. Heredia
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/109508.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/p-heredia-109508
                )

            [4] => Array
                (
                    [nick] => E. Figueroa
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/283141.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/erik-figueroa-283141
                )

            [5] => Array
                (
                    [nick] => Y. Leiva
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/295555.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/y-leiva-295555
                )

            [6] => Array
                (
                    [nick] => P. Alvarado
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/16852.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/p-alvarado-16852
                )

            [7] => Array
                (
                    [nick] => C. Vilches
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/131591.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/c-vilches-131591
                )

            [8] => Array
                (
                    [nick] => C. Pizarro
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/712687.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/c-pizarro-712687
                )

            [9] => Array
                (
                    [nick] => M. Navarrete
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/196007.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/m-navarrete-196007
                )

            [10] => Array
                (
                    [nick] => E. Wiemberg
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/154751.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/j-contreras-154751
                )

            [11] => Array
                (
                    [nick] => A. Cáceres
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/712685.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/a-caceres-712685
                )

            [12] => Array
                (
                    [nick] => Y. Andía
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/478850.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/j-andia-478850
                )

            [13] => Array
                (
                    [nick] => V. Ramírez
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/864030.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/v-ramirez-864030
                )

            [14] => Array
                (
                    [nick] => S. Zuñiga
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/94927.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/sebastian-zuniga
                )

            [15] => Array
                (
                    [nick] => M. Álvarez
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/696768.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/m-alvarez-696768
                )

            [16] => Array
                (
                    [nick] => S. Leyton
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/93443.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/s-leyton-93443
                )

            [17] => Array
                (
                    [nick] => D. Rojas
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/196031.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/diego-rojas-196031
                )

            [18] => Array
                (
                    [nick] => K. Vásquez
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/246641.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/m-lopez-246641
                )

            [19] => Array
                (
                    [nick] => C. Meneses
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/94620.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/c-meneses-94620
                )

            [20] => Array
                (
                    [nick] => M. Laba
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/213025.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/matias-laba-213025
                )

            [21] => Array
                (
                    [nick] => E. Valencia
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/626746.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/e-valencia-626746
                )

            [22] => Array
                (
                    [nick] => T. Rodriguez
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/288732.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/t-rodriguez-288732
                )

            [23] => Array
                (
                    [nick] => F. Manzano
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/196030.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/fabian-manzano-196030
                )

            [24] => Array
                (
                    [nick] => A. Quiñones
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/94266.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/c-munoz-94266
                )

            [25] => Array
                (
                    [nick] => M. Larrondo
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/51895.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/marcelo-larrondo
                )

            [26] => Array
                (
                    [nick] => F. Lobos
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/132165.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/g-lorenzetti-132165
                )

            [27] => Array
                (
                    [nick] => F. Manzo
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/196012.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/jorge-aguilar-196012
                )

            [28] => Array
                (
                    [nick] => J. Leiva
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/222307.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/j-leiva-222307
                )

            [29] => Array
                (
                    [nick] => J. Monreal
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/156655.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/c-alvarez-156655
                )

            [30] => Array
                (
                    [nick] => L. Robles
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/l-robles-881437
                )

            [31] => Array
                (
                    [nick] => N. Stefanelli
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/225776.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/n-stefanelli-225776
                )

            [32] => Array
                (
                    [nick] => E. Isnaldo
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/164870.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/e-isnaldo-164870
                )

        )

)
Array
(
    [type] => 9
    [isAfter] => 0
    [numMatches] => 1
    [date] => 2019-12-12 07:15:07
    [matches] => Array
        (
            [0] => Array
                (
                    [match_url] => partido/Union-Calera/Univ-Concepcion
                    [id] => 416845
                    [r1] => 3
                    [r2] => 1
                    [short_name1] => ULC
                    [short_name2] => UDE
                    [shedule] => 2019-03-29 22:30:00
                    [category] => Primera Chile
                    [year] => 2019
                    [team1] => 5587
                    [team2] => 2600
                    [winner] => 5587
                )

        )

)

12 Dic

0 segundos

¿Sabes qué pasó en encuentros anteriores?

ver más…
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso.
Aceptar Más información y cambio de configuración

  USO DE MEMORIA  
3,939,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Match / Index )  0.1777
Total Execution Time  0.1807
  CADENA URL  
/partido/Univ-Concepcion/Union-Calera/2019
  GET DATOS  
$_GET['/partido/Univ-Concepcion/Union-Calera/2019']  
$_GET['completed']  
$_GET['clang']  
$_GET['isocode']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (2)  
0.0047   SELECT c.*, 2019 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 calendars2019 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 = 'Univ-Concepcion' AND dt2.basealias = 'Union-Calera'
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=580041 AND extraId = 48720 AND type_rel = 4