4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Victoria CF
TEMPORADA 2023/2024
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Noia Noia 31 62 28 63
2 Boiro Boiro 30 51 25 56
3 Sigueiro CF Sigueiro CF 30 54 35 54
4 San Tirso SD Tirso 30 36 28 53
5 CD Lalín CD Lalín 30 49 39 49
6 SD Sofán SD Sofán 30 52 38 48
7 AD Miño AD Miño 30 42 33 46
8 At. Coruña Montañeros Coruña 30 40 26 45
9 Cidade de Ribeira CF Cidade 30 52 52 39
10 Dubra Dubra 31 35 43 39
11 Galicia Mugardos Galicia 30 33 35 38
12 Ribadeo FC Ribadeo FC 30 43 50 36
13 Club Lemos Club Lemos 30 31 40 35
14 CD Castro CD Castro 30 41 50 33
15 Victoria CF Victoria CF 30 30 52 30
16 SDC Residencia Residencia 30 34 56 29
17 As Pontes As Pontes 30 30 42 28
18 Eume Deportivo Eume 30 29 72 18
TEMPORADA 2022/2023
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 SD Sarriana SD Sarriana 38 79 31 83
2 Betanzos CF Betanzos CF 38 83 38 82
3 Boiro Boiro 38 74 25 79
4 Noia Noia 38 70 28 79
5 San Tirso SD Tirso 38 74 43 57
6 Dubra Dubra 38 51 54 56
7 SDC Residencia Residencia 38 51 46 55
8 Galicia Mugardos Galicia 38 53 43 55
9 SD Sofán SD Sofán 38 55 59 54
10 Ribadeo FC Ribadeo FC 38 53 62 53
11 O Pino O Pino 38 66 80 52
12 At. Coruña Montañeros Coruña 38 62 55 51
13 Sigueiro CF Sigueiro CF 38 55 50 51
14 Club Lemos Club Lemos 38 55 57 50
15 Victoria CF Victoria CF 38 53 51 49
16 As Pontes As Pontes 38 47 52 49
17 Club Ordenes SD Club Ordenes 38 49 54 46
18 CD Union CD Union 38 49 71 42
19 SD Fisterra SD Fisterra 38 30 143 15
20 Portomarín Portomarín 38 31 98 9
TEMPORADA 2021/2022
PREFERENTE GALICIA GRUPO 8
Equipo PJ GF GC Puntos
1 Victoria CF Victoria CF 8 7 5 17
2 San Tirso SD Tirso 8 7 7 17
3 Laracha Laracha 8 12 15 16
4 CD Foz CD Foz 8 8 8 12
5 Boimorto CF Boimorto CF 8 12 11 10
TEMPORADA 2020/2021
PREFERENTE GALICIA GRUPO 9
Equipo PJ GF GC Puntos
1 Victoria CF Victoria CF 2 6 2 4
2 Dubra Dubra 2 5 4 4
3 Santaballés Santaballés 2 2 7 0
TEMPORADA 2019/2020
PRIMERA GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Victoria CF Victoria CF 25 70 14 65
2 Betanzos CF Betanzos CF 25 53 22 53
3 Club Ordenes SD Club Ordenes 25 52 30 50
4 Sporting Sada Sporting 25 43 32 39
5 AD Miño AD Miño 25 43 37 38
6 Sporting Cambre Sporting 25 31 25 37
7 Cedeira SD Cedeira SD 25 36 31 37
8 Olimpico CF Olimpico CF 25 47 39 33
9 Eume Deportivo Eume 25 34 33 32
10 Brexo Lema Brexo Lema 25 37 37 32
11 Ud Carral Ud Carral 25 41 49 32
12 Club Deportivo Naron Club 25 40 43 31
13 Sporting Meicende Sporting 25 25 39 29
14 Club do Mar de Caion Club Caion 25 29 44 27
15 Sd O Val Sd O Val 25 34 53 24
16 Sporting Ciudad AC y D Sporting 25 26 51 22
17 Valdoviño SD Valdoviño 25 31 57 22
18 SE Abella SE Abella 25 25 61 12
TEMPORADA 2018/2019
PRIMERA GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Sdc Galicia Mugardos Galicia 34 98 27 82
2 Victoria CF Victoria CF 34 74 27 74
3 Betanzos CF Betanzos CF 34 73 37 64
4 Olimpico CF Olimpico CF 34 62 51 56
5 Club Deportivo Naron Club 34 61 57 56
6 Ud Carral Ud Carral 34 56 56 54
7 Cedeira SD Cedeira SD 34 51 58 47
8 Eume Deportivo Eume 34 49 50 45
9 AD Miño AD Miño 34 43 52 45
10 Sporting Sada Sporting 34 34 50 42
11 Sporting Ciudad AC y D Sporting 34 44 58 40
12 Brexo Lema Brexo Lema 34 58 65 39
13 Sd O Val Sd O Val 34 60 67 38
14 Sporting Cambre Sporting 34 42 58 38
15 Orillamar SD Orillamar 34 47 54 37
16 Cultural Maniños Cultural 34 42 52 36
17 Imperator OAR Imperator 34 40 55 35
18 Ortigueira Ortigueira 34 26 86 21
TEMPORADA 2017/2018
PRIMERA GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 At. Coruña Montañeros Coruña 34 78 29 79
2 Ud Carral Ud Carral 34 87 44 72
3 Victoria CF Victoria CF 34 79 34 71
4 Eume Deportivo Eume 34 68 53 63
5 Sdc Galicia Mugardos Galicia 34 57 35 61
6 Olimpico CF Olimpico CF 34 74 48 60
7 AD Miño AD Miño 34 59 50 59
8 Cedeira SD Cedeira SD 34 60 57 53
9 Sporting Cambre Sporting 34 47 50 48
10 Orillamar SD Orillamar 34 58 60 46
11 Brexo Lema Brexo Lema 34 43 49 44
12 O Val O Val 34 61 67 42
13 Ortigueira Ortigueira 34 47 62 37
14 Sporting Sada Sporting 34 44 54 35
15 Atletico San Pedro Atletico 34 42 69 29
16 Queixas Queixas 34 39 76 25
17 SE Abella SE Abella 34 34 78 24
18 Portazgo S.D. Portazgo 34 24 86 15
TEMPORADA 2016/2017
PRIMERA GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Boimorto CF Boimorto CF 34 82 38 78
2 O Val O Val 34 78 47 69
3 AD Miño AD Miño 34 64 36 69
4 San Tirso SD Tirso 34 81 38 67
5 Victoria CF Victoria CF 34 77 44 63
6 At. Coruña Montañeros Coruña 34 65 53 60
7 Queixas Queixas 34 58 65 48
8 Cedeira SD Cedeira SD 34 51 59 43
9 Eume Deportivo Eume 33 59 76 43
10 Ud Carral Ud Carral 34 47 50 41
11 Brexo Lema Brexo Lema 34 57 75 41
12 Olimpico CF Olimpico CF 34 62 68 40
13 SE Abella SE Abella 33 53 61 39
14 Portazgo S.D. Portazgo 34 43 56 37
15 Sporting Ciudad AC y D Sporting 34 48 67 35
16 Marino CF Marino CF 34 61 72 34
17 Club do Mar de Caion Club Caion 34 42 78 30
18 Cultural Maniños Cultural 34 43 88 14
TEMPORADA 2015/2016
PRIMERA GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Betanzos CF Betanzos CF 34 79 34 73
2 AD Miño AD Miño 34 71 32 67
3 Eume Deportivo Eume 34 70 49 59
4 Olimpico CF Olimpico CF 34 72 47 58
5 Boimorto CF Boimorto CF 34 65 54 56
6 Marino CF Marino CF 34 65 55 55
7 Victoria CF Victoria CF 34 61 54 54
8 Brexo Lema Brexo Lema 34 65 55 53
9 Club do Mar de Caion Club Caion 34 37 39 47
10 San Tirso SD Tirso 34 63 66 47
11 Ud Carral Ud Carral 34 63 65 46
12 SE Abella SE Abella 34 52 47 45
13 Cedeira SD Cedeira SD 34 51 49 44
14 Sporting Ciudad AC y D Sporting 34 59 69 40
15 Maravillas S.D. Maravillas 34 38 59 34
16 Orillamar SD Orillamar 34 51 77 31
17 Rapido de Neda Rapido Neda 34 45 87 25
18 Imperator OAR Imperator 34 37 106 14
TEMPORADA 2014/2015
PRIMERA GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 UD Paiosaco UD Paiosaco 34 73 40 64
2 San Tirso SD Tirso 34 49 39 64
3 Victoria CF Victoria CF 34 72 35 62
4 Marino CF Marino CF 34 56 38 55
5 Boimorto CF Boimorto CF 34 74 59 50
6 Olimpico CF Olimpico CF 34 66 57 49
7 Cedeira SD Cedeira SD 34 47 35 48
8 Rapido de Neda Rapido Neda 34 42 44 48
9 Ud Carral Ud Carral 34 70 66 47
10 Club do Mar de Caion Club Caion 34 39 35 46
11 Orillamar SD Orillamar 34 55 52 46
12 Eume Deportivo Eume 34 63 57 45
13 Sporting Ciudad AC y D Sporting 34 59 51 43
14 Imperator OAR Imperator 34 47 50 43
15 Narón BP Narón BP 34 64 76 43
16 Meiras CF Meiras CF 34 30 66 32
17 CD Ciudad CD Ciudad 34 42 101 29
18 Cultural Maniños Cultural 34 38 85 27

  USO DE MEMORIA  
6,170,152 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1196
Total Execution Time  0.1208
  CADENA URL  
/historico/Victoria-Galicia-Cf
  GET DATOS  
$_GET['/historico/Victoria-Galicia-Cf']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0032  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Victoria-Galicia-Cf' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=18893 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=18893 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=18893 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 74656
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18893 AND type_rel = 2
0.0023  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '18893' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '18893' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74656 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=18893 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (74656,73534) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 73534 AND teamId = 18893
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 74656 AND teamId = 18893
0.0022  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '18893' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18893' and rp.type = 4
0.0020  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '18893' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73534 WHERE rp.league_id = 73534 AND rp.teamId = 18893 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73534 WHERE rp.league_id = 73534 AND rp.teamId = 18893 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73534 WHERE rp.league_id = 73534 AND rp.teamId = 18893 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 18893 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2023` 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 = 68756 AND t.round = 38 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 `tables2022` 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 = 64090 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.0020  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 `tables2022` 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 = 67012 AND t.round = 10 ORDER BY team.conference ASC,t.position 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 `tables2021` 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 = 61701 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables2021` 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 = 62846 AND t.round = 3 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 `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 = 51294 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.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 `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 = 45147 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 39704 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 = 34035 AND t.round = 34 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 = 16765 AND t.round = 34 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 `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 = 4051 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC