Partido Al-Wasl - Shabab Al Ahli Dubai

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Al-Wasl - Shabab Al Ahli Dubai Al-Wasl - Shabab Al Ahli Dubai

Final

FINALIZADO

1313 Pts. Elo

54%

Al-Wasl

1313 Pts. Elo

45%

Shabab Al Ahli Dubai

2(1-4)2

Viernes, 13 Diciembre 2024, 16:45

		0 - 1	47'	Guilherme Bala
		0 - 2	53'	L. Milivojevic
N. Giménez	58'	1 - 2
Fabio Lima	98'	2 - 2

Eventos del partido

Goles

minuto 47'

Gol de Guilherme Bala

minuto 53'

Gol de L. Milivojevic

Gol de

N. Giménez

minuto 58'

Gol de penalti

Fabio Lima

minuto 98'

Tarjetas

T. Amarilla

Majid Surour

minuto 34'

minuto 37'

T. Amarilla S. Ezatolahi

T. Amarilla

H. Seferović

minuto 37'

T. Amarilla

S. Bouftini

minuto 44'

minuto 45'

T. Amarilla Guilherme Bala

T. Amarilla

A. Pérez

minuto 52'

minuto 57'

T. Amarilla Yuri Cesar

T. Amarilla

Salem Al Azizi

minuto 71'

minuto 74'

T. Amarilla F. Cartabia

minuto 82'

T. Amarilla Igor Gomes

Cambios

Entra en el partido

S. Mijailović

minuto 59'

Sale del partido

Siaka Sidibe

minuto 59'

Entra en el partido

Abdelrahman Saleh

minuto 59'

Sale del partido

Majid Surour

minuto 59'

Entra en el partido

Jonatas Santos

minuto 59'

Sale del partido

A. Pérez

minuto 59'

minuto 67'

Sale del partido S. Ezatolahi

minuto 67'

Sale del partido S. Suleiman

minuto 67'

Entra en el partido Igor Gomes

minuto 67'

Entra en el partido Breno

Sale del partido

Salem Al Azizi

minuto 75'

Entra en el partido

Rodrigo

minuto 75'

Sale del partido

H. Seferović

minuto 75'

Entra en el partido

Caio

minuto 75'

minuto 77'

Entra en el partido Yahya Alghassani

minuto 77'

Sale del partido Rikelme

minuto 77'

Entra en el partido Kauan Santos

minuto 77'

Sale del partido F. Cartabia

minuto 85'

Sale del partido Yuri Cesar

minuto 85'

Entra en el partido M. Dabbur

Otros

minuto 47'

Asistencia S. Azmoun

minuto 53'

Asistencia F. Cartabia

Asistencia

Fabio Lima

minuto 58'

Goles

Gol concedido

Abdelrahman Saleh

minuto 95'

Tanda de penaltis

Fabio Lima

S. Azmoun

Caio

Yahya Alghassani

N. Giménez

L. Milivojevic

Kauan Santos

Alineaciones

Al-Wasl

4-5-1

Alineación Inicial

1

K. Al Senani
15

Seung-Hyun Jung
4

S. Bouftini
25
59'

A. Pérez
44
75'

Salem Al Azizi
11
59'

Majid Surour
6
59'

Siaka Sidibe
31

N. Giménez
10

Fabio Lima
7

Ali Saleh
8
75'

H. Seferović

Suplentes

32

Mohamed Ali
12
59'

Abdelrahman Saleh
3

Yousif Ali Almheiri
19

T. Uchino
14
75'

Rodrigo
23

Tahnoon Al Zaabi
33
59'

S. Mijailović
18

Malek Janeer
5

Ali Salmin
9

Adama Diallo
77
59'

Jonatas Santos
17
75'

Caio

Shabab Al Ahli Dubai

4-3-3

Alineación Inicial

22

H. Abdullah
13

Renan
17

B. Planić
16
77'

Rikelme
50
67'

S. Suleiman
40

L. Milivojevic
66
67'

S. Ezatolahi
10
77'

F. Cartabia
77

Guilherme Bala
20

S. Azmoun
57
85'

Yuri Cesar

Suplentes

23

Rakaan Mubarak
12

H. Hamza
5

W. Abbas
25
67'

Igor Gomes
26

E. Khamis
80
67'

Breno
31
77'

Kauan Santos
18

Mohammed Almansoori
19

Mateusão
11
77'

Yahya Alghassani
9
85'

M. Dabbur
7

Harib Abdalla

Estadísticas del partido

Al-Wasl		Shabab Ahli
54%	Posesión del balón	45%
2	Goles	2
3	Tiros a puerta	4
2	Tiros fuera	9
8	Total tiros	14
2	Paradas del portero	1
5	Saques de esquina	3
3	Fueras de juego	0
0	Tarjetas Rojas	0
1	Asistencias	2
3	Sustituciones	3
17	Faltas	17

NOTICIAS RELACIONADAS

USO DE MEMORIA

7,054,064 bytes

BENCHMARKS

Loading Time Base Classes	0.0016
Controller Execution Time ( Match / Index )	1.5265
Total Execution Time	1.5281

CADENA URL

/partido/Al-Wasl/Shabab-Al-Ahli-Dubai/2019?section=legal

GET DATOS

$_GET['/partido/Al-Wasl/Shabab-Al-Ahli-Dubai/2019']
$_GET['section']	legal

POST DATOS

No hay datos POST existentes

CONSULTAS (48)

0.0067	SELECT c., c.stadium as real_stadium, 2025 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.seats, dt1.size, dt1.yearBuilt, 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, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM* calendars2025 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 futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Al-Wasl' AND dt2.basealias = 'Shabab-Al-Ahli-Dubai'
0.0025	SELECT c., 2025 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.seats, dt1.size, dt1.yearBuilt, 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, dt1.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, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM* calendars2025 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 datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Al-Wasl' AND dt2.basealias = 'Shabab-Al-Ahli-Dubai'
0.0038	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 78021
0.0019	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2025 AS ev WHERE ev.match_id=222355 ORDER BY (ev.action=1 OR ev.action=2 OR ev.action=6 OR ev.action=11 OR ev.action=12 OR ev.action=13) DESC,(ev.action=3 OR ev.action=4 OR ev.action=5) DESC,(ev.action=14 OR ev.action=15 OR ev.action=16 OR ev.action=17 OR ev.action=21) DESC,(ev.action=18 OR ev.action=19) DESC,(ev.action=20 OR ev.action=22) DESC, minute ASC, ev.real_date ASC, ev.id DESC, ev.action DESC
0.0031	SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=78021 WHERE dp.id IN (851056,194462,272371,249094,306382,274973,50808,801601,210433,854472,294220,146765,869171,192140,447544,3165931,929605,821029,987452,1011835,139416,832746,889280,3155934,155794,185425) AND (rp.team_id=6673388 OR rp.team_id=6673389)
0.0018	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2025 AS ev WHERE ev.match_id=222355 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0030	SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=78021 WHERE dp.id IN (306382,274973,50808,801601,851056,185425,210433,194462,146765,854472,272371,249094,192140,447544,3165931,929605,821029,869171,987452,294220,1011835,139416,832746,889280,3155934,155794) AND (rp.team_id=6673388 OR rp.team_id=6673389)
0.0017	SELECT data1 FROM stats2025 t WHERE league_id = 78021 AND teamId = 6673388 and type = 33
0.0017	SELECT data1 FROM stats2025 t WHERE league_id = 78021 AND teamId = 6673389 and type = 33
0.0019	SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 78021 AND id_match = 222355
0.0024	SELECT rel.,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='78021' AND relp.team_id = drea.team_id WHERE rel.team_number=5786316 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0029	SELECT rel.,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='78021' AND relp.team_id = drea.team_id WHERE rel.team_number=5794134 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0063	SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='78021' AND relp.team_id=6673388 WHERE mp.`match_id` = '222355' AND mp.year='2025' AND p.id NOT IN (289450,211945,801601,210433,294220,306382,447544,272371,249094,374990,50808,892122,851719,230118,889280,821029,194462,274973,146765,851056,185425,854472) ORDER BY mp.`team` ASC, p.`role` ASC
0.0063	SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='78021' AND relp.team_id=6673389 WHERE mp.`match_id` = '222355' AND mp.year='2025' AND p.id NOT IN (289450,211945,801601,210433,294220,306382,447544,272371,249094,374990,50808,892122,851719,230118,889280,821029,194462,274973,146765,851056,185425,854472) ORDER BY mp.`team` ASC, p.`role` ASC
0.0019	SELECT kit FROM kit_data_real WHERE league_id = 78021 AND id_match = 222355
0.0019	SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '222355' and rp.type = 2025 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020	SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '222355' and rp.type = 2025 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020	SELECT ,rel.id as rel_id FROM* `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='10' AND rel.active = 1 AND rel.league_id = 78021 AND rel.team1 = 6673388 AND rel.team2 = 6673389 ORDER BY FIELD(m.location,'es','en') DESC
0.0017	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 222355 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0017	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 222355 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0020	SELECT ,rel.id as rel_id FROM* `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='11' AND rel.active = 1 AND rel.league_id = 78021 AND rel.team1 = 6673388 AND rel.team2 = 6673389 ORDER BY FIELD(m.location,'es','en') DESC
0.0018	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 78021 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018	SELECT teamId FROM teams WHERE id = 6673388
0.0017	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2025 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2025 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 != 99 or c.r2 != 99) AND (c.datateam1 = 5464 OR c.datateam2 = 5464) ORDER BY shedule DESC LIMIT 10
0.0017	SELECT teamId FROM teams WHERE id = 6673389
0.0017	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2025 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2025 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 != 99 or c.r2 != 99) AND (c.datateam1 = 102486 OR c.datateam2 = 102486) ORDER BY shedule DESC LIMIT 10
0.0020	SELECT teamId FROM teams WHERE id = 6673388
0.0018	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2025 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2025 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 = 99 or c.r2 = 99) AND (c.datateam1 = 5464 OR c.datateam2 = 5464) ORDER BY shedule ASC LIMIT 10
0.0018	SELECT teamId FROM teams WHERE id = 6673389
0.0020	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2025 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2025 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 = 99 or c.r2 = 99) AND (c.datateam1 = 102486 OR c.datateam2 = 102486) ORDER BY shedule ASC LIMIT 10
0.0017	SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2, c.shedule,c.id, c.r1, c.r2, c.round, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments,c.league_id FROM `calendars2025` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 78021 AND c.`round` = 1 ORDER BY c.type ASC,((c.team1c.team1)+(c.team2c.team2)) ASC,shedule ASC LIMIT 12
0.0018	SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2025` WHERE league_id = 78021 AND round >= 1 AND round <= 1 AND team = 6673388 ORDER BY round ASC
0.0090	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2025` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 78021 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0096	SELECT dr.name as showName, dr2.name as referee_var FROM calendars2025 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2025 and r.role=1 INNER JOIN datareferees dr on dr.id=r.referee_id INNER JOIN rel_calendars_referee as r2 ON c.id = r2.match_id and r2.year=2025 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 6673388 AND c.team2 = 6673389 AND c.league_id = 78021
0.0020	SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='222355' AND `active` = 1 AND year = 2025
0.0018	SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='222355' AND `active` = 1 AND year = 2025
0.0020	SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='78021' AND relp.team_id=6673388 WHERE relp.in_squad=1 and mp.`match_id` = '222355' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018	SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='78021' AND relp.team_id=6673389 WHERE relp.in_squad=1 and mp.`match_id` = '222355' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018	SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '78021' AND id_match = '222355'
0.0020	SELECT rel., dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '5786316' ORDER BY rating DESC LIMIT 1
0.0017	SELECT rel., dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '5794134' ORDER BY rating DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=222355 AND extraId = 78021 AND type_rel = 4
0.0017	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1686 AND type_rel = 3
0.0017	SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1686 AND l.year = 2025 ORDER BY l.group_code ASC
0.0017	SELECT rating1, rating2 FROM calendars_elo WHERE id=222355 AND league_id=78021 AND year=2025
0.0017	SELECT position FROM tables2025 WHERE team=6673388 AND league_id=78021 AND round=1
0.0017	SELECT position FROM tables2025 WHERE team=6673389 AND league_id=78021 AND round=1
0.0017	SELECT * FROM futbol.calendars_lineups WHERE id = 222355 AND league_id = 78021 AND year = 2025


	¡Vas a denunciar un contenido! x Denuncia sólo contenidos que incumplan nuestras Normas de uso o conducta. Aunque revisamos todas las denuncias que nos llegan, sólo respondemos si procede. El uso indebido de esta herramienta también incumple las normas de conducta. Elige una de las siguientes opciones: Incumplimiento de las normas: Otra:

Eventos del partido

Goles

Tarjetas

Cambios

Otros

Goles

Tanda de penaltis

Alineaciones

Alineación Inicial

Suplentes

Alineación Inicial

Suplentes

Estadísticas del partido

Posesión del balón

Goles

Tiros a puerta

Tiros fuera

Total tiros

Paradas del portero

Saques de esquina

Fueras de juego

Tarjetas Rojas

Asistencias

Sustituciones

Faltas

LIGAS RELACIONADAS

NOTICIAS RELACIONADAS