4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Can Gibert
TEMPORADA 2023/2024
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 Manlleu Manlleu 27 53 27 61
2 Argentona Argentona 27 41 25 49
3 Caldes Montbui Caldes 27 41 31 45
4 Tossa Tossa 27 47 40 42
5 Can Gibert Can Gibert 27 34 28 40
6 Bescanó Bescanó 27 52 46 39
7 Parets Parets 27 35 28 38
8 Montcada Montcada 27 44 40 37
9 Banyoles Banyoles 27 41 39 36
10 Mollet Mollet 27 41 41 36
11 Roses Roses 27 40 49 35
12 Cardedeu Cardedeu 27 26 37 31
13 Blanes Blanes 27 33 48 31
14 EF Bosc de Tosca Bosc Tosca 27 37 52 28
15 Mataró Mataró 27 36 44 23
16 Begur Begur 27 30 56 21
TEMPORADA 2022/2023
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 L'Escala L'Escala 30 52 30 59
2 Palamós Palamós 30 46 35 53
3 UE Vic UE Vic 30 43 31 53
4 UE Figueres UE Figueres 30 44 39 51
5 EC Granollers Granollers 30 51 34 49
6 Lloret Lloret 30 57 45 48
7 Mataró Mataró 30 46 46 41
8 Manlleu Manlleu 30 43 44 40
9 Parets Parets 30 34 35 38
10 Banyoles Banyoles 30 33 37 38
11 Caldes Montbui Caldes 30 55 54 36
12 EF Bosc de Tosca Bosc Tosca 30 37 40 35
13 Can Gibert Can Gibert 30 40 53 34
14 Mollet Mollet 30 29 35 33
15 Bescanó Bescanó 30 37 57 29
16 CF Torelló CF Torelló 30 30 62 21
TEMPORADA 2021/2022
2ª CATALANA GRUPO 1
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
TEMPORADA 2020/2021
2ª CATALANA GRUPO 1
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
TEMPORADA 2019/2020
2ª CATALANA GRUPO 1
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
TEMPORADA 2018/2019
2ª CATALANA GRUPO 1
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
TEMPORADA 2017/2018
2ª CATALANA GRUPO 1
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
TEMPORADA 2016/2017
2ª CATALANA GRUPO 1
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
TEMPORADA 2015/2016
2ª CATALANA GRUPO 1
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
TEMPORADA 2014/2015
2ª CATALANA GRUPO 1
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,074,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.0881
Total Execution Time  0.0896
  CADENA URL  
/historico/Can-Gibert
  GET DATOS  
$_GET['/historico/Can-Gibert']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18133 AND type_rel = 2
0.0022  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 = '18133' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '18133' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 72878 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=18133 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (72878) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72878 AND teamId = 18133
0.0020  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '18133' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18133' and rp.type = 4
0.0021  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '18133' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0030  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 = 72878 WHERE rp.league_id = 72878 AND rp.teamId = 18133 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.0028  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 = 72878 WHERE rp.league_id = 72878 AND rp.teamId = 18133 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 72878 WHERE rp.league_id = 72878 AND rp.teamId = 18133 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 18133 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68448 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.0032  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.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 = 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.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 `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.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 `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.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 `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.0041  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.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 `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.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 `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