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

Partidos del Al Mesaimeer

Ir al LIVESCORE
27 Abr 24  Finalizado Al Mesaimeer Al Mesaimeer
2 - 3
Al Waab Al Waab 0
20 Abr 24  Finalizado Al Mesaimeer Al Mesaimeer
2 - 1
Al Waab Al Waab 0
13 Abr 24  Finalizado Al-Khor Al-Khor
3 - 1
Al Mesaimeer Al Mesaimeer 0
09 Mar 24  Finalizado Al Mesaimeer Al Mesaimeer
1 - 0
Lusail SC Lusail SC 0
28 Feb 24  Finalizado Al Mesaimeer Al Mesaimeer
2 - 3
Al Shahaniya Al Shahaniya 0
21 Feb 24  Finalizado Al Bidda Al Bidda
1 - 2
Al Mesaimeer Al Mesaimeer 0
11 Feb 24  Finalizado Al-Sailiya Al-Sailiya
3 - 3
Al Mesaimeer Al Mesaimeer 0

Estadísticas

Plantilla del Al Mesaimeer Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Delantero
23 mr 177 61 4 - -
35 jo 179 - 2 - -
- qa - - 1 - -
- qa - - - - -
- qa - - - - -
- qa - - 2 - -
- qa - - 2 - -
- qa - - - - -
- qa - - 8 - -

Noticias del Al Mesaimeer

Ver últimas noticias

El Boavista 'ficha' gol con Erivelto

Los 'ajedrezados' han reforzado su ataque con Erivelto, máximo goleador de la Segunda División lusa hace dos temporadas. Tras un año en Qatar, el brasileño regresa a Portugal.




  USO DE MEMORIA  
4,681,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.0464
Total Execution Time  0.0488
  CADENA URL  
/mesaimeer
  GET DATOS  
$_GET['/mesaimeer']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0042  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'mesaimeer' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=57525 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=57525 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=57525 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=57525 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 57525 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  SELECT /*35 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 (95683) ORDER BY n.cover_points DESC, update_date DESC
0.0029  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 = '57525' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020