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 Olímpico C.F. B Olímpico 18 33 17 36
2 CD Obrero CD Obrero 17 31 15 35
3 Suevos CF Suevos CF 19 36 25 33
4 Once Caballeros Once 18 27 16 33
5 Marino CF Marino CF 18 42 34 32
6 Sporting Burgo Sporting 18 29 27 32
7 C.D. Larín C.D. Larín 18 45 40 27
8 Portazgo S.D. Portazgo 18 30 28 23
9 Hercules SD Hercules SD 17 28 35 21
10 Mercurio Mercurio 16 17 28 15
11 Union Campestre Union 18 36 41 14
12 Bribes CF Bribes CF 18 20 34 13
13 Pastoriza SCD Pastoriza 17 16 50 7
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Xuventude de Crendes Xuventude 24 87 24 59
2 Mesia CD Mesia CD 24 66 27 53
3 Curtis CCD Curtis CCD 24 78 34 52
4 Ordenes B Ordenes B 24 47 38 46
5 X Aranga X Aranga 24 60 39 42
6 Ponte Carreira Ponte 24 49 45 40
7 Sobrado Xuventude Sobrado 24 45 59 35
8 Teixeiro Teixeiro 24 43 40 29
9 Vila de Ordes Vila Ordes 24 50 51 29
10 Sporting Meicende B Sporting 24 36 55 25
11 Visantoña CF. B Visantoña 24 22 74 17
12 Mercurio Mercurio 24 30 68 15
13 Abella B Abella B 24 24 83 8
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 CD Obrero CD Obrero 25 92 29 62
2 CD Ciudad CD Ciudad 26 89 28 59
3 Xuventude Dorneda Xuventude 26 84 28 59
4 Oza Juvenil S.D. Juvenil S.D. 26 67 34 51
5 Suevos CF Suevos CF 26 75 46 46
6 Orzán Sd Orzán Sd 26 66 59 40
7 CD X. Aranga Aranga 26 68 64 37
8 Ozacesuras Ozacesuras 26 72 61 36
9 Maravillas S.D. Maravillas 26 49 50 36
10 Brexo Lema B Brexo Lema 26 69 73 30
11 Sobrado Xuventude Sobrado 25 36 85 19
12 Unión Sportiva Unión 26 40 106 17
13 Sigras CD Sigras CD 26 38 63 15
14 Vizoño B Vizoño B 26 27 146 9
15 Miguel Rua-Don Bosco Miguel 0 0 0 0
16 UD America UD America 0 0 0 0
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Sporting Meicende Sporting 26 80 27 69
2 Culleredo Culleredo 25 78 24 63
3 CD Obrero CD Obrero 25 93 24 61
4 C.D. Larín C.D. Larín 25 60 29 51
5 Once Caballeros Once 26 54 36 46
6 UD Juvenil de Almeiras Juvenil 26 59 48 46
7 Suevos CF Suevos CF 26 37 60 29
8 Pastoriza SCD Pastoriza 25 50 64 25
9 Brexo Lema B Brexo Lema 26 56 68 24
10 Union Campestre Union 26 35 61 21
11 Olímpico C.F. B Olímpico 25 39 70 20
12 Atlético Perillo Atlético 25 53 85 20
13 Sigras CD Sigras CD 26 37 88 18
14 Hercules SD Hercules SD 24 37 84 14
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Sporting Burgo Sporting 30 103 31 82
2 Culleredo Culleredo 30 118 27 74
3 Cecebre SD Cecebre SD 30 61 63 46
4 Pastoriza SCD Pastoriza 29 68 45 44
5 Union Campestre Union 30 51 45 44
6 Brexo Lema B Brexo Lema 30 56 61 41
7 UD Juvenil de Almeiras Juvenil 30 64 94 36
8 Hercules SD Hercules SD 30 55 91 36
9 Atlético Perillo Atlético 28 68 76 28
10 Sigras CD Sigras CD 30 50 82 24
11 Sporting Bergondo Sporting 29 24 103 7
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Sporting Meicende Sporting 22 66 29 49
2 Atletico San Pedro Atletico 22 62 21 48
3 Suevos CF Suevos CF 22 49 37 42
4 Sporting Burgo Sporting 22 44 37 36
5 UD Juvenil de Almeiras Juvenil 22 50 38 35
6 Cecebre SD Cecebre SD 22 40 33 35
7 Sigras CD Sigras CD 22 29 41 25
8 Union Campestre Union 22 39 49 23
9 Pastoriza SCD Pastoriza 21 34 38 22
10 Brexo Lema B Brexo Lema 22 33 49 22
11 Hercules SD Hercules SD 22 26 56 18
12 Sporting Bergondo Sporting 21 31 75 11
13 Celeste CD Celeste CD 0 0 0 0

  USO DE MEMORIA  
5,286,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.2748
Total Execution Time  0.2780
  CADENA URL  
/tercera_galicia2020/grupo2/historico
  GET DATOS  
$_GET['/tercera_galicia2020/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0129  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 715 AND group_code = 2 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0133  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 = 51550 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 39852 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 37253 AND t.round = 26 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 `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 = 16869 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 5006 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 07:30:12' 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-27 07:30:12' 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=4 AND last_update > '2024-04-27 07:30:12' 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-04-27 07:30:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
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 = 51550 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51550 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.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 = 51550 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51550 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 = 51550 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51550 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  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 = 51550 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC