4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1988/1989
Equipo PJ GF GC Puntos
1 Levante Levante 38 66 29 59
2 AgD Ceuta AgD Ceuta 38 44 23 48
3 At. Sanluqueño Sanluqueño 38 47 27 47
4 Villarreal Villarreal 38 53 34 45
5 Eldense Eldense 38 37 32 44
6 Atlético Marbella Atlético 38 46 32 43
7 Cartagena F.C. UCAM Cartagena 38 39 29 41
8 Hércules Hércules 38 49 47 40
9 Alcoyano Alcoyano 38 48 44 39
10 Olimpic Xátiva Olimpic 38 41 41 39
11 CF Gandia CF Gandia 38 32 30 38
12 Albacete Albacete 38 46 45 36
13 Torrevieja Torrevieja 38 45 52 35
14 RB Linense RB Linense 38 36 41 35
15 UD Melilla UD Melilla 38 37 49 35
16 Granada Granada 38 40 47 32
17 Poli Almería Poli 38 37 59 28
18 Algeciras CF Algeciras 38 28 43 27
19 CF Lorca Deportiva Lorca 38 20 53 26
20 Nules Nules 38 32 66 23
Ver
TEMPORADA 1987/1988
Equipo PJ GF GC Puntos
1 UD Alzira UD Alzira 38 52 30 52
2 Villarreal Villarreal 38 60 38 48
3 Albacete Albacete 38 67 36 48
4 Olimpic Xátiva Olimpic 38 54 36 48
5 AgD Ceuta AgD Ceuta 38 51 26 46
6 Levante Levante 38 57 45 46
7 UD Melilla UD Melilla 38 39 31 40
8 CF Gandia CF Gandia 38 58 43 40
9 Atlético Marbella Atlético 38 34 30 40
10 Alcoyano Alcoyano 38 48 46 37
11 RB Linense RB Linense 38 39 42 37
12 CD Teruel CD Teruel 38 46 45 35
13 Eldense Eldense 38 44 54 33
14 Poli Almería Poli 38 37 53 32
15 CF Lorca Deportiva Lorca 38 29 39 32
16 Valencia Mestalla Valencia 38 37 53 31
17 CD Ronda CD Ronda 38 37 56 31
18 Benidorm Benidorm 38 27 42 31
19 UB Conquense Conquense 38 38 76 29
20 Cieza Cieza 38 31 64 24

JUGADORES DESTACADOS


  USO DE MEMORIA  
5,492,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0035
Controller Execution Time ( Home / Category )  0.2141
Total Execution Time  0.2177
  CADENA URL  
/segundab1989/grupo4/historico
  GET DATOS  
$_GET['/segundab1989/grupo4/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0018  SELECT type FROM routes WHERE alias = 'segundab1989'
0.0042  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segundab' AND (l.group_code = 4 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1989 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=4 DESC LIMIT 1
0.0052  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 3 AND group_code = 4 and tables = 1 AND year <= 1989 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0046  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 `tables1988` 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 = 22240 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 17:16:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 17:16:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 17:16:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0029  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 17:16:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segundab' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1989 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0419  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 events1989 e ON e.player_id = p.id AND e.league_id = 22243 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 22243 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.0647  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 events1989 e ON e.player_id = p.id AND e.league_id = 22243 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 22243 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0266  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 events1989 e ON e.player_id = p.id AND e.league_id = 22243 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 22243 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0057  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1989` 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 = 22243 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC