Web
            Analytics
  • Mié 28 AbrTo play11:00

Pre-Partido

Array
(
    [type] => 5
    [isAfter] => 0
    [img] => 
    [date] => 2021-01-20 04:14:43
    [body] => 3 de las 6 (50%) sustituciones del Melbourne City se han realizado entre los minutos 50 y 60 de cada partido.
)

20 Ene

10 minutos

3 de las 6 (50%) sustituciones del Melbourne City se han realizado entre los minutos 50 y 60 de cada partido.

Array
(
    [type] => 4
    [isAfter] => 0
    [body] => J. Maclaren es sin lugar a dudas el mejor jugador de Melbourne City y por lo tanto el jugador ofensivo más peligroso.
    [date] => 2021-01-20 04:14:43
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_asistencia@2x.png
    [img_player] => //resfu.thumbr.io/img_data/players/medium/291709.jpg?size=100x&ext=png&lossy=1
    [year] => 2021
    [player_id] => 291709
)

Jugador a tener en cuenta

J. Maclaren es sin lugar a dudas el mejor jugador de Melbourne City y por lo tanto el jugador ofensivo más peligroso.

Array
(
    [type] => 3
    [isAfter] => 0
    [eventT] => goles
    [date] => 2021-01-20 04:14:43
    [event] => Máximos goleadores
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_asistencia@2x.png
    [players] => Array
        (
            [0] => Array
                (
                    [year] => 2021
                    [player_id] => 429920
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/429920.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Metcalfe
                    [extra] => 1 goles
                    [player_url] => jugador/c-metcalfe-429920
                )

            [1] => Array
                (
                    [year] => 2021
                    [player_id] => 24136
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/24136.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Noone
                    [extra] => 1 goles
                    [player_url] => jugador/c-noone-24136
                )

            [2] => Array
                (
                    [year] => 2021
                    [player_id] => 291709
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/291709.jpg?size=100x&ext=png&lossy=1
                    [name] => J. Maclaren
                    [extra] => 1 goles
                    [player_url] => jugador/j-maclaren-291709
                )

        )

    [shield] => //resfu.thumbr.io/img_data/escudos/medium/18574.jpg?size=100x&ext=png&lossy=1
    [extra_team] => 1
)
Array
(
    [type] => 3
    [isAfter] => 0
    [eventT] => tarjetas
    [date] => 2021-01-20 04:14:43
    [event] => Tarjetas amarillas y rojas
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_silbato@2x.png
    [players] => Array
        (
            [0] => Array
                (
                    [year] => 2021
                    [player_id] => 213433
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/213433.jpg?size=100x&ext=png&lossy=1
                    [name] => A. Luna
                    [extra] => 2 tarjetas
                    [player_url] => jugador/a-luna-213433
                )

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

            [2] => Array
                (
                    [year] => 2021
                    [player_id] => 100521
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/100521.jpg?size=100x&ext=png&lossy=1
                    [name] => S. Jamieson
                    [extra] => 2 tarjetas
                    [player_url] => jugador/s-jamieson-100521
                )

        )

    [shield] => //resfu.thumbr.io/img_data/escudos/medium/18574.jpg?size=100x&ext=png&lossy=1
    [extra_team] => 1
)
Array
(
    [type] => 3
    [isAfter] => 0
    [eventT] => veces
    [date] => 2021-01-20 04:14:43
    [event] => Entra desde el banquillo
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_cambios@2x.png
    [players] => Array
        (
            [0] => Array
                (
                    [year] => 2021
                    [player_id] => 448573
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/448573.jpg?size=100x&ext=png&lossy=1
                    [name] => N. Tsubaki
                    [extra] => 2 veces
                    [player_url] => jugador/n-tsubaki-448573
                )

            [1] => Array
                (
                    [year] => 2021
                    [player_id] => 182871
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/182871.jpg?size=100x&ext=png&lossy=1
                    [name] => S. Galloway
                    [extra] => 2 veces
                    [player_url] => jugador/s-galloway-182871
                )

            [2] => Array
                (
                    [year] => 2021
                    [player_id] => 890745
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/890745.jpg?size=100x&ext=png&lossy=1
                    [name] => S. Colakovski
                    [extra] => 2 veces
                    [player_url] => jugador/s-colakovski-890745
                )

        )

    [shield] => //resfu.thumbr.io/img_data/escudos/medium/18574.jpg?size=100x&ext=png&lossy=1
    [extra_team] => 1
)
Array
(
    [type] => 3
    [isAfter] => 0
    [eventT] => veces
    [date] => 2021-01-20 04:14:43
    [event] => Veces sustituido
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_banquillo@2x.png
    [players] => Array
        (
            [0] => Array
                (
                    [year] => 2021
                    [player_id] => 24136
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/24136.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Noone
                    [extra] => 3 veces
                    [player_url] => jugador/c-noone-24136
                )

            [1] => Array
                (
                    [year] => 2021
                    [player_id] => 696774
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/696774.jpg?size=100x&ext=png&lossy=1
                    [name] => Marco Tilio
                    [extra] => 1 veces
                    [player_url] => jugador/marco-tilio-696774
                )

            [2] => Array
                (
                    [year] => 2021
                    [player_id] => 196488
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/196488.jpg?size=100x&ext=png&lossy=1
                    [name] => A. Nabbout
                    [extra] => 1 veces
                    [player_url] => jugador/a-nabbout-196488
                )

        )

    [shield] => //resfu.thumbr.io/img_data/escudos/medium/18574.jpg?size=100x&ext=png&lossy=1
    [extra_team] => 1
)
Array
(
    [type] => 3
    [isAfter] => 0
    [eventT] => asistencias
    [date] => 2021-01-20 04:14:43
    [event] => Máximos asistentes
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_asistencia@2x.png
    [players] => Array
        (
            [0] => Array
                (
                    [year] => 2021
                    [player_id] => 291709
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/291709.jpg?size=100x&ext=png&lossy=1
                    [name] => J. Maclaren
                    [extra] => 1 asistencias
                    [player_url] => jugador/j-maclaren-291709
                )

            [1] => Array
                (
                    [year] => 2021
                    [player_id] => 121846
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/121846.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Good
                    [extra] => 1 asistencias
                    [player_url] => jugador/c-good-121846
                )

            [2] => Array
                (
                    [year] => 2021
                    [player_id] => 890745
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/890745.jpg?size=100x&ext=png&lossy=1
                    [name] => S. Colakovski
                    [extra] => 1 asistencias
                    [player_url] => jugador/s-colakovski-890745
                )

        )

    [shield] => //resfu.thumbr.io/img_data/escudos/medium/18574.jpg?size=100x&ext=png&lossy=1
    [extra_team] => 1
)
Array
(
    [type] => 3
    [isAfter] => 0
    [eventT] => años
    [date] => 2021-01-20 04:14:43
    [event] => Jugadores más mayores
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_juegos@2x.png
    [players] => Array
        (
            [0] => Array
                (
                    [year] => 2021
                    [player_id] => 423063
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => Ahmed Hassan Taleb
                    [extra] => 40 años
                    [player_url] => jugador/ahmed-hassan-taleb-423063
                )

            [1] => Array
                (
                    [year] => 2021
                    [player_id] => 24136
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/24136.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Noone
                    [extra] => 33 años
                    [player_url] => jugador/c-noone-24136
                )

            [2] => Array
                (
                    [year] => 2021
                    [player_id] => 121827
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/121827.jpg?size=100x&ext=png&lossy=1
                    [name] => R. Griffiths
                    [extra] => 32 años
                    [player_url] => jugador/rostyn-griffiths-121827
                )

        )

    [shield] => //resfu.thumbr.io/img_data/escudos/medium/18574.jpg?size=100x&ext=png&lossy=1
    [extra_team] => 1
)
Array
(
    [type] => 3
    [isAfter] => 0
    [eventT] => años
    [date] => 2021-01-20 04:14:43
    [event] => Jugadores más jóvenes
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_juegos@2x.png
    [players] => Array
        (
            [0] => Array
                (
                    [year] => 2021
                    [player_id] => 896778
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/896778.jpg?size=100x&ext=png&lossy=1
                    [name] => R. Rodrigues
                    [extra] => 17 años
                    [player_url] => jugador/r-rodrigues-896778
                )

            [1] => Array
                (
                    [year] => 2021
                    [player_id] => 805770
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/805770.jpg?size=100x&ext=png&lossy=1
                    [name] => I. Abdulahi
                    [extra] => 17 años
                    [player_url] => jugador/i-abdulahi-805770
                )

            [2] => Array
                (
                    [year] => 2021
                    [player_id] => 870864
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => A. Taleb
                    [extra] => 18 años
                    [player_url] => jugador/a-taleb-870864
                )

        )

    [shield] => //resfu.thumbr.io/img_data/escudos/medium/18574.jpg?size=100x&ext=png&lossy=1
    [extra_team] => 1
)
Array
(
    [type] => 3
    [isAfter] => 0
    [eventT] => cm
    [date] => 2021-01-20 04:14:43
    [event] => Jugadores más altos
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_juegos@2x.png
    [players] => Array
        (
            [0] => Array
                (
                    [year] => 2021
                    [player_id] => 329991
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/329991.jpg?size=100x&ext=png&lossy=1
                    [name] => H. Delbridge
                    [extra] => 193 cm
                    [player_url] => jugador/h-delbridge-329991
                )

            [1] => Array
                (
                    [year] => 2021
                    [player_id] => 296411
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/296411.jpg?size=100x&ext=png&lossy=1
                    [name] => Tom Glover
                    [extra] => 190 cm
                    [player_url] => jugador/t-glover-296411
                )

            [2] => Array
                (
                    [year] => 2021
                    [player_id] => 121827
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/121827.jpg?size=100x&ext=png&lossy=1
                    [name] => R. Griffiths
                    [extra] => 187 cm
                    [player_url] => jugador/rostyn-griffiths-121827
                )

        )

    [shield] => //resfu.thumbr.io/img_data/escudos/medium/18574.jpg?size=100x&ext=png&lossy=1
    [extra_team] => 1
)
Array
(
    [type] => 11
    [isAfter] => 0
    [key] => squad
    [date] => 2021-01-20 04:14:43
    [local] => Array
        (
            [0] => Array
                (
                    [nick] => Tom Glover
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/296411.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/t-glover-296411
                )

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

            [2] => Array
                (
                    [nick] => A. Taleb
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/a-taleb-870864
                )

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

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

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

            [6] => Array
                (
                    [nick] => B. Garuccio
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/191891.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/b-garuccio-191891
                )

            [7] => Array
                (
                    [nick] => Nuno Reis
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/68753.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/n-reis-68753
                )

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

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

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

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

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

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

            [14] => Array
                (
                    [nick] => H. Delbridge
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/329991.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/h-delbridge-329991
                )

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

            [16] => Array
                (
                    [nick] => R. Griffiths
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/121827.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/rostyn-griffiths-121827
                )

            [17] => Array
                (
                    [nick] => Marco Tilio
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/696774.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/marco-tilio-696774
                )

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

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

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

            [21] => Array
                (
                    [nick] => A. O'Neill
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/334521.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/a-o-neill-334521
                )

            [22] => Array
                (
                    [nick] => L. Oresti
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/l-oresti-907967
                )

            [23] => Array
                (
                    [nick] => F. Bérenguer
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/52546.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/f-berenguer-52546
                )

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

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

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

            [27] => Array
                (
                    [nick] => Ahmed Hassan Taleb
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/ahmed-hassan-taleb-423063
                )

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

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

            [30] => Array
                (
                    [nick] => J. Cabrera
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/192295.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/m-cabrera-192295
                )

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

        )

    [visitor] => Array
        (
            [0] => Array
                (
                    [nick] => K. Ota
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/img_data/players/medium/129978.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/k-ota-129978
                )

        )

)
Array
(
    [type] => 9
    [isAfter] => 0
    [numMatches] => 2
    [date] => 2021-01-20 04:24:43
    [matches] => Array
        (
            [0] => Array
                (
                    [match_url] => partido/Perth-Glory/Melbourne-City/2020
                    [id] => 172884
                    [r1] => 2
                    [r2] => 3
                    [short_name1] => PER
                    [short_name2] => MCI
                    [shedule] => 2020-03-08 08:00:00
                    [category] => Liga Australiana
                    [year] => 2020
                    [team1] => 1953
                    [team2] => 18574
                    [winner] => 18574
                )

            [1] => Array
                (
                    [match_url] => partido/Melbourne-City/Perth-Glory/2020
                    [id] => 172854
                    [r1] => 0
                    [r2] => 0
                    [short_name1] => MCI
                    [short_name2] => PER
                    [shedule] => 2020-01-25 09:30:00
                    [category] => Liga Australiana
                    [year] => 2020
                    [team1] => 18574
                    [team2] => 1953
                    [winner] => 0
                )

        )

)

20 Ene

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,584,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Match / Index )  0.1269
Total Execution Time  0.1282
  CADENA URL  
/partido/Melbourne-City/Perth-Glory
  GET DATOS  
$_GET['/partido/Melbourne-City/Perth-Glory']  
$_GET['completed']  
$_GET['clang']  
$_GET['isocode']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (2)  
0.0033   SELECT c.*, 2021 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 calendars2021 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 = 'Melbourne-City' AND dt2.basealias = 'Perth-Glory'
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=214094 AND extraId = 60104 AND type_rel = 4