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 O Pino O Pino 25 55 26 46
2 CF Dumbría CF Dumbría 25 47 36 46
3 Soneira Sd Soneira Sd 25 53 44 46
4 CD Lalín CD Lalín 25 41 27 43
5 Tordoia Tordoia 25 44 46 40
6 Flavia Flavia 25 46 36 39
7 Cordeiro CF Cordeiro CF 25 41 29 37
8 Praiña Praiña 25 29 33 34
9 SD Agolada SD Agolada 25 39 39 33
10 Negreira Negreira 25 30 33 33
11 Piloño Piloño 25 27 36 32
12 Esclavitud Esclavitud 25 33 39 31
13 CD Baio CD Baio 25 32 44 31
14 Mazaricos Mazaricos 25 35 43 27
15 Val do Ulla Val do Ulla 25 38 52 27
16 CD Union CD Union 25 34 33 26
17 Volantes de Baño Volantes 25 37 46 26
18 Cidade de Ribeira CF Cidade 25 35 54 25
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Sigueiro CF Sigueiro CF 34 70 17 79
2 SD Fisterra SD Fisterra 34 72 27 79
3 Flavia Flavia 34 78 31 75
4 CD Baio CD Baio 34 62 43 60
5 CF Dumbría CF Dumbría 34 59 51 51
6 CD Union CD Union 34 38 40 49
7 Piloño Piloño 34 52 58 47
8 CD Lalín CD Lalín 34 42 43 45
9 Soneira Sd Soneira Sd 34 46 48 45
10 Esclavitud Esclavitud 34 37 54 44
11 Praiña Praiña 34 42 52 42
12 Tordoia Tordoia 34 52 55 41
13 Val do Ulla Val do Ulla 34 60 67 41
14 Cordeiro CF Cordeiro CF 34 49 53 40
15 Chaian Chaian 34 31 57 35
16 SD Esteirana Esteirana 34 37 54 33
17 Bertamiráns FC Bertamiráns 34 43 89 26
18 Bastavales Bastavales 34 38 69 25
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 SD Agolada SD Agolada 34 60 29 73
2 Puebla Galicia CF Puebla 34 69 28 69
3 SD Piloño SD Piloño 34 61 43 69
4 Flavia Flavia 34 60 30 64
5 CD Union CD Union 34 63 43 62
6 Bastavales Bastavales 34 56 46 57
7 Soneira Sd Soneira Sd 34 60 40 56
8 Lalín Lalín 34 69 48 55
9 Bertamiráns FC Bertamiráns 34 51 53 46
10 CD Baio CD Baio 34 43 43 40
11 Cordeiro CF Cordeiro CF 34 53 59 40
12 Chaián Chaián 34 45 46 39
13 Sigueiro CF Sigueiro CF 34 44 54 39
14 Tordoia Tordoia 34 32 54 37
15 SD Fisterra SD Fisterra 34 39 59 36
16 Cidade de Ribeira CF Cidade 34 43 82 29
17 San Lorenzo Verdillo Lorenzo 34 38 76 25
18 CF Silleda CF Silleda 34 35 88 17
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 CF Dumbría CF Dumbría 34 69 30 75
2 SD Agolada SD Agolada 34 62 46 65
3 Sigueiro CF Sigueiro CF 34 66 43 56
4 Puebla Galicia CF Puebla 34 49 38 55
5 SD Piloño SD Piloño 34 74 62 53
6 CD Union CD Union 34 52 44 53
7 Cordeiro CF Cordeiro CF 34 72 56 51
8 Flavia Flavia 34 59 46 51
9 Cidade de Ribeira CF Cidade 34 70 55 49
10 Tordoia Tordoia 34 49 44 44
11 SD Fisterra SD Fisterra 33 46 48 44
12 CF Silleda CF Silleda 34 34 52 44
13 Val do Ulla Val do Ulla 34 48 49 43
14 Outes Outes 34 41 65 41
15 Lalín Lalín 33 48 58 40
16 Sporting Zas Sporting 34 43 72 34
17 Esclavitud Esclavitud 34 35 61 27
18 SD Villestro Villestro 34 46 94 22
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Soneira Sd Soneira Sd 33 73 36 68
2 SD Sofán SD Sofán 34 67 35 67
3 Flavia Flavia 34 74 43 66
4 Val do Ulla Val do Ulla 34 71 45 65
5 CD Union CD Union 33 69 34 62
6 Cordeiro CF Cordeiro CF 34 75 44 60
7 SD Piloño SD Piloño 34 64 38 57
8 Sigueiro CF Sigueiro CF 34 66 54 51
9 Tordoia Tordoia 34 59 51 50
10 SD Agolada SD Agolada 34 53 40 50
11 Outes Outes 34 62 60 48
12 Lesende CFC Lousame Lesende 33 46 45 47
13 CD Baio CD Baio 34 34 55 37
14 Corme CF Corme CF 34 59 82 35
15 Bertamirans B Bertamirans 34 44 69 33
16 Hijos Palmeira Hijos 33 45 110 24
17 Carcacía Carcacía 34 31 88 18
18 Malpica SDC Malpica SDC 34 42 105 18
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 SD Villestro Villestro 34 58 34 68
2 Puebla Galicia CF Puebla 34 52 27 66
3 CD Union CD Union 34 49 27 63
4 CD Baio CD Baio 34 52 43 58
5 Bertamirans B Bertamirans 34 55 50 55
6 SD Sofán SD Sofán 34 47 49 53
7 Malpica SDC Malpica SDC 34 42 43 45
8 Corme CF Corme CF 34 47 50 45
9 Cordeiro CF Cordeiro CF 34 37 40 45
10 Sigueiro CF Sigueiro CF 34 52 47 44
11 SD Piloño SD Piloño 34 41 42 44
12 Flavia Flavia 34 34 43 44
13 Soneira Sd Soneira Sd 34 44 42 43
14 Lesende CFC Lousame Lesende 34 43 49 41
15 SD Agolada SD Agolada 34 42 46 39
16 Amio CF Amio CF 34 42 54 37
17 CF Silleda CF Silleda 34 33 57 33
18 SD Esteirana Esteirana 34 36 63 31

  USO DE MEMORIA  
5,711,368 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0858
Total Execution Time  0.0877
  CADENA URL  
/primera_galicia2020/grupo2/historico
  GET DATOS  
$_GET['/primera_galicia2020/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0018  SELECT type FROM routes WHERE alias = 'primera_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 = 'primera_galicia' AND (l.group_code = 2 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=2 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=694 AND type_rel = 3
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 694 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (912025,141904,92516) ORDER BY n.cover_points DESC, update_date DESC
0.0019  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 694 GROUP BY l.categoryId
0.0019  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=694 GROUP BY l.year ORDER BY l.year DESC
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 = 51295 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 694 AND group_code = 2 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 51295 AND t.round = 25 ORDER BY team.conference ASC,t.position 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 `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 = 45148 AND t.round = 34 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 `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 = 39705 AND t.round = 34 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 = 34036 AND t.round = 34 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 `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 = 16766 AND t.round = 34 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 `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 = 4052 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-30 09:10:35' 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-04-30 09:10:35' 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-30 09:10:35' 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-30 09:10:35' 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 = 'primera_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 = 51295 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51295 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 = 51295 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51295 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 = 51295 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51295 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0048  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 = 51295 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC