4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del York United

York United

Entrenador: Martin Nash

Temporada 2023/2024
TEMPORADA 2023/2024
PREMIER LEAGUE CANADÁ
Equipo PJ GF GC Puntos
1 Forge Forge 3 7 2 9
2 Atlético Ottawa Atlético 3 6 3 7
3 Pacific Pacific 3 3 0 7
4 Vancouver FC Vancouver 3 6 4 6
5 York United York United 3 4 5 3
6 Cavalry Cavalry 3 2 3 2
7 HFX Wanderers Wanderers 3 1 6 0
8 Valour Valour 3 2 8 0
TEMPORADA 2022/2023
PREMIER LEAGUE CANADÁ
Equipo PJ GF GC Puntos
1 Cavalry Cavalry 28 46 27 55
2 Forge Forge 28 39 32 42
3 HFX Wanderers Wanderers 28 39 32 42
4 Pacific Pacific 28 42 35 40
5 York United York United 28 35 44 38
6 Atlético Ottawa Atlético 28 38 34 36
7 Vancouver FC Vancouver 28 28 50 29
8 Valour Valour 28 25 38 26
TEMPORADA 2021/2022
PREMIER LEAGUE CANADÁ
Equipo PJ GF GC Puntos
1 Atlético Ottawa Atlético 28 36 29 49
2 Forge Forge 28 47 25 47
3 Cavalry Cavalry 28 39 33 47
4 Pacific Pacific 28 36 33 46
5 Valour Valour 28 36 34 37
6 York United York United 28 31 37 34
7 HFX Wanderers Wanderers 28 24 38 29
8 Edmonton Edmonton 28 31 51 20
TEMPORADA 2020/2021
PREMIER LEAGUE CANADÁ
Equipo PJ GF GC Puntos
1 Forge Forge 27 37 23 47
2 Cavalry Cavalry 27 33 30 47
3 Pacific Pacific 27 47 33 45
4 York United York United 27 34 37 36
5 HFX Wanderers Wanderers 28 28 34 35
6 Valour Valour 27 35 33 34
7 Edmonton Edmonton 27 31 38 27
8 Atlético Ottawa Atlético 28 30 47 26
TEMPORADA 2019/2020
PREMIER LEAGUE CANADÁ GRUPO 1
Equipo PJ GF GC Puntos
1 Cavalry Cavalry 7 10 7 13
2 HFX Wanderers Wanderers 7 12 7 12
3 Forge Forge 7 13 9 12
4 Pacific Pacific 7 10 8 11
5 York United York United 7 8 7 10
6 Valour Valour 7 8 9 8
7 Atlético Ottawa Atlético 7 7 12 8
8 Edmonton Edmonton 7 5 14 1
TEMPORADA 2018/2019
PREMIER LEAGUE CANADÁ
Equipo PJ GF GC Puntos
1 Cavalry Cavalry 28 51 19 62
2 Forge Forge 28 45 26 56
3 York United York United 28 39 37 34
4 Edmonton Edmonton 28 27 33 32
5 Pacific Pacific 28 35 46 31
6 HFX Wanderers Wanderers 28 21 35 28
7 Valour Valour 28 30 52 28

  USO DE MEMORIA  
5,023,984 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.0564
Total Execution Time  0.0579
  CADENA URL  
/historico/York9-Fc
  GET DATOS  
$_GET['/historico/York9-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=119654 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2119 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2119 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1267996,1264826,1241678,1208057,1160609) ORDER BY n.cover_points DESC, update_date DESC
0.0023  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 = '119654' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 75480 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 75134 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 75134 AND t.round = 4 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 119654 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0020  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 `tables2024` 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 = 75134 AND t.round = 4 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables2023` 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 = 70798 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2022` 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 = 66710 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2021` 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 = 60907 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2020` 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 = 55518 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables2019` 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 = 49174 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC