4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atletico VIllariño
TEMPORADA 2023/2024
SEGUNDA GALICIA GRUPO 10
Equipo PJ GF GC Puntos
1 Viana Viana 27 80 27 65
2 Corgomo Vilamartín Corgomo 28 84 33 61
3 Atletico VIllariño Atletico 28 67 27 59
4 La Purísima Purísima 27 49 30 51
5 UP Taboadela Taboadela 27 42 29 47
6 Paderne Paderne 27 52 37 46
7 Raio Alaricano Raio 28 50 38 44
8 Rocas CD Rocas CD 27 53 35 43
9 Antela B Antela B 27 58 41 42
10 Pabellon Ourense Pabellon 27 35 31 38
11 Piñeira Seca Piñeira 28 54 48 37
12 Trives Trives 27 35 52 24
13 Soutopenedo Soutopenedo 27 27 55 21
14 Vilar de Barrio Vilar Barrio 27 29 69 17
15 A Bola CD A Bola CD 27 24 65 16
16 Parada do Sil Parada 27 11 133 0
TEMPORADA 2022/2023
PRIMERA GALICIA GRUPO 4
Equipo PJ GF GC Puntos
1 CD Allariz CD Allariz 34 80 32 76
2 CF Monterrey Monterrey 34 62 29 73
3 CD Velle CD Velle 34 68 30 69
4 Sporting Celanova Sporting 34 63 38 60
5 Poligono San Ciprian Poligono 34 53 37 59
6 A Peroxa CF A Peroxa CF 34 58 45 56
7 SD Nogueira de Ramuín Nogueira 34 53 38 52
8 Sporting Carballino Sporting 34 57 60 52
9 Cartelle Cartelle 34 59 56 44
10 Maside Maside 34 50 61 43
11 UD Barbadas B Barbadas 34 56 60 40
12 Melias Melias 34 59 61 39
13 C.D. Seixalbo C.D. 34 46 73 37
14 Loñoá Loñoá 34 38 50 36
15 Santa Teresita Santa 34 55 76 36
16 Atletico VIllariño Atletico 34 44 66 26
17 CF Cortegada Cortegada 34 56 101 26
18 Pabellon Ourense Pabellon 34 34 78 24
TEMPORADA 2021/2022
PRIMERA GALICIA GRUPO 14
Equipo PJ GF GC Puntos
1 Antela FC Antela FC 8 20 9 21
2 CD Allariz CD Allariz 8 14 10 20
3 Sporting Celanova Sporting 8 20 13 18
4 A Peroxa CF A Peroxa CF 8 10 12 16
5 UD Barbadas B Barbadas 8 16 15 13
6 Maside Maside 8 10 14 10
7 Atletico VIllariño Atletico 8 11 16 9
8 Sporting Carballino Sporting 8 16 28 4
TEMPORADA 2019/2020
SEGUNDA GALICIA GRUPO 9
Equipo PJ GF GC Puntos
1 Atletico VIllariño Atletico 23 81 18 61
2 CF Cortegada Cortegada 22 60 26 51
3 Leiro Leiro 23 67 22 50
4 Coles Coles 23 43 33 42
5 Salamonde CF Salamonde 22 31 26 39
6 Vilamarin Vilamarin 23 40 32 36
7 Atlético Pontedeva Atlético 23 50 43 36
8 Trives Trives 22 28 33 32
9 CD Rua CD Rua 22 36 41 30
10 Amoeiro Amoeiro 22 37 37 25
11 Toen FS Toen FS 22 27 35 25
12 Velle B Velle B 22 33 54 25
13 Rocas CD Rocas CD 22 20 44 19
14 Cenlle CD Cenlle CD 22 17 51 15
15 Barra de Miño Barra Miño 23 21 60 14
16 Arrabaldo Arrabaldo 22 27 63 11
TEMPORADA 2018/2019
PRIMERA GALICIA GRUPO 4
Equipo PJ GF GC Puntos
1 At. Arnoia At. Arnoia 34 86 45 78
2 Poligono San Ciprian Poligono 34 80 30 67
3 Melias Melias 34 73 39 65
4 SD Nogueira de Ramuín Nogueira 34 77 44 60
5 CD Allariz CD Allariz 34 61 43 60
6 Sporting Celanova Sporting 34 78 55 56
7 A Peroxa CF A Peroxa CF 34 84 63 50
8 Verín Verín 33 34 41 49
9 AD Covadonga Covadonga 34 58 66 46
10 SD Valenza SD Valenza 33 50 49 43
11 CF Monterrey Monterrey 34 52 68 42
12 Loñoá Loñoá 34 48 51 41
13 Francelos Francelos 34 57 68 41
14 Maside Maside 34 48 64 37
15 Maceda Maceda 34 39 67 35
16 CF Cortegada Cortegada 34 49 72 31
17 C.D. Seixalbo C.D. 34 39 81 22
18 Atletico VIllariño Atletico 34 29 96 21
TEMPORADA 2017/2018
PRIMERA GALICIA GRUPO 4
Equipo PJ GF GC Puntos
1 CD Velle CD Velle 34 91 31 77
2 Antela FC Antela FC 34 80 37 71
3 Verín Verín 33 80 43 68
4 Poligono San Ciprian Poligono 34 76 35 60
5 Sporting Celanova Sporting 34 61 47 58
6 At. Arnoia At. Arnoia 34 65 58 57
7 CD Allariz CD Allariz 34 51 42 50
8 Maside Maside 34 59 51 49
9 CF Monterrey Monterrey 34 60 54 46
10 A Peroxa CF A Peroxa CF 34 60 57 45
11 Loñoá Loñoá 34 65 68 45
12 Francelos Francelos 34 49 63 43
13 Atletico VIllariño Atletico 34 50 54 41
14 SD Valenza SD Valenza 34 45 69 41
15 CF Cortegada Cortegada 33 42 61 35
16 Rante S. Cibrao Viñas Rante Cibrao 34 43 73 35
17 Viana Viana 34 29 100 18
18 Atlético Pontedeva Atlético 34 36 99 15
TEMPORADA 2016/2017
PRIMERA GALICIA GRUPO 4
Equipo PJ GF GC Puntos
1 SD Bande SD Bande 33 102 22 90
2 Ourense UD Ourense UD 33 81 25 81
3 Ribeiro FC Ribeiro FC 34 68 34 60
4 CD Velle CD Velle 34 72 44 57
5 At. Arnoia At. Arnoia 34 77 61 54
6 Maside Maside 34 68 59 54
7 CD Allariz CD Allariz 34 53 56 49
8 CF Monterrey Monterrey 34 46 54 48
9 Atletico VIllariño Atletico 34 50 55 47
10 Sporting Celanova Sporting 34 62 62 44
11 Antela FC Antela FC 34 53 67 43
12 A Peroxa CF A Peroxa CF 34 56 68 42
13 Francelos Francelos 34 52 68 39
14 Viana Viana 34 58 94 39
15 CF Cortegada Cortegada 34 40 56 37
16 UP Taboadela Taboadela 34 43 72 32
17 A Manchica A Manchica 34 49 85 23
18 Xunqueira de Ambia Xunqueira 34 37 85 16
TEMPORADA 2015/2016
PRIMERA GALICIA GRUPO 4
Equipo PJ GF GC Puntos
1 SD Nogueira de Ramuín Nogueira 34 74 27 76
2 Poligono San Ciprian Poligono 34 68 37 67
3 SD Bande SD Bande 34 70 39 65
4 CD Allariz CD Allariz 34 63 40 60
5 Ribeiro FC Ribeiro FC 34 57 37 59
6 A Peroxa CF A Peroxa CF 34 70 60 51
7 CD Velle CD Velle 34 40 32 49
8 Maside Maside 33 68 63 48
9 Atletico VIllariño Atletico 34 55 70 44
10 A Manchica A Manchica 34 55 61 42
11 UP Taboadela Taboadela 34 53 64 40
12 Francelos Francelos 32 48 52 40
13 Antela FC Antela FC 34 44 55 40
14 Sporting Celanova Sporting 34 48 58 40
15 CF Cortegada Cortegada 33 49 71 38
16 CD Rua CD Rua 34 47 64 37
17 SD Valenza SD Valenza 34 41 61 33
18 Piñeira Seca Piñeira 34 37 96 18
TEMPORADA 2014/2015
PRIMERA GALICIA GRUPO 4
Equipo PJ GF GC Puntos
1 CF Monterrey Monterrey 34 83 27 72
2 Barbadas B Barbadas B 34 74 27 68
3 Ourense CF Ourense CF 34 60 35 65
4 Poligono San Ciprian Poligono 34 78 46 58
5 CD Allariz CD Allariz 34 60 45 58
6 SD Bande SD Bande 34 48 35 49
7 UP Taboadela Taboadela 34 50 45 49
8 SD Valenza SD Valenza 34 48 49 49
9 CD Velle CD Velle 34 48 49 47
10 Ribeiro FC Ribeiro FC 34 61 60 44
11 Sporting Celanova Sporting 34 50 64 44
12 Atletico VIllariño Atletico 34 49 62 42
13 CD Rua CD Rua 34 38 56 42
14 Antela FC Antela FC 34 46 50 35
15 Atl. Barbantes Atl. 34 39 65 35
16 CF Cortegada Cortegada 34 38 68 33
17 AD Covadonga Covadonga 34 46 96 26
18 Melias Melias 34 46 83 25

  USO DE MEMORIA  
5,811,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.1000
Total Execution Time  0.1017
  CADENA URL  
/historico/Atletico-Villarino
  GET DATOS  
$_GET['/historico/Atletico-Villarino']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0027  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 = 'Atletico-Villarino' 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=18924 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=18924 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18924 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 714 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (369188,189167,170033,122664) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = '18924' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '18924' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '18924' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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=18924 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0025  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 (73706,68966) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 68966 AND teamId = 18924
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73706 AND teamId = 18924
0.0020  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 = '18924' 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 = '18924' 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 = '18924' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 73706 WHERE rp.league_id = 73706 AND rp.teamId = 18924 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.0020  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 = 73706 WHERE rp.league_id = 73706 AND rp.teamId = 18924 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 73706 WHERE rp.league_id = 73706 AND rp.teamId = 18924 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 18924 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024` 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 = 73706 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 = 68966 AND t.round = 34 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 `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 = 65125 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 67194 AND t.round = 8 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 `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 = 51434 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.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 = 45150 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 39707 AND t.round = 34 ORDER BY team.conference 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 `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 = 34038 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 16768 AND t.round = 34 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 = 4054 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC