4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Borges Blanques
TEMPORADA 2023/2024
PRIMERA CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 San Mauro San Mauro 27 59 19 64
2 Martinenc Martinenc 27 47 21 56
3 San Juan At. M. Juan 27 57 34 54
4 Pirinaica Pirinaica 26 30 19 45
5 Júpiter Júpiter 26 34 29 43
6 Castellar Castellar 27 48 43 39
7 Borges Blanques Borges 27 41 38 38
8 Sant Cugat Sant Cugat 27 41 31 37
9 Igualada Igualada 27 36 32 32
10 Artesa de Segre Artesa Segre 26 21 41 32
11 Artesa Lleida CF Artesa 27 29 31 31
12 Turó Peira Turó Peira 27 24 41 31
13 Joanenc Joanenc 27 36 49 29
14 Unificació Llefià Unificació 27 31 45 28
15 Tàrrega Tàrrega 27 24 50 20
16 Alguaire CE Alguaire CE 26 16 51 15
TEMPORADA 2022/2023
2ª CATALANA GRUPO 9
Equipo PJ GF GC Puntos
1 Artesa Lleida CF Artesa 19 48 8 47
2 Borges Blanques Borges 19 51 20 42
3 Alcarràs Alcarràs 20 43 28 33
4 Balàfia Balàfia 20 47 43 33
5 Juneda Juneda 20 33 31 31
6 Alguaire CE Alguaire CE 19 34 30 30
7 Térmens Térmens 20 30 37 21
8 Pardinyes Pardinyes 20 28 42 21
9 Lleida Esportiu B Lleida 18 28 35 20
10 Torrefarrera Torrefarrera 20 22 46 13
11 Tremp Tremp 19 12 56 9
TEMPORADA 2021/2022
PRIMERA CATALANA GRUPO 3
Equipo PJ GF GC Puntos
1 Rapitenca Rapitenca 28 46 23 57
2 CFJ Mollerussa Mollerussa 28 53 32 55
3 Viladecans Viladecans 28 31 29 47
4 UE Valls UE Valls 28 40 28 45
5 Vilanova Geltru CF Vilanova 28 36 34 44
6 Atlètic Lleida Atlètic 28 53 40 40
7 El Catllar El Catllar 28 40 46 39
8 Igualada Igualada 28 33 34 37
9 Tàrrega Tàrrega 28 26 28 35
10 Martorell Martorell 28 28 33 35
11 Solsona Solsona 28 37 42 33
12 Alcarràs Alcarràs 28 37 44 33
13 Vista Alegre Vista Alegre 28 33 50 28
14 CF Gavá CF Gavá 28 35 47 27
15 Borges Blanques Borges 28 26 44 27
TEMPORADA 2020/2021
PRIMERA CATALANA GRUPO 4
Equipo PJ GF GC Puntos
1 CFJ Mollerussa Mollerussa 18 46 24 38
2 Can Vidalet Can Vidalet 18 36 24 36
3 Borges Blanques Borges 18 25 13 34
4 Solsona Solsona 18 26 21 28
5 At. Sant Just Sant Just 18 37 31 25
6 Atlètic Lleida Atlètic 18 25 28 22
7 Alcarràs Alcarràs 18 18 38 20
8 Martinenc Martinenc 18 21 31 19
9 Tàrrega Tàrrega 18 12 29 14
10 Martorell Martorell 18 24 31 13
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
PRIMERA CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Andorra FC Andorra 34 58 35 67
2 CE Manresa CE Manresa 34 64 34 66
3 Igualada Igualada 34 58 42 60
4 Viladecans Viladecans 34 49 34 60
5 CFJ Mollerussa Mollerussa 34 58 42 56
6 Montañesa Montañesa 34 42 27 55
7 Vilanova Geltru CF Vilanova 34 43 33 53
8 Tàrrega Tàrrega 34 53 43 48
9 Vista Alegre Vista Alegre 34 38 41 46
10 Júpiter Júpiter 34 42 49 44
11 Ce Efac Almacelles Efac 34 41 43 44
12 CF Gavá CF Gavá 34 38 38 42
13 Sant Ildefons Sant 34 42 55 38
14 Borges Blanques Borges 34 42 51 36
15 Lleida Esportiu B Lleida 34 28 45 34
16 Cambrils Cambrils 34 32 52 29
17 Rapitenca Rapitenca 34 34 57 29
18 Balaguer Balaguer 34 29 70 19
TEMPORADA 2017/2018
PRIMERA CATALANA GRUPO 2
Equipo PJ GF GC Puntos
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,894,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.5313
Total Execution Time  0.5328
  CADENA URL  
/historico/Borges-Blanques
  GET DATOS  
$_GET['/historico/Borges-Blanques']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0152  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 = 'Borges-Blanques' 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.0150  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=18207 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=18207 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18207 AND type_rel = 2
0.0165  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 = '18207' ORDER BY l.year DESC,cat.coefficient DESC
0.0155  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 = '18207' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0151  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 = '18207' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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=18207 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (72879,68563) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 72879 AND teamId = 18207
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 68563 AND teamId = 18207
0.0146  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 = '18207' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18207' and rp.type = 4
0.0148  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 = '18207' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0157  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 = 72879 WHERE rp.league_id = 72879 AND rp.teamId = 18207 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.0154  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 = 72879 WHERE rp.league_id = 72879 AND rp.teamId = 18207 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 72879 WHERE rp.league_id = 72879 AND rp.teamId = 18207 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 18207 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150  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 = 72879 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 68563 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.0149  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 = 63410 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.0147  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 = 58717 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.0150  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.0151  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 = 44408 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 38992 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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.0153  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.0149  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