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 PSV - Emmen - Resultados de Fútbol
PSV
PSV
  • Sáb 14 Marpostponed-
  • -

Pre-Partido

Array
(
    [type] => 5
    [isAfter] => 0
    [img] => 
    [date] => 2020-03-14 09:21:00
    [body] => 10 de los 45 (22%) goles del PSV han sido en los últimos 10 minutos del partido.
)

14 Mar

4 meses

10 de los 45 (22%) goles del PSV han sido en los últimos 10 minutos del partido.

Array
(
    [type] => 5
    [isAfter] => 0
    [img] => 
    [date] => 2020-03-14 09:21:00
    [body] => 9 de las 35 (26%) sustituciones del PSV se han realizado entre los minutos 60 y 70 de cada partido.
)

14 Mar

4 meses

9 de las 35 (26%) sustituciones del PSV se han realizado entre los minutos 60 y 70 de cada partido.

Array
(
    [type] => 4
    [isAfter] => 0
    [body] => D. Malen es el máximo goleador y el mejor jugador de PSV, anota el 24% de los goles del equipo (11 goles).
    [date] => 2020-03-14 18:45:00
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_asistencia@2x.png
    [img_player] => //resfu.thumbr.io/img_data/players/medium/286302.jpg?size=100x&ext=png&lossy=1
    [year] => 2020
    [player_id] => 286302
)

Jugador a tener en cuenta

D. Malen es el máximo goleador y el mejor jugador de PSV, anota el 24% de los goles del equipo (11 goles).

Array
(
    [type] => 5
    [isAfter] => 0
    [img] => 
    [date] => 2020-03-14 09:21:00
    [body] => El entrenador del Emmen realiza el 24% de las sustituciones (13) en los últimos 10 minutos del partido.
)

14 Mar

4 meses

El entrenador del Emmen realiza el 24% de las sustituciones (13) en los últimos 10 minutos del partido.

Array
(
    [type] => 5
    [isAfter] => 0
    [img] => 
    [date] => 2020-03-14 09:21:00
    [body] => El 28% de los goles (8) del Emmen se han anotado entre los minutos 50 y 60 de cada partido.
)

14 Mar

4 meses

El 28% de los goles (8) del Emmen se han anotado entre los minutos 50 y 60 de cada partido.

Array
(
    [type] => 4
    [isAfter] => 0
    [body] => M. De Leeuw es el máximo goleador y el mejor jugador de Emmen, anota el 31% de los goles del equipo (9 goles).
    [date] => 2020-03-14 18:45:00
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_asistencia@2x.png
    [img_player] => //resfu.thumbr.io/img_data/players/medium/84177.jpg?size=100x&ext=png&lossy=1
    [year] => 2020
    [player_id] => 84177
)

Jugador a tener en cuenta

M. De Leeuw es el máximo goleador y el mejor jugador de Emmen, anota el 31% de los goles del equipo (9 goles).

Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => goles
    [date] => 2020-03-14 18:45: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/2023.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/2925.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 286302
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/286302.jpg?size=100x&ext=png&lossy=1
                    [name] => D. Malen
                    [extra] => 11 goles
                    [player_url] => jugador/d-malen-286302
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 249429
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/249429.jpg?size=100x&ext=png&lossy=1
                    [name] => D. Dumfries
                    [extra] => 7 goles
                    [player_url] => jugador/d-dumfries-249429
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 346648
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/346648.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Gakpo
                    [extra] => 7 goles
                    [player_url] => jugador/c-gakpo-346648
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 84177
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/84177.jpg?size=100x&ext=png&lossy=1
                    [name] => M. De Leeuw
                    [extra] => 9 goles
                    [player_url] => jugador/m-de-leeuw-84177
                )

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

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 204418
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/204418.jpg?size=100x&ext=png&lossy=1
                    [name] => S. Peña
                    [extra] => 4 goles
                    [player_url] => jugador/sergio-pena-204418
                )

        )

)
Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => tarjetas
    [date] => 2020-03-14 04:39: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/2023.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/2925.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 30234
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/30234.jpg?size=100x&ext=png&lossy=1
                    [name] => N. Viergever
                    [extra] => 6 tarjetas
                    [player_url] => jugador/nick-viergever
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 249429
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/249429.jpg?size=100x&ext=png&lossy=1
                    [name] => D. Dumfries
                    [extra] => 6 tarjetas
                    [player_url] => jugador/d-dumfries-249429
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 346648
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/346648.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Gakpo
                    [extra] => 5 tarjetas
                    [player_url] => jugador/c-gakpo-346648
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 238739
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/238739.jpg?size=100x&ext=png&lossy=1
                    [name] => G. Bijl
                    [extra] => 8 tarjetas
                    [player_url] => jugador/bijl-238739
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 189518
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/189518.jpg?size=100x&ext=png&lossy=1
                    [name] => M. Chacón
                    [extra] => 8 tarjetas
                    [player_url] => jugador/m-chacon-189518
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 107575
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/107575.jpg?size=100x&ext=png&lossy=1
                    [name] => L. Burnet
                    [extra] => 5 tarjetas
                    [player_url] => jugador/l-burnet
                )

        )

)
Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => veces
    [date] => 2020-03-14 09:21: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/2023.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/2925.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 22877
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/22877.jpg?size=100x&ext=png&lossy=1
                    [name] => K. Mitroglou
                    [extra] => 13 veces
                    [player_url] => jugador/k-mitroglou-22877
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 346648
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/346648.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Gakpo
                    [extra] => 11 veces
                    [player_url] => jugador/c-gakpo-346648
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 277178
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/277178.jpg?size=100x&ext=png&lossy=1
                    [name] => R. Doan
                    [extra] => 7 veces
                    [player_url] => jugador/r-doan-277178
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 281975
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/281975.jpg?size=100x&ext=png&lossy=1
                    [name] => J. Arias
                    [extra] => 11 veces
                    [player_url] => jugador/j-arias-281975
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 55056
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/55056.jpg?size=100x&ext=png&lossy=1
                    [name] => A. Jansen
                    [extra] => 7 veces
                    [player_url] => jugador/a-jansen-55056
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 346288
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/346288.jpg?size=100x&ext=png&lossy=1
                    [name] => F. Ugrinic
                    [extra] => 7 veces
                    [player_url] => jugador/f-ugrinic-346288
                )

        )

)
Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => veces
    [date] => 2020-03-14 09:21: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/2023.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/2925.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 162803
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/162803.jpg?size=100x&ext=png&lossy=1
                    [name] => Bruma
                    [extra] => 9 veces
                    [player_url] => jugador/bruma-162803
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 650762
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/650762.jpg?size=100x&ext=png&lossy=1
                    [name] => M. Ihattaren
                    [extra] => 8 veces
                    [player_url] => jugador/m-ihattaren-650762
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 346648
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/346648.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Gakpo
                    [extra] => 7 veces
                    [player_url] => jugador/c-gakpo-346648
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 182828
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/182828.jpg?size=100x&ext=png&lossy=1
                    [name] => M. Kolar
                    [extra] => 16 veces
                    [player_url] => jugador/m-kolar-182828
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 1413
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/1413.jpg?size=100x&ext=png&lossy=1
                    [name] => T. Hiariej
                    [extra] => 6 veces
                    [player_url] => jugador/t-hiariej-1413
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 189518
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/189518.jpg?size=100x&ext=png&lossy=1
                    [name] => M. Chacón
                    [extra] => 5 veces
                    [player_url] => jugador/m-chacon-189518
                )

        )

)
Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => penaltis
    [date] => 2020-03-14 09:21:00
    [event] => Penaltis tirados
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_silbato@2x.png
    [players] => Array
        (
        )

    [local_shield] => //resfu.thumbr.io/img_data/escudos/medium/2023.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/2925.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 286302
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/286302.jpg?size=100x&ext=png&lossy=1
                    [name] => D. Malen
                    [extra] => 2 penaltis
                    [player_url] => jugador/d-malen-286302
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 281881
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/281881.jpg?size=100x&ext=png&lossy=1
                    [name] => S. Lammers
                    [extra] => 2 penaltis
                    [player_url] => jugador/s-lammers-281881
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 650762
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/650762.jpg?size=100x&ext=png&lossy=1
                    [name] => M. Ihattaren
                    [extra] => 1 penaltis
                    [player_url] => jugador/m-ihattaren-650762
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 182828
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/182828.jpg?size=100x&ext=png&lossy=1
                    [name] => M. Kolar
                    [extra] => 1 penaltis
                    [player_url] => jugador/m-kolar-182828
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 204418
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/204418.jpg?size=100x&ext=png&lossy=1
                    [name] => S. Peña
                    [extra] => 1 penaltis
                    [player_url] => jugador/sergio-pena-204418
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 84177
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/84177.jpg?size=100x&ext=png&lossy=1
                    [name] => M. De Leeuw
                    [extra] => 1 penaltis
                    [player_url] => jugador/m-de-leeuw-84177
                )

        )

)
Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => asistencias
    [date] => 2020-03-14 14:03: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/2023.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/2925.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 346648
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/346648.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Gakpo
                    [extra] => 6 asistencias
                    [player_url] => jugador/c-gakpo-346648
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 162803
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/162803.jpg?size=100x&ext=png&lossy=1
                    [name] => Bruma
                    [extra] => 3 asistencias
                    [player_url] => jugador/bruma-162803
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 249429
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/249429.jpg?size=100x&ext=png&lossy=1
                    [name] => D. Dumfries
                    [extra] => 3 asistencias
                    [player_url] => jugador/d-dumfries-249429
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 238739
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/238739.jpg?size=100x&ext=png&lossy=1
                    [name] => G. Bijl
                    [extra] => 5 asistencias
                    [player_url] => jugador/bijl-238739
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 107575
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/107575.jpg?size=100x&ext=png&lossy=1
                    [name] => L. Burnet
                    [extra] => 4 asistencias
                    [player_url] => jugador/l-burnet
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 204418
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/204418.jpg?size=100x&ext=png&lossy=1
                    [name] => S. Peña
                    [extra] => 3 asistencias
                    [player_url] => jugador/sergio-pena-204418
                )

        )

)
Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => años
    [date] => 2020-03-14 09:21: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/2023.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/2925.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 1512
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/1512.jpg?size=100x&ext=png&lossy=1
                    [name] => I. Afellay
                    [extra] => 34 años
                    [player_url] => jugador/i-afellay-1512
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 22444
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/22444.jpg?size=100x&ext=png&lossy=1
                    [name] => R. Ruiter
                    [extra] => 33 años
                    [player_url] => jugador/r-ruiter-22444
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 22877
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/22877.jpg?size=100x&ext=png&lossy=1
                    [name] => K. Mitroglou
                    [extra] => 32 años
                    [player_url] => jugador/k-mitroglou-22877
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 84177
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/84177.jpg?size=100x&ext=png&lossy=1
                    [name] => M. De Leeuw
                    [extra] => 33 años
                    [player_url] => jugador/m-de-leeuw-84177
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 30012
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/30012.jpg?size=100x&ext=png&lossy=1
                    [name] => D. Telgenkamp
                    [extra] => 33 años
                    [player_url] => jugador/d-telgenkamp-30012
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 1413
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/1413.jpg?size=100x&ext=png&lossy=1
                    [name] => T. Hiariej
                    [extra] => 31 años
                    [player_url] => jugador/t-hiariej-1413
                )

        )

)
Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => años
    [date] => 2020-03-14 09:21: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/2023.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/2925.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 776353
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/776353.jpg?size=100x&ext=png&lossy=1
                    [name] => Noni Madueke
                    [extra] => 18 años
                    [player_url] => jugador/c-madueke-776353
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 650762
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/650762.jpg?size=100x&ext=png&lossy=1
                    [name] => M. Ihattaren
                    [extra] => 18 años
                    [player_url] => jugador/m-ihattaren-650762
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 346751
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/346751.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Gomes
                    [extra] => 19 años
                    [player_url] => jugador/c-gomes-346751
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 710775
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/710775.jpg?size=100x&ext=png&lossy=1
                    [name] => Brian Haak
                    [extra] => 19 años
                    [player_url] => jugador/brian-haak-710775
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 692393
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/692393.jpg?size=100x&ext=png&lossy=1
                    [name] => L. Sopic
                    [extra] => 19 años
                    [player_url] => jugador/l-sopic-692393
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 699054
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/699054.jpg?size=100x&ext=png&lossy=1
                    [name] => Freddy Quispel
                    [extra] => 19 años
                    [player_url] => jugador/freddy-quispel-699054
                )

        )

)
Array
(
    [type] => 12
    [isAfter] => 0
    [img] => 
    [date] => 2020-03-14 18:45:00
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_juegos@2x.png
    [img_team] => //resfu.thumbr.io/img_data/escudos/medium/2925.jpg?size=100x&ext=png&lossy=1
    [year] => 2020
    [team_id] => 2925
    [body] => La temporada realizada por Emmen le permite mantener una posición de tranquilidad en la clasificación gracias, en parte, a su racha de 10 puntos en los 5 últimos partidos.
)

