4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Santa Monica
TEMPORADA 2022/2023
1ª BALEAR JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Penya Arrabal C Penya 24 80 16 57
2 Pollença I Port Pollença 24 69 17 57
3 Llosetense Llosetense 24 83 43 54
4 Pla de Na Tesa B Tesa 24 67 40 50
5 Independiente Camp Redó Independient 24 88 70 38
6 CD Consell B Consell 24 61 59 36
7 Porto Cristo A Porto Cristo 24 64 69 35
8 Alcudia B Alcudia B 24 47 49 34
9 La Union B La Union B 24 48 68 30
10 Bunyola CF B Bunyola 24 55 65 24
11 Calvià Atlético Sub 19 Calvià 24 49 66 24
12 Santa Monica Santa Monica 24 33 99 7
13 Urba CD Urba CD 24 31 114 6
TEMPORADA 2021/2022
PREFERENTE BALEAR JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 SD La Salle B Salle 33 83 26 76
2 CD Manacor B Manacor 32 70 25 76
3 Andratx Sub 19 Andratx 33 78 46 72
4 Patronato A Patronato A 32 98 47 67
5 UE Alcúdia A Alcúdia 33 90 39 64
6 AD Penya Arrabal Sub 19 B Penya 32 72 35 60
7 Atlético Rafal B Atlético 33 59 51 52
8 Alaro Alaro 32 67 50 49
9 Constancia B Constancia 33 86 71 49
10 Sporting San Francisco Sporting 33 64 46 44
11 San Francisco C Francisco 33 58 68 39
12 Son Sardina A Sardina 33 65 82 38
13 UE Petra UE Petra 32 47 66 33
14 Genova Genova 33 69 97 31
15 Santa Monica Santa Monica 33 66 108 30
16 Calvià Atlético Sub 19 Calvià 32 45 112 24
17 Murense Murense 33 53 123 20
18 CE Algaida CE Algaida 33 32 110 10
TEMPORADA 2020/2021
1ª BALEAR JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Genova Genova 9 36 21 18
2 Viva Sports Viva Sports 10 28 16 18
3 San Cayetano Cayetano 10 26 20 18
4 Manacor C Manacor C 10 32 28 18
5 Santa Monica Santa Monica 9 21 11 17
6 Sineu Sineu 9 22 16 16
7 Pla de NA Tesa Atº Del PDNT Tesa Atº PD. 9 17 18 15
8 Recreativo Son Caliu A Recreativo 9 13 22 5
9 Margaritense At. Margaritense 7 11 28 4
10 A-Llubi A-Llubi 10 6 32 2
TEMPORADA 2019/2020
2ª BALEAR JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Santa Monica Santa Monica 18 84 10 48
2 Constancia C Constancia 17 53 24 38
3 A Llubi A Llubi 17 54 30 34
4 Son Cladera At. del SC Cladera 18 43 35 31
5 Alcudia B Alcudia B 17 43 22 30
6 ES Raval De Sta. C Raval Sta. 17 54 38 29
7 Rtvº Rafal Del At.R Rtvº Rafal 18 34 26 29
8 LLosetense B LLosetense 18 31 41 23
9 Rtvº Penya Arrabal Rtvº Penya 18 30 43 20
10 Soller B Soller B 17 22 36 14
11 Atlético Marratxí B Atlético 17 25 76 11
12 Rotlet-Molinar Rotlet-Molin 18 20 71 10
13 La Unión C La Unión C 18 21 62 5
TEMPORADA 2018/2019
2ª BALEAR JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Viva Sports Viva Sports 24 68 45 54
2 Pla de Na Tesa Atlético del Tesa 24 83 41 53
3 Santa Monica Santa Monica 24 91 38 50
4 Calvia Atlético del C B Calvia 24 83 53 49
5 Asoc. Dep. Marroquís Asoc. Dep.. 24 67 32 47
6 Consell CD Consell CD 24 77 56 44
7 Atlético Pl de Calvia del P Atlético 23 44 50 31
8 Santa Catalina Atlético B Santa 24 39 46 28
9 Sant Jordi B Sant Jordi 24 56 72 25
10 LLosetense B LLosetense 24 52 64 20
11 Xilvar B Xilvar B 24 37 89 18
12 Cala D'or Cala D'or 24 23 80 14
13 CD San Roque Roque 23 39 93 10
TEMPORADA 2017/2018
1ª BALEAR JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Manacor C Manacor C 37 114 35 95
2 Genova Genova 37 130 47 91
3 Son Sardina A Sardina 37 87 39 84
4 Sant Jordi A Sant Jordi 37 148 50 83
5 Xilvar Xilvar 38 104 76 68
6 Penya Esp Sarenal Penya 36 92 59 67
7 Son Cladera A Cladera 37 86 76 64
8 Espanya Espanya 37 108 76 62
9 Montaura Montaura 37 96 85 58
10 Interpla Interpla 38 93 72 55
11 CE Algaida CE Algaida 37 65 89 41
12 Bunyola CF B Bunyola 37 65 93 40
13 Son Ximelis Son Ximelis 37 85 120 37
14 Atlético Rafal B Atlético 37 59 86 36
15 Alcudia B Alcudia B 37 57 125 35
16 A Llubi A Llubi 37 45 106 32
17 Ciutat de Palma B Ciutat Palma 38 36 101 32
18 UE Petra UE Petra 37 71 91 31
19 Pla de Na Tesa Atlético del Tesa 37 61 97 25
20 Santa Monica Santa Monica 23 24 103 10
TEMPORADA 2016/2017
1ª BALEAR JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Arta Arta 38 162 87 92
2 Penya Arrabal C Penya 38 148 69 83
3 Santa Ponsa Santa Ponsa 38 138 66 78
4 Pollença I Port Pollença 38 104 71 78
5 Madre Alberta Madre 38 98 53 70
6 Murense Murense 38 92 62 63
7 Recreativo La Victoria Recreativo 38 96 71 63
8 CE Esporles CE Esporles 38 83 76 61
9 Cardassar Cardassar 37 92 76 60
10 Col San Pedro Pedro 38 108 99 56
11 Juventud Udso B Juventud 38 80 91 55
12 Cala D'or Cala D'or 38 91 83 53
13 Atlético Rafal B Atlético 38 82 116 45
14 Santa Monica Santa Monica 38 85 115 42
15 Penya Esp Sarenal Penya 38 87 132 42
16 Manacor C Manacor C 38 55 74 38
17 La Union B La Union B 38 73 91 37
18 Porto Cristo A Porto Cristo 38 48 101 25
19 Platges de Calvia B Platges 38 54 123 25
20 Collerense Collerense 37 36 156 8
TEMPORADA 2015/2016
2ª BALEAR JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Santa Ponsa Santa Ponsa 24 84 42 53
2 Patronato B Patronato B 24 73 34 51
3 Santa Monica Santa Monica 23 102 46 50
4 Soller B Soller B 24 58 37 47
5 Independiente Camp Redó Independient 24 91 61 47
6 Recreativo Son Caliu Recreativo 24 64 36 44
7 Sp. Sant Marçal Sant Marçal 24 78 79 44
8 CD Arenal B CD Arenal B 24 48 66 26
9 Rotlet Molinar B Rotlet 24 71 97 24
10 Son Sardina B Sardina 24 36 68 22
11 Collerense B Collerense 24 38 77 20
12 Interpla Interpla 23 30 75 9
13 Unió Esportiva Sta Maria Unió 13 16 47 5
14 Serralta Serralta 11 11 35 3
TEMPORADA 2014/2015
2ª BALEAR JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Manacor C Manacor C 29 94 45 64
2 Santanyi FB Santanyi FB 29 94 60 57
3 CD Arenal B CD Arenal B 29 106 43 55
4 Santa Monica Santa Monica 30 103 70 52
5 Soller B Soller B 29 73 39 51
6 Rotlet-Molinar Rotlet-Molin 30 70 63 46
7 Alqueria Alqueria 29 63 57 46
8 Santa Ponsa Santa Ponsa 30 66 61 45
9 Son Ximelis Son Ximelis 29 86 69 43
10 Porto Cristo B Porto Cristo 30 62 66 42
11 Luis Vives Luis Vives 29 55 55 40
12 Platges de Calvia B Platges 30 53 71 31
13 Pollença i Port B Pollença 21 40 36 28
14 Santa Maria UE Santa Maria 29 45 81 28
15 Son Sardina At. DSS Sardina 30 46 86 22
16 Interpla Interpla 29 14 168 7

  USO DE MEMORIA  
5,545,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1113
Total Execution Time  0.1126
  CADENA URL  
/historico/Santa-Monica-Juvenil
  GET DATOS  
$_GET['/historico/Santa-Monica-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0022  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 = 'Santa-Monica-Juvenil' 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.0031  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 = 'Santa-Monica-Juvenil' 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=29801 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=29801 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=29801 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=29801 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=29801 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=29801 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=29801 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=29801 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=29801 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=29801 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=29801 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=29801 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=828 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 828 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 (275951) ORDER BY n.cover_points DESC, update_date DESC
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 = '29801' ORDER BY l.year DESC,cat.coefficient DESC
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 = '29801' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '29801' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=29801 AND l.year in (2022,2023,2024) 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 (69174,63720) 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_base WHERE league_id = 69174 AND teamId = 29801
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 63720 AND teamId = 29801
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 = '29801' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '29801' and rp.type = 4
0.0021  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 = '29801' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 29801 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2023_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 = 69174 AND t.round = 26 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 `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 = 63720 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.0021  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_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 = 59340 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_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 = 54120 AND t.round = 26 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 `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 = 44770 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 `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 = 44771 AND t.round = 26 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 `tables2018_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 = 39246 AND t.round = 38 ORDER BY team.conference 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 `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 = 34270 AND t.round = 38 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 `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 = 17196 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 = 5182 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC