4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1958
Temporada Siguiente »
Tercera División 1958 G 8
1957/1958

G8

Tercera División 1958 G 8

  • Mallorca
  • Atlético Baleares
  • Constància
  • Manacor
  • Atlètic De Ciutadella
  • UE Porreres
  • CD España
  • UD Mahón
  • Felanitx
  • CD Menorca
  • CE Alaior
  • UD Alaró
  • Murense
  • Soller
  • Soledad
  • Poblense
  • Binissalem
  • Tercera División:
Ver
TEMPORADA 1957/1958
Equipo PJ GF GC Puntos
1 Mallorca Mallorca 32 99 34 55
2 Atlético Baleares Atlético 32 93 26 49
3 Constància Constància 32 86 30 48
4 Manacor Manacor 32 75 47 40
5 Atlètic De Ciutadella Atlètic 32 53 64 33
6 UE Porreres UE Porreres 32 54 46 31
7 CD España CD España 32 66 55 31
8 UD Mahón UD Mahón 32 68 61 31
9 Felanitx Felanitx 32 44 52 29
10 CD Menorca CD Menorca 32 58 64 29
11 CE Alaior CE Alaior 32 50 68 28
12 UD Alaró UD Alaró 32 56 80 28
13 Murense Murense 32 40 82 26
14 Soller Soller 32 54 73 25
15 Soledad Soledad 32 45 73 22
16 Poblense Poblense 32 44 72 22
17 Binissalem Binissalem 32 52 110 17
Ver
TEMPORADA 1956/1957
Equipo PJ GF GC Puntos
1 Mallorca Mallorca 34 120 27 57
2 Atlético Baleares Atlético 34 88 42 46
3 Manacor Manacor 34 76 50 46
4 Felanitx Felanitx 34 95 41 44
5 Constància Constància 34 83 74 40
6 Binissalem Binissalem 34 66 69 36
7 Soledad Soledad 34 66 62 35
8 UD Mahón UD Mahón 33 74 61 35
9 Atlètic De Ciutadella Atlètic 34 72 71 35
10 CD España CD España 34 74 56 35
11 Poblense Poblense 34 58 67 33
12 CE Alaior CE Alaior 34 74 87 31
13 Murense Murense 34 60 89 30
14 Santanyi Santanyi 33 53 85 24
15 Soller Soller 34 61 95 24
16 UD Alaró UD Alaró 34 47 74 23
17 UE Porreres UE Porreres 34 44 106 20
18 CD Menorca CD Menorca 34 40 95 16
Ver
TEMPORADA 1955/1956
Equipo PJ GF GC Puntos
1 Atlético Baleares Atlético 18 57 34 27
2 Mallorca Mallorca 18 50 31 25
3 Poblense Poblense 18 43 40 19
4 Manacor Manacor 18 33 32 18
5 CD España CD España 18 34 32 18
6 Soledad Soledad 18 29 39 16
7 Constància Constància 18 35 43 15
8 Binissalem Binissalem 18 28 39 15
9 Santanyi Santanyi 18 24 38 14
10 UE Porreres UE Porreres 18 30 35 13
Ver
TEMPORADA 1954/1955
Equipo PJ GF GC Puntos
1 Mallorca Mallorca 14 35 20 20
2 Constància Constància 14 30 18 19
3 Manacor Manacor 14 27 18 18
4 Poblense Poblense 14 22 23 15
5 Atlético Baleares Atlético 14 33 25 14
6 Binissalem Binissalem 14 22 31 12
7 UE Porreres UE Porreres 14 27 36 10
8 Santanyi Santanyi 14 25 50 4
Ver
TEMPORADA 1947/1948
Equipo PJ GF GC Puntos
1 UD Melilla UD Melilla 26 58 29 40
2 Recreativo Recreativo 26 84 36 35
3 RB Linense RB Linense 26 70 38 35
4 SD Ceuta SD Ceuta 26 64 55 29
5 Cádiz Cádiz 26 48 47 28
6 Iliturgi CF Iliturgi CF 26 68 56 26
7 Larache Larache 26 51 55 26
8 Tetuán Tetuán 26 60 58 25
9 Algeciras CF Algeciras 26 75 64 24
10 CD Electromecánica Electromecá 26 55 73 24
11 CD San Fernando Fernando 26 48 66 23
12 Coria CF Coria CF 26 36 56 19
13 Antequera CF Antequera 26 38 59 19
14 Calavera Calavera 26 30 93 11
Ver
TEMPORADA 1946/1947
Equipo PJ GF GC Puntos
1 Albacete Albacete 18 68 26 27
2 Tomelloso Tomelloso 18 44 30 25
3 CD Toledo CD Toledo 18 43 23 23
4 AD Ferroviaria Ferroviaria 18 50 39 19
5 AD Plus Ultra Plus Ultra 18 43 31 19
6 Mediodía Mediodía 18 28 33 18
7 CD Manchego CD Manchego 18 37 57 15
8 Gimnástico de Alcázar Gimnástico 18 25 50 14
9 UB Conquense Conquense 18 25 52 11
10 Imperio Madrid Imperio 18 15 37 9
Ver
TEMPORADA 1945/1946
Equipo PJ GF GC Puntos
1 Real Valladolid Real 18 41 22 27
2 Imperio Madrid Imperio 18 55 33 24
3 Cultural Leonesa Cultural 18 40 25 22
4 Fábrica Nacional Fábrica 18 37 30 19
5 AD Ferroviaria Ferroviaria 18 35 35 17
6 Real Ávila Real Ávila 18 32 41 16
7 Burgos Burgos 18 44 37 15
8 CA Zamora CA Zamora 18 31 48 14
9 Béjar Industrial Béjar 18 28 51 14
10 Gimnástica Segoviana Gimnástica 18 31 52 12
Ver
TEMPORADA 1944/1945
Equipo PJ GF GC Puntos
1 Elche Elche 18 64 30 26
2 CD Almansa CD Almansa 18 31 16 26
3 Albacete Albacete 18 35 19 22
4 Real Murcia Imperial Real Murcia 18 51 28 21
5 Cieza Cieza 18 39 45 21
6 Eldense Eldense 18 57 40 20
7 Cartagena CF Cartagena 18 29 33 16
8 Alicante Alicante 18 24 48 11
9 Crevillente Deportivo Crevillente 18 28 56 11
10 Gimnástica Abad Gimnástica 18 19 62 6
Ver
TEMPORADA 1943/1944
Equipo PJ GF GC Puntos
1 Elche Elche 18 59 12 32
2 Albacete Albacete 18 45 24 24
3 Eldense Eldense 18 44 25 24
4 Alicante Alicante 18 38 23 21
5 Cartagena CF Cartagena 18 37 34 19
6 Crevillente Deportivo Crevillente 18 38 31 17
7 Cieza Cieza 18 27 48 14
8 CD Almansa CD Almansa 18 30 33 13
9 Real Murcia Imperial Real Murcia 18 27 50 11
10 Lorca CF Lorca CF 18 9 74 5
Ver
TEMPORADA 1940/1941
Equipo PJ GF GC Puntos
1 Constància Constància 4 9 6 5
2 SD Ceuta SD Ceuta 4 7 11 4
3 Elche Elche 4 9 8 3
Ver
TEMPORADA 1933/1934
Equipo PJ GF GC Puntos
1 Granada Granada 4 9 6 6
2 Jerez FC Jerez FC 4 7 8 4
3 CD Málaga CD Málaga 4 6 8 2
Ver
TEMPORADA 1932/1933
Equipo PJ GF GC Puntos
1 At. Malagueño Malagueño 4 6 2 5
2 RCD Córdoba Córdoba 4 8 7 5
3 CD Málaga CD Málaga 4 4 9 2
Ver
TEMPORADA 1929/1930
Equipo PJ GF GC Puntos
1 Recreativo Recreativo 4 16 8 6
2 At. Malagueño Malagueño 4 8 6 6
3 CD Don Benito Benito 0 0 0 0
4 Real Málaga Real Málaga 4 4 14 0

  USO DE MEMORIA  
5,931,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  0.4901
Total Execution Time  0.4931
  CADENA URL  
/tercera1958/grupo8/historico
  GET DATOS  
$_GET['/tercera1958/grupo8/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0125  SELECT type FROM routes WHERE alias = 'tercera1958'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera' AND (l.group_code = 8 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1958 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=8 DESC LIMIT 1
0.0128  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 = 21453 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0140  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 4 AND group_code = 8 and tables = 1 AND year <= 1958 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0131  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 `tables1958` 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 = 21453 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables1957` 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 = 21484 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 `tables1956` 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 = 21466 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 `tables1955` 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 = 21423 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 `tables1948` 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 = 21367 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 `tables1947` 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 = 21360 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 `tables1946` 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 = 21353 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables1945` 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 = 21345 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables1944` 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 = 21327 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 `tables1941` 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 = 21271 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 `tables1934` 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 = 23081 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 `tables1933` 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 = 21247 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables1930` 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 = 21237 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 16:55:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 16:55:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 16:55:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 16:55:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1958 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0136  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 events1958 e ON e.player_id = p.id AND e.league_id = 21453 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 21453 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.0135  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 events1958 e ON e.player_id = p.id AND e.league_id = 21453 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 21453 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 events1958 e ON e.player_id = p.id AND e.league_id = 21453 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 21453 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0191  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1958` 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 = 21453 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC