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

G9

Tercera División 1956 G 10

  • Levante
  • Alicante
  • CF Gandia
  • Alcoyano
  • CD Acero
  • UD Alzira
  • CD Burriana
  • Ontinyent CF
  • Peña Soriano
  • Albacete
  • Tercera División:
Ver
TEMPORADA 1955/1956
Equipo PJ GF GC Puntos
1 Levante Levante 18 43 17 28
2 Alicante Alicante 18 48 22 26
3 CF Gandia CF Gandia 18 27 24 19
4 Alcoyano Alcoyano 18 26 21 19
5 CD Acero CD Acero 18 30 29 18
6 UD Alzira UD Alzira 18 30 37 16
7 CD Burriana CD Burriana 18 23 33 15
8 Ontinyent CF Ontinyent 18 27 34 13
9 Peña Soriano Peña 18 22 45 13
10 Albacete Albacete 18 25 39 13
Ver
TEMPORADA 1954/1955
Equipo PJ GF GC Puntos
1 Alcoyano Alcoyano 18 41 19 26
2 Valencia Mestalla Valencia 18 47 24 23
3 CD Burriana CD Burriana 18 22 20 21
4 CF Gandia CF Gandia 18 39 41 20
5 Alicante Alicante 18 42 31 19
6 UD Alzira UD Alzira 18 40 36 18
7 Peña Soriano Peña 18 38 47 16
8 Albacete Albacete 18 40 42 15
9 Villena Villena 18 31 50 14
10 Catarroja CF Catarroja 18 19 49 8
Ver
TEMPORADA 1946/1947
Equipo PJ GF GC Puntos
1 Recreativo Recreativo 18 63 18 31
2 Real Jaén Real Jaén 18 55 18 28
3 CD Badajoz CD Badajoz 18 43 17 25
4 Coria CF Coria CF 18 42 19 25
5 Egabrense Egabrense 18 52 30 22
6 CD Electromecánica Electromecá 18 24 47 14
7 Mérida CP Mérida CP 18 28 65 10
8 Calavera Calavera 17 17 54 8
9 CD Linares CD Linares 17 18 48 6
10 Lucena Lucena 16 21 47 4
Ver
TEMPORADA 1945/1946
Equipo PJ GF GC Puntos
1 CD Málaga CD Málaga 18 54 18 27
2 Real Jaén Real Jaén 18 40 26 25
3 UD Melilla UD Melilla 18 43 37 23
4 Larache Larache 18 36 36 17
5 RB Linense RB Linense 18 33 40 16
6 Coria CF Coria CF 18 33 37 15
7 Recreativo Recreativo 18 38 42 15
8 Cádiz Cádiz 18 28 47 15
9 CD Linares CD Linares 18 28 37 14
10 Algeciras CF Algeciras 18 28 41 13

  USO DE MEMORIA  
4,985,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0654
Total Execution Time  0.0673
  CADENA URL  
/tercera1956/grupo10/historico
  GET DATOS  
$_GET['/tercera1956/grupo10/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'tercera1956'
0.0038  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 = 10 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1956 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=10 DESC LIMIT 1
0.0021  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 = 21468 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 4 AND group_code = 10 and tables = 1 AND year <= 1956 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0022  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 = 21468 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 21425 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 21358 AND t.round = 18 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 `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 = 21355 AND t.round = 18 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-03 04:37:10' 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-03 04:37:10' 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-03 04:37:10' 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-03 04:37:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  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 = 1956 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 events1956 e ON e.player_id = p.id AND e.league_id = 21468 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 21468 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 events1956 e ON e.player_id = p.id AND e.league_id = 21468 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 21468 AND (e.action = 4 or e.action = 5) 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 events1956 e ON e.player_id = p.id AND e.league_id = 21468 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 21468 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  SELECT *,(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 = 21468 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC