4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Cardassar Cardassar 30 55 21 67
2 CD Son Cladera Cladera 30 50 17 58
3 Son Veri Son Veri 30 58 38 54
4 UD Alaró UD Alaró 30 55 34 52
5 Esporles Esporles 30 47 35 50
6 Serverense Serverense 30 46 31 49
7 Atletico Rafal Atletico 30 45 43 49
8 Santa Mónica Santa 30 52 40 47
9 Santa Catalina Atlético Santa 30 42 41 39
10 Murense Murense 30 40 48 35
11 Algaida Algaida 30 43 64 31
12 UE Petra UE Petra 30 38 63 31
13 Espanya Espanya 30 37 43 30
14 Xilvar Xilvar 30 44 64 25
15 Santa Ponsa Santa Ponsa 30 34 61 24
16 Sta Ponsa Talarrubias Ponsa 30 33 76 16
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 UE Alcudia UE Alcudia 30 76 25 69
2 Cardassar Cardassar 30 73 31 69
3 Algaida Algaida 30 66 28 59
4 CD Son Cladera Cladera 30 48 33 48
5 UD Alaró UD Alaró 30 43 40 41
6 Serverense Serverense 30 34 35 41
7 Atletico Rafal Atletico 30 43 44 40
8 CE Xilvar CE Xilvar 30 33 48 39
9 Son Veri Son Veri 30 32 55 37
10 Campos Campos 30 58 57 35
11 Recreativo La Victoria Recreativo 30 38 56 35
12 Indep. Camp Redó Indep. Camp 30 50 54 34
13 S´Horta S´Horta 30 43 53 34
14 Calvia Calvia 30 43 50 34
15 Son Sardina Son Sardina 30 41 63 26
16 Alqueria Alqueria 30 23 72 17
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 CD Menorca CD Menorca 20 56 20 46
2 CE Alaior CE Alaior 20 47 17 44
3 UD Mahón UD Mahón 20 52 20 42
4 CD Migjorn CD Migjorn 20 46 21 39
5 CE Ferreries Ferreries 20 34 23 36
6 CCE Sant Lluís Sant Lluís 20 31 44 26
7 Penya Ciutadella Penya 20 28 31 23
8 Atlètic De Ciutadella Atlètic 20 24 42 21
9 UE Sami UE Sami 20 16 34 13
10 Sporting de Mahón Sporting 20 18 54 8
11 Atlético Villacarlos Atlético 20 15 61 8
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Rotlet Molinar Rotlet 18 25 9 38
2 Murense Murense 18 25 11 37
3 Sineu Sineu 18 36 21 29
4 Serverense Serverense 18 30 23 29
5 UD Alaró UD Alaró 18 23 29 22
6 Alqueria Alqueria 18 20 28 22
7 CE Xilvar CE Xilvar 18 26 26 21
8 Cala Millor Cala Millor 18 18 33 20
9 Atletico Rafal Atletico 18 19 25 18
10 La Unión CF Unión 18 18 35 13
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Mercadal Mercadal 12 36 4 34
2 CE Alaior CE Alaior 13 26 20 25
3 CCE Sant Lluís Sant Lluís 13 22 16 23
4 UD Mahón UD Mahón 12 27 15 19
5 UE Sami UE Sami 13 14 16 17
6 Sporting de Mahón Sporting 13 19 15 16
7 CD Menorca CD Menorca 13 20 20 16
8 CE Ferreries Ferreries 13 22 28 15
9 CD Migjorn CD Migjorn 13 18 22 14
10 Penya Ciutadella Penya 12 16 37 7
11 Atlètic De Ciutadella Atlètic 13 8 35 6
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 UD Mahón UD Mahón 16 51 12 39
2 Sporting de Mahón Sporting 16 37 11 35
3 CE Ferreries Ferreries 16 29 18 27
4 CD Migjorn CD Migjorn 16 30 24 24
5 CE Alaior CE Alaior 16 29 35 23
6 UE Sami UE Sami 16 23 26 21
7 Penya Ciutadella Penya 16 15 25 18
8 CCE Sant Lluís Sant Lluís 16 23 33 13
9 Atlètic De Ciutadella Atlètic 16 11 64 1
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Sporting de Mahón Sporting 16 26 8 34
2 UD Mahón UD Mahón 16 44 17 33
3 CE Ferreries Ferreries 16 35 19 30
4 UE Sami UE Sami 16 23 20 26
5 Penya Ciutadella Penya 16 25 21 24
6 CCE Sant Lluís Sant Lluís 16 26 22 21
7 CE Alaior CE Alaior 16 22 33 15
8 Atlètic De Ciutadella Atlètic 16 8 30 10
9 CD Migjorn CD Migjorn 16 7 46 6
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 UD Mahón UD Mahón 16 35 16 37
2 UE Sami UE Sami 16 32 13 36
3 CCE Sant Lluís Sant Lluís 16 32 26 23
4 CE Ferreries Ferreries 16 18 19 22
5 CE Alaior CE Alaior 16 21 23 21
6 Atlètic De Ciutadella Atlètic 16 19 30 20
7 Sporting de Mahón Sporting 16 11 14 16
8 CD Migjorn CD Migjorn 16 18 31 14
9 CD Menorca CD Menorca 16 19 33 11
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 CE Alaior CE Alaior 16 32 11 38
2 Sporting de Mahón Sporting 16 26 11 34
3 UD Mahón UD Mahón 16 27 12 30
4 UE Sami UE Sami 15 29 22 28
5 CD Menorca CD Menorca 15 20 18 23
6 CE Ferreries Ferreries 16 21 26 18
7 Atlètic De Ciutadella Atlètic 16 22 37 13
8 CD Migjorn CD Migjorn 16 16 36 10
9 CCE Sant Lluís Sant Lluís 16 9 29 10
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 CE Ferreries Ferreries 18 46 14 43
2 CE Alaior CE Alaior 18 40 21 40
3 UE Sami UE Sami 17 35 16 32
4 Sporting de Mahón Sporting 18 38 24 32
5 UD Mahón UD Mahón 17 21 20 28
6 CCE Sant Lluís Sant Lluís 18 23 31 22
7 CF Norteño CF Norteño 18 19 30 18
8 CD Menorca CD Menorca 17 16 22 16
9 Atlètic De Ciutadella Atlètic 17 15 36 11
10 CD Migjorn CD Migjorn 18 12 51 5
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 CE Ferreries Ferreries 18 35 15 39
2 CD Migjorn CD Migjorn 18 30 17 39
3 CE Alaior CE Alaior 18 36 20 36
4 Atlètic De Ciutadella Atlètic 18 29 23 27
5 CD Menorca CD Menorca 18 22 22 25
6 UE Sami UE Sami 18 24 35 20
7 UD Mahón UD Mahón 18 21 25 19
8 CCE Sant Lluís Sant Lluís 18 22 28 17
9 Sporting de Mahón Sporting 18 15 30 15
10 CF Norteño CF Norteño 18 21 40 14
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 CD Migjorn CD Migjorn 18 34 17 37
2 Ce Ferreries Ferreries 18 32 17 35
3 CD Menorca CD Menorca 18 25 15 31
4 CE Alaior CE Alaior 18 28 28 31
5 UE Sami UE Sami 18 27 26 28
6 Atlètic De Ciutadella Atlètic 18 25 24 26
7 Atlético Villacarlos Atlético 18 23 31 20
8 UD Mahón UD Mahón 18 23 33 20
9 CCE Sant Lluís Sant Lluís 18 24 24 19
10 CF Norteño CF Norteño 18 16 42 5

  USO DE MEMORIA  
6,019,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1308
Total Execution Time  0.1328
  CADENA URL  
/illes_balears2024/grupo2/historico
  GET DATOS  
$_GET['/illes_balears2024/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'illes_balears' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=79 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 79 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 (1105676,1105343,1104898,676494,412502) ORDER BY n.cover_points DESC, update_date DESC
0.0020  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73341 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 79 AND group_code = 2 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 73341 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.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 `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 = 68764 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.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 `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 = 63861 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.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` 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 = 58942 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.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 `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 = 51181 AND t.round = 14 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 `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 = 44633 AND t.round = 18 ORDER BY team.conference 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 `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 = 39696 AND t.round = 18 ORDER BY team.conference 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 `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 = 34176 AND t.round = 18 ORDER BY team.conference 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 `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 = 16707 AND t.round = 18 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 `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 = 4320 AND t.round = 18 ORDER BY team.conference 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 `tables2014` 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 = 2684 AND t.round = 18 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 `tables2013` 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 = 2054 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 09:28:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 09:28:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 09:28:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 09:28:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0153  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73341 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73341 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0195  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73341 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73341 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0035  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73341 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73341 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0046  SELECT *,(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 = 73341 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