4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Escola Gava C H
TEMPORADA 2021/2022
2ª CATALANA ALEVIN GRUPO 1
Equipo PJ GF GC Puntos
1 Palleja CF A Palleja 25 164 51 69
2 Abrera Abrera 23 111 27 60
3 Sant Andreu de la Barca A Sant Andreu 27 115 71 54
4 Corbera CF A Corbera 25 113 62 50
5 San Mauro A San Mauro A 23 121 48 47
6 Anoia A Anoia A 26 93 102 42
7 Molins de Rei A Molins 25 89 86 38
8 Martorell Associacio Esport Martorell 26 81 70 37
9 Odena A Odena A 25 79 86 37
10 Sant Esteve Sesrovires A Sant Esteve 28 92 125 29
11 Fundacio Atletic Vilafranca Fundacio 22 57 95 24
12 Escola Gava C H Escola Gava 26 73 115 24
13 Igualada CF F Igualada 25 69 110 19
14 Esparreguera A Esparreguera 25 45 123 11
15 EF Olesa 87 C A Olesa 25 33 164 7
TEMPORADA 2019/2020
2ª CATALANA ALEVIN GRUPO 1
Equipo PJ GF GC Puntos
1 Fundacio E Atletic Vilafran Fundacio 19 86 32 46
2 Escola Gava C H Escola Gava 19 114 34 45
3 Igualada CF D Igualada 18 118 40 44
4 Cubelles CF A Cubelles 19 107 38 44
5 San Mauro A San Mauro A 17 71 19 41
6 Piera AE A Piera AE A 18 90 54 37
7 Odena A Odena A 19 55 79 30
8 Vilanova Geltru CF B Vilanova 19 57 58 27
9 Atletic Sant Just . F C D Atletic Sant 19 66 67 26
10 Sitges UE A Sitges UE A 19 67 81 25
11 Base Olerdola CE A Base 19 57 109 18
12 Ribes CD A Ribes CD A 19 36 81 14
13 Blanca Subur CF B Blanca Subur 19 51 90 11
14 Anoia A Anoia A 19 39 99 11
15 Sant Sadurni UE A Sant Sadurni 19 48 113 9
16 Riudebitlles A Riudebitlles 19 42 110 7
TEMPORADA 2018/2019
3ª CATALANA ALEVIN GRUPO 44
Equipo PJ GF GC Puntos
1 Barcelona E Barcelona E 30 255 26 90
2 Sporting Gava 2013 Futbol C Sporting 29 255 30 76
3 Escola Gava C H Escola Gava 30 176 78 72
4 Sant Vicenç Dels Horts 2014 Sant Vicenç 29 181 87 63
5 Begues D Begues D 30 204 111 60
6 Fundacio Unio Esportiva Cor Fundacio 29 153 107 58
7 Castelldefels F Castelldefel 30 117 93 47
8 Gava Mar C Gava Mar C 30 125 118 45
9 Corbera C Corbera C 30 140 189 39
10 Atletic Sant Just C E Atletic Sant 30 97 187 34
11 Atletic Prat Delta C Atletic Prat 28 93 162 31
12 Athletic Viladecans Athletic 29 86 158 31
13 Escola Esportiva Llor A Escola 29 76 180 17
14 Almeda A Almeda A 30 74 187 17
15 Santboia G Santboia G 30 78 228 10
16 Santfeliuenc J Santfeliuenc 29 46 255 6
TEMPORADA 2017/2018
3ª CATALANA ALEVIN GRUPO 53
Equipo PJ GF GC Puntos
1 Athletic Viladecans Athletic 28 219 40 82
2 Fontsanta Fatjo B Fontsanta 29 170 46 77
3 Viladecans E Viladecans 30 152 57 70
4 Terlenka Barcelonista Club Terlenka 30 201 92 63
5 Sant Ildefons C Sant 30 161 85 63
6 Escola Gava C H Escola Gava 30 159 80 58
7 Atletic Prat Delta C Atletic Prat 30 127 111 45
8 Santfeliuenc H Santfeliuenc 30 133 119 40
9 Pª Recreativa San Feliu Llo Recreativa 30 101 90 39
10 Sporting Gava 2013 Futbol C Sporting 30 88 107 35
11 Vinyets Moli Vell A Vinyets Moli 30 89 149 27
12 Sector Montserratina F Sector 30 74 201 25
13 La Palma Cervello A Palma 29 81 143 24
14 Prat F Prat F 30 85 179 21
15 Atletic Sant Just C H Atletic Sant 30 57 205 12
16 Sant Joan Despi H Sant Joan D. 30 45 238 10
TEMPORADA 2016/2017
3ª CATALANA ALEVIN GRUPO 53
Equipo PJ GF GC Puntos
1 EFO 87 B EFO 87 B 26 246 35 75
2 Sporting Gava 2013 Futbol C Sporting 25 203 55 66
3 Espluguenc C Espluguenc 26 145 57 64
4 Sant Ildefons D Sant 26 169 88 54
5 Sant Andreu de La Barca Agr Sant Andreu 26 105 127 42
6 Escola Gava C H Escola Gava 26 147 113 40
7 Prat D Prat D 26 120 102 40
8 Santfeliuenc F Santfeliuenc 26 117 135 36
9 Viladecans G Viladecans 26 97 101 29
10 Sector Montserratina D Sector 26 79 139 23
11 Begues C Begues C 26 87 200 23
12 Pª Recreativa San Feliu Llo Recreativa 26 87 137 21
13 Atletic Prat Delta B B Atletic Prat 26 89 177 21
14 Sant Vicenç Assoc Esportiva Sant Vicenç 26 28 245 1
15 Incresa Atletico Club Futbo Incresa 1 0 8 0
TEMPORADA 2015/2016
3ª CATALANA ALEVIN GRUPO 20
Equipo PJ GF GC Puntos
1 Castelldefels G Castelldefel 30 209 53 76
2 Vinyets Moli Vell A Vinyets Moli 30 240 66 75
3 Escola Gava C H Escola Gava 30 207 66 73
4 Sporting Gava 2013 Futbol C Sporting 29 183 48 70
5 Atletic Sant Just C E Atletic Sant 30 162 80 68
6 Almeda D Almeda D 30 140 121 50
7 Cornella K Cornella K 30 116 97 47
8 Ciudad Cooperativa E Ciudad 30 110 138 44
9 Atlètic Prat A Atlètic 30 140 134 42
10 Sector Montserratina E Sector 30 129 117 40
11 Prat D Prat D 30 105 91 40
12 Santboia G Santboia G 30 92 179 27
13 Incresa Atletico Club Futbo Incresa 29 97 204 23
14 La Palma Cervello A Palma 30 84 196 17
15 Viladecans E Viladecans 30 70 255 9
16 Sant Joan Despi H Sant Joan D. 30 37 255 3
TEMPORADA 2014/2015
3ª CATALANA ALEVIN GRUPO 30
Equipo PJ GF GC Puntos
1 Can Vidalet C Vidalet 30 182 35 90
2 Marianao Poblet D Marianao 30 135 53 69
3 Gava Mar D Gava Mar D 30 125 76 65
4 Sales Viladecans Club Futbo Sales 30 148 56 61
5 Escola Gava C H Escola Gava 30 144 90 57
6 Prat F Prat F 30 112 88 54
7 Club Esportiu Ccr Gava A Club 30 100 71 49
8 Sant Just Desvern Club Futb Sant Just D. 30 104 109 46
9 Ciudad Cooperativa F Ciudad 30 95 91 42
10 Escola Esportiva Llor A Escola 30 104 85 41
11 Vista Alegre B Vista Alegre 30 104 102 35
12 Sporting Gava 2013 Futbol C Sporting 30 71 87 34
13 Escola Prat Blaugrana C Escola Prat 30 72 106 32
14 Sector Montserratina F Sector 30 51 218 11
15 Begues D Begues D 30 38 161 10
16 Castelldefels I Castelldefel 30 38 195 2

  USO DE MEMORIA  
5,317,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4048
Total Execution Time  0.4060
  CADENA URL  
/historico/Escola-F-Gava-C-H-Alevin
  GET DATOS  
$_GET['/historico/Escola-F-Gava-C-H-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0110  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 = 'Escola-F-Gava-C-H-Alevin' 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.0119  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 = 'Escola-F-Gava-C-H-Alevin' 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.0105  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=36819 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=36819 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=36819 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=36819 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=36819 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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=36819 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0113  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=36819 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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=36819 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0136  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 = 65783
0.0110  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=36819 AND type_rel = 2
0.0120  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 = '36819' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0111  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 = '36819' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108  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 = '36819' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0112  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=36819 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0108  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 (65783) 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.0107  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65783 AND teamId = 36819
0.0112  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 = '36819' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0116  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 = '36819' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0124  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 = 36819 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0124  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_base` 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 = 65783 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123  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_base` 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 = 54461 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124  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_base` 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 = 46767 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124  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_base` 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 = 41471 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  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_base` 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 = 36157 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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_base` 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 = 17811 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 6107 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC