4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Guissona
TEMPORADA 2023/2024
2ª CATALANA GRUPO 5
Equipo PJ GF GC Puntos
1 Agramunt Escola Gerard Gate Agramunt 0 0 0 0
2 Alcarràs Alcarràs 0 0 0 0
3 At. Alpicat At. Alpicat 0 0 0 0
4 At. Castellserà Castellserà 0 0 0 0
5 Balàfia Balàfia 0 0 0 0
6 Balaguer Balaguer 0 0 0 0
7 Cervera Cervera 0 0 0 0
8 Guissona Guissona 0 0 0 0
9 Juneda Juneda 0 0 0 0
10 La Seu d' Urgell Urgell 0 0 0 0
11 Linyola Linyola 0 0 0 0
12 Lleida Ponent Esportiu B Lleida 0 0 0 0
13 Oliana Oliana 0 0 0 0
14 Palau d'Anglesola Palau 0 0 0 0
15 Pardinyes Pardinyes 0 0 0 0
16 Solsona Solsona 0 0 0 0
17 Soses CF Soses CF 0 0 0 0
18 Térmens Térmens 0 0 0 0
TEMPORADA 2022/2023
2ª CATALANA GRUPO 10
Equipo PJ GF GC Puntos
1 Artesa de Segre Artesa Segre 20 46 24 47
2 Guissona Guissona 20 39 17 40
3 Linyola Linyola 19 43 23 39
4 Solsona Solsona 20 29 26 32
5 La Seu d' Urgell Urgell 20 32 32 28
6 Gerard Gatell A.E. Gerard 18 30 20 26
7 Cervera Cervera 20 37 39 23
8 Palau d'Anglesola Palau 19 27 38 21
9 At. Castellserà Castellserà 20 20 37 18
10 Organyà Organyà 20 26 47 18
11 Angulària Angulària 20 25 51 13
TEMPORADA 2021/2022
2ª CATALANA GRUPO 9
Equipo PJ GF GC Puntos
1 Artesa de Segre Artesa Segre 20 55 20 49
2 Balaguer Balaguer 19 58 16 48
3 La Seu d' Urgell Urgell 20 29 29 35
4 At. Castellserà Castellserà 19 30 25 32
5 Guissona Guissona 20 34 26 29
6 Linyola Linyola 20 42 43 25
7 Palau d'Anglesola Palau 19 23 34 21
8 Angulària Angulària 18 25 28 20
9 Organyà Organyà 20 33 43 17
10 Cervera Cervera 20 22 46 17
11 Bellpuig Bellpuig 19 28 69 10
TEMPORADA 2020/2021
2ª CATALANA GRUPO 10
Equipo PJ GF GC Puntos
1 Balaguer Balaguer 2 11 1 6
2 Palau d'Anglesola Palau 2 5 1 6
3 Artesa de Segre Artesa Segre 2 5 1 6
4 Cervera Cervera 2 2 0 6
5 Linyola Linyola 2 3 2 4
6 Organyà Organyà 2 1 2 1
7 At. Castellserà Castellserà 2 0 3 0
8 Guissona Guissona 2 2 6 0
9 Angulària Angulària 2 1 5 0
10 Bellpuig Bellpuig 2 1 10 0
TEMPORADA 2019/2020
2ª CATALANA GRUPO 5
Equipo PJ GF GC Puntos
1 Borges Blanques Borges 23 66 13 61
2 Solsona Solsona 23 35 19 49
3 Artesa de Segre Artesa Segre 23 43 31 43
4 Torrefarrera Torrefarrera 23 31 20 38
5 Balàfia Balàfia 23 43 34 38
6 Lleida Esportiu B Lleida 23 49 34 35
7 Juneda Juneda 23 47 39 35
8 Angulària Angulària 23 27 32 34
9 Linyola Linyola 23 29 35 34
10 Balaguer Balaguer 23 36 31 32
11 At. Alpicat At. Alpicat 23 31 27 32
12 Sudanell Sudanell 23 41 52 27
13 Cervera Cervera 23 30 42 26
14 Guissona Guissona 23 36 39 24
15 Albi CF Albi CF 23 30 44 22
16 Palau d'Anglesola Palau 23 30 48 19
17 At. Castellserà Castellserà 23 16 50 18
18 Térmens Térmens 23 23 53 15
TEMPORADA 2018/2019
2ª CATALANA GRUPO 5
Equipo PJ GF GC Puntos
1 Alcarràs Alcarràs 34 72 40 71
2 Artesa de Segre Artesa Segre 34 77 38 67
3 Solsona Solsona 34 56 31 60
4 Balàfia Balàfia 34 65 50 60
5 At. Alpicat At. Alpicat 34 66 41 56
6 Juneda Juneda 34 71 58 56
7 Albi CF Albi CF 34 54 50 54
8 Torrefarrera Torrefarrera 34 55 48 51
9 Térmens Térmens 34 44 46 46
10 Palau d'Anglesola Palau 34 47 56 45
11 Linyola Linyola 34 58 55 43
12 Guissona Guissona 34 46 59 43
13 Cervera Cervera 34 52 56 41
14 At. Castellserà Castellserà 34 38 58 39
15 Gerard Gatell A.E. Gerard 34 52 66 38
16 Alcoletge Alcoletge 34 38 57 32
17 Organyà Organyà 34 46 77 30
18 Vallfogona de Balaguer Vallfogona 34 34 85 26
TEMPORADA 2017/2018
2ª CATALANA GRUPO 5
Equipo PJ GF GC Puntos
1 CFJ Mollerussa Mollerussa 34 79 24 80
2 Tàrrega Tàrrega 34 97 26 78
3 Linyola Linyola 34 67 42 67
4 Alcarràs Alcarràs 34 71 42 63
5 Solsona Solsona 34 68 51 58
6 Torrefarrera Torrefarrera 34 69 52 57
7 Térmens Térmens 34 37 35 55
8 Artesa de Segre Artesa Segre 34 52 41 48
9 Albi CF Albi CF 34 47 57 46
10 Cervera Cervera 34 42 56 44
11 Guissona Guissona 34 51 56 43
12 Juneda Juneda 34 63 72 43
13 At. Castellserà Castellserà 34 48 65 40
14 Palau d'Anglesola Palau 34 44 55 37
15 Organyà Organyà 34 36 66 33
16 Vallfogona de Balaguer Vallfogona 34 31 60 28
17 Bellpuig Bellpuig 34 37 69 26
18 Tremp Tremp 34 29 99 16
TEMPORADA 2016/2017
2ª CATALANA GRUPO 5
Equipo PJ GF GC Puntos
1 Borges Blanques Borges 34 69 25 79
2 Tàrrega Tàrrega 34 87 37 74
3 CFJ Mollerussa Mollerussa 34 71 44 63
4 Torrefarrera Torrefarrera 34 72 47 62
5 Solsona Solsona 34 72 52 59
6 Alcarràs Alcarràs 34 59 41 58
7 Linyola Linyola 34 47 32 54
8 Cervera Cervera 34 63 48 53
9 Organyà Organyà 34 48 68 44
10 Artesa de Segre Artesa Segre 34 56 62 42
11 Albi CF Albi CF 34 63 76 38
12 Bellpuig Bellpuig 34 43 67 38
13 Juneda Juneda 34 47 72 37
14 Guissona Guissona 34 53 65 36
15 At. Castellserà Castellserà 34 58 78 35
16 Palau d'Anglesola Palau 34 49 72 34
17 Gerard Gatell A.E. Gerard 34 41 70 31
18 Balàfia Balàfia 34 41 83 24
TEMPORADA 2015/2016
2ª CATALANA GRUPO 5
Equipo PJ GF GC Puntos
1 At. Alpicat At. Alpicat 34 99 40 89
2 Ce Efac Almacelles Efac 34 101 19 84
3 Borges Blanques Borges 34 81 54 71
4 CFJ Mollerussa Mollerussa 34 66 42 63
5 Albi CF Albi CF 34 60 54 59
6 Solsona Solsona 34 57 39 59
7 Balàfia Balàfia 34 70 65 50
8 Cervera Cervera 34 59 48 49
9 Linyola Linyola 34 35 36 48
10 Tàrrega Tàrrega 34 50 60 39
11 Guissona Guissona 34 47 61 38
12 Gerard Gatell A.E. Gerard 34 53 68 37
13 Bellpuig Bellpuig 34 35 67 36
14 Torrefarrera Torrefarrera 34 44 72 34
15 Artesa de Segre Artesa Segre 34 51 73 34
16 Organyà Organyà 34 48 65 32
17 Alcoletge Alcoletge 34 49 84 30
18 Mangraners CD Mangraners 34 29 87 9
TEMPORADA 2014/2015
2ª CATALANA GRUPO 5
Equipo PJ GF GC Puntos
1 FC Andorra FC Andorra 34 80 24 83
2 At. Alpicat At. Alpicat 34 91 28 81
3 Solsona Solsona 34 73 33 69
4 Borges Blanques Borges 34 60 43 64
5 Cervera Cervera 34 49 37 56
6 Linyola Linyola 34 51 30 55
7 Albi CF Albi CF 34 69 47 50
8 Guissona Guissona 34 62 57 50
9 Alcoletge Alcoletge 34 68 70 50
10 Balàfia Balàfia 34 43 48 44
11 Gerard Gatell A.E. Gerard 34 51 61 42
12 Artesa de Segre Artesa Segre 34 54 57 41
13 Organyà Organyà 34 52 58 41
14 Alcarràs Alcarràs 34 48 56 40
15 Angulària Angulària 34 39 65 34
16 Palau d'Anglesola Palau 34 41 74 29
17 Tremp Tremp 34 33 64 27
18 La Seu Durgell Durgell 34 27 139 4

  USO DE MEMORIA  
5,916,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.6373
Total Execution Time  0.6392
  CADENA URL  
/historico/Guissona
  GET DATOS  
$_GET['/historico/Guissona']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0127  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 = 'Guissona' 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.0111  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=18187 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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=18187 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0240  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72890
0.0112  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18187 AND type_rel = 2
0.0123  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 = '18187' ORDER BY l.year DESC,cat.coefficient DESC
0.0124  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 = '18187' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0119  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 = '18187' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0117  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 = 72890 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0125  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=18187 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0110  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 (72890) 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.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 72890 AND teamId = 18187
0.0107  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 = '18187' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18187' and rp.type = 4
0.0108  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 = '18187' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0108  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 = 72890 WHERE rp.league_id = 72890 AND rp.teamId = 18187 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.0107  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 = 72890 WHERE rp.league_id = 72890 AND rp.teamId = 18187 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0107  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 = 72890 WHERE rp.league_id = 72890 AND rp.teamId = 18187 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0109  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 = 18187 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0110  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 = 72890 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.0112  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 = 68564 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.0114  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 = 63743 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.0113  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 = 58782 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.0113  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 = 50603 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.0116  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 = 44413 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  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 = 38997 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 33989 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 16676 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 3952 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC