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 ADO Den Haag - Emmen - Resultados de Fútbol
  • Dom 05 Abrpostponed-
  • -

Pre-Partido

Array
(
    [type] => 5
    [isAfter] => 0
    [img] => 
    [date] => 2020-04-05 04:06:00
    [body] => 19 de las 56 (34%) sustituciones del ADO Den Haag se han realizado en los últimos 10 minutos del partido.
)

05 Abr

3 meses

19 de las 56 (34%) sustituciones del ADO Den Haag se han realizado en los últimos 10 minutos del partido.

Array
(
    [type] => 4
    [isAfter] => 0
    [body] => J. Goossens es uno de los mejores jugadores de ADO Den Haag en estos momentos, 2 goles y 5 asistencias.
    [date] => 2020-04-05 13:30:00
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_asistencia@2x.png
    [img_player] => //resfu.thumbr.io/img_data/players/medium/30081.jpg?size=100x&ext=png&lossy=1
    [year] => 2020
    [player_id] => 30081
)

Jugador a tener en cuenta

J. Goossens es uno de los mejores jugadores de ADO Den Haag en estos momentos, 2 goles y 5 asistencias.

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

05 Abr

3 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-04-05 04:06:00
    [body] => El 28% de los goles (8) del Emmen se han anotado entre los minutos 50 y 60 de cada partido.
)

05 Abr

3 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-04-05 13:30: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-04-05 13: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/73.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] => 85233
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/85233.jpg?size=100x&ext=png&lossy=1
                    [name] => T. Necid
                    [extra] => 6 goles
                    [player_url] => jugador/t-necid-85233
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 360814
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/360814.jpg?size=100x&ext=png&lossy=1
                    [name] => S. Pinas
                    [extra] => 3 goles
                    [player_url] => jugador/s-pinas-360814
                )

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

        )

    [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-04-04 23: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/73.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] => 56042
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/56042.jpg?size=100x&ext=png&lossy=1
                    [name] => D. Malone
                    [extra] => 7 tarjetas
                    [player_url] => jugador/d-malone-56042
                )

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

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

        )

    [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-04-05 04: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/73.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] => 216691
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/216691.jpg?size=100x&ext=png&lossy=1
                    [name] => B. Ould-Chikh
                    [extra] => 10 veces
                    [player_url] => jugador/b-ould-chikh-216691
                )

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

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

        )

    [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-04-05 04: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/73.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] => 30081
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/30081.jpg?size=100x&ext=png&lossy=1
                    [name] => J. Goossens
                    [extra] => 9 veces
                    [player_url] => jugador/j-goossens-30081
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 186046
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/186046.jpg?size=100x&ext=png&lossy=1
                    [name] => D. Bakker
                    [extra] => 8 veces
                    [player_url] => jugador/d-bakker-186046
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 68469
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/68469.jpg?size=100x&ext=png&lossy=1
                    [name] => E. Falkenburg
                    [extra] => 6 veces
                    [player_url] => jugador/e-falkenburg-68469
                )

        )

    [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-04-05 04:06: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/73.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] => 85233
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/85233.jpg?size=100x&ext=png&lossy=1
                    [name] => T. Necid
                    [extra] => 1 penaltis
                    [player_url] => jugador/t-necid-85233
                )

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

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 30081
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/30081.jpg?size=100x&ext=png&lossy=1
                    [name] => J. Goossens
                    [extra] => 1 penaltis
                    [player_url] => jugador/j-goossens-30081
                )

        )

    [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-04-05 08: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/73.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] => 30081
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/30081.jpg?size=100x&ext=png&lossy=1
                    [name] => J. Goossens
                    [extra] => 5 asistencias
                    [player_url] => jugador/j-goossens-30081
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 22453
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/22453.jpg?size=100x&ext=png&lossy=1
                    [name] => A. Meijers
                    [extra] => 2 asistencias
                    [player_url] => jugador/a-meijers-22453
                )

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

        )

    [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-04-05 04: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/73.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] => 5910
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/5910.jpg?size=100x&ext=png&lossy=1
                    [name] => R. Zwinkels
                    [extra] => 37 años
                    [player_url] => jugador/r-zwinkels-5910
                )

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

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

        )

    [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-04-05 04: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/73.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] => 427340
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/427340.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Summerville
                    [extra] => 18 años
                    [player_url] => jugador/crysencio-summerville-427340
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 697168
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/697168.jpg?size=100x&ext=png&lossy=1
                    [name] => L. Van Kleef
                    [extra] => 19 años
                    [player_url] => jugador/lorenzo-van-kleef-697168
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 827591
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/827591.jpg?size=100x&ext=png&lossy=1
                    [name] => Danté Roethof
                    [extra] => 19 años
                    [player_url] => jugador/dante-roethof-827591
                )

        )

    [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-04-05 13:30:00
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_juegos@2x.png
    [img_team] => //resfu.thumbr.io/img_data/escudos/medium/73.jpg?size=100x&ext=png&lossy=1
    [year] => 2020
    [team_id] => 73
    [body] => Peligrosa situación de ADO Den Haag que con una racha negativa de 3 puntos en 7 partidos le hace ver muy cerca el descenso de categoría.
)

05 Abr

3 meses

Peligrosa situación de ADO Den Haag que con una racha negativa de 3 puntos en 7 partidos le hace ver muy cerca el descenso de categoría.

Array
(
    [type] => 12
    [isAfter] => 0
    [img] => 
    [date] => 2020-04-05 13:30: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.
)

05 Abr

3 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] => 2
    [isAfter] => 0
    [date] => 2020-04-05 13:30:00
    [title] => ¿Quién va a ganar la posesión?
    [data_1] => 50
    [data_2] => 50
)

05 Abr

3 meses

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

timeline posesion
ADO Den HaagADO
50%
//resfu.thumbr.io/img_data/escudos/medium/2925.jpg?size=100x&5FCE
50%
Array
(
    [type] => 12
    [isAfter] => 0
    [body] => ADO Den Haag ha promediado un 52.7% de posesión en los últimos 26 partidos.
    [date] => 2020-04-05 13:30:00
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_asistencia@2x.png
    [img_team] => //resfu.thumbr.io/img_data/escudos/medium/73.jpg?size=100x&ext=png&lossy=1
    [year] => 2020
    [team_id] => 73
)

05 Abr

3 meses

ADO Den Haag ha promediado un 52.7% de posesión en los últimos 26 partidos.

Array
(
    [type] => 5
    [isAfter] => 0
    [img] => 
    [date] => 2020-04-05 13:30: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.
)

05 Abr

3 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-04-05 13:30:00
    [local] => Array
        (
            [0] => Array
                (
                    [nick] => R. Zwinkels
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/5910.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/r-zwinkels-5910
                )

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

            [2] => Array
                (
                    [nick] => Youri Schoonderwaldt
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/697131.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/youri-schoonderwaldt-697131
                )

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

            [4] => Array
                (
                    [nick] => Dehninio Muringen
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/697196.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/dehninio-muringen-697196
                )

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

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

            [7] => Array
                (
                    [nick] => S. Stubbs
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/355652.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/s-stubbs-355652
                )

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

            [9] => Array
                (
                    [nick] => L. De Bock
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/69983.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/l-de-bock-69983
                )

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

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

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

            [13] => Array
                (
                    [nick] => D. Bakker
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/186046.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/d-bakker-186046
                )

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

            [15] => Array
                (
                    [nick] => Maarten Rieder
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/697128.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/maarten-rieder-697128
                )

            [16] => Array
                (
                    [nick] => L. Van Kleef
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/697168.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/lorenzo-van-kleef-697168
                )

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

            [18] => Array
                (
                    [nick] => M. Van Kins
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/385808.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/v-kins-385808
                )

            [19] => Array
                (
                    [nick] => Danté Roethof
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/827591.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/dante-roethof-827591
                )

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

            [21] => Array
                (
                    [nick] => C. Baluta
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/303433.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/p-iacob-303433
                )

            [22] => Array
                (
                    [nick] => B. Ould-Chikh
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/216691.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/b-ould-chikh-216691
                )

            [23] => Array
                (
                    [nick] => K. Van Mil
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/644727.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/k-van-mil-644727
                )

            [24] => Array
                (
                    [nick] => T. Necid
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/85233.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/t-necid-85233
                )

            [25] => Array
                (
                    [nick] => O. Bogle
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/284455.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/o-bogle-284455
                )

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

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

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

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

            [30] => Array
                (
                    [nick] => M. Van Buren
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/228601.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/m-van-buren-228601
                )

            [31] => Array
                (
                    [nick] => Y. Boussakou
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/652512.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/y-boussakou-652512
                )

        )

    [visitor] => Array
        (
            [0] => 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
                )

            [1] => 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
                )

            [2] => 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
                )

            [3] => 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
                )

            [4] => 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
                )

            [5] => 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
                )

            [6] => 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
                )

            [7] => 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
                )

            [8] => 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
                )

            [9] => 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
                )

            [10] => 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
                )

            [11] => 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
                )

            [12] => 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
                )

            [13] => 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
                )

            [14] => 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
                )

            [15] => 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
                )

            [16] => 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
                )

            [17] => 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
                )

            [18] => 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
                )

            [19] => 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
                )

            [20] => 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
                )

            [21] => 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
                )

            [22] => 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
                )

            [23] => 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
                )

            [24] => 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
                )

            [25] => 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
                )

            [26] => 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
                )

            [27] => 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
                )

            [28] => 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
                )

            [29] => 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
                )

            [30] => 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
                )

            [31] => 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
                )

            [32] => 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
                )

            [33] => 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
                )

            [34] => 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
                )

        )

)
Array
(
    [type] => 9
    [isAfter] => 0
    [numMatches] => 1
    [date] => 2020-07-12 18:04:07
    [matches] => Array
        (
            [0] => Array
                (
                    [match_url] => partido/Emmen/Ado-Den-Haag
                    [id] => 11831
                    [r1] => 3
                    [r2] => 0
                    [short_name1] => FCE
                    [short_name2] => ADO
                    [shedule] => 2019-09-27 20:00:00
                    [category] => Eredivisie
                    [year] => 2020
                    [team1] => 2925
                    [team2] => 73
                    [winner] => 2925
                )

        )

)

12 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,860,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Match / Index )  3.5282
Total Execution Time  3.5302
  CADENA URL  
/partido/Ado-Den-Haag/Emmen
  GET DATOS  
$_GET['/partido/Ado-Den-Haag/Emmen']  
$_GET['completed']  
$_GET['clang']  
$_GET['isocode']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (2)  
0.0026   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 = 'Ado-Den-Haag' AND dt2.basealias = 'Emmen'
0.0005  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12018 AND extraId = 49848 AND type_rel = 4