4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Juv Can Picafort
TEMPORADA 2023/2024
1ª REGIONAL BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Consell Consell 29 79 22 67
2 Son Sardina Son Sardina 29 79 44 62
3 Juv Can Picafort Picafort 27 66 24 60
4 Port de Soller Port Soller 28 54 36 52
5 Unió Esportiva Sta Maria Unió 27 47 30 50
6 Cardassar B Cardassar B 28 62 41 48
7 Soller B Soller B 28 58 52 45
8 Maria de la Salut Maria Salut 29 44 50 37
9 Montaura Montaura 29 65 61 37
10 Atlético Rafal B Atlético 29 56 63 35
11 Constancia B Constancia 28 47 51 35
12 San Roque San Roque 28 41 55 31
13 Atlético Marratxí Atlético 29 54 74 29
14 Viva Sports Viva Sports 28 51 86 22
15 Alqueria Alqueria 29 34 95 11
16 Margaritense AtlÈtic Margaritense 13 7 60 0
TEMPORADA 2022/2023
1ª REGIONAL BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Santa Mónica Santa 30 73 20 77
2 Andratx B Andratx B 30 78 28 67
3 Athetic Club Montuiri Athetic Club 30 59 40 54
4 CE Escolar CE Escolar 30 63 43 53
5 Consell Consell 30 54 34 52
6 La Unión CF Unión 30 57 41 52
7 Unió Esportiva Sta Maria Unió 30 50 39 43
8 Athlàtic Huialfàs Athlàtic 30 50 46 42
9 Baleares Sin Fronteras Baleares 30 49 41 40
10 Margaritense AtlÈtic Margaritense 30 52 56 37
11 Port de Soller Port Soller 30 35 46 36
12 Juv Can Picafort Picafort 30 41 58 36
13 Pilares La Soledad Pilares 30 43 64 31
14 CD Binissalem B Binissalem 30 36 73 28
15 San Roque San Roque 30 37 65 18
16 Taujá Taujá 30 18 101 3
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
2ª REGIONAL BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Juv Can Picafort Picafort 18 49 19 39
2 Athlàtic Huialfàs Athlàtic 18 47 25 37
3 Porto Cristo Porto Cristo 18 34 24 31
4 Portol Portol 18 43 24 30
5 Santa Ponsa Santa Ponsa 18 36 32 27
6 Athetic Club Montuiri Athetic Club 18 29 29 24
7 Pilares La Soledad Pilares 18 34 41 20
8 UE Lloret UE Lloret 18 33 47 18
9 Cala D'or Cala D'or 18 24 35 17
10 Collerense B Collerense 18 27 80 9
TEMPORADA 2019/2020
2ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Arta Arta 27 78 28 68
2 Constancia B Constancia 28 58 31 56
3 Baleares Sin Fronteras Baleares 27 60 32 51
4 Portol Portol 26 69 44 50
5 Bunyola Bunyola 27 65 40 49
6 Santa Ponsa Santa Ponsa 27 61 39 45
7 CE Escolar CE Escolar 26 60 46 44
8 Pilares La Soledad Pilares 27 51 46 39
9 Athetic Club Montuiri Athetic Club 26 34 40 32
10 Llosetense C Llosetense 26 57 64 32
11 Collerense B Collerense 26 52 69 31
12 Taujá Taujá 25 42 48 29
13 Valldemossa Atl Valldemossa 26 44 65 29
14 Soller B Soller B 25 46 59 28
15 CD Binissalem B Binissalem 27 29 62 28
16 UE Lloret UE Lloret 27 43 56 26
17 San Cayetano Cayetano 26 42 67 25
18 Poblense B Poblense B 26 29 47 24
19 Juv Can Picafort Picafort 26 31 52 23
20 Establiments Establiments 25 44 60 17
TEMPORADA 2018/2019
2ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Santa Mónica Santa 38 100 43 90
2 Calvia Calvia 38 88 34 82
3 Vilafranca Vilafranca 38 108 58 80
4 Serralta Serralta 38 99 57 71
5 Alqueria Alqueria 37 78 58 63
6 Athetic Club Montuiri Athetic Club 38 80 50 62
7 UE Lloret UE Lloret 37 66 50 59
8 CD Binissalem B Binissalem 37 65 53 58
9 Establiments Establiments 38 65 57 57
10 CE Escolar CE Escolar 38 64 69 49
11 Constancia B Constancia 38 62 58 47
12 Portol Portol 38 62 71 45
13 Soller B Soller B 38 68 83 43
14 Pilares La Soledad Pilares 38 67 85 42
15 Juv Can Picafort Picafort 38 51 76 42
16 Poblense B Poblense B 38 38 72 39
17 Valldemossa Atl Valldemossa 38 57 86 36
18 Margaritense AtlÈtic Margaritense 38 44 70 35
19 Palmanyola Palmanyola 38 41 102 27
20 Porto Cristo Porto Cristo 37 37 108 18
TEMPORADA 2017/2018
3ª REGIONAL BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Son Ximelis Son Ximelis 23 85 20 61
2 Juv Can Picafort Picafort 23 65 21 51
3 Esporles B Esporles B 23 54 26 47
4 Collerense B Collerense 22 63 39 47
5 Mallorca Toppfotball Mallorca 21 53 36 34
6 Rotlet Molinar B Rotlet 23 56 52 32
7 Montaura B Montaura B 24 43 37 30
8 Sp. Son Ferrer A Ferrer 24 47 46 30
9 Deportivo Marratxi Deportivo 22 42 51 29
10 Campanet B Campanet B 23 35 53 17
11 Concos Concos 22 34 60 15
12 Son Maciá Son Maciá 23 28 123 10
13 Arta Arta 15 22 63 7
TEMPORADA 2016/2017
3ª REGIONAL BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético de Paguera Atlético 24 77 21 59
2 Constancia B Constancia 24 84 28 57
3 Atlético Marratxí Atlético 24 79 37 52
4 Juv Can Picafort Picafort 24 59 32 42
5 Mallorca Toppfotball Mallorca 23 61 30 39
6 Son Ximelis Son Ximelis 24 53 53 39
7 Collerense B Collerense 22 48 40 31
8 AtlÈtic Son Ximelis AtlÈtic 23 38 69 29
9 Son Sardina B Sardina 24 44 60 27
10 Sp. Son Ferrer A Ferrer 24 40 68 20
11 Arenal B Arenal B 24 42 76 20
12 Sant Jordi B Sant Jordi 24 36 87 18
13 Palmanyola Palmanyola 24 28 88 8

  USO DE MEMORIA  
5,750,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0979
Total Execution Time  0.0992
  CADENA URL  
/historico/Platges-Can-Picafort-Senior
  GET DATOS  
$_GET['/historico/Platges-Can-Picafort-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0027  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 = 'Platges-Can-Picafort-Senior' 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.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=91126 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=91126 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 73783
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=91126 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=686 AND type_rel = 3
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 686 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1104898,627067,564570) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = '91126' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '91126' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027  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 = 73783 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=91126 AND l.year in (2023,2024,2025) 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 (73783) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73783 AND teamId = 91126
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 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 = 73783 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0027  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 = 73783 WHERE rp.league_id = 73783 AND rp.teamId = 91126 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.0026  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 = 73783 WHERE rp.league_id = 73783 AND rp.teamId = 91126 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 73783 WHERE rp.league_id = 73783 AND rp.teamId = 91126 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 = 91126 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73783 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 `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 = 69164 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 `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.0020  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 = 59033 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.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 `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 = 51366 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.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 `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 = 44635 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 39186 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 34311 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC