4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Empuriabrava
TEMPORADA 2023/2024
2ª CATALANA GRUPO 1
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 Porqueres Porqueres 28 36 23 46
7 Fornells UE Fornells UE 28 60 41 45
8 Escola Girones Sabat A Escola 28 41 31 44
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 27 25 54 22
17 Bisbalenc Atlético Bisbalenc 28 23 55 22
18 Tordera Tordera 28 42 63 20
TEMPORADA 2022/2023
2ª CATALANA GRUPO 1
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
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
3ª CATALANA GRUPO 15
Equipo PJ GF GC Puntos
1 Empuriabrava Empuriabrava 34 99 25 83
2 Llançà Llançà 34 96 42 76
3 Torroella Torroella 34 96 48 74
4 Portbou Portbou 34 71 64 64
5 Begur Begur 34 83 50 64
6 Bascara A Bascara A 34 57 57 56
7 Bisbalenc Atlético Bisbalenc 34 66 51 55
8 Vila-Sacra A Vila-Sacra 34 74 61 55
9 Navata Navata 34 78 75 44
10 Roses Roses 34 46 55 41
11 Cistella CF Cistella CF 34 68 84 40
12 Pals Atletic Pals Atletic 34 61 67 40
13 Vilamalla Vilamalla 34 42 61 34
14 Sant Pere Pescador FC Sant Pere P. 34 57 90 33
15 Borrassa FC Borrassa FC 34 47 73 29
16 Esplais CF Esplais CF 34 52 82 26
17 Agullana CD Agullana CD 34 45 91 25
18 Cabanes UE Cabanes UE 34 37 99 18
TEMPORADA 2017/2018
3ª CATALANA GRUPO 15
Equipo PJ GF GC Puntos
1 Base Roses Base Roses 32 101 34 79
2 Bisbalenc Atlético Bisbalenc 32 95 40 70
3 Empuriabrava Empuriabrava 32 71 39 63
4 Bascara A Bascara A 32 67 50 59
5 Llançà Llançà 32 68 52 53
6 Torroella Torroella 32 64 52 51
7 Sant Pere Pescador FC Sant Pere P. 32 65 50 50
8 Cistella CF Cistella CF 32 61 59 46
9 Agullana CD Agullana CD 32 80 74 42
10 Vilabertran AE Vilabertran 32 55 69 38
11 Esplais CF Esplais CF 32 59 71 38
12 Vila-Sacra A Vila-Sacra 32 47 78 36
13 Vilamalla Vilamalla 32 38 52 33
14 Begur Begur 32 61 74 32
15 Borrassa FC Borrassa FC 32 55 72 31
16 Monells AE Monells AE 32 52 81 28
17 Sant Miquel Fluvia A Sant Miquel 32 42 134 8
TEMPORADA 2016/2017
3ª CATALANA GRUPO 15
Equipo PJ GF GC Puntos
1 Marca de L'Ham Marca L'Ham 34 80 24 82
2 Llançà Llançà 34 79 36 74
3 Esplais CF Esplais CF 33 57 42 60
4 Sant Pere Pescador FC Sant Pere P. 34 67 44 58
5 Borrassa FC Borrassa FC 34 58 59 51
6 Bisbalenc Atlético Bisbalenc 34 62 36 50
7 Agullana CD Agullana CD 34 75 78 48
8 Bascara A Bascara A 34 54 49 46
9 Empuriabrava Empuriabrava 34 55 56 45
10 Vilabertran AE Vilabertran 34 57 79 44
11 Monells AE Monells AE 34 41 67 43
12 Torroella Torroella 34 54 81 42
13 Vilamalla Vilamalla 34 56 71 40
14 Cistella CF Cistella CF 34 65 73 40
15 Sant Miquel Fluvia A Sant Miquel 34 75 83 38
16 Albons A Albons A 34 54 70 37
17 Cabanes UE Cabanes UE 33 56 77 33
18 Viladamat CF Viladamat 34 46 66 32
TEMPORADA 2015/2016
4ª CATALANA GRUPO 30
Equipo PJ GF GC Puntos
1 Empuriabrava Empuriabrava 32 111 23 82
2 Sant Miquel Fluvia A Sant Miquel 32 88 41 73
3 Llado A Llado A 32 83 42 71
4 Navata Navata 31 85 49 65
5 Portbou Portbou 32 78 42 64
6 Base Roses B Base Roses 32 73 57 54
7 L'Armentera A L'Armentera 32 75 59 50
8 Vilajuïga CF A Vilajuïga 32 71 63 47
9 Colectividad Boliviana Cata Colectividad 32 73 81 44
10 Sant Llorenç Muga A Sant 32 60 79 42
11 Camallera A Camallera A 30 51 67 36
12 Selvatans A Selvatans A 32 80 101 35
13 Cadaqués Cadaqués 29 45 74 31
14 Llers Llers 30 50 104 25
15 Siurana A Siurana A 30 59 88 23
16 Vilafant FC A Vilafant 31 38 82 22
17 Vila-Sacra A Vila-Sacra 31 44 112 7

  USO DE MEMORIA  
5,793,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4849
Total Execution Time  0.4861
  CADENA URL  
/historico/Empuriabrava-Castello-A-Senior
  GET DATOS  
$_GET['/historico/Empuriabrava-Castello-A-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0133  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 = 'Empuriabrava-Castello-A-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.0125  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=66400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=66400 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66400 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 683 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1235030,1214782,1117609,935979,869940) ORDER BY n.cover_points DESC, update_date DESC
0.0129  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 = '66400' ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '66400' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '66400' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 72886 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=66400 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (72886) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 72886 AND teamId = 66400
0.0140  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 = 72886 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '66400' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '66400' and rp.type = 4
0.0127  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 = '66400' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 72886 WHERE rp.league_id = 72886 AND rp.teamId = 66400 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.0131  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 = 72886 WHERE rp.league_id = 72886 AND rp.teamId = 66400 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 72886 WHERE rp.league_id = 72886 AND rp.teamId = 66400 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 66400 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.0129  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.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 `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.0129  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.0129  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 = 44430 AND t.round = 34 ORDER BY team.conference 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 `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 = 39013 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 `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 = 34094 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 = 16919 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC