4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Campusesport
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 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
2ª BALEARES BENJAMIN GRUPO 3
Equipo PJ GF GC Puntos
1 Madre Alberta Madre 28 192 24 82
2 Rtvo Ciutat de Palma Rtvo Ciutat 28 123 39 65
3 Balears B Balears B 28 113 35 63
4 Campusesport Campusesport 28 119 47 58
5 Collerense A Collerense 28 107 64 54
6 La Salle La Salle 28 94 50 53
7 Salla Atlético Salla 28 81 54 49
8 Bellver Palma Bellver 28 82 70 41
9 San Francisco Atletico Francisco 28 76 66 38
10 Genova Genova 28 60 65 28
11 Viva Sports Viva Sports 28 83 130 27
12 Recreativo Soledad Recreativo 28 49 174 17
13 Atletico Cide Atletico 28 34 135 16
14 San Pedro Atlético Pedro 28 45 121 10
15 Son Ximelis A Ximelis 28 26 210 3
TEMPORADA 2014/2015
2ª BALEARES BENJAMIN GRUPO 4
Equipo PJ GF GC Puntos
1 Son Ximelis A Ximelis 28 215 33 76
2 Santa Monica Santa Monica 28 169 38 74
3 Campusesport Campusesport 28 158 28 71
4 Ciutat de Palma B Ciutat Palma 28 116 55 61
5 Madre Alberta B Madre 28 102 49 57
6 Viva Sports Viva Sports 28 86 57 44
7 La Union La Union 28 88 91 41
8 S'indioteria Drlv S'indioteria 28 101 97 38
9 Bellver Palma Bellver 28 73 82 38
10 Rtvº Penya Arrabal B Rtvº Penya 28 69 119 29
11 Sant Jordi Sant Jordi 28 49 99 23
12 La Salle La Salle 28 51 134 19
13 Patronato B Patronato B 28 57 180 17
14 Son Sardina Dss Sardina 28 41 135 14
15 Rotlet Molinar B Rotlet 28 18 196 2

  USO DE MEMORIA  
5,055,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0941
Total Execution Time  0.0961
  CADENA URL  
/historico/Campusesport-Benjamin
  GET DATOS  
$_GET['/historico/Campusesport-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 = 'Campusesport-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 = 'Campusesport-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=34945 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=34945 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=34945 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=34945 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=34945 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=34945 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=34945 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0029  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 = 65288
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=34945 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=950 AND type_rel = 3
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 = '34945' ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '34945' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0019  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 = '34945' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = '34945' 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 = 65288 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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=34945 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0018  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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65288 AND teamId = 34945
0.0019  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 = 65288 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '34945' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  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 = '34945' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 34945 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  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.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 `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.0024  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.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 `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 = 18389 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 6435 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 65288 ORDER BY nameShow LIMIT 100