4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sarria Ter A
TEMPORADA 2023/2024
3ª CATALANA GRUPO 3
Equipo PJ GF GC Puntos
1 Amer CF Amer CF 0 0 0 0
2 Besalú Besalú 0 0 0 0
3 Campdevanol UE Campdevanol 0 0 0 0
4 Camprodon Camprodon 0 0 0 0
5 CE Abadessenc Abadessenc 0 0 0 0
6 Comacros Comacros 0 0 0 0
7 Cornella Terri AE Cornella 0 0 0 0
8 Escola F. Garrotxa A Escola 0 0 0 0
9 Fontcoberta A Fontcoberta 0 0 0 0
10 Hostoles A Hostoles A 0 0 0 0
11 Les Preses CF Preses 0 0 0 0
12 Sant Gregori AE Sant Gregori 0 0 0 0
13 Sant Ponç At. Sant Ponç 0 0 0 0
14 Sant Privat D'En Bas A Sant Privat 0 0 0 0
15 SantJoanenc SantJoanenc 0 0 0 0
16 Sarria Ter A Sarria 0 0 0 0
TEMPORADA 2022/2023
3ª CATALANA GRUPO 18
Equipo PJ GF GC Puntos
1 Fornells UE Fornells UE 34 95 41 82
2 Amer CF Amer CF 33 76 41 66
3 CE Abadessenc Abadessenc 34 69 44 64
4 Sarria Ter A Sarria 33 87 72 62
5 Campdevanol UE Campdevanol 34 76 53 60
6 Sant Gregori AE Sant Gregori 34 78 66 59
7 Fontcoberta A Fontcoberta 34 62 46 53
8 Camprodon Camprodon 34 65 59 49
9 Comacros Comacros 33 62 68 47
10 Sant Ponç At. Sant Ponç 33 55 59 46
11 Cornella Terri AE Cornella 34 66 72 45
12 Sant Privat D'En Bas A Sant Privat 33 46 57 45
13 Les Preses CF Preses 34 65 65 42
14 Escola F. Garrotxa A Escola 32 59 66 35
15 Atlètic Club Banyoles Atlètic 34 58 73 31
16 Cellera A Cellera A 34 62 98 27
17 Les Planes CF Planes 34 52 97 20
18 Santa Pau P Santa Pau P 33 41 97 17
TEMPORADA 2021/2022
4ª CATALANA GRUPO 29
Equipo PJ GF GC Puntos
1 Sarria Ter A Sarria 31 114 49 74
2 Monells AE Monells AE 29 92 28 69
3 La Punxa CF A Punxa 28 104 48 67
4 Comacros B Comacros B 31 76 64 60
5 Escola Baix Ter A Escola Baix 30 80 54 57
6 Jafre A Jafre A 28 83 63 45
7 Camallera A Camallera A 27 58 40 45
8 Mont-Ras CE Mont-Ras CE 27 60 74 38
9 La Pera A La Pera A 30 59 82 36
10 Mas Mascort De Palafrugell Mascort 30 48 61 35
11 Medes LEstartit FC Medes 29 56 72 34
12 Sant Ponç B Sant Ponç 27 54 44 30
13 Penya Bons Aires E B Penya Bons. 27 58 72 25
14 Sant Antoni Sant Antoni 31 52 93 25
15 Pals B Pals B 29 32 78 21
16 Fundacio Esportiva Palamos Fundacio 30 34 107 12
17 Flaça B Flaça B 8 7 38 3
TEMPORADA 2020/2021
4ª CATALANA GRUPO 29
Equipo PJ GF GC Puntos
1 Olimpic Malgrat B Olimpic 4 15 0 12
2 CE Cristinenc Cristinenc 4 19 6 12
3 Monells AE Monells AE 3 5 2 6
4 Flaça A Flaça A 3 8 6 6
5 Medes LEstartit FC Medes 4 8 10 6
6 Sarria Ter A Sarria 2 12 9 4
7 Albons Club Futbol A Albons Club 2 3 2 4
8 Penya Bons Aires E B Penya Bons. 4 7 9 4
9 Escola Baix Ter A Escola Baix 4 4 7 4
10 Camallera A Camallera A 4 3 9 4
11 La Pera A La Pera A 3 11 14 3
12 Sant Ponç B Sant Ponç 4 6 10 3
13 Pals B Pals B 4 3 15 3
14 Pontenc Club Esportiu A A Pontenc Club 4 8 10 2
15 Comacros B Comacros B 2 1 2 1
16 Sant Antoni Sant Antoni 0 0 0 0
17 Mont-Ras CE Mont-Ras CE 1 1 3 0
TEMPORADA 2019/2020
4ª CATALANA GRUPO 29
Equipo PJ GF GC Puntos
TEMPORADA 2018/2019
4ª CATALANA GRUPO 29
Equipo PJ GF GC Puntos
1 Verges Verges 32 98 45 75
2 Caldes Malavella Caldes 32 108 61 66
3 Bellcaire 2012 Bellcaire 30 86 36 61
4 Albons Club Futbol A Albons Club 29 63 49 57
5 Sarria Ter A Sarria 31 97 65 53
6 Camallera A Camallera A 29 73 46 53
7 Viladamat CF Viladamat 29 77 52 53
8 Medes LEstartit FC Medes 30 64 57 53
9 Monells AE Monells AE 32 73 73 45
10 Jafre A Jafre A 27 46 64 37
11 La Pera A La Pera A 31 66 76 34
12 Montessori-Palau A Montessori-P 30 58 69 34
13 FE Palamós A Palamós 28 52 101 27
14 Sant Gregori B Sant Gregori 29 55 81 25
15 La Salle Girona A Salle Girona 29 49 81 24
16 Mont-Ras CE Mont-Ras CE 30 39 102 14
17 Lloretenc 2016 B Lloretenc 16 8 54 2
TEMPORADA 2017/2018
4ª CATALANA GRUPO 29
Equipo PJ GF GC Puntos
1 Quart B Quart B 28 74 33 66
2 Sauleda Sauleda 30 96 46 65
3 Pals Atletic Pals Atletic 29 55 29 57
4 Can Gibert B Gibert 29 67 39 53
5 Sarria Ter A Sarria 28 86 64 50
6 Verges Verges 28 73 52 50
7 Viladamat CF Viladamat 30 62 51 49
8 Jafre A Jafre A 28 70 64 48
9 Bellcaire 2012 Bellcaire 28 69 51 41
10 Camallera A Camallera A 29 57 63 37
11 Flaça A Flaça A 30 62 99 27
12 Albons A Albons A 27 44 68 26
13 La Pera A La Pera A 29 54 83 26
14 Medes LEstartit FC Medes 28 41 73 24
15 Sant Gregori B Sant Gregori 29 59 98 23
16 Idem Salt Club Esportiu Idem Salt C. 26 22 78 9
TEMPORADA 2015/2016
3ª CATALANA GRUPO 17
Equipo PJ GF GC Puntos
1 Campdevanol UE Campdevanol 34 96 44 77
2 Sant Jaume de Llierca Sant Jaume. 34 86 46 72
3 Girones-Sabat Girones-Saba 34 79 45 69
4 Caldes Malavella UE Caldes 34 67 35 68
5 Porqueres Porqueres 34 78 44 67
6 Quart Quart 34 72 38 63
7 Hostoles A Hostoles A 34 73 61 55
8 Santa Pau P Santa Pau P 34 68 56 51
9 Celra A Celra A 34 56 56 49
10 Fornells UE Fornells UE 34 66 81 42
11 Amer CF Amer CF 34 77 82 42
12 SantJoanenc SantJoanenc 34 60 78 42
13 Les Preses CF Preses 34 50 67 35
14 Atlètic Club Banyoles Atlètic 34 58 80 34
15 Arbucies CF Arbucies CF 34 48 76 32
16 Ripoll CF Ripoll CF 34 41 74 30
17 Sant Esteve D'En Bas Sant Esteve 34 49 121 21
18 Sarria Ter A Sarria 34 56 96 19
TEMPORADA 2014/2015
4ª CATALANA GRUPO 28
Equipo PJ GF GC Puntos
1 Sarria Ter A Sarria 22 60 37 51
2 Celra A Celra A 22 53 28 48
3 La Salle Girona A Salle Girona 22 57 24 45
4 Quart B Quart B 22 55 32 44
5 Pontenc Esportiu A Pontenc 22 64 29 43
6 Camos A Camos A 22 22 35 26
7 Flaça A Flaça A 22 35 42 25
8 Vila-Roja A Vila-Roja A 22 48 60 25
9 Llagostera C Llagostera 22 37 59 18
10 Bescano B Bescano B 22 23 50 16
11 Sant Gregori B Sant Gregori 22 32 52 14
12 Comacros Comacros 22 19 57 11
13 Guixols C Guixols C 0 0 0 0
14 Sant Jordi Desvalls A Sant Jordi. 0 0 0 0

  USO DE MEMORIA  
5,642,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1024
Total Execution Time  0.1039
  CADENA URL  
/historico/Sarria-Ter-A
  GET DATOS  
$_GET['/historico/Sarria-Ter-A']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0031  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 = 'Sarria-Ter-A' 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=24264 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=24264 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 73169
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=24264 AND type_rel = 2
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 = '24264' 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 = '24264' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '24264' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 73169 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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=24264 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73169) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73169 AND teamId = 24264
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 73169 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '24264' 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 = '24264' 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 = '24264' 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 = 73169 WHERE rp.league_id = 73169 AND rp.teamId = 24264 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.0021  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 = 73169 WHERE rp.league_id = 73169 AND rp.teamId = 24264 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 = 73169 WHERE rp.league_id = 73169 AND rp.teamId = 24264 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 24264 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 = 73169 AND t.round = 27 ORDER BY team.conference ASC,t.position 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 `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 = 69330 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.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 `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 = 64541 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 = 58930 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 51621 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.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 `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 = 44544 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 39213 AND t.round = 30 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 = 16680 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 `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 = 4758 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC