4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Base Marc Bartra B
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 2019/2020
2ª CATALANA BENJAMIN SUB 10 GRUPO 1
Equipo PJ GF GC Puntos
1 Vilanova Geltru A Vilanova 17 128 16 48
2 Escola Gava H Escola Gava 17 73 30 41
3 Base Marc Bartra B Base Marc B. 17 89 41 33
4 Sitges B Sitges B 16 76 37 33
5 Blanca Subur B Blanca Subur 17 57 44 29
6 Piera A Piera A 17 54 53 29
7 Fundacio Unio Esportiva Cor Fundacio 16 69 68 28
8 La Palma Cervello A Palma 17 65 67 25
9 Odena A Odena A 17 55 78 21
10 Base Olerdola A Base 17 40 63 20
11 Fundacio Atletic Vilafranca Fundacio 16 37 50 18
12 Cubelles C Cubelles C 16 41 57 18
13 Jove de Les Roquetes A Jove 17 51 80 12
14 Sant Sadurni A Sant Sadurni 17 56 74 11
15 Igualada D Igualada D 17 38 80 11
16 Anoia A Anoia A 17 35 126 6
TEMPORADA 2018/2019
2ª CATALANA BENJAMIN SUB 10 GRUPO 1
Equipo PJ GF GC Puntos
1 Igualada E Igualada E 30 255 37 82
2 Ribes A Ribes A 30 255 50 77
3 Sant Sadurni A Sant Sadurni 30 175 56 73
4 Anoia A Anoia A 30 223 69 70
5 Base Olerdola A Base 30 143 66 64
6 Vilanova Geltru A Vilanova 30 174 85 59
7 Cubelles C Cubelles C 29 128 77 50
8 Odena A Odena A 30 101 104 44
9 Blanca Subur B Blanca Subur 30 132 125 42
10 Fundacio Atletic Vilafranca Fundacio 30 72 110 31
11 Base Marc Bartra B Base Marc B. 30 78 113 30
12 Pª Jove de Les Roquetes A Pª Jove Ro. 30 75 171 26
13 Gelida A Gelida A 29 66 142 23
14 Piera A Piera A 30 84 205 20
15 Mas Catarro A Catarro 29 31 255 7
16 Canyelles Assoc Esp A Canyelles 29 26 255 0
TEMPORADA 2017/2018
2ª CATALANA BENJAMIN SUB 10 GRUPO 1
Equipo PJ GF GC Puntos
1 Sitges B Sitges B 29 112 55 66
2 Fundacio Atletic Vilafranca Fundacio 30 142 72 64
3 Vilanova Geltru A Vilanova 30 102 42 64
4 Base Olerdola A Base 30 128 64 62
5 Mas Catarro A Catarro 30 98 73 58
6 Ribes A Ribes A 29 85 59 55
7 Sant Sadurni A Sant Sadurni 30 137 90 52
8 Pª Jove de Les Roquetes A Pª Jove Ro. 30 135 130 46
9 Anoia A Anoia A 30 92 84 42
10 Igualada E Igualada E 30 94 118 33
11 Blanca Subur B Blanca Subur 30 84 110 31
12 Odena A Odena A 29 85 106 29
13 Base Marc Bartra B Base Marc B. 30 74 121 28
14 Capellades A Capellades 29 82 160 23
15 Hostalets de Pierola A Hostalets 30 68 122 20
16 Base Vilanova La Geltru A Base 30 61 173 10
TEMPORADA 2016/2017
2ª CATALANA BENJAMIN SUB 10 GRUPO 25
Equipo PJ GF GC Puntos
1 Base Marc Bartra B Base Marc B. 27 255 26 78
2 Cubelles B Cubelles B 28 216 54 71
3 Tecnifutbol Salou C C Tecnifutbol 27 200 43 71
4 Torredembarra C Torredembarr 27 112 62 54
5 Gimnastic Tarragona C H Gimnastic 28 111 63 52
6 La Riera C C Riera 26 99 62 47
7 Bellvei A Bellvei A 28 106 117 45
8 Cunit A Cunit A 28 94 111 37
9 Santa Oliva B Santa Oliva 28 88 128 32
10 Vendrell B Vendrell B 28 81 131 27
11 Tancat Tancat 27 66 115 25
12 Escola Futbol Base Calafell Escola 27 51 156 20
13 Joventut Bisbalenca B B Joventut 26 47 129 16
14 Altafulla B B Altafulla 27 49 222 14
15 Base L'arboç C Base 28 34 196 8
TEMPORADA 2015/2016
2ª CATALANA BENJAMIN SUB 10 GRUPO 25
Equipo PJ GF GC Puntos
1 Roda de Bara A Roda Bara 28 224 31 84
2 Tancat E Tancat E 28 153 83 65
3 Santa Oliva B Santa Oliva 28 149 57 63
4 La Riera B La Riera B 28 158 73 61
5 Cubelles D Cubelles D 27 134 62 60
6 Unió Esportiva Creixell A Unió 27 116 66 46
7 Joventut Bisbalenca A Joventut 28 119 103 44
8 Escola Futbol Base Calafell Escola 28 85 93 34
9 Cunit A Cunit A 28 85 149 29
10 Calafell A Calafell A 28 82 127 27
11 Altafulla A Altafulla A 28 94 136 27
12 Bellvei A Bellvei A 28 55 123 27
13 Segur A Segur A 28 69 128 21
14 Base Marc Bartra B Base Marc B. 28 45 196 17
15 Base L'arboç C Base 28 26 167 9

  USO DE MEMORIA  
5,197,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1090
Total Execution Time  0.1102
  CADENA URL  
/historico/Base-Marc-Bartra-Cf-B-Benjamin
  GET DATOS  
$_GET['/historico/Base-Marc-Bartra-Cf-B-Benjamin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0023  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 = 'Base-Marc-Bartra-Cf-B-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.0029  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 = 'Base-Marc-Bartra-Cf-B-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.0020  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=75809 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=75809 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=75809 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=75809 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=75809 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=75809 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=75809 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=75809 AND type_rel = 2
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=943 AND type_rel = 3
0.0040  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 = '75809' ORDER BY l.year DESC,cat.coefficient DESC
0.0039  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 = '75809' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0029  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 = '75809' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0030  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 = '75809' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029  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 = 64686 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0043  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=75809 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0023  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 (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.0025  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64686 AND teamId = 75809
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 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 = 64686 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0027  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 = '75809' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0030  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 = '75809' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0037  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 = 75809 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0048  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.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 `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 = 53645 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.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 `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 = 47340 AND t.round = 30 ORDER BY team.conference 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 `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 = 41501 AND t.round = 30 ORDER BY team.conference 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 `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 = 35867 AND t.round = 30 ORDER BY team.conference 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 `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 = 18204 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 64686 ORDER BY nameShow LIMIT 100