4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Platges de Calvià B
TEMPORADA 2023/2024
PREFERENTE BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Porreres Porreres 30 92 17 83
2 Rotlet Molinar Rotlet 30 84 28 73
3 Campos Campos 30 57 36 61
4 CD Sant Jordi Sant Jordi 30 51 40 52
5 Andratx B Andratx B 30 52 45 46
6 Portol Portol 30 52 58 43
7 Recreativo La Victoria Recreativo 30 47 60 42
8 Platges de Calvià B Platges 30 45 43 41
9 UE Alcudia B Alcudia 30 46 52 39
10 Ferriolense Ferriolense 30 49 45 37
11 Sineu Sineu 30 36 45 36
12 Pla de Na Tesa Tesa 30 47 63 31
13 Athetic Club Montuiri Athetic Club 30 42 60 30
14 Cala Millor Cala Millor 30 35 67 23
15 Indep. Camp Redó Indep. Camp 30 52 96 22
16 Calvia Calvia 30 25 57 21
TEMPORADA 2022/2023
1ª REGIONAL BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Platges de Calvià B Platges 30 78 26 73
2 Sta Ponsa Talarrubias Ponsa 30 86 35 68
3 Constancia B Constancia 30 91 41 63
4 UE Alcudia B Alcudia 30 64 31 58
5 Santa Ponsa Santa Ponsa 30 67 42 56
6 Soller B Soller B 30 56 46 45
7 CF Pollença Pollença 30 67 57 44
8 Atlético Marratxí Atlético 30 62 60 40
9 Viva Sports Viva Sports 30 54 79 35
10 Ce Campanet Ce Campanet 30 41 59 31
11 Porto Cristo Porto Cristo 30 43 69 31
12 Sporting Sant Marçal Sporting 30 45 73 31
13 Montaura Montaura 30 47 63 30
14 Deportivo Marratxi Deportivo 30 48 82 28
15 Rotlet Molinar B Rotlet 30 53 93 25
16 Sant Jordi B Sant Jordi 30 49 95 24
TEMPORADA 2021/2022
1ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Algaida Algaida 38 89 33 80
2 UD Arenal UD Arenal 38 63 24 76
3 S´Horta S´Horta 37 80 41 72
4 Portol Portol 38 75 35 69
5 Atletico Rafal Atletico 37 55 34 65
6 Indep. Camp Redó Indep. Camp 38 86 52 62
7 Espanya Espanya 38 54 39 62
8 Cala Millor Cala Millor 38 72 56 61
9 CF Pollença Pollença 38 64 70 58
10 La Unión CF Unión 38 56 48 54
11 Platges de Calvià B Platges 38 65 70 51
12 Athlàtic Huialfàs Athlàtic 38 60 68 50
13 Montaura Montaura 38 54 69 49
14 UEF Santa María Santa María 38 39 57 45
15 Ce Campanet Ce Campanet 38 55 74 45
16 CE Escolar CE Escolar 38 42 68 40
17 A-Llubi A-Llubi 38 44 74 37
18 Constancia B Constancia 38 48 89 33
19 Juv Can Picafort Picafort 38 36 77 28
20 Porto Cristo Porto Cristo 38 39 98 24
TEMPORADA 2020/2021
1ª REGIONAL BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Arta Arta 18 59 24 42
2 Pla de Na Tesa Tesa 18 49 34 38
3 Son Sardina Son Sardina 18 46 32 36
4 CF Pollença Pollença 18 35 23 33
5 S´Horta S´Horta 18 32 29 25
6 Platges de Calvià B Platges 18 31 33 25
7 Constancia B Constancia 18 32 35 21
8 Consell Consell 18 20 33 16
9 Port de Soller Port Soller 18 23 42 13
10 Vilafranca Vilafranca 18 30 72 10
TEMPORADA 2019/2020
1ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Alqueria Alqueria 26 48 27 54
2 Son Sardina Son Sardina 27 67 45 53
3 Indep. Camp Redó Indep. Camp 27 67 53 45
4 CF Pollença Pollença 27 44 40 44
5 Algaida Algaida 25 48 26 43
6 Calvia Calvia 23 54 31 42
7 Recreativo La Victoria Recreativo 27 45 37 42
8 Santa Mónica Santa 27 58 51 40
9 Serralta Serralta 26 54 40 38
10 Ce Campanet Ce Campanet 26 51 54 38
11 Consell Consell 26 54 72 37
12 Vilafranca Vilafranca 25 48 38 36
13 S´Horta S´Horta 26 35 51 35
14 Pla de Na Tesa Tesa 26 58 48 34
15 Espanya Espanya 27 26 43 30
16 UD Arenal UD Arenal 25 41 36 29
17 Platges de Calvià B Platges 27 35 51 24
18 Port de Soller Port Soller 26 33 56 22
19 Sporting Sant Marçal Sporting 26 30 53 21
20 Montaura Montaura 27 34 78 21
TEMPORADA 2018/2019
1ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Porreres Porreres 38 78 29 77
2 UEF Santa María Santa María 38 80 40 77
3 Cardassar Cardassar 38 65 28 76
4 Algaida Algaida 38 74 59 65
5 Pla de Na Tesa Tesa 38 72 59 65
6 Indep. Camp Redó Indep. Camp 38 85 60 61
7 Sporting Sant Marçal Sporting 38 61 56 58
8 Ce Campanet Ce Campanet 38 56 59 54
9 Montaura Montaura 38 57 69 54
10 Olimpic de Felanitx Olimpic 38 67 74 48
11 UD Arenal UD Arenal 38 58 65 46
12 Platges de Calvià B Platges 38 48 58 46
13 CF Pollença Pollença 38 70 82 45
14 Juventud UDSO Juventud 37 49 58 44
15 Consell Consell 38 65 78 44
16 S´Horta S´Horta 38 51 76 44
17 Espanya Espanya 38 66 76 42
18 Baleares Sin Fronteras Baleares 37 57 67 41
19 Santa Ponsa Santa Ponsa 38 56 78 34
20 Llosetense C Llosetense 38 39 83 26
TEMPORADA 2017/2018
1ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Cala Millor Cala Millor 38 87 42 73
2 Son Sardina Son Sardina 37 69 37 72
3 Espanya Espanya 38 67 49 66
4 UEF Santa María Santa María 38 73 59 65
5 Juventud UDSO Juventud 37 92 54 65
6 Pla de Na Tesa Tesa 37 71 54 64
7 Ce Campanet Ce Campanet 38 64 67 54
8 CF Pollença Pollença 38 63 75 53
9 Platges de Calvià B Platges 38 83 69 53
10 Baleares Sin Fronteras Baleares 37 62 61 53
11 Montaura Montaura 38 72 74 52
12 UD Arenal UD Arenal 38 51 50 51
13 Consell Consell 38 66 73 51
14 Sporting Sant Marçal Sporting 38 55 63 47
15 Olimpic de Felanitx Olimpic 38 57 61 46
16 S´Horta S´Horta 37 64 73 45
17 Santa Ponsa Santa Ponsa 38 66 107 45
18 Establiments Establiments 38 58 60 44
19 CD Binissalem B Binissalem 38 38 60 38
20 Valldemossa Atl Valldemossa 37 23 93 12
TEMPORADA 2016/2017
PREFERENTE BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Manacor Manacor 38 70 27 77
2 UE Petra UE Petra 38 60 40 67
3 La Unión CF Unión 38 59 40 66
4 Santanyi Santanyi 38 48 37 64
5 CE Xilvar CE Xilvar 38 58 44 62
6 Serverense Serverense 38 62 47 59
7 Sineu Sineu 38 56 49 56
8 A-Llubi A-Llubi 38 47 43 54
9 Recreativo La Victoria Recreativo 38 48 52 52
10 Atletico Rafal Atletico 38 45 39 52
11 Murense Murense 38 51 64 51
12 Cardassar Cardassar 38 45 51 48
13 Port de Soller Port Soller 38 47 47 46
14 CD Génova CD Génova 38 65 78 44
15 UD Alaró UD Alaró 38 40 58 43
16 Andratx Andratx 38 48 47 43
17 Soller Soller 38 44 63 43
18 Indep. Camp Redó Indep. Camp 38 45 80 42
19 Platges de Calvià B Platges 38 39 55 40
20 Ce Campanet Ce Campanet 38 48 64 39

  USO DE MEMORIA  
5,916,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  1.1203
Total Execution Time  1.1224
  CADENA URL  
/historico/Platges-De-Calvia-B-Senior
  GET DATOS  
$_GET['/historico/Platges-De-Calvia-B-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0044  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 = 73339
0.0036  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90383 AND type_rel = 2
0.0023  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 = '90383' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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=90383 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73339,69163) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 73339 AND teamId = 90383
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 69163 AND teamId = 90383
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 = '90383' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0026  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '90383' and rp.type = 4
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 = '90383' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73339 WHERE rp.league_id = 73339 AND rp.teamId = 90383 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73339 WHERE rp.league_id = 73339 AND rp.teamId = 90383 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73339 WHERE rp.league_id = 73339 AND rp.teamId = 90383 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 90383 AND l.year <= 2024 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 `tables2024` 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 = 73339 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.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 `tables2023` 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 = 69163 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.0037  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` 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 = 63635 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046  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` 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 = 58943 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2020` 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 = 51289 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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` 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 = 44634 AND t.round = 38 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` 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 = 39184 AND t.round = 38 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 `tables2017` 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 = 33976 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC