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 Nieves Nieves 23 88 16 65
2 Cañiza Cañiza 23 89 28 58
3 Mosende Mosende 23 56 25 52
4 Progresista Progresista 23 67 31 47
5 A D Vila Do Corpus Vila Corpus 23 43 24 46
6 Covelo CF Covelo CF 23 61 30 44
7 Alerta Sanguiñeda Alerta 23 53 38 37
8 San Salvador Salvador 23 42 41 37
9 Ribadelouro Ribadelouro 23 35 41 25
10 G.D. Miño G.D. Miño 23 35 45 25
11 C Guillarei C Guillarei 23 38 50 24
12 Pontellas B Pontellas B 23 36 46 23
13 Arbo F.C. Arbo F.C. 23 41 64 21
14 SD Castelo SD Castelo 23 30 60 13
15 Oliveira Oliveira 23 17 58 7
16 San Juan de Rubios Juan Rubios 23 19 153 2
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Ribera Ribera 28 86 26 71
2 Tebra F.C. Tebra F.C. 28 85 35 67
3 Arbo F.C. Arbo F.C. 28 60 28 61
4 Alerta Sanguiñeda Alerta 28 56 40 55
5 Cañiza Cañiza 28 66 42 51
6 A D Vila Do Corpus Vila Corpus 28 43 33 46
7 San Juan de Rubios Juan Rubios 28 59 41 44
8 Covelo CF Covelo CF 28 52 62 32
9 C Guillarei C Guillarei 28 42 51 30
10 Ribadelouro Ribadelouro 28 36 47 29
11 SD Castelo SD Castelo 28 34 83 26
12 San Salvador Salvador 28 39 65 24
13 G.D. Miño G.D. Miño 28 35 57 22
14 Nieves Nieves 28 38 74 21
15 Oliveira Oliveira 28 16 63 11
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Poyo Poyo 21 70 11 59
2 Bueu Bueu 22 62 24 50
3 Cesantes CD Cesantes CD 22 52 31 44
4 Soutomaior CD Soutomaior 22 61 32 40
5 Atletico Estacion Atletico 21 51 28 40
6 Cotobade CED Cotobade 22 54 35 39
7 EF Cobres EF Cobres 22 34 48 24
8 Santome SD Santome SD 22 32 48 24
9 San Andres San Andres 22 40 61 20
10 Estrella Dorada Estrella 20 34 79 14
11 Caroi SD Caroi SD 22 28 68 12
12 SCD Salcedo B Salcedo 22 17 70 5
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 CD Vincios CD Vincios 27 77 35 61
2 Teis Teis 28 65 36 58
3 Coya CD Coya CD 28 72 51 56
4 Chapela CF Chapela CF 28 68 37 55
5 Lavadores Lavadores 28 85 45 54
6 Gondomar Base Gondomar 28 62 57 44
7 Moledo CF Moledo CF 28 61 59 44
8 Nespereira CD Nespereira 27 61 74 41
9 E.D.V.M. Pereiró E.D.V.M. 28 44 56 37
10 Club Peñasco Club 28 76 82 35
11 Balaidos CF Balaidos CF 28 52 48 32
12 Atletico de Villar Atletico 28 41 61 29
13 San Roque-Casablanca Roque-Casabl 28 60 81 28
14 Arenas de Alcabre Arenas 28 31 74 11
15 Chapela CF Chapela CF 28 25 84 10
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Sampayo U. Sampayo U. 26 82 16 64
2 Arcade Arcade 26 69 20 59
3 SCD Ponte Caldelas Ponte 26 61 29 52
4 Salcedo SCD Salcedo SCD 26 54 45 45
5 San Andres San Andres 26 54 44 45
6 Soutomaior CD Soutomaior 26 49 37 40
7 Atletico Estacion Atletico 25 46 29 40
8 Cerponzons CF Cerponzons 26 49 40 36
9 Santome SD Santome SD 26 47 52 35
10 Cesantes CD Cesantes CD 25 42 48 31
11 Cotobade CED Cotobade 26 27 59 26
12 Presqueiras SD Presqueiras 25 35 79 16
13 Caroi SD Caroi SD 26 33 83 14
14 Monteporreiro SD Monteporreir 25 23 90 3
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 A Lama SD A Lama SD 34 120 31 81
2 Campaño SD Campaño SD 34 107 38 77
3 SCD Ponte Caldelas Ponte 34 82 38 70
4 Cotobade CED Cotobade 34 65 27 68
5 Cerponzons CF Cerponzons 34 82 37 66
6 San Andres San Andres 34 93 58 65
7 Atletico Estacion Atletico 34 63 31 61
8 Salcedo SCD Salcedo SCD 34 56 62 54
9 Soutomaior CD Soutomaior 34 69 42 53
10 Santome SD Santome SD 34 53 49 53
11 Sampayo U. Sampayo U. 34 48 34 51
12 Monteporreiro SD Monteporreir 34 54 64 41
13 Cesantes CD Cesantes CD 34 46 76 31
14 Marcon B Marcon B 34 42 96 26
15 Marin B Marin B 34 39 79 23
16 Presqueiras SD Presqueiras 34 41 101 18
17 Caroi SD Caroi SD 34 37 118 16
18 EF Soutomaior Soutomaior 34 24 140 14

  USO DE MEMORIA  
5,491,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0030
Controller Execution Time ( Home / Category )  0.0810
Total Execution Time  0.0840
  CADENA URL  
/tercera_galicia2020/grupo14/historico
  GET DATOS  
$_GET['/tercera_galicia2020/grupo14/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0018  SELECT type FROM routes WHERE alias = 'tercera_galicia2020'
0.0039  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 = 14 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=14 DESC LIMIT 1
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=715 ORDER BY order_id ASC
0.0020  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 = 51572 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 715 AND group_code = 14 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 = 51572 AND t.round = 23 ORDER BY team.conference ASC,t.position 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 `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 = 45282 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 40099 AND t.round = 26 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 `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 = 35506 AND t.round = 30 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 `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 = 16896 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 5017 AND t.round = 34 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-28 12:43:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 12:43:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 12:43:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0027  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 12:43:23' 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.0021  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 = 51572 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51572 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 = 51572 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51572 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0025  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 = 51572 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51572 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0045  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 = 51572 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC