4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bahla
Información

Histórico de participación

Partidos del Bahla

Ir al LIVESCORE
25 May 24  en 29 días Bahla
17:15
Ibri 0
21 May 24  en 25 días Al-Shabab
17:15
Bahla 1
07 May 24  en 11 días Bahla
18:20
Al-Seeb 1
27 Abr 24  en 1 día Al-Nahda
15:55
Bahla 0
22 Abr 24  Finalizado Sohar
1 - 1
Bahla 8
18 Abr 24  Finalizado Bahla
0 - 0
Sur Club 1
08 Abr 24  Finalizado Al Wahda
0 - 1
Bahla 0
04 Abr 24  Finalizado Bahla
1 - 0
Dhofar 2
30 Mar 24  Finalizado Al Rustaq
3 - 2
Bahla 0
05 Mar 24  Finalizado Bahla
0 - 1
Oman FC 10
22 Feb 24  Finalizado Bahla
1 - 2
Al-Nasr Salalah 5
16 Feb 24  Finalizado Ibri
0 - 0
Bahla 9
10 Mar 24  Finalizado Dhofar
1 - 0
Bahla 0
28 Feb 24  Finalizado Bahla
0 - 0
DhofarTarjeta Roja 3

Plantilla del Bahla Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Defensa
33 cm - - 1 - -
- om - - - - -
Centrocampista
33 br 181 71 1 - -
24 gh 178 - - - -
31 br - - 1 - -
- om - - 1 - -
- om - - 1 - -
- om - - 1 - -
- om - - 1 - -

Noticias de Liga Omán

Ver últimas noticias

Fallece de un infarto un jugador de Oman en pleno calentamiento

El fútbol vuelve a vestirse de luto por el fallecimiento de un jugador. Se trata de Mukhaled Al-Raqadi, jugador del Muscat FC de Omán de solo 29 años que falleció en pleno calentamiento de un partido.

El jugador que lo dejó todo para irse a la Liga de Omán

Ferrán Tacón es un futbolista que bien sabe lo que es ir de un lugar para otro. Se le podría relacionar con un nómada, pero en el mundo del fútbol. Ahora, ha dejado el Eldense para irse a la Liga de Omán.

Un nuevo fracaso para Fabio Cannavaro

El mítico defensa central Fabio Cannavaro, galardonado con el Balón de Oro en 2006, no está disfrutando en los banquillos del mismo éxito que logró encima del césped.




  USO DE MEMORIA  
4,882,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2455
Total Execution Time  0.2474
  CADENA URL  
/Bahla
  GET DATOS  
$_GET['/Bahla']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=84126 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=502 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 502 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0130  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1083737,117382,41760) ORDER BY n.cover_points DESC, update_date DESC
0.0134  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '84126' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0138  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id WHERE (c.datateam1 = 84126 or c.datateam2 = 84126) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0166  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 84126 or c.datateam2 = 84126) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0148  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 84126 or c.datateam2 = 84126) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0151  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73468 WHERE rp.league_id = 73468 AND rp.teamId = 84126 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73468 WHERE rp.league_id = 73468 AND rp.teamId = 84126 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73468 WHERE rp.league_id = 73468 AND rp.teamId = 84126 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30