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

Partidos del La Passe

Ir al LIVESCORE
03 May 24  en 5 días La Passe
13:00
Anse Reunion 0
19 Abr 24  Finalizado Lightstars
3 - 1
La Passe 0
11 Abr 24  Finalizado La Passe
2 - 2
St Michel United 0
16 Mar 24  Finalizado Foresters
2 - 2
La Passe 0
09 Mar 24  Finalizado La Passe
2 - 1
Bazar Brothers 0
23 Feb 24  Finalizado Côte d'Or
0 - 3
La Passe 0
16 Feb 24  Finalizado La Passe
0 - 4
Northern Dynamo 0
13 Feb 24  Finalizado La Passe
0 - 1
Lightstars 0
03 Feb 24  Finalizado St Louis Suns
1 - 0
La Passe 0
27 Ene 24  Finalizado Red Star
1 - 3
La Passe 0
20 Ene 24  Finalizado Anse Reunion
0 - 0
La Passe 0

Noticias del La Passe

Ver últimas noticias

El portero viral por su sobrepeso trabajó como pastelero

Dave Mussard es el portero de las Islas Seychelles, pero se ha hecho famoso no por sus grandes actuaciones bajo palos, sino más bien por su redondeada figura.




  USO DE MEMORIA  
4,751,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.0435
Total Execution Time  0.0457
  CADENA URL  
/La-Passe
  GET DATOS  
$_GET['/La-Passe']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0030  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 = 'La-Passe' 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=61993 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=61993 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=61993 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61993 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 61993 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019  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 (500627) 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 = '61993' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 61993 AND rp.league_id = 74260 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1