4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Drancy Sub 19
TEMPORADA 2022/2023
LIGA FRANCESA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 Lens Sub 19 Lens Sub 19 26 58 26 58
2 PSG Sub 19 PSG Sub 19 26 82 25 52
3 Amiens SC Sub 19 Amiens 26 61 35 51
4 Montfermeil Sub 19 Montfermeil 26 59 32 47
5 Lille Sub 19 Lille 26 42 40 37
6 Stade de Reims Sub 19 Stade Reims 26 40 58 36
7 Le Havre Sub 19 Havre 26 44 33 35
8 Dunkerque Sub 19 Dunkerque 26 32 41 34
9 Valenciennes Sub 19 Valenciennes 26 39 41 33
10 Caen Sub 19 Caen Sub 19 26 38 48 33
11 USM Saran Sub 19 Saran 26 37 57 33
12 Orléans Sub 19 Orléans 26 41 65 24
13 Gonfreville Sub 19 Gonfreville 26 35 83 19
14 Drancy Sub 19 Drancy 26 31 55 18
TEMPORADA 2021/2022
LIGA FRANCESA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 PSG Sub 19 PSG Sub 19 26 95 26 65
2 Drancy Sub 19 Drancy 26 48 42 46
3 Caen Sub 19 Caen Sub 19 26 49 47 45
4 Amiens SC Sub 19 Amiens 26 51 37 44
5 Montfermeil Sub 19 Montfermeil 26 39 31 44
6 Valenciennes Sub 19 Valenciennes 26 38 33 43
7 Le Havre Sub 19 Havre 26 50 36 41
8 Orléans Sub 19 Orléans 26 49 34 40
9 Lille Sub 19 Lille 26 46 46 33
10 Lens Sub 19 Lens Sub 19 26 30 39 31
11 Feignies Sub 19 Feignies 26 31 44 24
12 Chambly Sub 19 Chambly 26 26 39 24
13 Saint-Pryve Sub 19 Saint-Pryve 26 17 76 17
14 Evreux 27 Sub 19 Evreux 26 27 66 16
TEMPORADA 2020/2021
LIGA FRANCESA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
TEMPORADA 2019/2020
LIGA FRANCESA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 Le Havre Sub 19 Havre 19 42 19 43
2 Amiens SC Sub 19 Amiens 19 46 27 40
3 PSG Sub 19 PSG Sub 19 19 43 22 39
4 Drancy Sub 19 Drancy 19 34 25 35
5 Orléans Sub 19 Orléans 19 39 34 33
6 Evreux 27 Sub 19 Evreux 19 28 32 31
7 Caen Sub 19 Caen Sub 19 19 41 24 28
8 Lens Sub 19 Lens Sub 19 19 38 45 26
9 Valenciennes Sub 19 Valenciennes 19 34 28 24
10 Lille Sub 19 Lille 19 30 32 23
11 Feignies Sub 19 Feignies 18 26 37 15
12 Quevilly Sub 19 Quevilly 18 26 38 15
13 Chartres Sub 19 Chartres 19 20 64 12
14 US Boulogne Sub 19 Boulogne 19 23 43 11
TEMPORADA 2017/2018
LIGA FRANCESA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Auxerre Sub 19 Auxerre 26 65 26 54
2 Stade de Reims Sub 19 Stade Reims 26 59 40 52
3 Troyes Sub 19 Troyes 26 49 31 48
4 Dijon Sub 19 Dijon 26 47 26 47
5 Nancy Sub 19 Nancy 26 38 40 44
6 Olympique Lyonnais Sub 19 Olympique 26 59 33 40
7 Metz Sub 19 Metz Sub 19 26 49 37 39
8 Strasbourg Sub 19 Strasbourg 26 47 40 36
9 Sochaux Sub 19 Sochaux 26 36 28 35
10 US Torcy Sub 19 Torcy 26 19 24 29
11 Drancy Sub 19 Drancy 26 33 36 28
12 Thonon Évian Sub 19 Thonon 26 37 67 25
13 Montceau Sub 19 Montceau 26 19 70 13
14 Belfort Sub 19 Belfort 26 22 81 13
TEMPORADA 2013/2014
LIGA FRANCESA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 Lille Sub 19 Lille 26 75 24 64
2 PSG Sub 19 PSG Sub 19 26 50 22 63
3 Lens Sub 19 Lens Sub 19 26 52 27 56
4 Le Havre Sub 19 Havre 26 53 28 49
5 Amiens SC Sub 19 Amiens 26 51 40 47
6 Paris FC Sub 19 Paris 26 40 34 37
7 Quevilly Sub 19 Quevilly 26 46 54 34
8 Caen Sub 19 Caen Sub 19 26 49 44 33
9 Valenciennes Sub 19 Valenciennes 26 50 45 30
10 Amiens AC Sub 19 Amiens 26 25 38 25
11 Arras Sub 19 Arras 26 40 77 25
12 Drancy Sub 19 Drancy 26 29 62 19
13 Avranches Sub 19 Avranches 26 32 52 18
14 Racing Club Sub 19 Racing Club 26 18 63 13
TEMPORADA 2012/2013
LIGA FRANCESA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Auxerre Sub 19 Auxerre 26 62 26 58
2 Sochaux Sub 19 Sochaux 26 46 18 54
3 CS Sedan Sub 19 Sedan 26 56 26 51
4 Nancy Sub 19 Nancy 26 56 34 49
5 Metz Sub 19 Metz Sub 19 26 44 27 44
6 Drancy Sub 19 Drancy 26 41 31 41
7 Troyes Sub 19 Troyes 26 41 38 39
8 Stade de Reims Sub 19 Stade Reims 26 53 54 34
9 Dijon Sub 19 Dijon 26 28 28 33
10 Paris FC Sub 19 Paris 26 35 46 31
11 FC Mulhouse Sub 19 Mulhouse 26 38 52 31
12 Amnéville Sub 19 Amnéville 26 24 54 19
13 Vesoul Sub 19 Vesoul 26 25 65 16
14 Jura Sud Sub 19 Jura 26 23 73 7
TEMPORADA 2011/2012
LIGA FRANCESA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Auxerre Sub 19 Auxerre 23 68 19 53
2 Metz Sub 19 Metz Sub 19 22 50 27 47
3 Troyes Sub 19 Troyes 22 48 36 39
4 Drancy Sub 19 Drancy 22 33 27 39
5 Nancy Sub 19 Nancy 22 39 27 38
6 Sochaux Sub 19 Sochaux 22 30 31 36
7 CS Sedan Sub 19 Sedan 22 22 32 29
8 Dijon Sub 19 Dijon 22 34 41 24
9 Vesoul Sub 19 Vesoul 22 22 39 23
10 Amnéville Sub 19 Amnéville 22 18 35 21
11 Paris FC Sub 19 Paris 22 15 27 17
12 Saint Quentin Sub 19 Saint 23 19 38 14
13 Epinal Sub 19 Epinal 22 16 35 14
14 Strasbourg Sub 19 Strasbourg 0 0 0 0

  USO DE MEMORIA  
5,694,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  4.7758
Total Execution Time  4.7770
  CADENA URL  
/historico/Drancy-Sub19
  GET DATOS  
$_GET['/historico/Drancy-Sub19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.2554  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 = 'Drancy-Sub19' 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.1334  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 = 'Drancy-Sub19' 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=88378 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=88378 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=88378 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=88378 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=88378 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=88378 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=88378 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=88378 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=88378 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=88378 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=88378 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 68345
0.0025  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 = 70834
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=88378 AND type_rel = 2
0.0815  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 = '88378' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.1177  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 = '88378' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0526  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 = 70834 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0261  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 = 68345 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.1851  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=88378 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0157  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 (70834,68345) 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.2515  SELECT count(id) as num_players from rel_players WHERE league_id = 68345 AND teamId = 88378
0.4149  SELECT count(id) as num_players from rel_players WHERE league_id = 70834 AND teamId = 88378
0.1317  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 = 68345 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0594  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '88378' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0219  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '88378' and rp.type = 4
0.0102  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '88378' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
1.1132  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 = 68345 WHERE rp.league_id = 68345 AND rp.teamId = 88378 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.5164  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 = 68345 WHERE rp.league_id = 68345 AND rp.teamId = 88378 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.2539  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 = 68345 WHERE rp.league_id = 68345 AND rp.teamId = 88378 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0889  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 = 88378 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.1268  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 = 68345 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.1870  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 = 63498 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.0019  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 = 58471 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.0721  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 = 51414 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1768  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 = 39605 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1410  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 `tables2014` 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 = 28014 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1626  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 `tables2013` 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 = 28050 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1183  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 `tables2012` 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 = 28115 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC