4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1989/1990
Equipo PJ GF GC Puntos
1 Albacete Albacete 38 88 29 60
2 UD Melilla UD Melilla 38 48 19 55
3 Sevilla At. Sevilla At. 38 53 31 49
4 AgD Ceuta AgD Ceuta 38 56 41 46
5 Granada Granada 38 58 36 46
6 CD Badajoz CD Badajoz 38 34 23 45
7 Linares CF Linares CF 38 57 34 44
8 Mérida CP Mérida CP 38 43 40 40
9 Marino Marino 38 43 49 38
10 At. Sanluqueño Sanluqueño 38 32 44 38
11 Tomelloso Tomelloso 38 49 41 38
12 Córdoba CF Córdoba CF 38 38 39 38
13 Telde Telde 38 31 50 34
14 RB Linense RB Linense 38 38 43 32
15 Estepona Estepona 38 34 51 31
16 Real Jaén Real Jaén 38 42 47 31
17 Atlético Marbella Atlético 38 30 38 31
18 Utrera Utrera 38 24 35 30
19 Maspalomas Maspalomas 38 38 63 23
20 Tenerife B Tenerife B 38 21 104 11
Ver
TEMPORADA 1988/1989
Equipo PJ GF GC Puntos
1 Atlético B Atlético B 38 78 40 52
2 Sevilla At. Sevilla At. 38 53 31 51
3 Linares CF Linares CF 38 46 25 51
4 CD Badajoz CD Badajoz 38 60 33 49
5 Tomelloso Tomelloso 38 53 36 46
6 Getafe Getafe 38 52 36 43
7 RSD Alcalá RSD Alcalá 38 42 45 41
8 Leganés Leganés 38 36 37 39
9 Galáctico Pegaso Galáctico 38 47 49 38
10 Real Jaén Real Jaén 38 43 48 37
11 Córdoba CF Córdoba CF 38 36 39 35
12 Real Ávila Real Ávila 38 39 42 35
13 Marino Marino 37 44 45 35
14 Maspalomas Maspalomas 38 39 47 34
15 Telde Telde 38 51 55 32
16 UD Sanse UD Sanse 38 28 43 32
17 Plasencia Plasencia 38 28 32 32
18 Betis Deportivo Betis 38 54 67 29
19 CD Don Benito Benito 38 30 59 28
20 Gimnástica Medinense Gimnástica 37 29 79 19
Ver
TEMPORADA 1987/1988
Equipo PJ GF GC Puntos
1 UD Salamanca Salamanca 38 60 20 57
2 CD Badajoz CD Badajoz 38 50 36 49
3 Getafe Getafe 38 71 41 47
4 Maspalomas Maspalomas 38 46 32 45
5 Córdoba CF Córdoba CF 38 47 37 43
6 Linares CF Linares CF 38 74 45 42
7 Leganés Leganés 38 54 39 42
8 Real Ávila Real Ávila 38 58 38 42
9 RSD Alcalá RSD Alcalá 38 45 47 42
10 Telde Telde 38 54 50 41
11 Atlético B Atlético B 38 51 37 39
12 Sevilla At. Sevilla At. 38 38 38 36
13 UD Sanse UD Sanse 38 33 42 35
14 Betis Deportivo Betis 38 55 43 34
15 At. Sanluqueño Sanluqueño 38 44 49 34
16 Plasencia Plasencia 38 38 43 33
17 Las Palmas At. Palmas 38 32 49 33
18 AD Parla AD Parla 38 29 70 28
19 CP Cacereño Cacereño 38 29 53 27
20 Daimiel Daimiel 38 19 118 11

JUGADORES DESTACADOS


  USO DE MEMORIA  
5,644,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.1515
Total Execution Time  0.1539
  CADENA URL  
/segundab1990/grupo3/historico
  GET DATOS  
$_GET['/segundab1990/grupo3/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0020  SELECT type FROM routes WHERE alias = 'segundab1990'
0.0048  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 = 3 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1990 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=3 DESC LIMIT 1
0.0039  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=3 ORDER BY l.group_code ASC
0.0022  SELECT id,name,alias,stepParent FROM categories WHERE parentId=3 ORDER BY order_id ASC
0.0025  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 = 22245 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 3 AND group_code = 3 and tables = 1 AND year <= 1990 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0029  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 `tables1990` 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 = 22245 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `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 = 22242 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 22239 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-10 04:42:26' 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-05-10 04:42:26' 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-05-10 04:42:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-10 04:42:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0028  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 = 1990 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0334  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 events1990 e ON e.player_id = p.id AND e.league_id = 22245 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 22245 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.0244  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 events1990 e ON e.player_id = p.id AND e.league_id = 22245 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 22245 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0134  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 events1990 e ON e.player_id = p.id AND e.league_id = 22245 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 22245 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0048  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1990` 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 = 22245 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC