4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Constancia B
TEMPORADA 2022/2023
PREFERENTE BALEAR JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Pla de na Tesa Tesa 33 115 36 76
2 Platges de Calvia B Platges 33 60 34 60
3 Alaro Alaro 34 70 49 59
4 Constancia B Constancia 34 73 55 58
5 Serverense Sub 19 Serverense 34 58 45 57
6 Ciutat de Palma SA Ciutat Palma 34 59 44 55
7 SD La Salle B Salle 33 63 50 54
8 CD Felanitx Sub 19 Felanitx 33 78 64 53
9 Arenal Arenal 34 70 53 52
10 Recreativo Son Caliu Recreativo 34 66 54 51
11 Sporting San Francisco Sporting 33 72 52 50
12 UE Petra UE Petra 34 55 53 49
13 Espanya Espanya 33 60 58 48
14 Binissalem A Binissalem 34 53 57 46
15 Montaura Montaura 33 56 83 36
16 La Unión Sub 19 Unión 33 39 69 28
17 Atlético Rafal B Atlético 34 34 115 9
18 Genova Genova 34 25 135 8
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
PREFERENTE BALEAR JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Constancia B Constancia 15 44 14 39
2 Andratx Sub 19 Andratx 15 53 20 32
3 Collerense Collerense 14 47 36 26
4 Patronato A Patronato A 15 34 29 26
5 San Francisco C Francisco 15 46 26 25
6 Pla de na Tesa Tesa 15 37 35 25
7 CE Algaida CE Algaida 15 31 32 18
8 Son Cladera A Cladera 15 31 46 18
9 Binissalem A Binissalem 14 27 36 15
10 S'Horta S'Horta 14 28 43 13
11 Xilvar A Xilvar A 14 25 47 10
12 CE Esporles CE Esporles 15 18 57 2
TEMPORADA 2019/2020
PREFERENTE BALEAR JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético Baleares Sub 19 B Atlético 23 74 16 58
2 Constancia B Constancia 23 69 34 52
3 CD Felanitx Sub 19 Felanitx 23 55 33 45
4 Pla de na Tesa Tesa 23 49 48 39
5 Joventut Mallorca A Joventut 23 42 30 38
6 CD Manacor B Manacor 23 43 33 36
7 San Francisco C Francisco 23 44 45 36
8 CF Sóller A Sóller 23 53 42 33
9 Independiente Camp Redó Independient 23 51 48 30
10 Atlético Rafal B Atlético 23 41 50 29
11 CE Algaida CE Algaida 23 37 46 28
12 CE Esporles CE Esporles 23 42 54 25
13 UE Alcúdia A Alcúdia 23 36 63 22
14 SD La Salle B Salle 23 19 50 20
15 Patronato A Patronato A 23 29 57 16
16 UE Petra UE Petra 23 29 64 13
TEMPORADA 2018/2019
PREFERENTE BALEAR JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Calvià Atlético Sub 19 Calvià 30 97 19 74
2 CD Felanitx Sub 19 Felanitx 30 82 31 68
3 Pla de na Tesa Tesa 30 81 32 63
4 CD Serverense Serverense 30 87 49 59
5 Atlético Baleares Sub 19 B Atlético 30 81 42 57
6 Penya Arrabal C Penya 29 72 40 54
7 Pollença I Port Pollença 29 73 55 52
8 SD La Salle B Salle 30 61 57 42
9 Son Sardina A Sardina 30 57 60 42
10 Constancia B Constancia 30 54 51 39
11 Patronato A Patronato A 30 44 51 39
12 Col San Pedro Pedro 30 49 61 35
13 Santa Catalina Atletico A Santa 30 40 76 25
14 Escolar Escolar 30 46 106 16
15 Sp. Sant Marçal Sant Marçal 30 28 110 10
16 Santa Ponsa Santa Ponsa 28 13 125 1
TEMPORADA 2017/2018
PREFERENTE BALEAR JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Rafal Sub 19 Atlético 30 84 30 69
2 La Unión Sub 19 Unión 30 78 31 67
3 Atlético Baleares Sub 19 B Atlético 30 87 33 65
4 Escolar Escolar 30 89 40 62
5 CD Serverense Serverense 30 89 66 56
6 Constancia B Constancia 30 72 44 55
7 Patronato A Patronato A 30 65 56 48
8 Joventut Mallorca A Joventut 30 58 46 42
9 S'Horta S'Horta 30 69 53 40
10 Murense Murense 30 53 56 40
11 Arenal Arenal 30 55 75 39
12 Ciutat de Palma SA Ciutat Palma 30 55 75 33
13 Ferriolense B Ferriolense 30 38 58 30
14 Sineu Sineu 30 57 91 22
15 Llosetense Llosetense 30 29 127 10
16 Alaro Alaro 30 19 116 6
TEMPORADA 2016/2017
1ª BALEAR JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Constancia B Constancia 38 110 24 91
2 Pla de na Tesa Tesa 38 151 74 90
3 Escolar Escolar 38 104 35 89
4 Arenal Arenal 38 105 39 86
5 Sineu Sineu 38 101 64 75
6 CD Felanitx Sub 19 Felanitx 38 127 75 74
7 Son Cladera A Cladera 38 97 68 56
8 CE Algaida CE Algaida 38 104 79 55
9 Genova Genova 38 113 90 55
10 Son Sardina A Sardina 38 60 53 54
11 UE Petra UE Petra 38 74 74 54
12 Montaura Montaura 38 90 107 52
13 CE Campos CE Campos 38 87 85 48
14 Atletico Marratxi Atletico 38 63 80 42
15 Santa Catalina Atlético B Santa 38 67 130 36
16 Es Pla Es Pla 38 57 82 35
17 Sant Jordi A Sant Jordi 38 68 112 30
18 Ciutat de Palma B Ciutat Palma 38 37 131 22
19 A Llubi A Llubi 38 45 138 18
20 Atletico de Paguera Atletico 38 58 178 18
TEMPORADA 2015/2016
1ª BALEAR JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Ferriolense B Ferriolense 36 121 33 95
2 Consell CD Consell CD 37 140 53 88
3 Arta Arta 37 144 87 83
4 Pla de na Tesa Tesa 36 138 54 76
5 CE Algaida CE Algaida 37 116 62 73
6 Constancia B Constancia 37 96 43 72
7 Manacor C Manacor C 37 106 81 63
8 Son Cladera Son Cladera 37 86 71 57
9 Arenal Arenal 37 95 92 52
10 Genova Genova 36 77 71 50
11 Atletico Marratxi Atletico 37 86 107 48
12 Pollença I Port Pollença 37 69 90 43
13 CD Felanitx Sub 19 Felanitx 37 62 90 40
14 Sant Jordi A Sant Jordi 37 69 94 40
15 Sineu Sineu 37 66 114 30
16 Montaura Montaura 36 70 142 29
17 Santa Catalina Atlético B Santa 36 60 150 25
18 A Llubi A Llubi 37 48 138 21
19 Ciutat de Palma B Ciutat Palma 37 60 133 19
20 Llucmajor Llucmajor 14 28 32 14
TEMPORADA 2014/2015
1ª BALEAR JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 CF Sóller A Sóller 38 144 37 104
2 UE Alcúdia A Alcúdia 38 98 46 83
3 Montuiri Montuiri 38 121 63 81
4 Pollença i Port A Pollença 38 118 65 73
5 CE Esporles CE Esporles 38 92 66 66
6 San Pedro Col. Pedro Col. 38 122 84 65
7 Son Sardina A Sardina 38 66 55 60
8 Arenal Arenal 38 107 89 59
9 Constancia B Constancia 38 79 62 58
10 CD Felanitx Sub 19 Felanitx 38 106 91 58
11 Son Ferrer Son Ferrer 38 103 114 51
12 Margaritense Margaritense 38 90 89 50
13 Montaura Montaura 38 64 115 45
14 Genova Genova 38 97 116 44
15 Pla de na Tesa Tesa 38 85 87 41
16 Sineu Sineu 38 75 103 40
17 A-Llubi A-Llubi 38 69 122 37
18 Ciutat de Palma B Ciutat Palma 38 70 92 32
19 UE Petra UE Petra 38 79 139 20
20 Recreativo La Victoria B Recreativo 38 47 197 15

  USO DE MEMORIA  
5,751,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.3583
Total Execution Time  0.3597
  CADENA URL  
/historico/Constancia-B-Juvenil
  GET DATOS  
$_GET['/historico/Constancia-B-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0129  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 = 'Constancia-B-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.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=29714 AND type_rel = 2
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=827 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 827 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0130  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 (824282,275951) ORDER BY n.cover_points DESC, update_date DESC
0.0127  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 = '29714' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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=29714 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (69171) 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.0132  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69171 AND teamId = 29714
0.0128  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 = 29714 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0254  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 = 69171 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.0131  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.0128  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 = 59334 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 54131 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.0130  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 = 44639 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 39247 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 34271 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 17185 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 5176 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC