4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del San Mauro A
TEMPORADA 2022/2023
1ª CATALANA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Can Vidalet B B Vidalet 29 114 37 74
2 San Mauro A San Mauro A 29 79 34 68
3 Escola F Gava C B Escola Gava 30 78 41 58
4 Igualada CF B Igualada 30 79 55 57
5 Vinyets Moli-Vell A Vinyets 27 60 42 48
6 Riudebitlles CD A Riudebitlles 30 76 60 48
7 Corbera A Corbera A 29 72 67 40
8 Sitges UE A Sitges UE A 29 52 58 40
9 Levante Las Planas FC A Levante 30 60 72 39
10 Fundacio E Atletic Vilafran Fundacio 29 56 48 38
11 Ribes CD A Ribes CD A 29 59 64 34
12 Vista Alegre A Vista Alegre 30 49 73 25
13 Pª Barc Sant Vicenç Horts A Barc Sant V. 30 39 79 25
14 Base Marc Bartra A Base Marc B. 29 43 89 23
15 Terlenka Barcelonista Club Terlenka 30 41 93 22
16 Castelldefels B Castelldefel 30 43 88 20
TEMPORADA 2021/2022
1ª CATALANA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Vilanova Geltru CF A Vilanova 30 87 21 77
2 Can Buxeres B Buxeres 30 85 35 66
3 Castelldefels C Castelldefel 30 77 44 62
4 Sitges UE A Sitges UE A 28 68 41 52
5 Escola F Gava C B Escola Gava 27 59 49 48
6 Corbera A Corbera A 29 69 52 44
7 Fundacio E Atletic Vilafran Fundacio 26 62 52 41
8 San Mauro A San Mauro A 29 68 62 41
9 Sant Cugat Sesgarrigues Clu Sant Cugat. 28 61 65 39
10 Sant Vicenç Dels Horts Sant Vicenç 29 50 64 37
11 Base Marc Bartra A Base Marc B. 29 60 90 31
12 Ciudad Cooperativa A A Ciudad 29 61 88 27
13 Ribes A Ribes A 28 40 75 27
14 Sporting Gava 2013 Futbol A Sporting 28 41 59 24
15 Martorell B Martorell B 27 36 69 20
16 Arrabal Calaf Gramanet B Arrabal 27 50 108 14
TEMPORADA 2020/2021
1ª CATALANA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Blanca Subur Sub 19 Blanca Subur 1 6 1 3
2 Santboia FC A Santboia 1 4 0 3
3 Base Marc Bartra A Base Marc B. 1 4 1 3
4 Corbera A Corbera A 1 3 0 3
5 San Mauro A San Mauro A 1 6 4 3
6 Escola F Gava C B Escola Gava 1 2 0 3
7 Anoia CE A Anoia CE A 1 1 0 3
8 Gelida CF A Gelida CF A 0 0 0 0
9 Igualada Sub 19 Igualada 0 0 0 0
10 Ribes A Ribes A 1 0 1 0
11 Cubelles CF A Cubelles 1 4 6 0
12 Vilanova Geltru CF A Vilanova 1 0 2 0
13 Fundacio E Atletic Vilafran Fundacio 1 1 4 0
14 Sitges UE A Sitges UE A 1 0 3 0
15 Martorell CF B Martorell 1 0 4 0
16 Sant Vicenç Dels Horts Sant Vicenç 1 1 6 0
TEMPORADA 2019/2020
1ª CATALANA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Marianao Poblet UD A Marianao 17 61 19 49
2 Santboia FC A Santboia 18 38 20 42
3 Escola F Gava C B Escola Gava 17 39 18 34
4 San Mauro A San Mauro A 18 44 35 34
5 Sant Vicenç Dels Horts Sant Vicenç 17 46 44 27
6 Sitges UE A Sitges UE A 15 34 26 26
7 Cubelles CF A Cubelles 17 35 33 23
8 Anoia CE A Anoia CE A 17 36 36 23
9 Vilanova Geltru CF A Vilanova 18 39 46 23
10 Igualada Sub 19 Igualada 18 27 32 22
11 Ribes A Ribes A 17 27 31 20
12 Blanca Subur CF A Blanca Subur 18 22 27 20
13 Base Marc Bartra A Base Marc B. 16 20 26 16
14 Martorell CF B Martorell 17 31 41 16
15 Gelida CF A Gelida CF A 17 21 53 11
16 Fundacio E Atletic Vilafran Fundacio 17 17 50 7
TEMPORADA 2018/2019
1ª CATALANA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Ciudad Cooperativa B Ciudad 29 94 31 72
2 Piera A Piera A 29 101 41 71
3 Escola Gava B Escola Gava 29 74 38 56
4 San Mauro A San Mauro A 27 72 41 45
5 Marianao Poblet B Marianao 27 58 52 45
6 Juv. 25 Setembre Juv. 26 77 56 40
7 Anoia A Anoia A 27 64 62 40
8 Base Marc Bartra A Base Marc B. 27 43 45 40
9 Sitges Sitges 27 83 66 39
10 Palleja A Palleja A 29 55 57 36
11 Cubelles B Cubelles B 28 63 74 31
12 Fundacio E Atletic Vilafran Fundacio 28 62 74 31
13 Sant Ildefons C Sant 29 53 69 31
14 Pª Blaugrana Vallirana A Blaugrana 27 57 68 29
15 Sant Joan Despi B Sant Joan D. 29 28 140 7
16 Sant Vicent Torello A Sant Vicent 12 7 77 0
TEMPORADA 2017/2018
1ª CATALANA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Barcelonista Terlenka A Barcelonista 30 130 36 82
2 Escola Gava C Escola Gava 30 91 37 71
3 Igualada Sub 19 Igualada 30 88 38 69
4 Vista Alegre A Vista Alegre 30 98 50 62
5 Marianao Poblet B Marianao 30 93 51 60
6 San Mauro A San Mauro A 30 72 63 51
7 Piera A Piera A 30 78 102 40
8 Sitges Sitges 30 59 65 36
9 Sant Ildefons C Sant 29 69 77 36
10 Fundacio E Atletic Vilafran Fundacio 30 57 77 34
11 Sant Joan Despi B Sant Joan D. 30 68 104 29
12 Cubelles B Cubelles B 30 55 100 26
13 Efo 87 A Efo 87 A 30 54 94 24
14 Ribes A Ribes A 30 51 84 22
15 Vilanova Geltru B Vilanova 30 49 100 22
16 Blanca Subur B Blanca Subur 29 45 79 17
TEMPORADA 2016/2017
2ª CATALANA JUVENIL GRUPO 22
Equipo PJ GF GC Puntos
1 Piera A Piera A 28 111 30 69
2 San Mauro A San Mauro A 27 124 30 68
3 Anoia A Anoia A 26 107 43 64
4 Ribes B Ribes B 27 132 39 63
5 Gelida A Gelida A 27 100 51 51
6 Masquefa Masquefa 26 115 58 50
7 Masquefa Club Esportiu A Masquefa 26 82 53 43
8 Igualada B Igualada B 28 75 54 41
9 Odena A Odena A 27 79 89 32
10 La Pobla Claramunt Pobla 27 60 95 26
11 Hostalets de Pierola A Hostalets 25 49 77 25
12 Sitges B Sitges B 28 49 88 24
13 Capellades A A Capellades 28 58 133 19
14 Base Olerdola B Base 28 36 175 6
15 Calaf A Calaf A 26 35 197 6
TEMPORADA 2015/2016
1ª CATALANA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Atletic Vilafranca A Atletic 29 107 29 77
2 Santfeliuenc Sub 19 Santfeliuenc 30 97 32 75
3 Ue Castelldefels Sub 19 Castelldefel 29 94 29 68
4 Vilanova Geltru B Vilanova 30 108 72 61
5 Efo 87 A Efo 87 A 30 97 64 58
6 Igualada Sub 19 Igualada 30 81 56 50
7 Molins de Rei A Molins 30 72 64 43
8 Atl Sant Just Sub 19 Sant Just 29 65 63 38
9 Marianao Poblet B Marianao 30 61 78 38
10 Blanca Subur B Blanca Subur 30 46 68 34
11 Levante las Planas A Levante 30 67 85 33
12 Sant Joan Despi B Sant Joan D. 30 51 78 33
13 Anoia A Anoia A 29 39 83 25
14 Odena A Odena A 29 50 94 24
15 Base Olerdola A Base 29 39 105 13
16 San Mauro A San Mauro A 30 30 104 7
TEMPORADA 2014/2015
PREFERENTE CATALANA JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 Manresa Sub 19 Manresa 30 81 24 70
2 Gimnástic Manresa Sub 19 Gimnástic 30 74 40 58
3 Escola Gava B Escola Gava 30 60 49 56
4 Junior A Junior A 30 65 46 48
5 Mercantil Sub 19 B Mercantil 30 56 47 48
6 Lleida Esportiu Terraferma Lleida 30 57 50 46
7 Segre A Segre A 30 43 43 45
8 Escola Tarrega A Escola 30 58 56 44
9 Jabac I Terrassa Sub 19 B Jabac 30 56 45 43
10 Europa C Europa C 30 61 46 38
11 San Cristobal A Cristobal 30 61 75 38
12 Sabadell Sub 19 Sabadell 30 50 65 38
13 Rubí Rubí 30 43 53 34
14 Igualada Sub 19 Igualada 30 37 46 33
15 Escola Comarcal Garrigues Escola 30 28 62 21
16 San Mauro A San Mauro A 30 24 107 8

  USO DE MEMORIA  
5,634,072 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5353
Total Execution Time  0.5365
  CADENA URL  
/historico/San-Mauro-Ud-A-Juvenil
  GET DATOS  
$_GET['/historico/San-Mauro-Ud-A-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0134  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 = 'San-Mauro-Ud-A-Juvenil' 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.0149  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 = 'San-Mauro-Ud-A-Juvenil' 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.0126  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=21109 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0134  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=21109 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=21109 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=21109 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=21109 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=21109 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=21109 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=21109 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=21109 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=21109 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=21109 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=721 AND type_rel = 3
0.0130  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 = '21109' ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '21109' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '21109' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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=21109 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0129  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 (69731) 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.0145  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69731 AND teamId = 21109
0.0134  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 = '21109' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0131  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '21109' and rp.type = 4
0.0136  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 = '21109' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0134  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 = 21109 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  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_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 = 69731 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.0129  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 = 64549 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.0128  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_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 = 59231 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 54270 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.0130  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 = 45669 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 39997 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 35541 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 17008 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 4530 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC