4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Les Ulis
TEMPORADA 2022/2023
NATIONAL 3 GRUPO 10
Equipo PJ GF GC Puntos
1 Aubervilliers Aubervillier 26 45 40 44
2 Linas-Montlhery Linas-Montlh 26 34 33 42
3 Drancy Drancy 26 46 34 41
4 Vitry Vitry 26 39 36 37
5 Les Mureaux Les Mureaux 26 45 45 35
6 Montrouge Montrouge 26 38 41 35
7 Brétigny Foot Brétigny 26 28 32 35
8 Sannois Gratien Sannois 26 27 25 34
9 Ivry Ivry 26 27 29 34
10 Les Ulis Les Ulis 26 33 28 33
11 Paris II Paris II 26 45 44 32
12 PSG II PSG II 26 31 30 30
13 Blanc Mesnil Blanc Mesnil 26 27 38 29
14 Le Mée Le Mée 26 28 38 28
TEMPORADA 2021/2022
NATIONAL 3 GRUPO 11
Equipo PJ GF GC Puntos
1 Racing Paris Racing Paris 25 62 20 60
2 Paris II Paris II 26 47 31 49
3 Blanc Mesnil Blanc Mesnil 26 38 30 42
4 Aubervilliers Aubervillier 26 31 32 39
5 Brétigny Foot Brétigny 26 37 39 39
6 PSG II PSG II 26 35 36 37
7 Linas-Montlhery Linas-Montlh 26 35 38 36
8 Drancy Drancy 25 31 28 33
9 Ivry Ivry 26 37 44 30
10 Les Mureaux Les Mureaux 26 26 35 29
11 Les Ulis Les Ulis 26 25 42 27
12 Créteil II Créteil II 26 26 31 26
13 Mantes Mantes 26 26 31 23
14 Meaux Academy Meaux 26 16 35 21
TEMPORADA 2020/2021
NATIONAL 3 GRUPO 7
Equipo PJ GF GC Puntos
1 Aubervilliers Aubervillier 0 0 0 0
2 Créteil II Créteil II 0 0 0 0
3 Linas-Montlhery Linas-Montlh 0 0 0 0
4 Meaux Academy Meaux 0 0 0 0
5 Drancy Drancy 0 0 0 0
6 Racing Paris Racing Paris 0 0 0 0
7 Les Ulis Les Ulis 0 0 0 0
8 Les Mureaux Les Mureaux 0 0 0 0
9 Brétigny Foot Brétigny 0 0 0 0
10 Ivry Ivry 0 0 0 0
11 Blanc Mesnil Blanc Mesnil 0 0 0 0
12 Paris II Paris II 0 0 0 0
13 Mantes Mantes 0 0 0 0
14 PSG II PSG II 0 0 0 0
TEMPORADA 2019/2020
NATIONAL 3 GRUPO 11
Equipo PJ GF GC Puntos
1 Versailles Versailles 18 35 7 42
2 Ivry Ivry 18 25 9 40
3 Créteil II Créteil II 17 20 14 28
4 Paris II Paris II 17 23 19 27
5 Racing Colombes 92 Racing 17 25 15 26
6 Blanc Mesnil Blanc Mesnil 16 14 15 25
7 Les Ulis Les Ulis 17 27 24 24
8 Les Mureaux Les Mureaux 17 17 18 21
9 Aubervilliers Aubervillier 17 17 20 21
10 PSG II PSG II 17 21 24 20
11 Noisy Le Grand Noisy Grand 18 13 29 16
12 US Torcy US Torcy 16 15 24 14
13 Saint-Leu Saint-Leu 18 11 26 14
14 Boulogne-Billancourt Boulogne-Bil 17 8 27 12
TEMPORADA 2018/2019
NATIONAL 3 GRUPO 11
Equipo PJ GF GC Puntos
1 Paris 13 Atletico Paris 26 50 24 49
2 Versailles Versailles 26 38 26 47
3 Aubervilliers Aubervillier 26 47 34 42
4 Racing Colombes 92 Racing 26 32 26 41
5 Les Mureaux Les Mureaux 26 31 29 39
6 Paris II Paris II 26 35 29 38
7 Ivry Ivry 26 37 31 35
8 Les Ulis Les Ulis 26 31 28 35
9 Blanc Mesnil Blanc Mesnil 26 30 34 33
10 Créteil II Créteil II 26 35 42 32
11 Noisy-le-Sec Noisy-le-Sec 26 25 35 28
12 Brétigny Foot Brétigny 26 15 28 28
13 Meaux Academy Meaux 26 29 42 27
14 Le Mée Le Mée 26 24 51 24
TEMPORADA 2017/2018
NATIONAL 3 GRUPO 12
Equipo PJ GF GC Puntos
1 Bobigny Bobigny 26 45 21 51
2 Aubervilliers Aubervillier 26 38 32 45
3 Noisy-le-Sec Noisy-le-Sec 26 46 26 43
4 Versailles Versailles 26 35 31 43
5 Paris 13 Atletico Paris 26 37 31 40
6 Blanc Mesnil Blanc Mesnil 26 37 29 38
7 Ivry Ivry 26 37 35 36
8 Les Mureaux Les Mureaux 26 21 21 34
9 Les Ulis Les Ulis 26 36 43 33
10 Créteil II Créteil II 26 38 33 32
11 Racing Colombes 92 Racing 26 30 41 29
12 Paris II Paris II 26 34 45 28
13 Saint-Ouen-l'Aumône Saint-Ouen-l 26 26 41 25
14 Sénart Moissy Sénart 26 26 57 19

  USO DE MEMORIA  
5,474,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.0929
Total Execution Time  0.0944
  CADENA URL  
/historico/Les-Ulis
  GET DATOS  
$_GET['/historico/Les-Ulis']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0048  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 = 70208
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=102224 AND type_rel = 2
0.0025  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 = '102224' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = '102224' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0041  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 = 70208 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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 = 68304 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=102224 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0021  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (70208,68304) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 68304 AND teamId = 102224
0.0044  SELECT count(id) as num_players from rel_players WHERE league_id = 70208 AND teamId = 102224
0.0028  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 68304 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0044  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 events2023 e ON e.player_id = p.id AND e.league_id = 68304 WHERE rp.league_id = 68304 AND rp.teamId = 102224 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.0040  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 events2023 e ON e.player_id = p.id AND e.league_id = 68304 WHERE rp.league_id = 68304 AND rp.teamId = 102224 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 events2023 e ON e.player_id = p.id AND e.league_id = 68304 WHERE rp.league_id = 68304 AND rp.teamId = 102224 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 102224 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0026  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 = 68304 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 63493 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 57388 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 50964 AND t.round = 18 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 `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 = 44570 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables2018` 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 = 39141 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC