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 Coya CD Coya CD 24 77 29 59
2 San Miguel C.F. Miguel C.F. 25 95 37 56
3 Lavadores Lavadores 25 71 22 55
4 San Roque-Casablanca Roque-Casabl 25 68 41 51
5 Club Peñasco Club 24 78 38 50
6 Balaidos CF Balaidos CF 24 53 33 48
7 Chapela CF Chapela CF 24 48 22 45
8 Descanso Sampayo Descanso 25 60 48 42
9 Teis Teis 24 50 41 35
10 Apóstol Santiago Apóstol 25 58 67 31
11 Racing Vilariño Racing 25 44 82 24
12 Oiense Oiense 24 33 59 22
13 Independiente CF Independient 24 38 66 19
14 Moledo CF Moledo CF 24 20 54 17
15 CD Vincios CD Vincios 25 21 64 14
16 ED Vigo 2015 Vigo 2015 24 21 76 13
17 Nespereira CD Nespereira 25 23 79 13
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 SDR San Esteban Esteban 30 79 17 71
2 ED Val Miñor Miñor 30 92 29 69
3 Atlantida Matama Atlantida 30 73 18 62
4 Chapela CF Chapela CF 30 69 40 57
5 Lavadores Lavadores 30 86 43 56
6 Coya CD Coya CD 30 71 33 56
7 Arenas de Alcabre Arenas 29 73 38 52
8 San Miguel C.F. Miguel C.F. 30 63 36 49
9 San Roque-Casablanca Roque-Casabl 30 47 59 43
10 Balaidos CF Balaidos CF 30 70 66 40
11 Club Peñasco Club 30 81 84 36
12 Descanso Sampayo Descanso 29 40 78 32
13 Edvm Pereiro Edvm Pereiro 30 39 76 22
14 Moledo CF Moledo CF 30 28 102 16
15 Nespereira CD Nespereira 30 30 138 10
16 Oiense Oiense 30 37 121 8
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Xinzo Xinzo 32 96 32 75
2 Progresista Progresista 32 73 21 74
3 Mosende Mosende 32 95 34 72
4 Ribera Ribera 32 96 62 64
5 Nieves CF Nieves CF 32 74 58 50
6 San Salvador Salvador 32 71 57 50
7 Alerta Sanguiñeda Alerta 32 84 58 49
8 Covelo CF Covelo CF 32 68 67 45
9 CF Guillarei Guillarei 31 70 57 44
10 Arbo F.C. Arbo F.C. 32 63 65 44
11 Cañiza Cañiza 32 57 66 41
12 San Juan de Rubios Juan Rubios 31 58 78 36
13 Caselas B Caselas B 31 46 66 32
14 Vilasobroso AD Vilasobroso 31 44 100 31
15 GD Miño GD Miño 32 43 75 30
16 Castelo SD Castelo SD 32 37 104 12
17 Oliveira Oliveira 32 21 96 10
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Noalla Noalla 26 53 33 51
2 Puente Arnelas SD Puente 26 53 28 50
3 Portas CD Portas CD 26 46 27 47
4 Ribadumia B Ribadumia B 26 66 43 44
5 Poyo Poyo 26 47 39 40
6 Chispa SD Chispa SD 26 50 40 37
7 Xil CD Xil CD 26 53 54 37
8 Libertad SC Libertad SC 26 47 40 35
9 Romay SD Romay SD 26 45 39 34
10 Barro CF Barro CF 26 38 36 34
11 Dorron CF Dorron CF 25 35 48 26
12 Atletico San Miguel Atletico 26 30 49 24
13 Faxilde Atletico Faxilde 26 37 68 24
14 Beiramar CF Beiramar CF 25 19 75 15
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Padrenda CF Padrenda CF 20 38 22 41
2 Moreiras Moreiras 19 48 18 40
3 Toen FS Toen FS 19 37 20 39
4 Salamonde CF Salamonde 20 49 26 37
5 Sporting Carballino Sporting 20 54 30 35
6 Cenlle CD Cenlle CD 18 46 22 33
7 Outomuro CF Outomuro CF 20 47 35 32
8 A Peroxa B A Peroxa B 20 30 59 22
9 Razamonde AC Razamonde 19 28 45 17
10 Castrelo de Miño Castrelo 20 22 53 10
11 Os Chaos CF Os Chaos CF 19 17 86 0
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Ourense UD Ourense UD 27 156 10 81
2 Palmes CD Palmes CD 27 96 48 68
3 Ribadavia At. Ribadavia 27 86 49 53
4 Barra de Miño Barra Miño 27 78 48 51
5 Cenlle CD Cenlle CD 27 61 50 50
6 Sporting Carballino Sporting 27 78 47 48
7 Parada do Sil Parada 26 64 51 36
8 A Peroxa B A Peroxa B 27 59 70 36
9 Salamonde CF Salamonde 26 50 63 28
10 Loureiro CF Loureiro CF 27 43 80 27
11 Piñor SD Piñor SD 27 38 66 25
12 Razamonde AC Razamonde 27 39 68 23
13 Arcos CF Arcos CF 14 33 29 20
14 Castrelo de Miño Castrelo 27 41 96 18
15 Os Chaos CF Os Chaos CF 27 11 158 0

  USO DE MEMORIA  
5,545,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0773
Total Execution Time  0.0792
  CADENA URL  
/tercera_galicia2020/grupo13/historico
  GET DATOS  
$_GET['/tercera_galicia2020/grupo13/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0018  SELECT type FROM routes WHERE alias = 'tercera_galicia2020'
0.0040  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 = 13 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=13 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=715 ORDER BY order_id ASC
0.0019  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 = 51571 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 715 AND group_code = 13 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 51571 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.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 `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 = 45281 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 39863 AND t.round = 34 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 `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 = 35505 AND t.round = 26 ORDER BY team.conference 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 `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 = 16895 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 5016 AND t.round = 30 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-05-01 20:22:13' 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-05-01 20:22:13' 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-05-01 20:22:13' 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-05-01 20:22:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  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 = 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.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 = 51571 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51571 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 = 51571 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51571 AND (e.action = 4 or e.action = 5) 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 = 51571 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51571 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0044  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 = 51571 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