14 Mar

4 meses

La temporada realizada por Emmen le permite mantener una posición de tranquilidad en la clasificación gracias, en parte, a su racha de 10 puntos en los 5 últimos partidos.

Array
(
    [type] => 12
    [isAfter] => 0
    [img] => 
    [date] => 2020-03-14 18:45:00
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_juegos@2x.png
    [img_team] => //resfu.thumbr.io/img_data/escudos/medium/2023.jpg?size=100x&ext=png&lossy=1
    [year] => 2020
    [team_id] => 2023
    [body] => Esta temporada parece que PSV estará en la lucha por las posiciones de cabeza gracias, en gran medida, a la buena racha de resultados que ha encadenado últimamente con 13 puntos en 5 partidos.
)

14 Mar

4 meses

Esta temporada parece que PSV estará en la lucha por las posiciones de cabeza gracias, en gran medida, a la buena racha de resultados que ha encadenado últimamente con 13 puntos en 5 partidos.

Array
(
    [type] => 2
    [isAfter] => 0
    [date] => 2020-03-14 18:45:00
    [title] => ¿Quién va a ganar la posesión?
    [data_1] => 49
    [data_2] => 51
)

14 Mar

4 meses

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

timeline posesion
PSVPSV
49%
//resfu.thumbr.io/img_data/escudos/medium/2925.jpg?size=100x&5FCE
51%
Array
(
    [type] => 12
    [isAfter] => 0
    [body] => Emmen ha promediado un 51.9% de posesión en los últimos 26 partidos.
    [date] => 2020-03-14 18:45:00
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_asistencia@2x.png
    [img_team] => //resfu.thumbr.io/img_data/escudos/medium/2925.jpg?size=100x&ext=png&lossy=1
    [year] => 2020
    [team_id] => 2925
)

14 Mar

4 meses

Emmen ha promediado un 51.9% de posesión en los últimos 26 partidos.

Array
(
    [type] => 5
    [isAfter] => 0
    [img] => 
    [date] => 2020-03-14 18:45:00
    [body] => Ambos equipos presentan estadísticas muy similares en tiros a puerta, corners y fueras de juego, por ello es difícil saber quién puede llegar a dominar estos apartados estadísticos en el partido.
)

14 Mar

4 meses

Ambos equipos presentan estadísticas muy similares en tiros a puerta, corners y fueras de juego, por ello es difícil saber quién puede llegar a dominar estos apartados estadísticos en el partido.

Array
(
    [type] => 11
    [isAfter] => 0
    [key] => squad
    [date] => 2020-03-14 18:45:00
    [local] => Array
        (
            [0] => Array
                (
                    [nick] => Y. Van Osch
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/279658.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/y-van-osch-279658
                )

            [1] => Array
                (
                    [nick] => R. Ruiter
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/22444.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/r-ruiter-22444
                )

            [2] => Array
                (
                    [nick] => N. Roulaux
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/341320.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/n-roulaux-y-w-341320
                )

            [3] => Array
                (
                    [nick] => M. Van De Meulenhof
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/290616.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/m-van-de-meulenhof-290616
                )

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

            [5] => Array
                (
                    [nick] => T. Daverveld
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/343324.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/t-daverveld-343324
                )

            [6] => Array
                (
                    [nick] => N. Viergever
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/30234.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/nick-viergever
                )

            [7] => Array
                (
                    [nick] => O. Boscagli
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/240621.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/o-boscagli-240621
                )

            [8] => Array
                (
                    [nick] => R. Rodriguez
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/129539.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/r-rodriguez-129539
                )

            [9] => Array
                (
                    [nick] => D. Schwaab
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/25012.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/d-schwaab-25012
                )

            [10] => Array
                (
                    [nick] => T. Baumgartl
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/204791.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/t-baumgartl-204791
                )

            [11] => Array
                (
                    [nick] => J. Teze
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/325846.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/j-teze-325846
                )

            [12] => Array
                (
                    [nick] => D. Dumfries
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/249429.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/d-dumfries-249429
                )

            [13] => Array
                (
                    [nick] => M. Sadilek
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/309781.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/m-sadilek-309781
                )

            [14] => Array
                (
                    [nick] => R. Ledezma
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/667932.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/r-ledezma-667932
                )

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

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

            [17] => Array
                (
                    [nick] => R. Thomas
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/201057.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/ryan-thomas-201057
                )

            [18] => Array
                (
                    [nick] => M. Ihattaren
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/650762.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/m-ihattaren-650762
                )

            [19] => Array
                (
                    [nick] => I. Afellay
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/1512.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/i-afellay-1512
                )

            [20] => Array
                (
                    [nick] => J. Hendrix
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/189309.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/j-hendrix-189309
                )

            [21] => Array
                (
                    [nick] => Noni Madueke
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/776353.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/c-madueke-776353
                )

            [22] => Array
                (
                    [nick] => E. Gutiérrez
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/203582.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/e-gutierrez-203582
                )

            [23] => Array
                (
                    [nick] => Bruma
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/162803.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/bruma-162803
                )

            [24] => Array
                (
                    [nick] => R. Doan
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/277178.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/r-doan-277178
                )

            [25] => Array
                (
                    [nick] => S. Lammers
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/281881.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/s-lammers-281881
                )

            [26] => Array
                (
                    [nick] => C. Gakpo
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/346648.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/c-gakpo-346648
                )

            [27] => Array
                (
                    [nick] => D. Malen
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/286302.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/d-malen-286302
                )

            [28] => Array
                (
                    [nick] => C. Ngonge
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/367945.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/c-ngonge-367945
                )

            [29] => Array
                (
                    [nick] => K. Mitroglou
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/22877.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/k-mitroglou-22877
                )

        )

    [visitor] => Array
        (
            [0] => Array
                (
                    [nick] => Brian Haak
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/710775.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/brian-haak-710775
                )

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

            [2] => Array
                (
                    [nick] => D. Telgenkamp
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/30012.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/d-telgenkamp-30012
                )

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

            [4] => Array
                (
                    [nick] => R. Jalving
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/513683.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/r-jalving-513683
                )

            [5] => Array
                (
                    [nick] => S. Van Der Lei
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/139110.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/s-van-der-lei-139110
                )

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

            [7] => Array
                (
                    [nick] => J. Beste
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/320357.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/j-beste-320357
                )

            [8] => Array
                (
                    [nick] => N. Bakker
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/139113.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/bakker-139113
                )

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

            [10] => Array
                (
                    [nick] => F. Gorgulu
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/84171.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/ferhat-gorgulu-84171
                )

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

            [12] => Array
                (
                    [nick] => D. Payne
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/244310.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/d-payne-244310
                )

            [13] => Array
                (
                    [nick] => K. Veendorp
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/313490.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/k-veendorp-313490
                )

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

            [15] => Array
                (
                    [nick] => D. Bos
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/454925.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/d-bos-454925
                )

            [16] => Array
                (
                    [nick] => H. Ben Moussa
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/139117.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/h-ben-moussa-139117
                )

            [17] => Array
                (
                    [nick] => H. Bos
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/134429.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/h-bos-134429
                )

            [18] => Array
                (
                    [nick] => S. Peña
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/204418.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/sergio-pena-204418
                )

            [19] => Array
                (
                    [nick] => F. Ugrinic
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/346288.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/f-ugrinic-346288
                )

            [20] => Array
                (
                    [nick] => W. Marinus
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/232161.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/w-marinus-232161
                )

            [21] => Array
                (
                    [nick] => R. De Vos
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/284626.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/r-de-vos-284626
                )

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

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

            [24] => Array
                (
                    [nick] => M. Chacón
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/189518.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/m-chacon-189518
                )

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

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

            [27] => Array
                (
                    [nick] => M. De Leeuw
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/84177.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/m-de-leeuw-84177
                )

            [28] => Array
                (
                    [nick] => M. Kolar
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/182828.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/m-kolar-182828
                )

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

            [30] => Array
                (
                    [nick] => Ruben Roosken
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/710741.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/ruben-roosken-710741
                )

            [31] => Array
                (
                    [nick] => K. Frei
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/124295.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/k-koyunlu-124295
                )

            [32] => Array
                (
                    [nick] => L. Adzic
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/332192.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/l-adzic-332192
                )

            [33] => Array
                (
                    [nick] => Freddy Quispel
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/699054.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/freddy-quispel-699054
                )

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

        )

)
Array
(
    [type] => 9
    [isAfter] => 0
    [numMatches] => 1
    [date] => 2020-07-13 04:33:33
    [matches] => Array
        (
            [0] => Array
                (
                    [match_url] => partido/Emmen/Psv
                    [id] => 11889
                    [r1] => 1
                    [r2] => 1
                    [short_name1] => FCE
                    [short_name2] => PSV
                    [shedule] => 2019-12-01 20:00:00
                    [category] => Eredivisie
                    [year] => 2020
                    [team1] => 2925
                    [team2] => 2023
                    [winner] => 0
                )

        )

)

13 Jul

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,850,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0063
Controller Execution Time ( Match / Index )  0.1873
Total Execution Time  0.1937
  CADENA URL  
/partido/Psv/Emmen
  GET DATOS  
$_GET['/partido/Psv/Emmen']  
$_GET['completed']  
$_GET['clang']  
$_GET['isocode']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (2)  
0.0025   SELECT c.*, 2020 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 calendars2020 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 = 'Psv' AND dt2.basealias = 'Emmen'
0.0008  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12000 AND extraId = 49848 AND type_rel = 4