A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

A PHP Error was encountered

Severity: Warning

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

Filename: ajax/db_link.php

Line Number: 42

Match Al Batin - Al-Kawkab - Resultados de Fútbol
  • Mié 15 Ene 13:20finalizado1
  • 1

Pre-Partido

Array
(
    [type] => 4
    [isAfter] => 0
    [body] => H. Sharahili es el máximo goleador y el mejor jugador de Al Batin, anota el 29% de los goles del equipo (5 goles).
    [date] => 2020-01-15 12:20:00
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_asistencia@2x.png
    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
    [year] => 2020
    [player_id] => 353769
)

Jugador a tener en cuenta

H. Sharahili es el máximo goleador y el mejor jugador de Al Batin, anota el 29% de los goles del equipo (5 goles).

Array
(
    [type] => 5
    [isAfter] => 0
    [img] => 
    [date] => 2020-01-15 02:56:00
    [body] => El 57% de los goles (4) del Al-Kawkab se han anotado entre los minutos 60 y 70 de cada partido.
)

15 Ene

2 meses

El 57% de los goles (4) del Al-Kawkab se han anotado entre los minutos 60 y 70 de cada partido.

Array
(
    [type] => 4
    [isAfter] => 0
    [body] => C. Reguii es el máximo goleador y el mejor jugador de Al-Kawkab, anota el 43% de los goles del equipo (3 goles).
    [date] => 2020-01-15 12:20:00
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_asistencia@2x.png
    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
    [year] => 2020
    [player_id] => 892796
)

Jugador a tener en cuenta

C. Reguii es el máximo goleador y el mejor jugador de Al-Kawkab, anota el 43% de los goles del equipo (3 goles).

Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => goles
    [date] => 2020-01-15 12:20: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/17261.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/17266.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 353769
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => H. Sharahili
                    [extra] => 5 goles
                    [player_url] => jugador/h-sharahili-353769
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 391127
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => Daifallah Al-Qarni
                    [extra] => 3 goles
                    [player_url] => jugador/daifallah-al-qarni-391127
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 300802
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => L. Diaby
                    [extra] => 3 goles
                    [player_url] => jugador/lassinadiaby-300802
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 892796
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Reguii
                    [extra] => 3 goles
                    [player_url] => jugador/c-reguii-892796
                )

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

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 324157
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => Boubacar Cissokho
                    [extra] => 1 goles
                    [player_url] => jugador/boubacar-cissokho-324157
                )

        )

)
Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => años
    [date] => 2020-01-15 02:56: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/17261.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/17266.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 353769
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => H. Sharahili
                    [extra] => 33 años
                    [player_url] => jugador/h-sharahili-353769
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 391127
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => Daifallah Al-Qarni
                    [extra] => 31 años
                    [player_url] => jugador/daifallah-al-qarni-391127
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 311094
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => Bader Al Nakhli
                    [extra] => 31 años
                    [player_url] => jugador/baderal-nakhli-311094
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 892796
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Reguii
                    [extra] => 32 años
                    [player_url] => jugador/c-reguii-892796
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 152040
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/152040.jpg?size=100x&ext=png&lossy=1
                    [name] => S. Moreno
                    [extra] => 27 años
                    [player_url] => jugador/s-moreno-152040
                )

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

        )

)
Array
(
    [type] => 14
    [isAfter] => 0
    [eventT] => años
    [date] => 2020-01-15 02:56: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/17261.jpg?size=100x&ext=png&lossy=1
    [visitor_shield] => //resfu.thumbr.io/img_data/escudos/medium/17266.jpg?size=100x&ext=png&lossy=1
    [players1] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 769240
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => Omar Hamad Al Aowda
                    [extra] => 21 años
                    [player_url] => jugador/omar-hamad-al-aowda-769240
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 922866
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => Y. Al-Mozairib
                    [extra] => 22 años
                    [player_url] => jugador/y-al-mozairib-922866
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 569876
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => Yousef Al Shammari
                    [extra] => 22 años
                    [player_url] => jugador/yousef-al-shammari-569876
                )

        )

    [players2] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 198127
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/198127.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Jbeli
                    [extra] => 23 años
                    [player_url] => jugador/c-jbeli-198127
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 152040
                    [img_player] => //resfu.thumbr.io/img_data/players/medium/152040.jpg?size=100x&ext=png&lossy=1
                    [name] => S. Moreno
                    [extra] => 27 años
                    [player_url] => jugador/s-moreno-152040
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 892796
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => C. Reguii
                    [extra] => 32 años
                    [player_url] => jugador/c-reguii-892796
                )

        )

)
Array
(
    [type] => 3
    [isAfter] => 0
    [eventT] => cm
    [date] => 2020-01-14 11:53:36
    [event] => Jugadores más altos
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_juegos@2x.png
    [players] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 391127
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => Daifallah Al-Qarni
                    [extra] => 181 cm
                    [player_url] => jugador/daifallah-al-qarni-391127
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 300802
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => L. Diaby
                    [extra] => 180 cm
                    [player_url] => jugador/lassinadiaby-300802
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 311094
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => Bader Al Nakhli
                    [extra] => 179 cm
                    [player_url] => jugador/baderal-nakhli-311094
                )

        )

    [shield] => //resfu.thumbr.io/img_data/escudos/medium/17261.jpg?size=100x&ext=png&lossy=1
    [extra_team] => 1
)
Array
(
    [type] => 3
    [isAfter] => 0
    [eventT] => cm
    [date] => 2020-01-14 11:53:36
    [event] => Jugadores más bajos
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_juegos@2x.png
    [players] => Array
        (
            [0] => Array
                (
                    [year] => 2020
                    [player_id] => 332866
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => A. Al Sharid
                    [extra] => 163 cm
                    [player_url] => jugador/a-al-sharid-332866
                )

            [1] => Array
                (
                    [year] => 2020
                    [player_id] => 353769
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => H. Sharahili
                    [extra] => 170 cm
                    [player_url] => jugador/h-sharahili-353769
                )

            [2] => Array
                (
                    [year] => 2020
                    [player_id] => 569876
                    [img_player] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=100x&ext=png&lossy=1
                    [name] => Yousef Al Shammari
                    [extra] => 170 cm
                    [player_url] => jugador/yousef-al-shammari-569876
                )

        )

    [shield] => //resfu.thumbr.io/img_data/escudos/medium/17261.jpg?size=100x&ext=png&lossy=1
    [extra_team] => 1
)
Array
(
    [type] => 12
    [isAfter] => 0
    [img] => 
    [date] => 2020-01-15 12:20:00
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_juegos@2x.png
    [img_team] => //resfu.thumbr.io/img_data/escudos/medium/17266.jpg?size=100x&ext=png&lossy=1
    [year] => 2020
    [team_id] => 17266
    [body] => Peligrosa situación de Al-Kawkab que con una racha negativa de 2 puntos en 7 partidos le hace ver muy cerca el descenso de categoría.
)

15 Ene

2 meses

Peligrosa situación de Al-Kawkab que con una racha negativa de 2 puntos en 7 partidos le hace ver muy cerca el descenso de categoría.

Array
(
    [type] => 12
    [isAfter] => 0
    [img] => 
    [date] => 2020-01-15 12:20:00
    [img_action] => //resfu.thumbr.io/media/timeline_ico/timeline_ico_juegos@2x.png
    [img_team] => //resfu.thumbr.io/img_data/escudos/medium/17261.jpg?size=100x&ext=png&lossy=1
    [year] => 2020
    [team_id] => 17261
    [body] => La mala racha de Al Batin, que tan sólo ha logrado 3 puntos en 2 jornadas, le puede acabar privando de estar en las posiciones de cabeza.
)

15 Ene

2 meses

La mala racha de Al Batin, que tan sólo ha logrado 3 puntos en 2 jornadas, le puede acabar privando de estar en las posiciones de cabeza.

Array
(
    [type] => 11
    [isAfter] => 0
    [key] => squad
    [date] => 2020-01-15 12:20:00
    [local] => Array
        (
            [0] => Array
                (
                    [nick] => H. Sharahili
                    [role] => 1
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/h-sharahili-353769
                )

            [1] => Array
                (
                    [nick] => Omar Hamad Al Aowda
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/omar-hamad-al-aowda-769240
                )

            [2] => Array
                (
                    [nick] => Bader Al Nakhli
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/baderal-nakhli-311094
                )

            [3] => Array
                (
                    [nick] => Mohsen Mohammed
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/mohsen-mohammed-395631
                )

            [4] => Array
                (
                    [nick] => A. Al Sharid
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/a-al-sharid-332866
                )

            [5] => Array
                (
                    [nick] => Daifallah Al-Qarni
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/daifallah-al-qarni-391127
                )

            [6] => Array
                (
                    [nick] => I. Al Maghrabi
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/i-al-maghrabi-301256
                )

            [7] => Array
                (
                    [nick] => Y. Al-Mozairib
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/y-al-mozairib-922866
                )

            [8] => Array
                (
                    [nick] => L. Diaby
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/lassinadiaby-300802
                )

            [9] => Array
                (
                    [nick] => Yousef Al Shammari
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/yousef-al-shammari-569876
                )

        )

    [visitor] => Array
        (
            [0] => Array
                (
                    [nick] => Boubacar Cissokho
                    [role] => 2
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/boubacar-cissokho-324157
                )

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

            [2] => Array
                (
                    [nick] => C. Reguii
                    [role] => 3
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/c-reguii-892796
                )

            [3] => Array
                (
                    [nick] => Y. Al Jumaiah
                    [role] => 4
                    [player_img] => //resfu.thumbr.io/media/img/avatar-player.jpg?size=34x&ext=png&lossy=1
                    [player_url] => jugador/y-al-jumaiah-887620
                )

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

        )

)
Array
(
    [type] => 9
    [isAfter] => 0
    [numMatches] => 2
    [date] => 2020-03-29 05:44:50
    [matches] => Array
        (
            [0] => Array
                (
                    [match_url] => partido/Al-Baten/Al-Kawkab
                    [id] => 151079
                    [r1] => 1
                    [r2] => 1
                    [short_name1] => ALB
                    [short_name2] => ALK
                    [shedule] => 2020-01-15 13:20:00
                    [category] => Primera Arabia Saudí
                    [year] => 2020
                    [team1] => 17261
                    [team2] => 17266
                    [winner] => 0
                )

            [1] => Array
                (
                    [match_url] => partido/Al-Kawkab/Al-Baten
                    [id] => 150889
                    [r1] => 2
                    [r2] => 0
                    [short_name1] => ALK
                    [short_name2] => ALB
                    [shedule] => 2019-08-21 18:00:00
                    [category] => Primera Arabia Saudí
                    [year] => 2020
                    [team1] => 17266
                    [team2] => 17261
                    [winner] => 17266
                )

        )

)

29 Mar

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,536,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Match / Index )  0.1665
Total Execution Time  0.1687
  CADENA URL  
/partido/Al-Baten/Al-Kawkab
  GET DATOS  
$_GET['/partido/Al-Baten/Al-Kawkab']  
$_GET['completed']  
$_GET['clang']  
$_GET['isocode']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (2)  
0.0468   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 = 'Al-Baten' AND dt2.basealias = 'Al-Kawkab'
0.0007  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=151079 AND extraId = 50042 AND type_rel = 4