4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC Unirea Alba Iulia
TEMPORADA 2008/2009
SEGUNDA RUMANÍA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Unirea Alba Iulia Unirea Alba 34 58 28 69
2 Internaţional C. de Argeş Internaţion 34 61 40 64
3 Tîrgu Mures Tîrgu Mures 34 54 27 57
4 CSM Râmnicu Vâlcea Râmnicu 34 52 37 54
5 Drobeta-Turnu Severin Drobeta-Turn 34 48 43 54
6 Liberty Oradea Liberty 34 38 28 51
7 Mioveni Mioveni 34 45 40 51
8 Minerul Lupeni Minerul 34 41 43 48
9 UTA Arad UTA Arad 34 32 35 47
10 Jiul Petrosani Jiul 34 46 36 46
11 Bihor Oradea Bihor Oradea 34 44 49 46
12 Mureşul Deva Mureşul 34 44 51 45
13 Arieşul Turda Arieşul 34 30 29 44
14 Universitatea Cluj Universitate 34 37 33 43
15 ACU Arad ACU Arad 34 45 51 41
16 CFR Timisoara Timisoara 34 41 60 39
17 FCM Târgovişte Târgovişte 34 23 53 26
18 Arieşul 1907 Arieşul 34 22 78 11
TEMPORADA 2007/2008
SEGUNDA RUMANÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Argeş Piteşti Argeş 34 77 22 75
2 Gaz Metan Gaz Metan 34 77 43 73
3 Jiul Petrosani Jiul 34 53 29 61
4 Chimia Râmnicu-Vâlcea Chimia 34 56 39 61
5 FC Unirea Alba Iulia Unirea Alba 34 56 36 60
6 Drobeta-Turnu Severin Drobeta-Turn 34 46 33 58
7 Mureşul Deva Mureşul 34 39 40 50
8 FCM Târgovişte Târgovişte 34 45 40 47
9 Liberty Oradea Liberty 34 36 33 47
10 Bihor Oradea Bihor Oradea 34 32 36 47
11 Minerul Lupeni Minerul 34 41 45 41
12 Arieşul 1907 Arieşul 34 29 38 41
13 CFR Timisoara Timisoara 34 34 45 39
14 Arieşul Turda Arieşul 34 35 49 38
15 Municipal Reşiţa Municipal 34 38 65 33
16 CS Politehnica Timisoara Politehnica 34 27 56 33
17 Caracal Caracal 34 34 57 25
18 CS Hunedoara Hunedoara 34 21 70 19
TEMPORADA 2006/2007
SEGUNDA RUMANÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Universitatea Cluj Universitate 34 49 21 72
2 Mioveni Mioveni 34 44 26 60
3 CSM Râmnicu Vâlcea Râmnicu 34 40 31 59
4 FC Unirea Alba Iulia Unirea Alba 34 34 28 54
5 Minerul Lupeni Minerul 34 39 37 52
6 Gaz Metan Gaz Metan 34 54 37 51
7 CS Hunedoara Hunedoara 34 48 37 49
8 Caracal Caracal 34 40 33 49
9 Arieşul 1907 Arieşul 34 31 36 47
10 CS Politehnica Timisoara Politehnica 34 45 37 46
11 Municipal Reşiţa Municipal 34 38 37 46
12 Bihor Oradea Bihor Oradea 34 40 42 46
13 FCM Târgovişte Târgovişte 34 29 31 46
14 CFR Timisoara Timisoara 34 37 45 45
15 Building Vanju Mare Building 34 28 33 41
16 FC Baia Mare Baia Mare 34 27 54 35
17 Auxerre Lugoj Auxerre 34 24 44 25
18 Unirea Dej Unirea Dej 34 28 66 24
TEMPORADA 2005/2006
SEGUNDA RUMANÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Liberty Oradea Liberty 28 37 16 58
2 Bihor Oradea Bihor Oradea 28 53 27 55
3 Universitatea Cluj Universitate 28 44 16 54
4 Gaz Metan Gaz Metan 28 38 21 51
5 Municipal Reşiţa Municipal 28 26 29 40
6 CS Hunedoara Hunedoara 28 33 35 38
7 CFR Timisoara Timisoara 28 33 40 36
8 Gloria Bistriţa II Gloria 28 25 34 36
9 Arieşul 1907 Arieşul 28 30 29 34
10 Minerul Lupeni Minerul 28 26 31 34
11 Unirea Dej Unirea Dej 28 29 37 32
12 FC Olimpia Satu Mare Olimpia Satu 28 24 36 32
13 FC Unirea Alba Iulia Unirea Alba 28 21 31 28
14 UTA Arad UTA Arad 28 25 35 27
15 Unirea Sânnicolau Mare Unirea 28 21 48 23
TEMPORADA 2004/2005
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FCSB FCSB 30 47 18 63
2 Dinamo Bucureşti Dinamo 30 60 30 62
3 FC Rapid Bucuresti Rapid 30 51 27 57
4 Progresul Bucureşti Progresul 30 50 33 57
5 FC Farul Constanta Farul 30 42 28 52
6 Politehnica Timisoara Politehnica 30 37 34 45
7 Sportul Studenţesc Sportul 30 37 27 45
8 Oțelul Galați Oțelul 30 31 32 40
9 FC Politehnica Iasi Politehnica 30 28 41 38
10 Argeş Piteşti Argeş 30 32 37 36
11 CFR Cluj CFR Cluj 30 33 44 36
12 FC Municipal Bacău Municipal 30 20 28 33
13 ACF Gloria Bistrita Gloria 30 38 46 32
14 FC Unirea Alba Iulia Unirea Alba 30 28 62 26
15 FC Brasov FC Brasov 30 28 45 21
16 FC Universitatea Craiova Universitate 30 24 54 20
TEMPORADA 2003/2004
LIGA RUMANA
Equipo PJ GF GC Puntos
1 Dinamo Bucureşti Dinamo 30 71 30 70
2 FCSB FCSB 30 60 20 64
3 FC Rapid Bucuresti Rapid 30 51 32 55
4 FC Universitatea Craiova Universitate 30 38 34 44
5 Oțelul Galați Oțelul 30 30 26 43
6 FC Unirea Alba Iulia Unirea Alba 30 32 47 41
7 Progresul Bucureşti Progresul 30 36 39 39
8 Politehnica Timisoara Politehnica 30 30 40 39
9 FC Farul Constanta Farul 30 39 42 37
10 Argeş Piteşti Argeş 30 31 35 36
11 FC Brasov FC Brasov 30 40 42 36
12 ACF Gloria Bistrita Gloria 30 36 48 35
13 FC Municipal Bacău Municipal 30 29 43 31
14 FC Ceahlaul Piatra Neamt Ceahlaul 30 34 50 30
15 Petrolul Ploiesti Petrolul 30 38 55 27
16 Bihor Oradea Bihor Oradea 30 38 50 24

  USO DE MEMORIA  
5,445,984 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4350
Total Execution Time  0.4362
  CADENA URL  
/historico/Unirea-Alba-Iulia/2009
  GET DATOS  
$_GET['/historico/Unirea-Alba-Iulia/2009']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0173  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 = 'Unirea-Alba-Iulia' AND l.year = 2009 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.0126  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=2596 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=2596 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2596 AND type_rel = 2
0.0130  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 = '2596' ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '2596' AND l.year = 2009 ORDER BY l.year DESC,cat.coefficient DESC
0.0132  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 = '2596' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137  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=2596 AND l.year in (2008,2009,2010) ORDER BY l.id DESC, l.year DESC ;
0.0131  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 (20729,13956,866) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 866 AND teamId = 2596
0.0124  SELECT count(id) as num_players from rel_players WHERE league_id = 13956 AND teamId = 2596
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 20729 AND teamId = 2596
0.0128  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 = '2596' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2596' and rp.type = 4
0.0127  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 = '2596' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  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 events2009 e ON e.player_id = p.id AND e.league_id = 13956 WHERE rp.league_id = 13956 AND rp.teamId = 2596 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.0128  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 events2009 e ON e.player_id = p.id AND e.league_id = 13956 WHERE rp.league_id = 13956 AND rp.teamId = 2596 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 events2009 e ON e.player_id = p.id AND e.league_id = 13956 WHERE rp.league_id = 13956 AND rp.teamId = 2596 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 2596 AND l.year <= 2009 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0252  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 `tables2009` 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 = 13956 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables2008` 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 = 13953 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables2007` 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 = 13952 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables2006` 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 = 13950 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables2005` 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 = 226 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2004` 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 = 227 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC