4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Santboia A
TEMPORADA 2022/2023
PREFERENTE CATALANA BENJAMIN SUB 10 GRUPO 1
Equipo PJ GF GC Puntos
1 Barcelona A Barcelona A 29 193 19 85
2 Fundación UE Cornellá B Fundación 30 169 43 81
3 Unio Base Jabac Terrassa A Unio Base J. 30 117 40 70
4 Manresa A Manresa A 30 89 56 53
5 Gimnastic Manresa C B Gimnastic 30 109 72 51
6 Can Rull R. Tronchoni Sub 1 Rull 30 66 49 50
7 Sant Andreu Sub 10 Sant Andreu 29 102 96 42
8 L'Hospitalet Centre Esports L'Hospitalet 30 80 94 42
9 Atletic Sant Just FC. A Atletic Sant 30 68 83 42
10 Igualada A Igualada A 30 96 80 40
11 Sant Cugat Futbol Club B Sant Cugat. 30 79 106 38
12 Cerdanyola Valles Sub 10 Cerdanyola 29 96 83 35
13 Escola Gava A Escola Gava 29 74 88 30
14 Escola de Futbol Premier Ba Escola 30 65 114 25
15 Berga CE A Berga CE A 30 44 204 6
16 Santboia A Santboia A 30 21 241 3
TEMPORADA 2021/2022
1ª CATALANA BENJAMIN SUB 10 GRUPO 1
Equipo PJ GF GC Puntos
1 Santboia A Santboia A 27 128 29 73
2 Escola Gava C Escola Gava 29 96 46 64
3 Castelldefels A Castelldefel 27 125 42 62
4 Barcelona C Barcelona C 28 94 43 58
5 Fundacio Unio Esportiva Cor Fundacio 30 120 101 55
6 Sitges A Sitges A 29 110 81 52
7 Igualada C Igualada C 29 96 63 47
8 Viladecans A Viladecans 29 92 79 46
9 Martorell Associacio Esport Martorell 27 86 62 44
10 Santfeliuenc A Santfeliuenc 28 68 79 34
11 Base Marc Bartra B Base Marc B. 29 81 107 34
12 Cubelles B Cubelles B 29 87 93 33
13 Terlenka Barcelonista C F A Terlenka 29 81 126 27
14 Sporting Gava 2013 Futbol C Sporting 29 63 134 16
15 Ribes CD A Ribes CD A 27 49 149 8
16 Olesa 87 C A Olesa 30 38 180 2
TEMPORADA 2020/2021
1ª CATALANA BENJAMIN SUB 10 GRUPO 2
Equipo PJ GF GC Puntos
1 EF Premier Barcelona C Premier 6 36 9 18
2 Sant Gabriel Sub 10 Sant Gabriel 6 32 6 18
3 Barcelona D Barcelona D 6 40 8 16
4 Vila Olimpica Club Esp. A Vila 6 38 7 14
5 Sants A Sants A 6 26 13 14
6 Santa Eulalia A Santa 6 16 14 12
7 Santboia A Santboia A 5 24 8 7
8 Sarria A Sarria A 5 16 14 6
9 Prat A Prat A 5 9 23 6
10 Escola Angel Pedraza A Escola Angel 6 15 32 4
11 Fundacio Europa C Fundacio 6 13 29 1
12 Fundacio Unio Esportiva Cor Fundacio 5 4 20 1
13 Martinenc B Martinenc B 5 12 34 1
14 Montañesa CF A Montañesa 5 5 30 1
15 Sant Andreu de La Barca A Sant Andreu 6 3 42 1
TEMPORADA 2019/2020
1ª CATALANA BENJAMIN SUB 10 GRUPO 2
Equipo PJ GF GC Puntos
1 Martinenc B Martinenc B 11 83 18 33
2 Fundacio Europa C Fundacio 11 50 10 28
3 Sant Gabriel Sub 10 Sant Gabriel 11 48 17 28
4 Barcelona D Barcelona D 11 37 29 25
5 L'Hospitalet Centre Esports L'Hospitalet 11 40 23 23
6 Vila Olimpica Club Esp. A Vila 10 38 28 17
7 Prat A Prat A 10 42 34 16
8 Sant Joan Despi UE A Sant Joan D. 11 33 40 14
9 Santboia A Santboia A 11 23 36 11
10 Santa Eulalia A Santa 11 21 32 10
11 Sarria A Sarria A 10 26 39 10
12 Fundacio Unio Esportiva Cor Fundacio 9 15 30 10
13 Montañesa CF A Montañesa 10 27 44 7
14 EF Premier Barcelona C Premier 11 22 41 6
15 Marianao Poblet A Marianao 11 23 64 6
16 Sants A Sants A 11 13 56 3
TEMPORADA 2018/2019
PREFERENTE CATALANA BENJAMIN SUB 10 GRUPO 1
Equipo PJ GF GC Puntos
1 Barcelona A Barcelona A 30 255 13 90
2 Fundación UE Cornellá B Fundación 30 175 31 84
3 Igualada A Igualada A 29 85 80 50
4 Cerdanyola Valles Sub 10 Cerdanyola 29 63 56 49
5 Gimnastic Manresa C B Gimnastic 28 68 56 47
6 Escola Gava A Escola Gava 30 70 79 46
7 L'Hospitalet Centre Esports L'Hospitalet 30 76 94 46
8 Sant Cugat Futbol Club B Sant Cugat. 28 63 56 42
9 Can Rull R. Tronchoni Sub 1 Rull 30 61 82 38
10 Vilassar Mar Sub 10 Vilassar 29 57 84 33
11 Manresa A Manresa A 29 45 77 32
12 Unio Base Jabac I Terrassa Unio Base J. 29 63 104 27
13 Sitges A Sitges A 29 75 136 27
14 Santboia A Santboia A 29 47 92 25
15 Sarria A Sarria A 29 35 127 18
16 Castelldefels A Castelldefel 28 43 128 17
TEMPORADA 2017/2018
PREFERENTE CATALANA BENJAMIN SUB 10 GRUPO 1
Equipo PJ GF GC Puntos
1 Barcelona A Barcelona A 30 255 17 90
2 Cornella B Cornella B 30 166 43 80
3 Manresa A Manresa A 30 136 48 74
4 Sant Cugat Futbol Club B Sant Cugat. 30 125 47 68
5 Gimnastic Manresa A Gimnastic 30 95 56 63
6 Escola Gava A Escola Gava 30 82 69 51
7 Igualada A Igualada A 30 77 87 39
8 Vilassar Mar Sub 10 Vilassar 30 53 82 35
9 Sitges A Sitges A 30 77 117 32
10 Unio Base Jabac I Terrassa Unio Base J. 30 67 116 32
11 Can Rull R. Tronchoni Sub 1 Rull 30 56 133 32
12 Cerdanyola Valles Sub 10 Cerdanyola 30 42 103 28
13 Santboia A Santboia A 30 49 133 25
14 Vila Olimpica Club Esportiu Vila 30 60 116 21
15 Terlenka Barcelonista Club Terlenka 30 49 129 19
16 Fundacio Europa A Fundacio 30 50 144 17
TEMPORADA 2016/2017
PREFERENTE CATALANA BENJAMIN SUB 10 GRUPO 1
Equipo PJ GF GC Puntos
1 Barcelona B Barcelona B 30 170 29 85
2 Cornella A Cornella A 30 109 39 74
3 Sant Cugat Esport A Sant Cugat. 30 93 29 70
4 Gimnastic Manresa C C Gimnastic 30 106 44 66
5 Unio Base Jabac Terrassa A Unio Base J. 30 71 50 50
6 Sant Andreu Sub 10 Sant Andreu 29 75 41 48
7 Sitges A Sitges A 30 88 90 43
8 Vilassar Dalt A Vilassar 30 64 86 34
9 Vila Olimpica Club Esportiu Vila 30 43 91 34
10 Fundacio Europa A Fundacio 30 58 88 33
11 Igualada A Igualada A 29 73 85 32
12 Santboia A Santboia A 30 60 88 32
13 Escola Gava A Escola Gava 30 56 88 32
14 Martinenc A Martinenc A 30 54 99 30
15 L'hospitalet Centre Esports L'hospitalet 30 46 124 18
16 Blanca Subur A Blanca Subur 30 35 130 8
TEMPORADA 2015/2016
PREFERENTE CATALANA BENJAMIN SUB 10 GRUPO 1
Equipo PJ GF GC Puntos
1 Barcelona A Barcelona A 30 214 16 90
2 Cornella A Cornella A 30 113 37 64
3 Escola Gava A Escola Gava 30 91 44 57
4 Tecnofutbol A Tecnofutbol 30 89 81 57
5 Sant Andreu Sub 10 Sant Andreu 30 89 51 56
6 Sant Cugat B Sant Cugat 30 50 40 49
7 Santboia A Santboia A 30 65 57 48
8 Igualada A Igualada A 30 78 70 45
9 Sitges A Sitges A 30 62 69 44
10 Unio Base Jabac Terrassa A Unio Base J. 30 67 64 39
11 Gimnastic Manresa C B Gimnastic 30 75 65 39
12 L'Hospitalet Centre Esports L'Hospitalet 30 43 79 39
13 Vila Olimpica Club Esportiu Vila 30 53 71 36
14 Natacio Terrassa C A Natacio 30 37 150 15
15 Sabadell B Sabadell B 30 51 150 10
16 Rubi A Rubi A 30 20 153 1

  USO DE MEMORIA  
5,460,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.1189
Total Execution Time  0.1206
  CADENA URL  
/historico/Santboia-Fc-A-Benjamin
  GET DATOS  
$_GET['/historico/Santboia-Fc-A-Benjamin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0025  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 = 'Santboia-Fc-A-Benjamin' 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.0033  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 = 'Santboia-Fc-A-Benjamin' 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.0019  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=75466 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=75466 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=75466 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=75466 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=75466 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=75466 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=75466 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=75466 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=75466 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0033  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 = 68649
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=75466 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 = '75466' 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 = '75466' AND l.year = 2023 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 = '75466' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '75466' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 68649 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0050  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=75466 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0042  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 (68649,64686) 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.0020  SELECT count(id) as num_players from rel_players_base WHERE league_id = 68649 AND teamId = 75466
0.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64686 AND teamId = 75466
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 = '75466' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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 = '75466' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0026  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 = 75466 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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_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 = 68649 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.0031  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 = 64686 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.0032  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 = 62883 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.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 `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 = 53620 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.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 `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 = 47154 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 `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 = 41473 AND t.round = 30 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 `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 = 35107 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 18155 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 68649 ORDER BY nameShow LIMIT 100