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 Club Atl. Central Club Atl. C. 25 59 31 58
2 CD Demo CD Demo 25 64 28 57
3 Nervión Nervión 25 53 27 52
4 CDF Herrera CDF Herrera 25 49 26 45
5 Montequinto CD Montequinto 25 34 32 41
6 Utrera B Utrera B 25 45 34 40
7 Montellano CD Montellano 25 30 33 39
8 Badolatosa CF Badolatosa 25 40 34 38
9 San Pablo Pino Montano Pablo Pino. 25 39 28 37
10 San Roque Balompié Roque 25 43 43 36
11 CD Diablos Rojos Diablos 25 37 36 33
12 Arahal Arahal 25 37 39 33
13 El Tinte de Utrera Tinte Utrera 25 41 62 29
14 CD San Marcos Marcos 25 34 49 23
15 Ecija CF Ecija CF 25 21 44 20
16 El Rubio El Rubio 25 22 45 19
17 Andalucia Este CF Andalucia 25 23 49 17
18 Triana CF Triana CF 25 25 56 17
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Ventippo Ventippo 34 72 31 79
2 At. Dos Hermanas Hermanas 34 68 30 72
3 CDF Herrera CDF Herrera 34 77 50 65
4 Utrera B Utrera B 34 59 43 61
5 Nervión Nervión 34 62 40 50
6 Badolatosa CF Badolatosa 34 73 65 50
7 Ecija CF Ecija CF 34 54 47 50
8 El Rubio El Rubio 34 55 55 48
9 Andalucia Este CF Andalucia 34 60 59 45
10 San Pablo Pino Montano Pablo Pino. 34 57 56 45
11 El Tinte de Utrera Tinte Utrera 34 56 67 45
12 Montellano CD Montellano 34 49 46 44
13 CD Diablos Rojos Diablos 34 41 41 44
14 Triana CF Triana CF 34 38 49 41
15 Ciudad Jardin Ciudad 34 42 62 41
16 Marchena Balompié Marchena 34 46 81 29
17 Calavera Calavera 34 39 67 27
18 UD Morón B UD Morón B 34 37 96 25
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Alcalá del Río CF Alcalá Río 34 49 17 74
2 Camino Viejo Camino Viejo 34 63 37 72
3 UD Rinconada Rinconada 34 80 51 67
4 At. Dos Hermanas Hermanas 34 83 48 59
5 Andalucia Este CF Andalucia 33 54 34 56
6 Puebla CF Puebla CF 34 87 50 55
7 Pilas Pilas 34 65 35 55
8 CD Albaida CD Albaida 33 64 55 55
9 Mosqueo Mosqueo 34 70 62 54
10 CDF Cazalla CDF Cazalla 34 73 54 52
11 UD Loreto UD Loreto 34 53 50 47
12 Atlético Sanlucar Atlético 33 57 70 44
13 Calavera Calavera 34 56 49 40
14 Atlético Libertad Atlético 34 54 89 33
15 UD Bellavista B Bellavista 34 38 75 26
16 Olivarense Olivarense 34 43 103 25
17 UD Soleá UD Soleá 34 42 84 16
18 Benacazón CF Benacazón 33 34 102 16
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 CD Coronil CD Coronil 34 78 36 74
2 UD Morón UD Morón 34 75 35 67
3 Mosqueo Mosqueo 34 78 48 63
4 C.D. Arahelense C.D. 34 72 50 62
5 Espartinas CF Espartinas 34 68 58 62
6 Marchena Balompié Marchena 34 71 54 51
7 Paradas Balompié Paradas 34 90 64 50
8 Atlético Sanlucar Atlético 34 66 68 49
9 Olivarense Olivarense 34 69 63 48
10 Atlético Libertad Atlético 33 65 60 47
11 Benacazón CF Benacazón 34 60 61 46
12 Triana CF Triana CF 34 63 74 41
13 AD. Carmona AD. Carmona 34 47 69 37
14 Camino Viejo Camino Viejo 33 51 75 37
15 Huévar C.F. Huévar C.F. 34 45 82 32
16 Montellano CD Montellano 34 42 68 29
17 Círculo Don Bosco Círculo 34 49 78 29
18 Pilas Atlético Pilas 32 25 71 26

  USO DE MEMORIA  
5,429,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3698
Total Execution Time  0.3717
  CADENA URL  
/segunda_andaluza_sevilla2020/grupo2/historico
  GET DATOS  
$_GET['/segunda_andaluza_sevilla2020/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0125  SELECT type FROM routes WHERE alias = 'segunda_andaluza_sevilla2020'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_andaluza_sevilla' AND (l.group_code = 2 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=2 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=277 AND type_rel = 3
0.0131  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 277 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0132  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 (986815,818727,685220,55701) ORDER BY n.cover_points DESC, update_date DESC
0.0136  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 = 51360 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 277 AND group_code = 2 and tables = 1 AND year <= 2020 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 `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 = 51360 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.0135  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 = 44924 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 39685 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 `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 = 34431 AND t.round = 34 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-05-01 08:18:27' 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=2 AND last_update > '2024-05-01 08:18:27' 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=4 AND last_update > '2024-05-01 08:18:27' 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-05-01 08:18:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_andaluza_sevilla' AND (l.group_code = 0 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=0 DESC LIMIT 1
0.0128  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 = 51360 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51360 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.0127  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 = 51360 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51360 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  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 = 51360 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51360 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0140  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 = 51360 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