4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 PD Rociera PD Rociera 26 52 18 63
2 Lora CF Lora CF 26 46 29 47
3 Camas Camas 26 41 33 46
4 UD Morón UD Morón 26 43 30 45
5 Mairena Mairena 26 40 29 44
6 Villafranco Villafranco 26 42 34 41
7 UD Bellavista Bellavista 26 41 35 41
8 Ventippo Ventippo 26 41 32 39
9 CD Pedrera CD Pedrera 26 46 48 38
10 A. Cerro Águila Cerro 26 28 40 32
11 Estrella San Agustín Estrella 26 34 36 31
12 Dos Hermanas CF Hermanas 26 43 41 29
13 UD Rinconada Rinconada 26 30 39 29
14 La Barrera La Barrera 26 37 43 28
15 Osuna Bote Club Osuna Bote. 26 28 46 28
16 Paradas Balompié Paradas 26 43 47 26
17 Pilas Pilas 26 29 36 20
18 CD Coronil CD Coronil 26 20 68 13
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Cubillas FC Cubillas FC 34 78 25 81
2 Vandalia Vandalia 34 93 51 68
3 Churriana de la Vega Churriana 34 78 39 66
4 Águilas De Zujaira Águilas 34 58 37 60
5 Campotejar CF Campotejar 34 61 46 57
6 Salar CF Salar CF 34 49 44 56
7 Gabia Gabia 33 66 52 50
8 CF Sierra Nevada Cenes Sierra 34 50 50 49
9 Atl. La Zubia Atl. Zubia 33 48 50 43
10 CD Iznalloz CD Iznalloz 34 59 67 43
11 Puerto de Motril Puerto 34 58 65 42
12 CD Dúrcal CD Dúrcal 34 57 77 38
13 Pinos Puente Pinos Puente 34 44 75 37
14 Purullena CF Purullena 33 52 87 34
15 Huetor Tajar B Huetor Tajar 34 56 73 32
16 Estrellas Chana Estrellas 34 47 61 30
17 Atletico de Ogijares Atletico 33 36 59 30
18 CD UD Íllora Íllora 34 29 61 27
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Celtic Pulianas Celtic 34 96 34 80
2 Cubillas FC Cubillas FC 33 80 31 70
3 Salar CF Salar CF 34 71 39 70
4 Campotejar CF Campotejar 32 64 35 62
5 Vandalia Vandalia 34 75 51 55
6 Huetor Tajar B Huetor Tajar 33 71 46 54
7 CD Dúrcal CD Dúrcal 34 56 57 48
8 CD UD Íllora Íllora 34 58 59 46
9 Gabia Gabia 33 57 69 44
10 Puerto de Motril Puerto 32 64 57 42
11 Atletismo Padul Atletismo 33 58 59 41
12 Águilas De Zujaira Águilas 33 61 66 41
13 Purullena CF Purullena 33 68 70 39
14 Chauchina Chauchina 32 51 81 37
15 Cd Abes Cd Abes 26 55 73 27
16 Atl. La Zubia Atl. Zubia 33 42 79 23
17 Pd La Herradura Herradura 30 31 82 20
18 Valderrubio Fútbol 98 Valderrubio 33 32 102 18
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Churriana de la Vega Churriana 34 85 30 81
2 Vandalia Vandalia 34 76 34 74
3 Ciudad De Santa Fe Ciudad Santa 34 99 44 69
4 Campotejar CF Campotejar 34 74 40 68
5 Cubillas FC Cubillas FC 33 59 27 65
6 Celtic Pulianas Celtic 34 73 50 59
7 Huetor Tajar B Huetor Tajar 34 61 46 58
8 Gabia Gabia 34 65 70 46
9 Águilas De Zujaira Águilas 34 68 66 45
10 Pd La Herradura Herradura 34 54 60 45
11 Purullena CF Purullena 34 69 67 42
12 Cd Abes Cd Abes 34 97 107 41
13 Atl. La Zubia Atl. Zubia 32 62 78 39
14 Albolote CF Albolote CF 34 56 74 38
15 Atletismo Padul Atletismo 33 58 67 38
16 CF Sierra Nevada Cenes Sierra 34 52 82 28
17 Otura CF Otura CF 34 34 92 21
18 Alfacar UD Alfacar UD 34 21 129 0

  USO DE MEMORIA  
5,598,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0075
Controller Execution Time ( Home / Category )  0.1150
Total Execution Time  0.1225
  CADENA URL  
/andaluza2020/grupo8/historico
  GET DATOS  
$_GET['/andaluza2020/grupo8/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'andaluza' AND (l.group_code = 8 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=8 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 5 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1267671,1255959,1148089,1109642,1107691) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=5 ORDER BY order_id ASC
0.0020  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 = 51261 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 5 AND group_code = 8 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 51261 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 44627 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 39695 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 34595 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 14:45:40' 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-04-28 14:45:40' 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-04-28 14:45:40' 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-04-28 14:45:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0141  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 events2020 e ON e.player_id = p.id AND e.league_id = 51261 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51261 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.0173  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 events2020 e ON e.player_id = p.id AND e.league_id = 51261 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51261 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0043  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 events2020 e ON e.player_id = p.id AND e.league_id = 51261 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51261 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0047  SELECT *,(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 = 51261 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC