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 Palmanyola Palmanyola 27 69 25 64
2 Urbanitzacions Urbanitzacio 27 68 28 64
3 Cala D'or Cala D'or 27 104 39 61
4 Rotlet Molinar B Rotlet 27 81 37 57
5 Poblense B Poblense B 28 65 47 50
6 Sant Jordi B Sant Jordi 27 54 64 38
7 Santa Catalina Atlético B Santa 27 52 54 36
8 Son Sardina Son Sardina 27 52 65 35
9 Unio Esportiva Valldemossa Unio 27 67 70 34
10 Santa Ponsa B Santa Ponsa 27 47 59 32
11 Portol B Portol B 27 47 61 32
12 Algaida B Algaida B 28 51 85 29
13 Playa de Palma del A Playa Palma 27 47 72 23
14 Bunyola Bunyola 27 36 79 16
15 Consell B Consell B 28 39 94 10
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Alaró B Alaró B 26 80 29 63
2 Vilafranca Vilafranca 25 95 34 58
3 Maria de la Salut Maria Salut 26 75 33 58
4 S'arraco S'arraco 25 73 26 57
5 Son Cladera B Cladera 26 70 32 50
6 Cala D'or Cala D'or 26 55 46 40
7 Santa Ponsa B Santa Ponsa 26 56 56 33
8 Lloret del S Lloret 26 45 60 29
9 Ferriolense B Ferriolense 26 63 88 29
10 Llosetense C Llosetense 26 48 67 26
11 Recreativo Marratxí del Atm Recreativo 26 29 45 25
12 Unión Latina Unión 26 35 83 22
13 Sant Jordi C Sant Jordi 26 32 77 16
14 San Roque B San Roque B 26 32 112 9
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Sta Ponsa Talarrubias Ponsa 38 78 36 83
2 Andratx B Andratx B 37 95 30 82
3 Consell Consell 38 89 43 81
4 Santa Ponsa Santa Ponsa 37 78 44 71
5 Baleares Sin Fronteras Baleares 38 66 39 71
6 Pilares La Soledad Pilares 38 67 56 62
7 Sporting Sant Marçal Sporting 37 61 55 54
8 Santa Mónica Santa 37 74 71 54
9 CD Binissalem B Binissalem 38 56 58 54
10 Soller B Soller B 36 67 59 53
11 UE Alcudia B Alcudia 38 66 58 52
12 Port de Soller Port Soller 38 51 62 51
13 Atlético Marratxí Atlético 37 73 77 45
14 Sant Jordi B Sant Jordi 37 63 70 45
15 Athetic Club Montuiri Athetic Club 37 52 75 43
16 Margaritense AtlÈtic Margaritense 36 62 69 39
17 Deportivo Marratxi Deportivo 37 52 98 29
18 Taujá Taujá 38 42 91 23
19 Establiments Establiments 36 27 96 23
20 Santanyi del Atb B Santanyi 30 35 67 21
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 CE Escolar CE Escolar 19 50 21 44
2 Sta Ponsa Talarrubias Ponsa 19 44 23 37
3 Andratx B Andratx B 19 30 16 35
4 Santa Mónica Santa 19 34 27 34
5 Soller B Soller B 19 29 30 25
6 Taujá Taujá 19 23 34 25
7 Establiments Establiments 19 26 34 22
8 Bunyola Bunyola 19 29 30 21
9 CD Binissalem B Binissalem 19 23 31 20
10 Valldemossa Atl Valldemossa 19 24 39 17
11 Poblense B Poblense B 20 20 47 12
Ver
TEMPORADA 2019/2020
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
Ver
TEMPORADA 2018/2019
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
Ver
TEMPORADA 2017/2018
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
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Bunyola Bunyola 38 102 29 90
2 Son Veri Son Veri 38 112 64 78
3 CF Pollença Pollença 37 98 49 70
4 Establiments Establiments 38 72 52 69
5 Montaura Montaura 38 72 42 66
6 Baleares Sin Fronteras Baleares 35 73 49 65
7 UEF Santa María Santa María 37 79 58 62
8 Llucmajor Llucmajor 38 70 54 59
9 Athetic Club Montuiri Athetic Club 38 75 58 58
10 Portol Portol 38 76 67 58
11 Algaida Algaida 38 68 65 57
12 Soller B Soller B 38 65 67 54
13 Alqueria Alqueria 37 76 73 49
14 Serralta Serralta 38 67 80 48
15 Porto Cristo Porto Cristo 38 67 89 46
16 Vilafranca Vilafranca 38 73 93 38
17 San Cayetano Cayetano 38 57 90 36
18 Santanyi DS Santanyi DS 37 40 92 29
19 Sporting Valldemossa Sporting 38 55 101 25
20 Son Ferrer Son Ferrer 35 32 157 6
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Valldemossa Atl Valldemossa 37 101 40 80
2 Son Sardina Son Sardina 37 85 38 80
3 Cala Millor Cala Millor 36 78 51 67
4 Llucmajor Llucmajor 37 58 41 64
5 Llosetense C Llosetense 36 76 55 62
6 Baleares Sin Fronteras Baleares 36 71 47 59
7 Maria de la Salut Maria Salut 36 79 66 57
8 Serralta Serralta 36 71 57 56
9 Soller B Soller B 36 63 55 55
10 Montaura Montaura 36 65 61 55
11 Porto Cristo Porto Cristo 36 50 49 54
12 San Cayetano Cayetano 37 72 79 49
13 UEF Santa María Santa María 37 64 78 42
14 Bunyola Bunyola 36 44 62 37
15 Vilafranca Vilafranca 37 68 89 37
16 Alqueria Alqueria 37 75 88 34
17 Sporting Valldemossa Sporting 36 63 98 33
18 Son Ximelis Son Ximelis 37 43 80 29
19 Poblense B Poblense B 37 50 111 28
20 Pollença B Pollença B 9 7 38 4

  USO DE MEMORIA  
6,057,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.1400
Total Execution Time  0.1434
  CADENA URL  
/segunda_regional_baleares2024/grupo1/historico
  GET DATOS  
$_GET['/segunda_regional_baleares2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0018  SELECT type FROM routes WHERE alias = 'segunda_regional_baleares2024'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_regional_baleares' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=687 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 687 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,195814,194841) ORDER BY n.cover_points DESC, update_date DESC
0.0017  SELECT id,name,alias,stepParent FROM categories WHERE parentId=687 ORDER BY order_id ASC
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 = 73787 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 687 AND group_code = 1 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 = 73787 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.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` 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 = 69165 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.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 `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 = 63706 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.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 `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 = 59032 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.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.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 `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.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` 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.0018  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 = 34312 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 16795 AND t.round = 38 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 = 3983 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 22:28:36' 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-04-27 22:28:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 22:28:36' 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-04-27 22:28:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  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 = 73787 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73787 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.0018  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 = 73787 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73787 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0031  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 = 73787 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73787 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0049  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 = 73787 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