4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Àgora Portals
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
2ª BALEARES BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Santa Ponsa A Santa Ponsa 20 114 18 57
2 Palmanyola Palmanyola 19 92 23 46
3 Esporles Esporles 18 91 30 43
4 Madre Alberta B Madre 18 85 30 42
5 Àgora Portals Àgora 18 78 42 37
6 Son Caliu del Atsc A Caliu Atsc 18 78 46 36
7 Calvia Calvia 17 53 43 30
8 La Unión La Unión 19 55 45 28
9 Platges de Calvia Platges 18 69 81 21
10 Andratx B Andratx B 19 39 58 20
11 Santa Ponsa B Santa Ponsa 19 43 77 16
12 Son Caliu B Son Caliu B 18 53 87 15
13 Sollerense B Sollerense 19 35 104 9
14 San Pedro Atº DCSP B Pedro Atº D. 17 12 136 4
15 Palmanyola B Palmanyola 19 22 99 3
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

  USO DE MEMORIA  
4,820,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2095
Total Execution Time  0.2114
  CADENA URL  
/historico/Agora-Portals-Benjamin
  GET DATOS  
$_GET['/historico/Agora-Portals-Benjamin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=117622 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=950 AND type_rel = 3
0.0107  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 = '117622' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = '117622' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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.0108  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=117622 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0105  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.0105  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65288 AND teamId = 117622
0.0107  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 = 117622 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0111  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.0108  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.0111  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