4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Muleño Cf Muleño Cf 34 87 34 74
2 FC La Unión Atl. Unión Atl. 34 74 26 72
3 FC Cartagena B Cartagena 34 78 26 71
4 FC Pinatar FC Pinatar 34 59 32 68
5 Cf Santomera Santomera 34 69 38 67
6 Caravaca Caravaca 34 76 43 66
7 Sporting Club Aguileño Sporting 34 60 41 63
8 EF Alhama EF Alhama 34 70 33 62
9 Ciudad De Calasparra Ciudad 34 58 52 50
10 CD Cieza B CD Cieza B 34 46 59 42
11 Balsicas Atlético Balsicas 34 48 72 41
12 Montecasillas Fc Montecasilla 34 51 75 35
13 Alcantarilla Thader Alcantarilla 34 45 93 35
14 Ud Los Garres Garres 34 47 59 33
15 Ad Guadalupe Guadalupe 34 42 67 31
16 CD Lumbreras Lumbreras 34 38 76 23
17 Ad Moratalla Moratalla 34 35 92 20
18 Ed Churra Ed Churra 34 30 95 16
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Águilas FC Águilas FC 38 69 18 96
2 Esperanza Esperanza 38 84 41 75
3 Deportiva Minera Deportiva 38 79 41 75
4 Torre Pacheco Torre 38 73 56 67
5 Ceuti At. Ceuti At. 38 70 54 63
6 Thader Murcia CF Thader 38 63 42 59
7 Pozo Estrecho Pozo 38 65 67 56
8 Cuarto Distrito Cuarto 38 54 55 53
9 Muleño CF Muleño CF 38 65 60 52
10 CD Bullense CD Bullense 38 57 52 52
11 El Palmar El Palmar 38 46 48 52
12 UD Los Garres Garres 38 65 72 52
13 Yeclano B Yeclano B 38 43 42 51
14 Mazarrón FC Mazarrón 38 43 54 44
15 Ciudad de Cieza Ciudad Cieza 38 45 62 43
16 Guadalupe Guadalupe 38 50 63 38
17 Lumbreras Lumbreras 38 45 60 37
18 Montecasillas Montecasilla 38 64 86 35
19 Ed Javalí-Ñora Javalí-Ñor 38 38 93 26
20 Emf Cotillas Cotillas 38 35 87 23
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 La Hoya La Hoya 37 83 33 87
2 Unión Molinense Unión 37 81 26 81
3 Racing Cartagena Mar Menor Racing 37 95 49 71
4 CD Bullense CD Bullense 37 56 48 66
5 Esperanza Esperanza 37 63 51 62
6 Minera Minera 37 65 45 57
7 Torre Pacheco Torre 37 67 45 56
8 Ceutí At. Ceutí At. 37 68 52 56
9 Muleño CF Muleño CF 37 66 61 50
10 Montecasillas Montecasilla 36 59 75 45
11 Ciudad de Cieza Ciudad Cieza 37 52 60 44
12 Alquerias Alquerias 37 53 59 42
13 UD Águilas UD Águilas 36 46 69 42
14 Guadalupe Guadalupe 37 61 71 40
15 Invercosta Progreso Invercosta 37 51 66 40
16 Pozo Estrecho Pozo 37 60 77 39
17 El Palmar El Palmar 37 51 61 38
18 Olímpico de Totana Olímpico 37 56 71 38
19 Alberca Huracán Alberca 37 53 147 22
20 San Ginés San Ginés 19 36 56 21
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Puente Tocinos Puente 38 81 32 78
2 Club Fortuna Club Fortuna 38 63 37 74
3 FC Cartagena B Cartagena 38 58 30 73
4 Cuarto Distrito Cuarto 38 68 45 73
5 CF Base Abarán Base Abarán 38 62 39 71
6 Minera Minera 38 60 43 70
7 CD Bullense CD Bullense 38 73 47 67
8 Ciudad de Cieza Ciudad Cieza 38 59 47 66
9 Ceutí At. Ceutí At. 38 55 36 58
10 Archena Archena 38 52 53 51
11 Olímpico de Totana Olímpico 38 60 51 50
12 Racing Cartagena Mar Menor Racing 38 50 51 49
13 Alberca Alberca 38 56 65 49
14 Santiago El Mayor Santiago 38 44 62 43
15 Molinense Molinense 38 54 66 37
16 Alquerias Alquerias 38 45 65 37
17 La Hoya La Hoya 38 28 56 37
18 Javalí-Ñora Javalí-Ñor 38 43 70 33
19 Pinatar B Pinatar B 38 50 91 24
20 Atletico Ciudad B Atletico 38 33 108 14

  USO DE MEMORIA  
5,470,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.4030
Total Execution Time  0.4051
  CADENA URL  
/murcia2013/grupo1/historico
  GET DATOS  
$_GET['/murcia2013/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0144  SELECT type FROM routes WHERE alias = 'murcia2013'
0.0293  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'murcia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=81 AND type_rel = 3
0.0146  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 = 2074 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 81 AND group_code = 1 and tables = 1 AND year <= 2013 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0150  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 = 2074 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2009` 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 = 295 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 18:19:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 18:19:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 18:19:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 18:19:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'murcia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0147  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 events2013 e ON e.player_id = p.id AND e.league_id = 2074 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2074 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.0146  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 events2013 e ON e.player_id = p.id AND e.league_id = 2074 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2074 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0147  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 events2013 e ON e.player_id = p.id AND e.league_id = 2074 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2074 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0159  SELECT *,(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 = 2074 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC