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 Catoira Catoira 20 63 26 46
2 Caldas CF Caldas CF 19 67 29 44
3 Libertad SC Libertad SC 18 37 20 39
4 At. Cuntis B Cuntis 20 37 22 38
5 Ribadumia B Ribadumia B 19 57 36 35
6 Puente Arnelas SD Puente 19 38 23 35
7 Noalla Noalla 20 39 36 32
8 Barro CF Barro CF 19 38 35 25
9 Bamio Bamio 19 31 30 24
10 Dorron CF Dorron CF 19 23 32 19
11 Beiramar CF Beiramar CF 20 30 52 19
12 USD de O Grove B Grove 20 36 59 19
13 Chispa SD Chispa SD 18 33 47 15
14 Anduriña SD Anduriña 19 32 63 13
15 Villagarcía Villagarcía 19 13 64 3
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Portas CD Portas CD 26 76 27 59
2 Faxilde Atletico Faxilde 26 69 37 55
3 Xil CD Xil CD 26 74 42 52
4 Catoira Catoira 26 59 36 45
5 Chispa SD Chispa SD 26 64 42 45
6 Barro CF Barro CF 26 58 39 44
7 At. Cuntis B Cuntis 25 54 44 41
8 Libertad SC Libertad SC 26 58 54 41
9 Villagarcía Villagarcía 25 55 48 35
10 Ribadumia B Ribadumia B 26 60 55 35
11 Dorron CF Dorron CF 26 39 51 26
12 USD de O Grove B Grove 24 40 77 17
13 Beiramar CF Beiramar CF 26 37 92 10
14 Club Atlético Peñaflor Club 24 19 118 5
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Gondomar Base Gondomar 30 101 33 74
2 Atletico de Villar Atletico 30 104 40 63
3 Lavadores Lavadores 30 88 33 62
4 Chapela CF Chapela CF 30 78 44 62
5 Atlántida Matamá Atlántida 30 63 36 58
6 Club Peñasco Club 30 94 60 53
7 Coya CD Coya CD 30 66 40 52
8 Arenas de Alcabre Arenas 30 73 47 49
9 Balaidos CF Balaidos CF 30 68 65 44
10 San Roque-Casablanca Roque-Casabl 30 62 51 42
11 E.D.V.M. Pereiró E.D.V.M. 30 39 48 39
12 Moledo CF Moledo CF 30 60 73 35
13 Descanso Sampayo Descanso 30 54 78 28
14 Chapela CF Chapela CF 30 37 134 12
15 Nespereira CD Nespereira 30 37 128 11
16 Racing Vilariño B Racing 30 28 142 11
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Salcedo SCD Salcedo SCD 26 95 34 65
2 Cerponzons CF Cerponzons 26 63 18 59
3 Cesantes CD Cesantes CD 26 62 25 55
4 Bueu Bueu 26 73 29 53
5 SCD Ponte Caldelas Ponte 26 91 31 51
6 Atletico Estacion Atletico 26 67 32 51
7 Soutomaior CD Soutomaior 26 83 31 47
8 Campaño SD Campaño SD 26 62 45 43
9 At. Cuntis B Cuntis 26 44 55 31
10 Cotobade CED Cotobade 26 42 50 28
11 Santome SD Santome SD 26 33 59 20
12 Presqueiras SD Presqueiras 26 19 93 10
13 Caroi SD Caroi SD 26 18 94 9
14 Estrella Dorada Estrella 26 11 167 4
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 C.D. Seixalbo C.D. 17 64 13 46
2 Molgas ADF Molgas ADF 17 54 12 45
3 Rocas CD Rocas CD 18 43 24 35
4 Espadana Espadana 18 33 34 23
5 Maceda B Maceda B 18 30 49 23
6 Sainza Sainza 18 21 26 21
7 San Roque de Villardebos Roque 16 24 31 21
8 Loureiro CF Loureiro CF 18 29 48 20
9 Parada do Sil Parada 18 16 49 8
10 Vilar de Barrio Vilar Barrio 18 20 48 6
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Raio Alaricano Raio 20 66 19 50
2 Carballeira CF Carballeira 20 42 13 44
3 Villardebos SD Villardebos 20 63 36 38
4 Allariz B Allariz B 20 50 26 37
5 A Bola CD A Bola CD 20 45 25 33
6 Molgas ADF Molgas ADF 20 36 40 26
7 Rocas CD Rocas CD 19 20 28 24
8 San Roque de Villardebos Roque 19 28 46 20
9 Vilar de Barrio Vilar Barrio 20 29 40 19
10 Maceda B Maceda B 20 21 65 10
11 Arnuid CF Arnuid CF 20 21 83 6
12 Calvos de Randin Calvos 0 0 0 0

  USO DE MEMORIA  
5,376,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0035
Controller Execution Time ( Home / Category )  0.3021
Total Execution Time  0.3056
  CADENA URL  
/tercera_galicia2020/grupo12/historico
  GET DATOS  
$_GET['/tercera_galicia2020/grupo12/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0106  SELECT type FROM routes WHERE alias = 'tercera_galicia2020'
0.0217  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 = 12 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=12 DESC LIMIT 1
0.0108  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 = 51569 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 715 AND group_code = 12 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0110  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 = 51569 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 45280 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 39862 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 35504 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 16894 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 5015 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 12:00:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 12:00:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 12:00:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 12:00:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  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.0107  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 = 51569 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51569 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.0107  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 = 51569 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51569 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0106  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 = 51569 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51569 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0116  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 = 51569 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC