4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del União de Coimbra
TEMPORADA 2023/2024
CAMPEONATO DE PORTUGAL GRUPO 3
Equipo PJ GF GC Puntos
1 União Santarém União 26 52 23 55
2 Lusitânia Lusitânia 26 40 22 51
3 Marinhense Marinhense 26 43 26 50
4 Alverca II Alverca II 26 34 19 39
5 União de Coimbra União 26 30 26 38
6 Benfica Castelo Branco Benfica 26 34 29 37
7 Sertanense Sertanense 26 26 25 37
8 Mortágua Mortágua 26 30 36 37
9 Peniche Peniche 26 28 39 37
10 Fontinhas Fontinhas 26 23 32 32
11 Rabo Peixe Rabo Peixe 26 30 34 30
12 Vitoria de Sernache Vitoria 26 17 30 25
13 Gouveia Gouveia 26 35 48 21
14 Uniao Tomar Uniao Tomar 26 20 53 17
TEMPORADA 2021/2022
CAMPEONATO DE PORTUGAL GRUPO 8
Equipo PJ GF GC Puntos
1 Vianense Vianense 6 9 4 13
2 Merelinense Merelinense 6 9 9 10
3 Os Limianos Os Limianos 6 7 8 6
4 Forjães Forjães 6 6 10 4
5 Pedras Salgadas Pedras 6 5 2 10
6 Maria da Fonte Maria Fonte 6 5 5 8
7 Mirandela Mirandela 6 2 3 6
8 Macedo Cavaleiros Macedo 6 4 6 6
9 Amarante Amarante 6 15 5 13
10 Tirsense Tirsense 6 7 7 9
11 Vila Real Vila Real 6 5 10 7
12 Berco Berco 6 8 13 4
13 Camacha Camacha 6 10 4 12
14 Vila Meã Vila Meã 6 5 5 7
15 Santa Marta Penaguião Santa Marta 6 4 6 6
16 Câmara de Lobos Câmara 6 7 11 5
17 Valadares Gaia Valadares 6 10 2 16
18 Espinho Espinho 6 5 5 8
19 Gondomar Gondomar 6 7 10 8
20 Santa Cruz de Alvarenga Santa Cruz. 6 6 11 1
21 Castro Daire Castro Daire 6 8 1 11
22 Ferreira de Aves Ferreira 6 7 7 11
23 União de Coimbra União 6 6 4 10
24 Gouveia Gouveia 6 2 11 0
25 Benfica Castelo Branco Benfica 6 14 7 14
26 Oleiros Oleiros 6 7 5 11
27 União Idanhense União 6 4 8 4
28 Condeixa Condeixa 6 6 11 3
29 Marinhense Marinhense 6 6 2 12
30 Coruchense Coruchense 6 8 5 10
31 Vitoria de Sernache Vitoria 6 7 5 8
32 Peniche Peniche 6 2 11 2
33 Sintrense Sintrense 6 10 4 13
34 Loures Loures 6 7 4 13
35 Sacavenense Sacavenense 6 10 8 9
36 O Elvas O Elvas 6 3 14 0
37 Praiense Praiense 6 12 6 12
38 Rabo Peixe Rabo Peixe 6 11 5 9
39 Operário Operário 6 8 7 8
40 Ideal Ideal 6 4 17 3
41 Juventude Évora Juventude 6 10 3 15
42 Serpa Serpa 6 10 6 10
43 FC Barreirense Barreirense 6 7 7 8
44 União Montemor União 6 3 14 1
45 Imortal DC Imortal DC 4 4 3 7
46 Esperança de Lagos Esperança 4 4 7 5
47 Louletano Louletano 4 7 5 4
TEMPORADA 1972/1973
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 30 101 13 58
2 Os Belenenses Belenenses 30 53 30 40
3 Vitória Setúbal Vitória 30 65 26 38
4 Porto Porto 30 56 28 37
5 Sporting CP Sporting CP 30 57 31 37
6 Vitória Guimarães Vitória 30 38 38 33
7 Boavista Boavista 30 41 47 31
8 Fabril Barreiro Fabril 30 38 37 30
9 Leixões Leixões 30 32 45 30
10 FC Barreirense Barreirense 30 43 64 25
11 Farense Farense 30 27 53 24
12 Beira Mar SC Beira 30 27 57 23
13 Montijo CD Montijo CD 30 29 47 23
14 União de Coimbra União 30 22 54 17
15 Atlético CP Atlético 30 27 52 17
16 Uniao Tomar Uniao Tomar 30 35 69 17

  USO DE MEMORIA  
5,469,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4094
Total Execution Time  0.4106
  CADENA URL  
/historico/Uniao-De-Coimbra
  GET DATOS  
$_GET['/historico/Uniao-De-Coimbra']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=50337 AND type_rel = 2
0.0147  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 = '50337' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 73486 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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=50337 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 (73560,73486) 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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 73486 AND teamId = 50337
0.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 73560 AND teamId = 50337
0.0148  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 = 73486 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '50337' 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 = '50337' 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 = '50337' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0165  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 = 73486 WHERE rp.league_id = 73486 AND rp.teamId = 50337 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.0169  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 = 73486 WHERE rp.league_id = 73486 AND rp.teamId = 50337 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 73486 WHERE rp.league_id = 73486 AND rp.teamId = 50337 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 = 50337 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152  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 = 73486 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.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 `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 = 63452 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.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 `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 = 66953 AND t.round = 6 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 `tables1973` 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 = 5740 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 73486 ORDER BY nameShow LIMIT 100