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 Matela Matela 16 49 17 37
2 SD Viveiro SD Viveiro 16 54 15 36
3 Fonsagrada Balompe Fonsagrada 15 28 6 36
4 Friol B Friol B 17 27 23 26
5 Comercial Comercial 16 32 28 23
6 Rioaveso Machinango S.D. Rioaveso 17 36 31 22
7 SD Cazas SD Cazas 16 25 25 20
8 Catro Roldas Catro Roldas 16 40 32 18
9 Celeiro Club del Mar Celeiro Club 16 28 28 18
10 Balompie Lugo Union Balompie 17 27 41 17
11 ADC Valle del oro Valle 0 0 0 0
12 SD Nuevo Nausti Nuevo Nausti 16 6 106 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Alfoz Alfoz 22 52 17 51
2 SD Muimenta SD Muimenta 22 55 27 49
3 Matela Matela 22 71 30 45
4 Catro Roldas Catro Roldas 22 49 32 43
5 SCD Milagrosa Milagrosa 22 56 33 42
6 Celta Barreiros Celta 22 48 29 37
7 Fonsagrada Balompe Fonsagrada 22 30 29 33
8 Friol B Friol B 22 30 52 19
9 Celeiro Club del Mar Celeiro Club 22 25 69 18
10 SD Cazas SD Cazas 22 22 43 16
11 Rioaveso Machinango S.D. Rioaveso 22 25 70 14
12 Balompie Lugo Union Balompie 22 18 50 11
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Cervo-Sargadelos SD Cervo-Sargad 14 28 13 32
2 Goiriz Goiriz 14 27 13 29
3 Catro Roldas Catro Roldas 14 33 17 28
4 Celta Barreiros Celta 14 30 27 22
5 SD Muimenta SD Muimenta 14 29 22 21
6 Rioaveso Machinango S.D. Rioaveso 14 27 40 15
7 Celeiro CM Celeiro CM 14 11 32 8
8 SD Cazas SD Cazas 14 12 33 5
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Ourol SD Ourol SD 20 53 23 49
2 Roupar SDC Roupar SDC 19 45 18 45
3 Goiriz Goiriz 20 40 17 43
4 Matela AD Matela AD 19 36 25 33
5 Cervo-Sargadelos SD Cervo-Sargad 20 35 28 31
6 Fonsagrada Balompe Fonsagrada 20 25 27 31
7 SD Cazas SD Cazas 20 27 25 26
8 Rioaveso Machinango S.D. Rioaveso 20 21 38 18
9 Celta Barreiros Celta 20 19 46 13
10 Celeiro CM Celeiro CM 19 15 40 7
11 San Roman CD Roman 19 14 43 7
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Zona Vella CF Zona Vella 21 53 24 45
2 Peña Bodegon Arzua Peña 21 57 28 43
3 La Salle La Salle 21 58 36 38
4 Atlético Fátima Atlético 21 40 31 36
5 Santa Cruz de Montaos Santa Cruz. 21 41 27 36
6 Resmon Resmon 21 44 33 35
7 Vila de Ordes Vila Ordes 21 39 44 30
8 Portomouro Portomouro 21 37 44 26
9 Belvis B Belvis B 21 21 47 18
10 Tordoia B Tordoia B 21 31 55 17
11 Dubra B Dubra B 21 24 48 17
12 Rial CF Rial CF 11 12 40 1
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Atletico de Melide Atletico 22 86 14 61
2 Conxo CD Conxo CD 22 72 19 54
3 Atletico Pino Atletico 22 50 22 49
4 Santiso UD Santiso UD 22 49 22 49
5 Vila de Ordes Vila Ordes 22 61 21 46
6 Rodeiro CF Rodeiro CF 22 41 19 46
7 Peña Bodegon Arzua Peña 22 56 25 45
8 Santa Cruz de Montaos Santa Cruz. 22 45 34 38
9 La Salle La Salle 22 54 46 37
10 Ponte-Camporrapado Ponte-Campor 22 45 36 36
11 O Pino SD O Pino SD 22 46 38 35
12 Touro SD Touro SD 22 47 38 32
13 Sporting Santiago Sporting 22 24 38 31
14 Racing San Lorenzo Racing 22 34 49 29
15 Zona Vella CF Zona Vella 22 30 31 28
16 Cruces SD Cruces SD 22 26 30 28
17 Silleda B Silleda B 22 23 59 17
18 Rial CF Rial CF 22 25 55 15
19 Tordoia B Tordoia B 22 21 53 14
20 A Gracia CF A Gracia CF 22 21 66 14
21 Dozon SD Dozon SD 22 15 60 12
22 Campo da Angustia Campo 22 16 65 10
23 Deza SD Deza SD 22 18 65 6
24 Villestro B Villestro B 0 0 0 0

  USO DE MEMORIA  
5,237,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0679
Total Execution Time  0.0698
  CADENA URL  
/tercera_galicia2020/grupo8/historico
  GET DATOS  
$_GET['/tercera_galicia2020/grupo8/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_galicia' 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.0023  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 715 AND group_code = 8 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0022  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 = 51565 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.0026  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 = 45276 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 39858 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 35502 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 16876 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 5011 AND t.round = 23 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-27 12:13:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 12:13:17' 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-27 12:13:17' 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-27 12:13:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  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 = 51565 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51565 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.0019  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 = 51565 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51565 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  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 = 51565 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51565 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030  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 = 51565 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