4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Trasmallo Trasmallo 32 120 30 75
2 Divina Pastora Divina 32 128 36 73
3 Isla de León Isla León 31 86 31 69
4 Tiempo Libre A.D. Tiempo Libre 32 84 35 64
5 Recreativo Portuense Recreativo 32 71 52 56
6 La Salle Pto.Real B Salle 33 78 53 54
7 C.D. Puertorrealeña C.D. 32 74 54 54
8 Fútbol Sanix C.D. Fútbol 32 62 45 47
9 Novo Gazul Novo Gazul 32 51 48 46
10 Barriada la playa Barriada 32 52 71 40
11 San Fernando Atletico B Fernando 32 62 64 40
12 UD Río San Pedro Río Pedro 32 61 103 33
13 C.D. Novo Chiclana C.D. Novo C. 32 44 89 30
14 Junior Junior 32 38 70 25
15 San Marcos P.S.M Marcos P.S.M 32 56 90 25
16 Los Frailes Los Frailes 31 22 65 23
17 Cañorrera Cañorrera 32 18 171 7
18 Burreños Burreños 1 0 0 1

  USO DE MEMORIA  
4,988,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2917
Total Execution Time  0.2937
  CADENA URL  
/cuarta_andaluza_cadiz_juvenil2014/grupo1/historico
  GET DATOS  
$_GET['/cuarta_andaluza_cadiz_juvenil2014/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0104  SELECT type FROM routes WHERE alias = 'cuarta_andaluza_cadiz_juvenil2014'
0.0213  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'cuarta_andaluza_cadiz_juvenil' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2014 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=442 AND type_rel = 3
0.0106  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 442 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108  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 (584919,135759,135358,134139,12487) ORDER BY n.cover_points DESC, update_date DESC
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=442 ORDER BY order_id ASC
0.0106  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 442 AND group_code = 1 and tables = 1 AND year <= 2014 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0110  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 = 3039 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 15:22:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 15:22:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 15:22:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 15:22:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0212  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'cuarta_andaluza_cadiz_juvenil' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2014 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0108  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 events2014 e ON e.player_id = p.id AND e.league_id = 3039 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 3039 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.0107  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 events2014 e ON e.player_id = p.id AND e.league_id = 3039 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 3039 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0106  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 events2014 e ON e.player_id = p.id AND e.league_id = 3039 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 3039 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0222  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014_base` 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 = 3039 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC