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 Monteporreiro SD Monteporreir 19 55 12 44
2 Soutomaior CD Soutomaior 18 47 25 36
3 Cotobade CED Cotobade 18 48 27 36
4 Campaño SD Campaño SD 19 52 33 35
5 Figueirido Figueirido 19 36 25 33
6 Salcedo SCD Salcedo SCD 18 32 27 32
7 Rápido Bahía Rápido 18 31 22 28
8 Poyo Poyo 18 27 22 27
9 EF Cobres EF Cobres 18 25 45 20
10 Marcon B Marcon B 18 26 29 19
11 San Andres San Andres 18 29 47 18
12 Santome SD Santome SD 18 20 49 11
13 Club Atlético Peñaflor Club 9 10 35 7
14 ACD Barro ACD Barro 18 17 57 2
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Cerponzons CF Cerponzons 26 71 28 64
2 SCD Ponte Caldelas Ponte 26 81 21 60
3 Soutomaior CD Soutomaior 25 77 27 53
4 Figueirido Figueirido 26 64 30 45
5 Marcon B Marcon B 26 46 32 42
6 Cotobade CED Cotobade 26 51 53 38
7 Santome SD Santome SD 25 51 44 35
8 Rápido Bahía Rápido 24 35 32 35
9 Salcedo SCD Salcedo SCD 26 53 52 34
10 Atletico Estacion Atletico 25 41 51 25
11 Monteporreiro SD Monteporreir 26 31 58 25
12 San Andres San Andres 26 33 53 23
13 EF Cobres EF Cobres 26 34 68 19
14 Caroi SD Caroi SD 23 16 135 1
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Vilamarin Vilamarin 34 118 29 80
2 Barra de Miño Barra Miño 34 62 24 75
3 Ourense B Ourense B 34 88 30 74
4 Allariz B Allariz B 34 69 37 66
5 Toen FS Toen FS 33 64 28 63
6 Cartelle Cartelle 34 78 38 62
7 Soutopenedo Soutopenedo 34 65 39 60
8 A Merca A Merca 34 69 47 55
9 Vilar de Santos Vilar Santos 34 72 36 50
10 Cenlle CD Cenlle CD 34 43 52 43
11 Muntián-Maravillas Muntián-Mar 34 57 61 41
12 Parada do Sil Parada 34 58 78 38
13 Rocas CD Rocas CD 34 63 70 36
14 Vilar de Barrio Vilar Barrio 34 40 72 30
15 Padrenda CF Padrenda CF 33 41 84 29
16 Bubal Bubal 34 54 105 26
17 Maceda B Maceda B 34 37 92 18
18 Os Chaos CF Os Chaos CF 34 16 172 7
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Sporting Carballino Sporting 18 81 14 48
2 Salamonde CF Salamonde 18 54 21 38
3 Outomuro CF Outomuro CF 18 47 28 35
4 Padrenda CF Padrenda CF 18 30 26 29
5 Muntián-Maravillas Muntián-Mar 18 35 17 28
6 Barra de Miño Barra Miño 18 47 23 27
7 Vilamarin Vilamarin 18 33 29 21
8 Cenlle CD Cenlle CD 18 29 40 18
9 Razamonde AC Razamonde 18 19 63 6
10 Os Chaos CF Os Chaos CF 18 11 125 1
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Oural SD Oural SD 26 76 29 58
2 Garabolos SDC Garabolos 26 58 28 57
3 Quiroga FC Quiroga FC 26 62 16 53
4 Monterroso B Monterroso 26 62 49 49
5 O Incio Terra Brava C.F. Incio Terra 26 65 33 49
6 Portomarín Portomarín 26 57 43 45
7 Sporting Lucense Sporting 26 59 39 44
8 Paradela Paradela 26 42 37 41
9 Antas B Antas B 26 32 58 27
10 Pradeda FC Pradeda FC 26 37 51 27
11 Becerrea FC Becerrea FC 26 34 84 25
12 Lajosa SD Lajosa SD 26 22 56 19
13 San Antonio SDC Antonio 26 34 67 17
14 Rio Sil CD Rio Sil CD 26 21 71 7
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 San Roque SDC Roque 26 74 25 60
2 Oural SD Oural SD 26 56 31 53
3 San Lazaro SD Lazaro 26 35 17 53
4 Garabolos SDC Garabolos 26 48 31 45
5 Sober CD Sober CD 26 45 30 44
6 Sporting Lucense Sporting 26 39 28 41
7 Arenas CF Arenas CF 26 55 46 39
8 Quiroga FC Quiroga FC 26 43 41 36
9 Lajosa SD Lajosa SD 26 32 53 31
10 San Antonio SDC Antonio 26 45 55 30
11 Rio Sil CD Rio Sil CD 26 38 53 29
12 Antas B Antas B 26 30 53 25
13 Pradeda FC Pradeda FC 26 39 60 20
14 Becerrea FC Becerrea FC 26 26 82 5

  USO DE MEMORIA  
5,359,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.3431
Total Execution Time  0.3464
  CADENA URL  
/tercera_galicia2020/grupo11/historico
  GET DATOS  
$_GET['/tercera_galicia2020/grupo11/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0254  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 = 11 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=11 DESC LIMIT 1
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=715 ORDER BY order_id ASC
0.0129  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 715 AND group_code = 11 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0131  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 = 51568 AND t.round = 19 ORDER BY team.conference ASC,t.position 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 `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 = 45279 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 39861 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 34448 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 16893 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 5014 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 08:33:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 08:33:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 08:33:58' 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=3 AND last_update > '2024-04-28 08:33:58' 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 = 51568 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51568 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.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 = 51568 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51568 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 = 51568 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51568 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 = 51568 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC