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 Brenes Balompié Brenes 25 48 27 51
2 C.D. Los Caminantes C.D. 25 45 26 51
3 Campana Balompié Campana 25 42 29 46
4 Guadalcanal C.D Guadalcanal 25 44 30 42
5 Deportivo Oduciarosal Deportivo 25 30 21 42
6 CD Valencina Valencina 25 35 25 41
7 Minas CF Minas CF 25 42 32 40
8 Atletico Algabeño Atletico 24 35 23 39
9 Liceo C.D.C. Alanis Liceo C.D.C. 24 42 37 38
10 Torre Reina CD Torre Reina 25 28 27 38
11 Calavera Calavera 25 38 36 36
12 Gelves C.D Gelves C.D 25 38 36 35
13 Priorato Juventud Priorato 25 29 45 26
14 AD. Carmona AD. Carmona 25 25 39 24
15 Atletico Viso Atletico 25 25 34 22
16 AD San José José 25 26 40 22
17 Union de los Morales Union 25 25 57 18
18 Montequinto MV8 Montequinto 25 18 51 9
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Constantina UD Constantina 31 79 14 72
2 Guillena Cf Guillena Cf 31 92 30 70
3 Olivarense Olivarense 32 90 50 69
4 Brenes Balompié Brenes 32 71 41 59
5 Salteras Salteras 31 91 55 56
6 Gelves C.D Gelves C.D 32 70 58 51
7 Alcolea del Río F.C. Alcolea Río 29 70 61 46
8 Priorato Juventud Priorato 32 48 49 45
9 Guadalcanal C.D Guadalcanal 32 75 73 42
10 Celti Puebla Celti Puebla 32 75 81 41
11 Huévar C.F. Huévar C.F. 32 54 62 40
12 Torre Reina CD Torre Reina 32 40 54 38
13 San Martin C.D. Martin C.D. 31 45 61 37
14 Liceo C.D.C. Alanis Liceo C.D.C. 31 57 83 31
15 Benacazón CF Benacazón 32 50 87 27
16 Real CD Real CD 31 51 105 21
17 Cantillana Cantillana 31 36 130 9
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 CD Peñaflor Peñaflor 28 81 24 65
2 Villanueva Atlético Villanueva 29 73 30 59
3 Aznalcollar C.D Aznalcollar 29 50 25 57
4 Constantina UD Constantina 28 61 38 52
5 Guadalcanal C.D Guadalcanal 29 51 40 47
6 Alcolea del Río F.C. Alcolea Río 28 60 55 46
7 Brenes Balompié Brenes 28 49 44 43
8 Priorato Juventud Priorato 28 34 27 40
9 Liceo C.D.C. Alanis Liceo C.D.C. 28 39 42 40
10 Almensilla CD Almensilla 29 43 52 33
11 Salteras Salteras 29 45 67 32
12 San Martin C.D. Martin C.D. 28 38 54 30
13 Navas de la Concepción Navas 28 37 76 25
14 Cantillana Cantillana 29 29 63 22
15 Torre Reina CD Torre Reina 27 24 61 17
16 Minas CF Minas CF 9 14 30 5
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Calavera Calavera 32 86 34 71
2 CD Albaida CD Albaida 33 81 28 69
3 UD Bellavista B Bellavista 33 82 43 68
4 Guillena Cf Guillena Cf 33 80 41 65
5 CD Peñaflor Peñaflor 32 82 38 64
6 Aznalcollar C.D Aznalcollar 32 70 43 60
7 Pino Montano Pino Montano 33 69 66 44
8 Constantina UD Constantina 32 61 56 43
9 Cantillana Cantillana 33 48 63 41
10 Guadalcanal C.D Guadalcanal 32 62 70 40
11 Liceo C.D.C. Alanis Liceo C.D.C. 33 57 67 40
12 Alcolea del Río F.C. Alcolea Río 32 54 74 40
13 Priorato Juventud Priorato 32 48 48 39
14 Minas CF Minas CF 33 35 65 34
15 Castillo C.F. Castillo 32 55 115 27
16 Navas de la Concepción Navas 33 51 105 24
17 Santiponce Santiponce 32 45 84 19
18 C.D. de el Pedroso C.D. Pedroso 12 15 41 7
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 UD Bellavista Bellavista 32 76 33 67
2 C.D. Arahelense C.D. 33 65 39 61
3 Triana CF Triana CF 33 58 38 60
4 CDF Herrera CDF Herrera 33 66 37 59
5 Marchena Balompié Marchena 33 57 37 57
6 CD Antonio Puerta B Antonio 34 80 68 54
7 La Jara La Jara 33 63 57 53
8 El Rubio El Rubio 34 52 41 52
9 San Jeronimo Jeronimo 33 56 45 51
10 Campana Balompié Campana 32 56 46 49
11 Andalucia Este CF Andalucia 31 51 44 43
12 CD Demo CD Demo 34 48 64 40
13 Montellano CD Montellano 32 33 57 34
14 Círculo Don Bosco Círculo 33 36 62 32
15 Atletico Viso Atletico 34 40 59 28
16 An Andalis An Andalis 21 32 47 27
17 Los Corrales Corrales 30 40 74 27
18 Su Eminencia Eminencia 31 27 88 14
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 CD Diablos Rojos Diablos 30 68 26 59
2 Ciudad Jardin Ciudad 30 63 32 59
3 Gilena C.F. Gilena C.F. 30 66 37 58
4 Montellano CD Montellano 30 51 38 55
5 CDF Herrera CDF Herrera 30 57 41 52
6 Andalucia Este CF Andalucia 30 58 37 48
7 La Jara La Jara 30 58 48 47
8 San Jeronimo Jeronimo 30 49 45 46
9 Campana Balompié Campana 30 57 49 44
10 Marchena Balompié Marchena 30 43 39 43
11 Los Corrales Corrales 30 52 48 41
12 Su Eminencia Eminencia 30 43 41 38
13 Círculo Don Bosco Círculo 30 59 64 34
14 Pino Montano Pino Montano 30 34 53 33
15 CD Demo CD Demo 30 37 56 31
16 Calavera Calavera 30 33 63 21
17 Ventippo Ventippo 30 38 86 20
18 Fuente del Rey Fuente 30 21 84 13
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Campana Balompié Campana 28 73 28 62
2 Alcalá del Río CF Alcalá Río 28 70 36 59
3 CDF Cazalla CDF Cazalla 28 70 26 57
4 Salteras Salteras 28 91 39 57
5 Guadajoz C.F. Guadajoz 28 64 59 49
6 Guadalcanal C.D Guadalcanal 28 51 48 45
7 Constantina UD Constantina 28 52 43 43
8 C.D. de el Pedroso C.D. Pedroso 28 61 49 43
9 Priorato Juventud Priorato 28 40 36 36
10 Valencina Juv.Dva. Valencina 28 45 43 36
11 Alcolea del Río F.C. Alcolea Río 28 40 59 34
12 Carmonense Carmonense 28 36 67 22
13 Liceo C.D.C. Alanis Liceo C.D.C. 28 34 72 22
14 Castilblanco Castilblanco 28 25 90 13
15 An Andalis An Andalis 28 36 93 12
16 El Ronquillo CF Ronquillo 0 0 0 0
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Adp Sevilla Este Sevilla Este 30 63 43 63
2 Salteras Salteras 30 86 45 60
3 Cantillana Cantillana 30 65 42 56
4 Pino Montano Pino Montano 30 53 37 53
5 Aznalcollar C.D Aznalcollar 30 54 41 50
6 Campana Balompié Campana 30 60 46 49
7 Guadajoz C.F. Guadajoz 30 60 51 48
8 CDF Cazalla CDF Cazalla 30 44 43 41
9 Recreativo Alcosa CD Recreativo 30 53 61 39
10 Priorato Juventud Priorato 30 45 60 39
11 C.D.Santiponce C.D.Santipon 30 44 57 33
12 Alcolea del Río F.C. Alcolea Río 30 46 64 33
13 Murcia Féminas Murcia 30 31 43 32
14 Valencina Juv.Dva. Valencina 30 41 54 31
15 Constantina UD Constantina 30 47 63 31
16 C.D. de el Pedroso C.D. Pedroso 30 38 80 12
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 El Palmar Vereda Real Palmar 29 81 39 64
2 Racing Los Molares Racing 29 76 36 63
3 San Antonio Drago Antonio 29 86 42 58
4 CD Demo CD Demo 29 67 38 57
5 An Andalis An Andalis 29 49 50 46
6 JD Bormujos JD Bormujos 29 65 45 45
7 Pino Montano Pino Montano 29 52 53 45
8 Lepanto Atco Lepanto Atco 29 60 57 40
9 El Trobal UD Trobal 29 55 56 40
10 Pinzón CD Pinzón CD 29 54 72 36
11 Fuente del Rey Fuente 29 51 65 35
12 Gelves C.D Gelves C.D 29 44 57 32
13 Mairena Aljarafe B Mairena 29 48 78 27
14 Claret C.F. Claret C.F. 29 51 71 25
15 Salteras Salteras 15 24 43 13
16 Espartinas CF Espartinas 29 29 90 10
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 JD Bormujos JD Bormujos 32 91 47 70
2 Montequinto CD Montequinto 32 65 34 70
3 San Gines San Gines 32 51 28 68
4 CS San Antonio Antonio 32 85 37 62
5 UD Dos Hermanas Hermanas 32 88 59 58
6 Pinzón CD Pinzón CD 32 65 59 51
7 El Tinte de Utrera Tinte Utrera 32 73 48 50
8 Almensilla CD Almensilla 32 55 60 49
9 LA Buhaira CF Buhaira 32 59 60 42
10 Espartinas CF Espartinas 32 69 90 42
11 Círculo Don Bosco Círculo 32 57 64 40
12 El Trobal UD Trobal 32 50 70 40
13 CD Mota Del Cuervo Mota Cuervo 32 48 60 36
14 UD Bellavista B Bellavista 32 58 65 34
15 Mairena Aljarafe B Mairena 32 58 81 28
16 Pilas Pilas 32 39 70 27
17 Olivarense Olivarense 32 24 103 8

  USO DE MEMORIA  
6,232,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5129
Total Execution Time  0.5148
  CADENA URL  
/tercera_andaluza_sevilla2020/grupo2/historico
  GET DATOS  
$_GET['/tercera_andaluza_sevilla2020/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0144  SELECT type FROM routes WHERE alias = 'tercera_andaluza_sevilla2020'
0.0302  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_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.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=425 AND type_rel = 3
0.0158  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 425 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0161  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 (1173167,1070077,1068434,948472,75761) ORDER BY n.cover_points DESC, update_date DESC
0.0159  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 = 51519 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 425 AND group_code = 2 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0152  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 = 51519 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.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 `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 = 45327 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 39834 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170  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 `tables2016` 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 = 16851 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170  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 `tables2015` 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 = 4111 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 `tables2014` 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 = 3343 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0175  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 `tables2013` 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 = 3007 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 `tables2012` 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 = 3006 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables2011` 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 = 3005 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 16:18:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-03 16:18:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 16:18:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-03 16:18:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_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.0146  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 = 51519 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51519 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.0145  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 = 51519 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51519 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0147  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 = 51519 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51519 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  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 = 51519 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