4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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,997,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4721
Total Execution Time  0.4739
  CADENA URL  
/division_honor_senior_andalucia2022/grupo1/historico
  GET DATOS  
$_GET['/division_honor_senior_andalucia2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0125  SELECT type FROM routes WHERE alias = 'division_honor_senior_andalucia2022'
0.0265  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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0130  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1896 ORDER BY order_id ASC
0.0137  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 = 63951 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1896 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0149  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.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 `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.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 `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.0154  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.0149  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 `tables2018` 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 = 39236 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 `tables2017` 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 = 34070 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-23 18:24:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-23 18:24:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-23 18:24:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-23 18:24:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0133  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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0379  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 events2022 e ON e.player_id = p.id AND e.league_id = 63951 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63951 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.0706  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 events2022 e ON e.player_id = p.id AND e.league_id = 63951 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63951 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0164  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 events2022 e ON e.player_id = p.id AND e.league_id = 63951 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63951 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138  SELECT *,(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