4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Llagostera B

Llagostera B

Entrenador: Gabriel Maragall

Temporada 2021/2022
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
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 UE Vilassar de Mar Vilassar 34 56 31 70
2 Girona FC B Girona FC B 34 69 26 68
3 Banyoles Banyoles 34 42 31 57
4 Palamós Palamós 34 50 39 53
5 Guineueta Guineueta 34 50 44 52
6 Manlleu Manlleu 34 51 48 47
7 UE Vic UE Vic 34 41 29 46
8 Sabadell Nord Sabadell 34 46 54 46
9 Lloret Lloret 34 52 48 45
10 Can Vidalet Can Vidalet 34 45 44 44
11 Llagostera B Llagostera 34 53 58 44
12 Rubí Rubí 34 45 47 43
13 Tona Tona 34 52 65 42
14 La Jonquera UE Jonquera 34 40 53 41
15 Sant Cugat Sant Cugat 34 42 51 40
16 San Juan At. M. Juan 34 52 64 36
17 Farners Farners 34 29 49 36
18 Argentona Argentona 34 37 71 28
TEMPORADA 2017/2018
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 FE Grama FE Grama 34 64 29 73
2 CE Manresa CE Manresa 34 57 26 66
3 Can Vidalet Can Vidalet 34 47 32 57
4 UE Vic UE Vic 34 53 39 55
5 Montañesa Montañesa 34 44 34 54
6 Farners Farners 34 52 45 53
7 Manlleu Manlleu 34 40 43 52
8 La Jonquera UE Jonquera 34 45 48 44
9 Llagostera B Llagostera 34 50 52 43
10 San Juan At. M. Juan 34 49 46 43
11 Sant Cugat Sant Cugat 34 47 49 43
12 Júpiter Júpiter 34 34 45 42
13 Banyoles Banyoles 34 31 38 41
14 Lloret Lloret 34 51 54 40
15 Cardedeu Cardedeu 34 53 63 40
16 Sabadell B Sabadell B 34 36 44 40
17 Mollet Mollet 34 43 55 37
18 Castellar Castellar 34 27 81 18
TEMPORADA 2016/2017
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 UA Horta UA Horta 34 68 32 65
2 UE Sants UE Sants 34 48 35 62
3 FC Andorra FC Andorra 34 43 32 62
4 Martinenc Martinenc 34 49 42 55
5 Llagostera B Llagostera 34 45 37 51
6 Lloret Lloret 34 45 41 50
7 Mollet Mollet 34 51 44 49
8 UE Vic UE Vic 34 42 45 46
9 Farners Farners 34 44 46 45
10 CE Manresa CE Manresa 34 38 34 43
11 San Juan At. M. Juan 34 48 56 42
12 Sant Cugat Sant Cugat 34 47 49 40
13 Girona FC B Girona FC B 34 42 40 40
14 Masnou Masnou 34 38 44 40
15 Tona Tona 34 43 56 37
16 Ripollet Ripollet 34 32 54 34
17 Avià Avià 34 40 55 31
18 Hermes A Hermes A 34 29 50 28
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  
5,735,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.1318
Total Execution Time  0.1335
  CADENA URL  
/historico/Llagostera-B
  GET DATOS  
$_GET['/historico/Llagostera-B']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0030  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 = 'Llagostera-B' 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.0030  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 = 'Llagostera-B' 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.0018  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=18132 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=18132 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=18132 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=18132 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=18132 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=18132 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=18132 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=18132 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=18132 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=18132 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18132 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 18132 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020  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 (48780) ORDER BY n.cover_points DESC, update_date DESC
0.0047  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 = '18132' AND l.year = 2022 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 = '18132' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = '18132' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 63408 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=18132 AND l.year in (2021,2022,2023) 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 (63408) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 63408 AND teamId = 18132
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '18132' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0052  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18132' and rp.type = 4
0.0020  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 = '18132' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0039  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 events2022 e ON e.player_id = p.id AND e.league_id = 63408 WHERE rp.league_id = 63408 AND rp.teamId = 18132 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.0033  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 events2022 e ON e.player_id = p.id AND e.league_id = 63408 WHERE rp.league_id = 63408 AND rp.teamId = 18132 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 events2022 e ON e.player_id = p.id AND e.league_id = 63408 WHERE rp.league_id = 63408 AND rp.teamId = 18132 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 18132 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0024  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 = 33951 AND t.round = 34 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 `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.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 `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.0019  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 63408 ORDER BY nameShow LIMIT 100