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 Juventus-Lloret Juventus-Llo 26 52 19 55
2 Farners Farners 28 43 32 52
3 Torroella Torroella 28 54 41 51
4 Sant Jaume Olot B CF A Sant Jaume. 28 56 39 47
5 Calonge Calonge 27 42 26 47
6 Fornells UE Fornells UE 28 60 41 45
7 Escola Girones Sabat A Escola 28 41 31 44
8 Porqueres Porqueres 27 34 23 43
9 Sporting-Vidrerenca Sporting-Vid 28 46 43 41
10 La Jonquera UE Jonquera 27 37 34 39
11 Cal Aguido Cal Aguido 28 47 45 38
12 Quart Quart 28 49 55 37
13 Palafrugell Palafrugell 28 38 47 36
14 Bellcaire 2012 Bellcaire 28 32 51 26
15 Empuriabrava Empuriabrava 27 27 51 23
16 Marca de L'Ham Marca L'Ham 26 25 52 22
17 Bisbalenc Atlético Bisbalenc 28 23 55 22
18 Tordera Tordera 28 42 63 20
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Roses Roses 20 35 21 44
2 Torroella Torroella 20 35 20 41
3 Begur Begur 20 41 29 37
4 La Jonquera UE Jonquera 20 35 23 33
5 Sant Jaume de Llierca Sant Jaume. 19 27 25 25
6 Porqueres Porqueres 20 19 20 25
7 Bisbalenc Atlético Bisbalenc 20 25 28 22
8 Marca de L'Ham Marca L'Ham 19 17 30 22
9 Empuriabrava Empuriabrava 20 27 34 21
10 Besalú Besalú 20 25 38 19
11 Viladamat CF Viladamat 20 21 39 15
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Can Gibert Can Gibert 22 55 12 56
2 Porqueres Porqueres 22 51 15 52
3 EF Bosc de Tosca Bosc Tosca 22 59 18 48
4 Empuriabrava Empuriabrava 21 41 19 44
5 Sant Jaume de Llierca Sant Jaume. 22 35 27 36
6 Marca de L'Ham Marca L'Ham 22 22 38 26
7 Roses Roses 22 44 43 25
8 Amer CF Amer CF 22 35 45 25
9 Besalú Besalú 22 28 42 20
10 Comacros Comacros 22 28 50 16
11 Llançà Llançà 21 24 68 10
12 Camprodon Camprodon 22 26 71 9
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Can Gibert Can Gibert 2 6 1 6
2 Comacros Comacros 2 5 2 4
3 Empuriabrava Empuriabrava 2 2 0 4
4 Besalú Besalú 2 2 1 4
5 Porqueres Porqueres 2 5 4 3
6 Sant Jaume de Llierca Sant Jaume. 1 0 0 1
7 EF Bosc de Tosca Bosc Tosca 2 0 2 1
8 Amer CF Amer CF 2 0 3 1
9 Marca de L'Ham Marca L'Ham 0 0 0 0
10 Llançà Llançà 1 1 4 0
11 Camprodon Camprodon 2 1 5 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Bescanó Bescanó 23 49 27 48
2 EF Bosc de Tosca Bosc Tosca 23 46 26 45
3 Guíxols Guíxols 22 53 24 43
4 Marca de L'Ham Marca L'Ham 23 30 19 38
5 Porqueres Porqueres 23 32 22 38
6 Sant Jaume de Llierca Sant Jaume. 22 32 28 35
7 Tossa Tossa 23 32 27 34
8 Can Gibert Can Gibert 23 33 36 33
9 Farners Farners 23 36 32 32
10 Amer CF Amer CF 23 28 34 32
11 Empuriabrava Empuriabrava 23 38 51 29
12 Blanes Blanes 23 32 51 27
13 Quart Quart 23 47 50 25
14 Camprodon Camprodon 23 33 39 25
15 Besalú Besalú 23 29 38 24
16 Malgrat Malgrat 23 26 41 24
17 Cassà Cassà 23 36 41 22
18 Llançà Llançà 23 26 52 14
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 L'Escala L'Escala 34 79 30 78
2 Bescanó Bescanó 34 62 22 76
3 Guíxols Guíxols 34 88 35 71
4 Can Gibert Can Gibert 34 63 51 57
5 EF Bosc de Tosca Bosc Tosca 34 62 47 54
6 Sant Jaume de Llierca Sant Jaume. 34 57 50 54
7 Quart Quart 34 47 44 46
8 Porqueres Porqueres 34 48 49 46
9 Tossa Tossa 34 52 63 45
10 Camprodon Camprodon 34 44 48 45
11 Besalú Besalú 34 45 52 44
12 Marca de L'Ham Marca L'Ham 34 51 48 44
13 Cassà Cassà 34 46 53 44
14 Caldes Malavella UE Caldes 34 47 64 43
15 CE Abadessenc Abadessenc 34 51 58 35
16 Vilartagues Vilartagues 34 42 79 28
17 Santa Pau P Santa Pau P 34 38 67 27
18 Base Roses Base Roses 34 39 101 26
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Girona FC B Girona FC B 34 86 25 87
2 Bescanó Bescanó 34 55 31 68
3 Can Gibert Can Gibert 34 65 43 62
4 Cassà Cassà 34 65 51 58
5 L'Escala L'Escala 34 55 44 58
6 EF Bosc de Tosca Bosc Tosca 34 61 43 56
7 Guíxols Guíxols 34 71 51 54
8 Porqueres Porqueres 34 62 46 52
9 CE Abadessenc Abadessenc 34 54 48 50
10 Tossa Tossa 34 49 58 46
11 Camprodon Camprodon 34 47 49 46
12 Marca de L'Ham Marca L'Ham 34 34 58 41
13 Caldes Malavella UE Caldes 34 44 48 36
14 Sant Jaume de Llierca Sant Jaume. 34 46 59 35
15 Palafrugell Palafrugell 34 52 71 35
16 Aro CE Aro CE 34 36 62 28
17 Roses Roses 34 43 71 23
18 Palafolls Palafolls 34 31 98 17
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Banyoles Banyoles 34 73 37 72
2 EF Bosc de Tosca Bosc Tosca 34 64 42 62
3 Cassà Cassà 34 66 41 61
4 L'Escala L'Escala 34 49 25 58
5 Camprodon Camprodon 34 57 41 58
6 Can Gibert Can Gibert 34 67 43 55
7 Bescanó Bescanó 34 53 45 55
8 Guíxols Guíxols 34 62 48 49
9 Roses Roses 34 50 48 47
10 Palafrugell Palafrugell 34 47 56 44
11 Palafolls Palafolls 34 41 56 43
12 Aro CE Aro CE 34 43 60 43
13 CE Abadessenc Abadessenc 34 35 49 41
14 Cornella Terri AE Cornella 34 58 70 36
15 Blanes Blanes 34 44 66 35
16 Campdevanol UE Campdevanol 34 44 64 31
17 Base Roses Base Roses 34 45 70 30
18 Angles Angles 34 31 68 25
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Llagostera B Llagostera 34 84 33 73
2 Palafolls Palafolls 34 55 34 68
3 Banyoles Banyoles 34 70 52 58
4 Camprodon Camprodon 34 56 54 52
5 Cassà Cassà 34 59 50 50
6 Base Roses Base Roses 34 47 54 49
7 EF Bosc de Tosca Bosc Tosca 34 55 44 49
8 Can Gibert Can Gibert 34 53 51 49
9 Guíxols Guíxols 34 64 54 49
10 Cornella Terri AE Cornella 34 56 50 48
11 Bescanó Bescanó 34 54 57 48
12 Blanes Blanes 34 61 67 48
13 Tordera Tordera 34 62 78 47
14 Breda Breda 34 55 66 41
15 Bisbalenc Atlético Bisbalenc 34 42 47 41
16 Sant Gregori AE Sant Gregori 34 35 69 31
17 Vilamalla Vilamalla 34 48 79 30
18 Besalú Besalú 34 41 58 29
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 CE Abadessenc Abadessenc 34 62 37 66
2 Camprodon Camprodon 34 58 40 64
3 Guíxols Guíxols 34 57 37 60
4 Vilamalla Vilamalla 34 56 44 55
5 Llagostera B Llagostera 34 51 36 54
6 Can Gibert Can Gibert 34 51 41 54
7 Cassà Cassà 34 50 47 47
8 Bisbalenc Atlético Bisbalenc 34 47 60 47
9 Bescanó Bescanó 34 52 48 46
10 Tordera Tordera 34 53 58 45
11 Besalú Besalú 34 43 44 44
12 Base Roses Base Roses 34 47 51 43
13 Breda Breda 34 51 57 43
14 Roses Roses 34 45 46 41
15 Quart Quart 34 46 51 40
16 Calonge Calonge 34 41 50 39
17 Aro CE Aro CE 34 57 68 39
18 Torroella Torroella 34 25 77 16

  USO DE MEMORIA  
6,153,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4255
Total Execution Time  0.4274
  CADENA URL  
/segunda_catalana2024/grupo1/historico
  GET DATOS  
$_GET['/segunda_catalana2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0127  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 683 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 72886 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.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 `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 = 68555 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.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 `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 = 63735 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.0674  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 = 58771 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.0133  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 = 50599 AND t.round = 23 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 `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 = 44409 AND t.round = 34 ORDER BY team.conference 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 `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 = 38993 AND t.round = 34 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` 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 = 33985 AND t.round = 34 ORDER BY team.conference 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 `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 = 16672 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 3948 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 18:35:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 18:35:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 18:35:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 18:35:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0136  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 = 72886 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72886 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.0134  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 = 72886 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72886 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  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 = 72886 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72886 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0187  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 = 72886 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