4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Sevilla C Sevilla C 34 48 11 73
2 Paradas B. Paradas B. 34 63 36 66
3 A.D. San José A.D. José 34 63 40 66
4 Real Betis C Real Betis 34 85 37 65
5 Estepa Ind. Estepa Ind. 34 60 36 64
6 UD Tomares UD Tomares 34 47 35 50
7 UD Marinaleda Marinaleda 34 40 34 49
8 CD San Martin Martin 34 49 44 46
9 AD. Carmona AD. Carmona 34 46 49 44
10 Lebrijana Lebrijana 34 41 55 43
11 Viso UP Viso UP 33 43 41 41
12 Mosqueo Mosqueo 34 38 47 40
13 San Juan Bosco Juan Bosco 34 47 54 38
14 Poli Aguadulce Poli 34 45 58 38
15 Su Eminencia Eminencia 34 48 77 38
16 UD Rinconada Rinconada 34 37 56 37
17 La Estrella La Estrella 34 26 50 31
18 Brenes Balompié Brenes 33 25 91 19
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Cabecense Cabecense 34 58 30 72
2 Pilas Pilas 34 63 26 70
3 Estepa Ind. Estepa Ind. 34 59 40 57
4 AD. Carmona AD. Carmona 34 49 28 56
5 UD Marinaleda Marinaleda 34 47 35 56
6 San Juan Bosco Juan Bosco 34 57 42 52
7 CD San Martin Martin 34 32 31 48
8 Mosqueo Mosqueo 34 57 53 46
9 Viso UP Viso UP 34 43 43 45
10 UD Tomares UD Tomares 34 30 39 44
11 Su Eminencia Eminencia 34 42 56 42
12 Lebrijana Lebrijana 34 50 61 40
13 La Estrella La Estrella 34 41 60 40
14 Brenes Balompié Brenes 34 34 44 39
15 Atlético Algabeño Atlético 34 41 62 38
16 Puebla Farnals Puebla 34 33 44 37
17 Cantillana Cantillana 34 42 67 29
18 JD Bormujos JD Bormujos 34 39 56 26
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Utrera Utrera 34 65 32 71
2 Castilleja Castilleja 34 56 29 67
3 Mairena Mairena 34 68 38 64
4 A.D. San José A.D. José 33 50 24 62
5 Nervión Nervión 34 64 36 60
6 Marchena Balompié Marchena 34 50 47 55
7 Moron Moron 34 49 34 54
8 Camas Camas 34 36 44 50
9 Pilas Pilas 34 41 45 46
10 Cabecense Cabecense 33 49 41 44
11 San Juan Bosco Juan Bosco 34 50 53 44
12 Estepa Ind. Estepa Ind. 34 51 52 43
13 Cantillana Cantillana 34 47 64 40
14 Viso UP Viso UP 34 34 43 38
15 JD Bormujos JD Bormujos 34 39 75 31
16 Lebrijana Lebrijana 34 34 62 29
17 Puebla Farnals Puebla 34 26 52 27
18 Su Eminencia Eminencia 34 37 75 21
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 A. Cerro Águila Cerro 32 52 31 61
2 Moron Moron 32 48 32 60
3 Nueva Sevilla Nueva 32 46 25 59
4 Castilleja Castilleja 32 48 37 59
5 San Juan Bosco Juan Bosco 33 59 39 58
6 Mairena Mairena 32 48 31 55
7 Utrera Utrera 32 50 34 55
8 Pilas Pilas 32 43 29 47
9 JD Bormujos JD Bormujos 32 47 46 47
10 Camas Camas 33 31 32 45
11 Marchena Balompié Marchena 32 46 39 44
12 Estepa Ind. Estepa Ind. 32 49 59 37
13 Cabecense Cabecense 32 39 58 36
14 Puebla Farnals Puebla 32 37 47 35
15 Benacazón CF Benacazón 32 30 49 35
16 Arahal Arahal 33 38 60 30
17 Osuna BC Osuna BC 32 23 36 29
18 AD. Carmona AD. Carmona 32 25 49 27
19 UD Tomares UD Tomares 33 38 64 27

  USO DE MEMORIA  
5,426,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0759
Total Execution Time  0.0780
  CADENA URL  
/segunda_andaluza_sevilla2006/grupo1/historico
  GET DATOS  
$_GET['/segunda_andaluza_sevilla2006/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0017  SELECT type FROM routes WHERE alias = 'segunda_andaluza_sevilla2006'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_andaluza_sevilla' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=277 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 277 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (986815,818727,685220,55701) ORDER BY n.cover_points DESC, update_date DESC
0.0017  SELECT id,name,alias,stepParent FROM categories WHERE parentId=277 ORDER BY order_id ASC
0.0020  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 = 2938 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 277 AND group_code = 1 and tables = 1 AND year <= 2006 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables2006` 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 = 2938 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2005` 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 = 2937 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2004` 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 = 2936 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2003` 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 = 2935 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0017  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 16:22:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 16:22:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 16:22:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 16:22:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_andaluza_sevilla' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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 events2006 e ON e.player_id = p.id AND e.league_id = 2938 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2938 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.0019  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 events2006 e ON e.player_id = p.id AND e.league_id = 2938 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2938 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0018  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 events2006 e ON e.player_id = p.id AND e.league_id = 2938 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2938 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0047  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` 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 = 2938 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC