4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA RUMANA GRUPO 2
Equipo PJ GF GC Puntos
1 UTA Arad UTA Arad 7 12 8 34
2 Oțelul Galați Oțelul 7 8 5 33
3 Hermannstadt Hermannstadt 7 10 5 31
4 Universitatea Cluj Universitate 7 8 7 29
5 Petrolul Ploiesti Petrolul 7 6 11 26
6 Botosani Botosani 7 11 9 24
7 Voluntari Voluntari 7 11 9 23
8 U Craiova 1948 Craiova 1948 7 6 10 22
9 Dinamo Bucureşti Dinamo 7 5 9 21
10 Politehnica Iași Politehnica 7 4 8 21
TEMPORADA 2022/2023
SEGUNDA RUMANÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Politehnica Iași Politehnica 10 20 8 60
2 CSA Steaua Bucuresti Steaua 10 16 18 52
3 Oțelul Galați Oțelul 10 8 13 49
4 Dinamo Bucureşti Dinamo 10 16 12 46
5 FC Buzău FC Buzău 10 9 11 42
6 Unirea Dej Unirea Dej 10 2 9 40
TEMPORADA 2021/2022
LIGA RUMANA GRUPO 3
Equipo PJ GF GC Puntos
1 Sepsi Sepsi 9 21 4 42
2 Botosani Botosani 9 18 9 41
3 FC Rapid Bucuresti Rapid 9 22 7 39
4 U Craiova 1948 Craiova 1948 9 14 11 34
5 UTA Arad UTA Arad 9 10 6 33
6 Mioveni Mioveni 9 12 10 31
7 Chindia Târgovişte Chindia 9 8 8 26
8 Dinamo Bucureşti Dinamo 9 14 11 23
9 LPS HD Clinceni Clinceni 9 4 32 -43
10 Gaz Metan Gaz Metan 9 6 31 -46
TEMPORADA 2020/2021
LIGA RUMANA GRUPO 2
Equipo PJ GF GC Puntos
1 Chindia Târgovişte Chindia 9 7 3 36
2 Gaz Metan Gaz Metan 9 15 10 32
3 Viitorul Constanţa Viitorul 9 9 4 32
4 UTA Arad UTA Arad 9 7 9 32
5 Dinamo Bucureşti Dinamo 9 11 8 31
6 FC Arges FC Arges 9 10 7 31
7 Voluntari Voluntari 9 6 7 28
8 Hermannstadt Hermannstadt 9 6 9 26
9 FC Astra Giurgiu Astra 9 6 12 24
10 Politehnica Iași Politehnica 9 7 15 20
TEMPORADA 2019/2020
LIGA RUMANA GRUPO 3
Equipo PJ GF GC Puntos
1 Viitorul Constanţa Viitorul 14 25 17 43
2 Hermannstadt Hermannstadt 12 18 14 35
3 Sepsi Sepsi 13 19 17 34
4 LPS HD Clinceni Clinceni 14 14 21 32
5 Voluntari Voluntari 14 16 12 31
6 Politehnica Iași Politehnica 14 17 17 30
7 Dinamo Bucureşti Dinamo 9 8 11 25
8 Chindia Târgovişte Chindia 12 9 17 23
TEMPORADA 2018/2019
LIGA RUMANA GRUPO 1
Equipo PJ GF GC Puntos
1 CFR Cluj CFR Cluj 26 39 16 54
2 FCSB FCSB 26 49 29 49
3 Universitatea Craiova Universitate 26 43 24 45
4 FC Astra Giurgiu Astra 26 36 23 42
5 Viitorul Constanţa Viitorul 26 26 27 38
6 Sepsi Sepsi 26 32 25 37
7 Botosani Botosani 26 31 33 36
8 Politehnica Iași Politehnica 26 28 38 34
9 Dinamo Bucureşti Dinamo 26 29 37 32
10 Hermannstadt Hermannstadt 26 25 28 32
11 Gaz Metan Gaz Metan 26 25 32 31
12 Dunărea Călăraşi Dunărea 26 16 25 24
13 Voluntari Voluntari 26 30 46 21
14 Concordia Chiajna Concordia 26 19 45 18
TEMPORADA 2017/2018
LIGA RUMANA GRUPO 3
Equipo PJ GF GC Puntos
1 Dinamo Bucureşti Dinamo 14 29 10 54
2 Botosani Botosani 14 12 9 40
3 Sepsi Sepsi 14 21 14 34
4 Gaz Metan Gaz Metan 14 18 15 30
5 Concordia Chiajna Concordia 14 13 17 30
6 Voluntari Voluntari 14 16 22 27
7 ACS Poli Timişoara Poli 14 10 16 27
8 Daco-Getica Daco-Getica 14 9 25 17
TEMPORADA 2016/2017
LIGA RUMANA GRUPO 3
Equipo PJ GF GC Puntos
1 Viitorul Constanţa Viitorul 10 12 8 44
2 FCSB FCSB 10 15 7 44
3 Dinamo Bucureşti Dinamo 10 15 8 40
4 CFR Cluj CFR Cluj 10 8 14 33
5 Universitatea Craiova Universitate 10 8 14 31
6 FC Astra Giurgiu Astra 10 10 17 27
TEMPORADA 2015/2016
LIGA RUMANA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Astra Giurgiu Astra 10 20 9 48
2 FCSB FCSB 10 18 8 43
3 Pandurii Pandurii 10 12 7 39
4 Dinamo Bucureşti Dinamo 10 12 15 36
5 Viitorul Constanţa Viitorul 10 14 21 29
6 Tîrgu Mures Tîrgu Mures 10 8 24 22
TEMPORADA 2014/2015
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FCSB FCSB 34 59 23 71
2 Tîrgu Mures Tîrgu Mures 34 51 25 68
3 FC Astra Giurgiu Astra 34 53 27 57
4 CFR Cluj CFR Cluj 34 46 29 57
5 Universitatea Craiova Universitate 34 40 34 53
6 Petrolul Ploiesti Petrolul 34 42 30 52
7 Dinamo Bucureşti Dinamo 34 47 44 48
8 Botosani Botosani 34 40 43 47
9 Pandurii Pandurii 34 47 42 45
10 Politehnica Iași Politehnica 34 31 39 43
11 Viitorul Constanţa Viitorul 34 44 54 43
12 Concordia Chiajna Concordia 34 39 44 41
13 Gaz Metan Gaz Metan 34 29 34 39
14 FC Brasov FC Brasov 34 33 46 36
15 Universitatea Cluj Universitate 34 29 41 35
16 FC Rapid Bucuresti Rapid 34 21 42 33
17 Oțelul Galați Oțelul 34 24 45 32
18 FC Ceahlaul Piatra Neamt Ceahlaul 34 25 58 27
TEMPORADA 2013/2014
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FCSB FCSB 34 71 20 77
2 FC Astra Giurgiu Astra 34 70 28 72
3 Petrolul Ploiesti Petrolul 34 53 20 68
4 Dinamo Bucureşti Dinamo 34 52 34 59
5 CFR Cluj CFR Cluj 34 44 33 51
6 FC Vaslui FC Vaslui 34 38 32 51
7 Pandurii Pandurii 34 59 39 50
8 Botosani Botosani 34 36 52 43
9 FC Ceahlaul Piatra Neamt Ceahlaul 34 27 31 41
10 Oțelul Galați Oțelul 34 43 52 41
11 Universitatea Cluj Universitate 34 29 46 40
12 Viitorul Constanţa Viitorul 34 29 50 40
13 Gaz Metan Gaz Metan 34 32 38 39
14 Concordia Chiajna Concordia 34 34 47 39
15 FC Brasov FC Brasov 34 32 40 38
16 ACS Poli Timişoara Poli 34 26 42 38
17 Săgeata Năvodari Săgeata 34 32 54 38
18 Corona Braşov Corona 34 20 69 14

  USO DE MEMORIA  
6,186,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7051
Total Execution Time  0.7063
  CADENA URL  
/historico/Dinamo-Bucure-Ti
  GET DATOS  
$_GET['/historico/Dinamo-Bucure-Ti']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0302  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 = 75606
0.0181  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 = 74011
0.0228  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 = '9960' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0159  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 = 74011 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155  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 = 75606 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0199  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=9960 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0148  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 (75606,74011,73672,71809,71432,71248) 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.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 75606 AND teamId = 9960
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 71248 AND teamId = 9960
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 74011 AND teamId = 9960
0.0159  SELECT count(id) as num_players from rel_players WHERE league_id = 71809 AND teamId = 9960
0.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 73672 AND teamId = 9960
0.0238  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9960
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 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 = 75606 AND t.round = 7 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0159  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 = 75606 WHERE rp.league_id = 75606 AND rp.teamId = 9960 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.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 = 75606 WHERE rp.league_id = 75606 AND rp.teamId = 9960 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 75606 WHERE rp.league_id = 75606 AND rp.teamId = 9960 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 = 9960 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75606 AND t.round = 7 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 `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 = 68106 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 71248 AND t.round = 10 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 = 66915 AND t.round = 9 ORDER BY team.conference ASC,t.position 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 `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 = 58371 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.0155  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 = 62145 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 = 50015 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.0159  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 = 55591 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 49256 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 44208 AND t.round = 26 ORDER BY team.conference 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 `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 = 42958 AND t.round = 14 ORDER BY team.conference 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 `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 = 33801 AND t.round = 26 ORDER BY team.conference 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 `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 = 38062 AND t.round = 10 ORDER BY team.conference 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 `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 = 15579 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 20792 AND t.round = 10 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 = 3826 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 `tables2014` 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 = 2510 AND t.round = 34 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 = 75606 ORDER BY nameShow LIMIT 100