4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Versailles Sub 17 Versailles 24 43 19 55
2 Amiens SC Sub 17 Amiens 24 61 26 54
3 PSG Sub 17 PSG Sub 17 23 67 25 50
4 Le Havre Sub 17 Havre 24 58 26 45
5 Stade Lavallois Sub 17 Stade 24 37 29 38
6 Orléans Sub 17 Orléans 23 41 38 33
7 FC Mantois 78 Sub 17 Mantois 24 34 38 30
8 Caen sub 17 Caen sub 17 24 35 41 29
9 Le Mans Sub 17 Mans 24 39 51 27
10 Paris FC Sub 17 Paris 24 25 39 27
11 QRM Sub 17 QRM Sub 17 24 42 59 24
12 Blois Sub 17 Blois 24 32 60 22
13 Montrouge sub 17 Montrouge 24 33 59 21
14 Châteauroux Sub 17 Châteauroux 24 22 59 14
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Amiens SC Sub 17 Amiens 26 65 18 61
2 PSG Sub 17 PSG Sub 17 26 80 30 56
3 Le Havre Sub 17 Havre 26 50 29 56
4 Paris FC Sub 17 Paris 26 39 39 41
5 Montrouge sub 17 Montrouge 26 52 55 39
6 Stade Lavallois Sub 17 Stade 26 38 46 33
7 Orléans Sub 17 Orléans 26 37 41 32
8 Caen sub 17 Caen sub 17 26 37 46 32
9 Châteauroux Sub 17 Châteauroux 26 40 47 30
10 QRM Sub 17 QRM Sub 17 26 49 58 30
11 Mantes Sub 17 Mantes 26 37 47 29
12 Brétigny Foot Sub 17 Brétigny 26 46 53 28
13 Étoile Bleue Sub 17 Étoile 26 41 67 26
14 FC Rouen 1899 Sub 17 Rouen 1899 26 33 68 16
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 PSG Sub 17 PSG Sub 17 26 80 35 58
2 Paris FC Sub 17 Paris 26 69 33 53
3 Caen sub 17 Caen sub 17 26 46 30 49
4 Avranches Sub 17 Avranches 26 52 44 44
5 Montrouge sub 17 Montrouge 26 42 35 42
6 Orléans Sub 17 Orléans 26 51 47 41
7 Le Havre Sub 17 Havre 26 55 32 40
8 Mantes Sub 17 Mantes 26 44 34 37
9 Brétigny Foot Sub 17 Brétigny 26 51 59 37
10 Le Mans Sub 17 Mans 26 39 49 27
11 FC Rouen 1899 Sub 17 Rouen 1899 26 51 63 25
12 Blois Sub 17 Blois 26 32 62 20
13 Vitré Sub 17 Vitré 26 32 87 19
14 Tours Sub 17 Tours 26 33 67 18

  USO DE MEMORIA  
5,233,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0030
Controller Execution Time ( Home / Category )  0.4141
Total Execution Time  0.4171
  CADENA URL  
/liga_francesa_sub172024/grupo1/historico
  GET DATOS  
$_GET['/liga_francesa_sub172024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0127  SELECT type FROM routes WHERE alias = 'liga_francesa_sub172024'
0.0276  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_francesa_sub17' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2172 AND type_rel = 3
0.0135  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=2172 ORDER BY l.group_code ASC
0.0127  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2172 ORDER BY order_id ASC
0.0129  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2172 GROUP BY l.categoryId
0.0127  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=2172 GROUP BY l.year ORDER BY l.year DESC
0.0127  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73371 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2172 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0131  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 = 73371 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 68349 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.0129  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 = 65110 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.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 16:35:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 16:35:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 16:35:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 16:35:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0134  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_francesa_sub17' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0335  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73371 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73371 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0209  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73371 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73371 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0132  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73371 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73371 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  SELECT *,(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 = 73371 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC