4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del At. Arnoia
TEMPORADA 2023/2024
PREFERENTE GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 Villalonga FC Villalonga 31 65 30 67
2 Céltiga FC Céltiga FC 31 63 34 58
3 CD Valladares Valladares 31 56 40 53
4 Choco Choco 31 54 39 53
5 Portonovo Portonovo 31 55 46 47
6 Porriño Industrial Porriño 31 53 44 47
7 Cambados Cambados 31 48 52 44
8 Cultural Areas Cultural 31 41 49 43
9 Juvenil Ponteareas Juvenil 31 44 39 43
10 UD Atios UD Atios 31 42 36 42
11 Antela FC Antela FC 31 44 49 42
12 At. Arnoia At. Arnoia 31 46 53 42
13 Barco Barco 31 45 43 39
14 CD Moaña CD Moaña 31 39 54 38
15 Ribadumia Ribadumia 31 49 49 34
16 CD Velle CD Velle 31 32 57 26
17 Alertanavia CP Alertanavia 31 30 61 25
18 CD Allariz CD Allariz 31 37 68 19
TEMPORADA 2022/2023
PREFERENTE GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 Barbadás Barbadás 38 66 29 81
2 Pontevedra B Pontevedra 38 44 19 74
3 Juvenil Ponteareas Juvenil 38 64 42 61
4 Céltiga FC Céltiga FC 38 64 44 59
5 UD Atios UD Atios 38 50 38 57
6 Ribadumia Ribadumia 38 50 51 56
7 Porriño Industrial Porriño 38 58 57 55
8 Antela FC Antela FC 38 48 53 53
9 Portonovo Portonovo 38 63 55 53
10 Villalonga FC Villalonga 38 53 52 52
11 CD Valladares Valladares 38 50 55 52
12 Cambados Cambados 38 50 57 50
13 At. Arnoia At. Arnoia 38 51 47 50
14 Cultural Areas Cultural 38 55 51 50
15 Umia Umia 38 50 52 49
16 CD Beluso CD Beluso 38 52 54 49
17 Verín Verín 38 37 40 44
18 Pontellas Pontellas 38 36 56 38
19 Racing Castrelos Racing 38 39 87 27
20 Moraña Moraña 38 29 70 27
TEMPORADA 2021/2022
TERCERA FEDERACIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 CD Lugo B CD Lugo B 32 54 23 68
2 Ourense CF Ourense CF 32 48 21 67
3 Somozas Somozas 32 43 30 63
4 Barco Barco 32 50 37 54
5 Deportivo Fabril Deportivo 32 49 23 53
6 Rápido de Bouzas Rápido 32 39 26 51
7 RC Villalbés Villalbés 32 43 24 50
8 CD Estradense Estradense 32 36 40 44
9 Alondras CF Alondras CF 32 30 29 40
10 Silva SD Silva SD 32 34 41 39
11 CSD Arzua CSD Arzua 32 29 35 38
12 Viveiro Viveiro 32 32 42 36
13 Choco Choco 32 32 43 35
14 Noia Noia 32 30 49 29
15 Juvenil Ponteareas Juvenil 32 25 43 28
16 At. Arnoia At. Arnoia 32 25 54 22
17 SD Sofán SD Sofán 32 29 68 17
TEMPORADA 2020/2021
PREFERENTE GALICIA GRUPO 8
Equipo PJ GF GC Puntos
1 Celta C – Gran Peña Celta Gran. 3 5 5 7
2 Juvenil Ponteareas Juvenil 3 5 5 7
3 At. Arnoia At. Arnoia 3 1 2 7
4 Barbadás Barbadás 3 3 2 6
5 Villalonga FC Villalonga 3 6 5 5
6 Cultural Areas Cultural 3 4 5 3
TEMPORADA 2019/2020
PREFERENTE GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ribadumia Ribadumia 26 41 14 56
2 UD Atios UD Atios 26 55 20 51
3 Cultural Areas Cultural 26 54 37 49
4 Céltiga FC Céltiga FC 26 49 31 46
5 Villalonga FC Villalonga 26 44 34 46
6 Barbadás Barbadás 26 50 32 45
7 Mondariz CF Mondariz CF 26 35 29 45
8 At. Arnoia At. Arnoia 26 33 30 41
9 CD Moaña CD Moaña 26 45 37 39
10 Pontevedra B Pontevedra 26 40 46 34
11 Porriño Industrial Porriño 26 34 43 34
12 Sanxenxo Sanxenxo 26 22 27 33
13 Juvenil Ponteareas Juvenil 26 48 38 32
14 CD Beluso CD Beluso 26 34 46 29
15 Cambados Cambados 26 33 47 29
16 CD Velle CD Velle 26 32 37 28
17 Celta C – Gran Peña Celta Gran. 26 25 46 26
18 Portonovo Portonovo 26 29 38 25
19 CD Valladares Valladares 26 22 52 15
20 Poligono San Ciprian Poligono 26 15 56 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
SEGUNDA GALICIA GRUPO 9
Equipo PJ GF GC Puntos
1 Ourense UD Ourense UD 34 135 37 86
2 At. Arnoia At. Arnoia 34 78 36 76
3 Loñoá Loñoá 34 99 54 66
4 Arrabaldo Arrabaldo 34 90 61 64
5 Santa Teresita Santa 34 91 54 62
6 Amoeiro Amoeiro 34 71 45 62
7 AD Covadonga Covadonga 34 96 75 57
8 Ribadavia At. Ribadavia 34 70 75 43
9 CD Cea CD Cea 34 57 75 41
10 Melias Melias 34 77 76 39
11 Atlético Pontedeva Atlético 34 65 84 39
12 Leiro Leiro 34 55 65 39
13 Caldelao Caldelao 34 49 82 38
14 Palmes CD Palmes CD 34 65 94 35
15 Coles Coles 34 46 85 31
16 Barra de Miño Barra Miño 34 56 103 30
17 Trives Trives 34 45 90 28
18 Atlético Velle Atlético 34 44 98 20
TEMPORADA 2014/2015
SEGUNDA GALICIA GRUPO 9
Equipo PJ GF GC Puntos
1 A Peroxa CF A Peroxa CF 34 117 42 83
2 Francelos Francelos 34 90 42 79
3 Maside Maside 34 101 38 78
4 At. Arnoia At. Arnoia 34 81 50 65
5 Loñoá Loñoá 34 61 45 59
6 Arrabaldo Arrabaldo 34 84 67 55
7 Trives Trives 34 54 64 48
8 Amoeiro Amoeiro 34 65 60 45
9 Atlético Pontedeva Atlético 34 83 86 45
10 Santa Teresita Santa 34 62 62 44
11 Atlético Velle Atlético 34 44 52 43
12 CD Cea CD Cea 34 60 83 41
13 Coles Coles 34 57 65 40
14 Leiro Leiro 34 48 75 36
15 Atlético A Peroxa Atlético 34 43 75 33
16 Caldelao Caldelao 34 49 96 28
17 Padrenda CF Padrenda CF 34 23 72 26
18 Moreiras Moreiras 34 47 95 19

  USO DE MEMORIA  
6,294,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1190
Total Execution Time  0.1202
  CADENA URL  
/historico/Arnoia
  GET DATOS  
$_GET['/historico/Arnoia']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0063  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 = 'Arnoia' 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.0023  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=20221 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=20221 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=20221 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0063  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.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20221 AND type_rel = 2
0.0041  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 = '20221' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0041  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 = '20221' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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.0031  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=20221 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022  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,73535) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 73535 AND teamId = 20221
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 74656 AND teamId = 20221
0.0044  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 = 73535 WHERE rp.league_id = 73535 AND rp.teamId = 20221 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.0040  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 = 73535 WHERE rp.league_id = 73535 AND rp.teamId = 20221 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 = 73535 WHERE rp.league_id = 73535 AND rp.teamId = 20221 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 = 20221 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 = 73535 AND t.round = 31 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 `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 = 68757 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.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 = 62385 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.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 `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 = 61704 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.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 = 62844 AND t.round = 4 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 `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 = 51174 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.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 = 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.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 = 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.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 `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 = 16825 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 `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 = 4352 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC