4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del L'Escala

L'Escala

Entrenador: Aday Benítez

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Olot Olot 31 46 17 70
2 L´Hospitalet L´Hospitale 30 46 27 57
3 UE Vilassar de Mar Vilassar 30 37 25 54
4 Badalona Badalona 30 34 31 47
5 AE Prat AE Prat 30 30 24 44
6 Tona Tona 30 44 40 43
7 L'Escala L'Escala 30 48 50 42
8 CFJ Mollerussa Mollerussa 30 28 37 41
9 FE Grama FE Grama 30 35 40 40
10 CF Peralada CF Peralada 30 30 28 40
11 Montañesa Montañesa 30 28 30 40
12 Reus FC Reddis Reus Reddis 30 25 25 38
13 Girona FC B Girona FC B 31 41 36 37
14 CP San Cristóbal Cristóbal 30 29 48 36
15 CF Pobla de Mafumet Pobla 30 29 33 35
16 FC Vilafranca Vilafranca 30 28 44 32
17 Rapitenca Rapitenca 30 31 40 30
18 Castelldefels Castelldefel 30 27 41 27
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
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 Montañesa Montañesa 26 48 25 53
2 Lloret Lloret 26 52 34 45
3 L'Escala L'Escala 26 47 33 42
4 Mollet Mollet 26 33 24 40
5 Mataró Mataró 26 38 32 40
6 Parets Parets 26 41 35 39
7 Bescanó Bescanó 26 32 36 38
8 Palamós Palamós 26 42 36 35
9 Unificació Llefià Unificació 26 36 36 35
10 Banyoles Banyoles 26 25 30 33
11 Martinenc Martinenc 26 26 33 32
12 Les Franqueses Franqueses 26 39 41 31
13 Llagostera B Llagostera 26 24 48 28
14 La Jonquera UE Jonquera 26 18 58 12
TEMPORADA 2020/2021
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 Tona Tona 18 37 20 36
2 Lloret Lloret 18 45 23 35
3 UE Vic UE Vic 18 33 17 29
4 L'Escala L'Escala 18 34 23 29
5 Bescanó Bescanó 18 25 15 29
6 Manlleu Manlleu 18 28 29 26
7 Palamós Palamós 18 21 18 23
8 Llagostera B Llagostera 18 22 28 23
9 Vic Riuprimer Riuprimer 18 17 29 15
10 La Jonquera UE Jonquera 18 7 67 1
TEMPORADA 2019/2020
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 Girona FC B Girona FC B 22 46 2 62
2 FE Grama FE Grama 22 34 24 42
3 Palamós Palamós 22 43 29 41
4 Manlleu Manlleu 22 37 28 41
5 UE Vic UE Vic 22 34 17 38
6 Guineueta Guineueta 22 29 20 34
7 Mataró Mataró 22 24 24 33
8 Júpiter Júpiter 21 26 30 26
9 L'Escala L'Escala 22 30 35 26
10 Rubí Rubí 21 24 37 26
11 Lloret Lloret 21 31 36 25
12 La Jonquera UE Jonquera 22 17 28 25
13 Sabadell Nord Sabadell 21 25 38 24
14 Mollet Mollet 21 32 33 22
15 Tona Tona 22 18 32 17
16 Parets Parets 22 25 45 16
17 Llagostera B Llagostera 21 14 31 13
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
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 UE Vilassar de Mar Vilassar 34 52 29 62
2 La Jonquera UE Jonquera 34 46 29 58
3 UA Horta UA Horta 34 41 34 58
4 CE Manresa CE Manresa 34 50 36 56
5 Martinenc Martinenc 34 53 48 55
6 UE Sants UE Sants 34 48 43 54
7 UE Vic UE Vic 34 42 33 52
8 Tona Tona 34 47 43 52
9 Farners Farners 34 38 32 51
10 FC Andorra FC Andorra 34 43 41 50
11 Mollet Mollet 34 34 33 47
12 Avià Avià 34 51 54 46
13 Lloret Lloret 34 42 42 43
14 Girona FC B Girona FC B 34 45 46 41
15 Mataró Mataró 34 47 45 41
16 L'Escala L'Escala 34 36 51 35
17 CE Abadessenc Abadessenc 34 37 66 30
18 Molletense Molletense 34 21 68 12
TEMPORADA 2014/2015
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 Júpiter Júpiter 34 61 32 71
2 EC Granollers Granollers 34 58 36 63
3 CE Manresa CE Manresa 34 50 27 59
4 Avià Avià 34 48 45 58
5 L'Escala L'Escala 34 42 30 54
6 UE Sants UE Sants 34 49 38 53
7 Lloret Lloret 34 55 42 50
8 Girona FC B Girona FC B 34 53 44 49
9 Mollet Mollet 34 34 32 49
10 La Jonquera UE Jonquera 34 53 49 47
11 UA Horta UA Horta 34 40 43 47
12 UE Vic UE Vic 34 48 55 44
13 Molletense Molletense 34 36 35 43
14 Farners Farners 34 35 40 43
15 UDA Gramanet Gramanet 34 40 46 37
16 Ce Tecnofutbol Tecnofutbol 34 34 59 34
17 Banyoles Banyoles 34 27 57 23
18 Montcada Montcada 34 25 78 15

  USO DE MEMORIA  
6,058,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.4547
Total Execution Time  0.4570
  CADENA URL  
/historico/L-Escala
  GET DATOS  
$_GET['/historico/L-Escala']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0134  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 = 'L-Escala' 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.0126  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=9254 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=9254 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9254 AND type_rel = 2
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9254 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0139  SELECT /*35 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 (49771,265100,264464,1022061,1167252) ORDER BY n.cover_points DESC, update_date DESC
0.0128  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 = '9254' 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 = '9254' 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 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=9254 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 (72264,68448,67320) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 72264 AND teamId = 9254
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 68448 AND teamId = 9254
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 9254
0.0127  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 = '9254' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  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 = '9254' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0135  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 = 72264 WHERE rp.league_id = 72264 AND rp.teamId = 9254 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.0134  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 = 72264 WHERE rp.league_id = 72264 AND rp.teamId = 9254 AND (e.action = 4 or e.action = 5) 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 = 72264 WHERE rp.league_id = 72264 AND rp.teamId = 9254 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 9254 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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 = 63408 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.0127  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 = 58714 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.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 `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 = 50597 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 = 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.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 = 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.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 `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 = 16583 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC