4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Minuto a Minuto

Clasificación

Equipo PJ GF GC Puntos
1 Gimnástic Manresa Sub 19 Gimnástic 26 58 24 62
2 Barcelona Sub 19 B Barcelona 26 60 28 58
3 Gimnàstic Sub 19 Gimnàstic 27 67 28 58
4 CF Damm Sub 19 B Damm 26 39 29 51
5 Martinenc Sub 19 Martinenc 26 47 45 44
6 CE Europa Sub 19 Europa 26 44 40 41
7 Sabadell Sub 19 B Sabadell 27 42 42 36
8 Sant Andreu Sub 19 Sant Andreu 26 37 38 35
9 FE Grama Sub 19 Grama 27 33 47 34
10 Olot Sub 19 Olot Sub 19 26 37 44 34
11 Espanyol Sub 19 B Espanyol 26 45 42 32
12 CE APA Poblec Sub 19 Poblec 26 36 40 31
13 Cornellà Sub 19 B Cornellà 26 30 46 27
14 At. Segre Sub 19 Segre 26 37 52 23
15 Lloret Sub 19 Lloret 26 31 52 17
16 UE Figueres Sub 19 Figueres 27 25 71 14

  USO DE MEMORIA  
5,044,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.2932
Total Execution Time  0.2956
  CADENA URL  
/nacional_juvenil2024/grupo7/minutoaminuto
  GET DATOS  
$_GET['/nacional_juvenil2024/grupo7/minutoaminuto']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'nacional_juvenil' AND (l.group_code = 7 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=7 DESC LIMIT 1
0.0311  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 73377 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 100
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 17:33:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 17:33:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 17:33:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 17:33:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0214  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 = 73377 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73377 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.0222  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 = 73377 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73377 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0133  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 = 73377 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73377 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0140  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 = 73377 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC