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 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 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
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
2ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Porreres Porreres 38 108 28 92
2 Algaida Algaida 38 105 46 91
3 Santa Mónica Santa 38 97 40 78
4 Vilafranca Vilafranca 37 90 57 74
5 CE Escolar CE Escolar 38 88 56 73
6 Athetic Club Montuiri Athetic Club 37 80 57 69
7 Alqueria Alqueria 38 65 57 62
8 Constancia B Constancia 38 77 64 58
9 Serralta Serralta 37 72 87 49
10 Soller B Soller B 38 59 62 49
11 Margaritense AtlÈtic Margaritense 38 54 65 48
12 Porto Cristo Porto Cristo 37 62 76 47
13 UE Lloret UE Lloret 38 68 85 43
14 Calvia Calvia 37 57 69 42
15 Atlético de Paguera Atlético 38 66 96 40
16 Santanyi DS Santanyi DS 38 46 78 37
17 Portol Portol 38 49 77 36
18 Pilares La Soledad Pilares 38 56 113 35
19 San Cayetano Cayetano 37 47 79 33
20 Atlético Marratxí Atlético 38 50 104 20
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
TEMPORADA 2015/2016
3ª REGIONAL BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Porreres Porreres 22 74 24 56
2 Olimpic de Felanitx Olimpic 22 62 23 52
3 Son Ximelis Son Ximelis 22 66 36 46
4 Margaritense AtlÈtic Margaritense 22 52 34 41
5 Son Sardina B Sardina 22 47 50 31
6 Constancia B Constancia 22 44 50 30
7 Esporles B Esporles B 22 41 31 29
8 Cardassar B Cardassar B 22 46 72 25
9 S'hostalot S'hostalot 22 28 49 20
10 Sant Jordi B Sant Jordi 22 31 49 18
11 Ses Salines Ses Salines 22 43 66 18
12 A Llubí B A Llubí B 22 34 84 10

  USO DE MEMORIA  
5,886,208 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5550
Total Execution Time  0.5569
  CADENA URL  
/historico/Constancia-B-Senior
  GET DATOS  
$_GET['/historico/Constancia-B-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0155  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-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.0145  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=85202 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=85202 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293  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.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=85202 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=686 AND type_rel = 3
0.0145  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.0147  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.0149  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 = '85202' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '85202' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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.0147  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=85202 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 73783 AND teamId = 85202
0.0149  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.0157  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 = 85202 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.0156  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 = 85202 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 85202 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 85202 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150  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.0153  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.0161  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.0165  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.0169  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.0164  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.0166  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 = 39185 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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
0.0152  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` 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 = 22217 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC