4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Esporles
TEMPORADA 2021/2022
1ª BALEARES BENJAMÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Esporles Esporles 27 177 21 72
2 Son Caliu Recreativo Caliu 27 145 29 66
3 Santa Ponsa A Santa Ponsa 28 154 43 62
4 Atlético Pl de Calvia del P Atlético 28 122 38 59
5 Recreativo Penya Arrabal Recreativo 28 96 72 50
6 Àgora Portals Àgora 28 118 84 47
7 Soller Soller 27 101 67 47
8 Recreativo Puigpunyent I Ga Recreativo 27 115 88 46
9 Atletic Bunyola Atletic 27 105 78 39
10 Genova Genova 27 40 125 23
11 Patronato Patronato 28 49 150 23
12 Santa Ponsa B Santa Ponsa 26 30 136 17
13 Joventut Mallorca B Joventut 28 26 156 17
14 Campusesport Campusesport 28 28 123 16
15 San Pedro Atº DCSP B Pedro Atº D. 28 40 136 11
TEMPORADA 2019/2020
PREBENJAMÍN PRIMER AÑO MALLORCA GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Baleares B Atlético 16 79 13 43
2 Penya Arrabal C Penya 16 64 14 40
3 Àgora Portals Àgora 16 82 30 38
4 San Francisco Francisco 16 104 32 34
5 Rvo. Son Caliu Rvo. Caliu 16 58 24 33
6 San Pedro Atlético Pedro 16 41 23 31
7 Ciutat de Palma B Ciutat Palma 15 34 23 26
8 La Salle Atletico Salle 16 45 38 26
9 Atlético Rafal B Atlético 16 50 34 22
10 Esporles Esporles 14 22 53 19
11 Son Caliu Atlético Caliu 16 36 70 13
12 Calvia Calvia 16 32 69 9
13 Collerense B Collerense 15 23 62 7
14 La Union La Union 16 13 95 4
15 Independiente C/r Independient 16 9 112 0
TEMPORADA 2018/2019
2ª BALEARES BENJAMIN GRUPO 4
Equipo PJ GF GC Puntos
1 Àgora Portals Àgora 34 197 48 94
2 Sta Ponsa Talarrubias Ponsa 34 120 34 91
3 Calvia Calvia 34 156 43 81
4 Campusesport Campusesport 34 165 58 75
5 Recreativo Marratxí del Atm Recreativo 34 152 38 74
6 Son Caliu B Son Caliu B 34 122 33 72
7 Santa Ponsa Santa Ponsa 34 127 74 67
8 Sollerense B Sollerense 34 92 93 51
9 Esporles Esporles 33 100 87 49
10 Rotlet Molinar Atlético del Rotlet 34 103 97 47
11 Palmanyola Palmanyola 34 99 112 45
12 Bunyola Club de Futbol Bunyola Club 34 67 86 38
13 Platges de Calvia Platges 34 73 127 33
14 Atlético Santa Monica del Atlético 33 85 111 32
15 Atº de Paguera Atº Paguera 34 55 137 20
16 Son Caliu C Son Caliu C 34 39 192 14
17 Penya Esps'arenal Penya 34 64 179 11
18 Genova Atlético del G Genova 34 5 255 0
TEMPORADA 2016/2017
2ª BALEARES BENJAMIN GRUPO 5
Equipo PJ GF GC Puntos
1 Esporles Esporles 26 162 23 75
2 Andratx Andratx 26 150 33 64
3 Son Caliu Recreativo Caliu 26 139 56 61
4 Penya Esps'arenal Penya 26 168 69 59
5 Campusesport Campusesport 26 95 68 43
6 Calvia Calvia 26 107 84 40
7 Viva Sports Viva Sports 26 85 93 40
8 Valldemossa Atº Valldemossa 26 125 102 37
9 Àgora B Àgora B 26 102 81 37
10 Atlético Camp Redo Industri Atlético 26 100 108 31
11 Santa Ponsa Santa Ponsa 26 86 112 29
12 Palmanyola Palmanyola 26 30 160 10
13 Patronato B Patronato B 26 19 189 8
14 Atletic Bunyola Atletic 26 12 202 0
TEMPORADA 2015/2016
3ª BALEARES - PUEBLOS BENJAMIN GRUPO 5
Equipo PJ GF GC Puntos
1 Platges de Calvia Platges 26 132 23 73
2 Son Caliu del Atsc A Caliu Atsc 26 180 17 69
3 Arenal Arenal 26 184 45 65
4 Santa Ponsa Santa Ponsa 26 98 51 50
5 Àgora A Àgora A 26 106 57 46
6 Atº de Paguera Atº Paguera 26 57 73 40
7 Àgora B Àgora B 26 102 95 36
8 Esporles Esporles 26 76 69 36
9 Urbanitzacions Urbanitzacio 26 77 89 35
10 Son Caliu B Son Caliu B 26 66 90 24
11 Andratx Andratx 26 46 101 21
12 Calvia Calvia 26 52 140 18
13 Santa Ponsa B Santa Ponsa 26 49 186 11
14 Recreativo Marratxí del Atm Recreativo 26 19 208 0
TEMPORADA 2014/2015
3ª BALEARES - PUEBLOS BENJAMIN GRUPO 5
Equipo PJ GF GC Puntos
1 Sollerense A Sollerense 26 207 16 78
2 Àgora A Àgora A 26 155 71 56
3 Andratx A Andratx A 26 107 39 53
4 Son Caliu B Son Caliu B 26 111 59 53
5 Atº de Paguera Atº Paguera 26 89 55 51
6 Platges de Calvia Platges 26 116 60 49
7 Calvia Calvia 26 98 63 49
8 Valldemossa Atº Valldemossa 26 85 45 47
9 Son Caliu A Son Caliu A 26 82 85 37
10 Cercle Solleric Cercle 26 56 103 20
11 Àgora B Àgora B 26 43 143 15
12 Sollerense B Sollerense 26 33 153 10
13 Esporles Esporles 26 22 188 9
14 Santa Ponsa Santa Ponsa 26 35 159 8

  USO DE MEMORIA  
5,192,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.5698
Total Execution Time  0.5709
  CADENA URL  
/historico/Esporles-Benjamin
  GET DATOS  
$_GET['/historico/Esporles-Benjamin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0152  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 = 'Esporles-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.0155  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 = 'Esporles-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.0145  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=34396 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=34396 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=34396 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=34396 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=34396 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=34396 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=34396 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=34396 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=34396 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=34396 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=950 AND type_rel = 3
0.0150  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 = '34396' ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '34396' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0146  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 = '34396' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = '34396' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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=34396 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (65288) 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 = 65288 AND teamId = 34396
0.0145  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 = '34396' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  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 = '34396' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0162  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 = 34396 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0167  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 = 65288 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.0173  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 = 54191 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.0156  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 = 54181 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.0151  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 = 55498 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.0151  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 = 47623 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 37302 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 18394 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 6425 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC