Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 La Palma CF La Palma CF 30 52 25 62
2 Cabecense Cabecense 30 45 23 54
3 UD Tomares UD Tomares 30 59 38 53
4 Chiclana CF Chiclana CF 30 40 25 52
5 Villafranco Villafranco 30 36 28 52
6 UD Algaida UD Algaida 30 43 30 47
7 Castilleja Castilleja 30 36 30 44
8 Los Barrios Los Barrios 30 27 26 43
9 Lebrijana Lebrijana 30 26 21 36
10 Viso UP Viso UP 30 34 35 35
11 Club Atl. Central Club Atl. C. 30 24 34 35
12 Montilla Montilla 30 21 30 34
13 Palma del Rio Atletico CF Palma 30 23 48 30
14 Arcos CF Arcos CF 30 32 54 26
15 Moguer CD Moguer CD 30 22 53 22
16 Egabrense Egabrense 30 31 51 21
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Coria CF Coria CF 38 57 21 75
2 Ayamonte Ayamonte 38 57 31 74
3 Bollullos CF Bollullos 38 50 39 69
4 Atlético Espeleño Atlético 38 56 35 67
5 Montilla Montilla 38 40 32 66
6 Castilleja Castilleja 38 62 40 60
7 Viso UP Viso UP 38 46 40 58
8 Arcos CF Arcos CF 38 51 36 58
9 La Palma CF La Palma CF 38 56 41 53
10 Club Atl. Central Club Atl. C. 38 45 55 52
11 Chiclana CF Chiclana CF 38 35 30 52
12 Egabrense Egabrense 38 41 57 50
13 Lebrijana Lebrijana 38 42 51 49
14 Torreblanca CF Torreblanca 38 35 45 47
15 CD Guadalcacín Guadalcacín 38 42 50 44
16 PD Rociera PD Rociera 38 49 67 44
17 CD Alcalá CD Alcalá 38 50 56 42
18 Jerez Industrial CF Jerez 38 31 48 37
19 Atlético Onubense Atlético 38 34 70 25
20 Atlético Algabeño Atlético 38 41 76 23
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 AD Cartaya AD Cartaya 18 37 20 37
2 Montilla Montilla 18 32 22 35
3 Atlético Espeleño Atlético 18 30 19 34
4 Viso UP Viso UP 18 25 29 26
5 Bollullos CF Bollullos 18 25 16 26
6 Atlético Onubense Atlético 18 30 24 24
7 Aroche CF Aroche CF 18 23 24 21
8 Isla Cristina Isla 18 21 27 21
9 Ciudad Jardin CD Ciudad 18 18 31 17
10 Écija Balompié Écija 18 17 46 7
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Castilleja Castilleja 25 44 23 52
2 Cabecense Cabecense 25 49 26 46
3 La Palma CF La Palma CF 25 41 29 45
4 Atlético Onubense Atlético 25 35 21 40
5 Chiclana CF Chiclana CF 25 35 34 40
6 Atlético Espeleño Atlético 25 43 30 39
7 UD Tomares UD Tomares 25 39 33 36
8 CD San Roque Roque 25 33 25 35
9 AD Cartaya AD Cartaya 25 28 21 35
10 Torreblanca CF Torreblanca 25 27 26 34
11 Viso UP Viso UP 25 30 31 30
12 CD Guadalcacín Guadalcacín 25 26 27 30
13 AD San José José 25 41 43 30
14 Aroche CF Aroche CF 25 21 35 30
15 Isla Cristina Isla 25 22 35 28
16 CD Alcalá CD Alcalá 25 27 41 25
17 Atlético Algabeño Atlético 25 30 52 20
18 Ciudad Jardin CD Ciudad 25 26 65 18
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Atlético Antoniano Atlético 34 62 34 66
2 CD Rota CD Rota 34 62 39 66
3 CD Pozoblanco Pozoblanco 34 56 32 65
4 Viso UP Viso UP 34 52 35 59
5 Atlético Onubense Atlético 34 46 29 58
6 Atlético Algabeño Atlético 34 61 45 58
7 Castilleja Castilleja 34 69 46 57
8 AD Cartaya AD Cartaya 34 44 32 55
9 CD Alcalá CD Alcalá 34 52 42 52
10 La Palma CF La Palma CF 34 56 64 43
11 Torreblanca CF Torreblanca 34 29 46 39
12 AD San José José 34 49 62 39
13 CD San Roque Roque 34 41 52 39
14 Isla Cristina Isla 34 41 51 35
15 Peñarroya Pueblonuevo Peñarroya 34 28 53 31
16 Ol. Valverdeña Valverdeña 34 41 60 31
17 Pinzón CD Pinzón CD 34 25 57 27
18 Roteña Roteña 34 28 63 21
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Xerez Deportivo Xerez 34 58 18 72
2 Coria CF Coria CF 34 56 33 65
3 Conil Conil 34 51 30 62
4 Viso UP Viso UP 34 50 33 53
5 Atlético Antoniano Atlético 34 37 42 50
6 CD Pozoblanco Pozoblanco 34 41 44 49
7 Ol. Valverdeña Valverdeña 34 39 46 48
8 CD San Roque Roque 34 46 49 47
9 AD San José José 34 47 37 45
10 Isla Cristina Isla 34 43 55 44
11 CD Rota CD Rota 34 50 58 44
12 La Palma CF La Palma CF 34 53 58 44
13 Atlético Algabeño Atlético 34 38 43 44
14 AD Cartaya AD Cartaya 34 40 30 43
15 Montilla Montilla 34 42 53 34
16 Chiclana Industrial Chiclana 34 35 45 33
17 Estrella San Agustín Estrella 34 33 52 32
18 Ciudad Jardin CD Ciudad 34 26 59 27
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Cádiz CF Mirandilla Cádiz 38 83 28 82
2 Salerm Puente Genil Salerm 38 72 36 73
3 Xerez CD Xerez CD 38 74 37 72
4 Ciudad de Lucena Ciudad 38 60 39 71
5 Estrella San Agustín Estrella 38 59 46 68
6 Xerez Deportivo Xerez 38 65 43 63
7 Conil Conil 38 65 47 60
8 CD Pozoblanco Pozoblanco 38 39 36 58
9 La Palma CF La Palma CF 38 73 58 57
10 Viso UP Viso UP 38 47 38 54
11 AD Cartaya AD Cartaya 38 49 48 54
12 AD San José José 38 57 45 53
13 Ol. Valverdeña Valverdeña 38 55 74 45
14 CD Rota CD Rota 38 58 85 44
15 Chiclana CF Chiclana CF 38 46 62 42
16 Roteña Roteña 38 48 66 41
17 Lora CF Lora CF 38 48 71 39
18 San Juan San Juan 38 58 78 38
19 Pinzón CD Pinzón CD 38 45 71 28
20 Almodóvar del Río Almodóvar 38 25 118 13

  USO DE MEMORIA  
5,969,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4164
Total Execution Time  0.4184
  CADENA URL  
/division_honor_senior_andalucia2023/grupo1/historico
  GET DATOS  
$_GET['/division_honor_senior_andalucia2023/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0105  SELECT type FROM routes WHERE alias = 'division_honor_senior_andalucia2023'
0.0216  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'division_honor_senior_andalucia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0107  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 = 68671 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1896 AND group_code = 1 and tables = 1 AND year <= 2023 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0114  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 `tables2023` 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 = 68671 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0121  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 `tables2022` 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 = 63951 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0121  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 `tables2021` 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 = 58969 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  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 `tables2020` 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 = 51038 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 `tables2019` 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 = 44941 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 23:29:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 23:29:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 23:29:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0113  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 23:29:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0122  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'division_honor_senior_andalucia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0496  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 events2023 e ON e.player_id = p.id AND e.league_id = 68671 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 68671 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.0771  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 events2023 e ON e.player_id = p.id AND e.league_id = 68671 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 68671 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0122  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 events2023 e ON e.player_id = p.id AND e.league_id = 68671 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 68671 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0116  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 68671 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC