4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						Argentina Third Level (Primera B - Metropolitano) 2004/05



Torneo Apertura

 1 Tigre                      20 12  7  1 33-11 43 
 2 Platense                   20 11  5  4 24-13 38 
 3 Sportivo Italiano          20 10  7  3 27-17 37 
 4 Tristán Suárez             20 10  4  6 32-23 34 
 5 All Boys                   20  8  8  4 22-20 32 
 6 Atlanta                    20 10  2  8 30-29 32 
 7 Temperley                  20  9  4  7 31-23 31 
 8 Los Andes                  20  8  7  5 33-33 31 
 9 Deportivo Morón            20  7  9  4 20-13 30 
10 Central Córdoba (Rosario)  20  6 10  4 26-21 28 
11 Deportivo Armenio          20  7  6  7 21-17 27 
12 Talleres (R. de Escalada)  20  6  8  6 20-22 26 
13 Almirante Brown            20  4 12  4 22-21 24 
14 Estudiantes (Buenos Aires) 20  5  9  6 22-25 24 
15 Defensores de Cambaceres   20  4 11  5 16-18 23 
16 Brown (Adrogué)            20  5  6  9 19-25 21 
17 Deportivo Laferrere        20  5  5 10 24-36 20 
18 Argentino (Rosario)        20  5  4 11 22-37 19 
19 Social Español             20  4  5 11 20-32 17 
20 San Telmo                  20  3  5 12 24-36 14 
21 Flandria                   20  2  4 14 16-32 10 

Torneo Clausura

 1 Tigre                      20 15  5  0 39-13 50 
 2 Platense                   20 10  5  5 33-21 35 
 3 Atlanta                    20  9  8  3 29-18 35 
 4 Los Andes                  20  9  6  5 43-34 33 
 5 Deportivo Armenio          20  9  6  5 31-24 33 
 6 Deportivo Morón            20  9  5  6 24-25 32 
 7 Brown (Adrogué)            20  9  5  6 23-26 32 
 8 Talleres (R. de Escalada)  20  9  4  7 32-28 31 
 9 Tristán Suárez             20  8  4  8 24-22 28 
10 All Boys                   20  7  7  6 20-18 28 
11 Sportivo Italiano          20  7  7  6 27-26 28 
12 Flandria                   20  7  6  7 22-16 27 
13 Social Español             20  7  6  7 20-20 27 
14 Estudiantes (Buenos Aires) 20  7  5  8 30-34 26 
15 San Telmo                  20  6  5  9 25-31 23 
16 Central Córdoba (Rosario)  20  5  7  8 22-26 22 
17 Temperley                  20  4  8  8 15-19 20 
18 Defensores de Cambaceres   20  3  8  9 19-32 17 
19 Argentino (Rosario)        20  5  2 13 20-36 17 
20 Almirante Brown            20  2  8 10 15-28 14 
21 Deportivo Laferrere        20  2  5 13 14-30 11 

Total

 1 Tigre                      40 27 12  1 72-24 93  Champions and Promoted
 2 Platense                   40 21 10  9 57-34 73  Qualify to Second Phase of Reducido
 3 Atlanta                    40 19 10 11 59-47 67  Qualify to Reducido
 4 Sportivo Italiano          40 17 14  9 54-43 65  Qualify to Reducido
 5 Los Andes                  40 17 13 10 76-67 64  Qualify to Reducido
 6 Tristán Suárez             40 18  8 14 56-45 62  Qualify to Reducido
 7 Deportivo Morón            40 16 14 10 44-38 62  Qualify to Reducido
 8 Deportivo Armenio          40 16 12 12 52-41 60  Qualify to Reducido
 9 All Boys                   40 15 15 10 42-38 60 
10 Talleres (R. de Escalada)  40 15 12 13 52-50 57 
11 Brown (Adrogué)            40 14 11 15 42-51 53 
12 Temperley                  40 13 12 15 46-42 51 
13 Central Córdoba (Rosario)  40 11 17 12 48-47 50 
14 Estudiantes (Buenos Aires) 40 12 14 14 52-59 50 
15 Social Español             40 11 11 18 40-52 44 
16 Defensores de Cambaceres   40  7 19 14 35-50 40 
17 Almirante Brown            40  6 20 14 37-49 38 
18 Flandria                   40  9 10 21 38-48 37 
19 San Telmo                  40  9 10 21 49-67 37 
20 Argentino (Rosario)        40 10  6 24 42-73 36 
21 Deportivo Laferrere        40  7 10 23 38-66 31 

Reducido (Promotion Playoff Qualifying)

First Phase

First Legs
[Jun 4]
Tristán Suárez     1-1 Los Andes
[Jun 5]
Deportivo Armenio  1-1 Sportivo Italiano
Deportivo Morón    2-2 Atlanta

Second Legs
[Jun 10]
Los Andes          2-3 Tristán Suárez
[Jun 11]
Sportivo Italiano  1-0 Deportivo Armenio
[Jun 12]
Atlanta            0-2 Deportivo Morón

Second Phase

First Legs [Jun 15]
Deportivo Morón    0-1 Platense
Tristán Suárez     2-1 Sportivo Italiano

Second Legs
[Jun 18]
Sportivo Italiano  1-3 Tristán Suárez
[Jun 19]
Platense           0-1 Deportivo Morón

Third Phase

First Leg [Jun 23]
Tristán Suárez     2-2 Platense

Second Leg [Jun 27]
Platense           4-0 Tristán Suárez

NB: Platense qualified for promotion/relegation playoff

Promotion Playoff

First Leg [Jul 2]
Platense           1-1 Chacarita Juniors

Second Leg [Jul 9]
Chacarita Juniors  1-1 Platense

Platense remain at 3rd level (Chacarita qualify on better record, i.e. playing
in a higher division)

Relegation Table:
                            02-03 03-04 04-05   PTS  MP  AVR
 1 Atlanta                    57    81    67    205 118 1,737
 2 Tigre                      46    52    93    191 118 1,619
 3 Platense                   65    51    73    189 118 1,602
 4 Los Andes                   0     0    64     64  40 1,600
 5 All Boys                   64    64    60    188 118 1,593
 6 Almirante Brown            70    77    38    185 118 1,568
 7 Tristán Suárez             41    81    62    184 118 1,559
 8 Deportivo Morón            49    69    62    180 118 1,525
 9 Central Córdoba (Rosario)  56    67    50    173 118 1,466
10 Estudiantes (Buenos Aires) 50    71    50    171 118 1,449
11 Sportivo Italiano          48    54    65    167 116 1,440
12 Temperley                  51    53    51    155 116 1,336
13 Deportivo Armenio          42    42    60    144 116 1,241
14 Flandria                   38    71    37    146 118 1,237
15 Talleres (R. de Escalada)  44    38    57    139 118 1,178
16 San Telmo                  46    53    37    136 116 1,172
17 Social Español              0    48    44     92  82 1,122
18 Brown (Adrogué)            31    45    53    129 118 1,093
19 Deportivo Laferrere        56    42    31    129 118 1,093
20 Defensores de Cambaceres   41    44    40    125 118 1,059  Relegation Playoff
21 Argentino (Rosario)         0     0    36     36  40 0,900  Relegated

Relegation Playoff

First Leg [Jun 25]
Deportivo Merlo    0-0 Def. de Cambaceres

Second Leg [Jul 2]
Def. de Cambaceres 1-0 Deportivo Merlo

NB: Def. de Cambaceres remain at 3rd level


Author: Juan Pablo Andrés
(jpandres@tutopia.com)
Last updated: 30 Jul 2005

(C) Copyright Juan Pablo Andrés and RSSSF 2005
You are free to copy this document in whole or part provided that proper acknowledgement is given to the author. All rights reserved.


  USO DE MEMORIA  
4,292,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5853
Total Execution Time  0.5873
  CADENA URL  
/primera_b_metropolitana2005
  GET DATOS  
$_GET['/primera_b_metropolitana2005']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0125  SELECT type FROM routes WHERE alias = 'primera_b_metropolitana2005'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_metropolitana' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2005 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=206 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 206 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1217126,1186023,1100435,1089425,1054264) ORDER BY n.cover_points DESC, update_date DESC
0.0130  SELECT text_es as historical_text FROM leagues_text WHERE id=5366
0.0133  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 33839 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0175  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=206 ORDER BY l.group_code ASC
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-24 09:01:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-24 09:01:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-24 09:01:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-24 09:01:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_metropolitana' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2005 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (33839) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0125  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (33839) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (33839) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0129  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (33839) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0129  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (33839) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0127  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (33839) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0129  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (33839) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0128  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (33839) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0130  SELECT rp.lineup as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 33839 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0129  SELECT rp.events as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 33839 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0139  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=33839 AND rel.round=40
0.0136  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 33839 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0135  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 33839 AND esl.points > 0
0.0133  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-25" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 33839 ORDER BY creation_date DESC LIMIT 0, 10
0.0147  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-03-25" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 33839
0.0129  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2005` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 33839 AND c.`round` = 40 ORDER BY shedule ASC LIMIT 200
0.0126  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2005` e INNER JOIN calendars2005 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 40 AND e.real_date IS NOT NULL AND e.league_id = 33839 ORDER BY total DESC LIMIT 40
0.0133  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2005` e INNER JOIN calendars2005 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 33839 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0135  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 = 33839 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  SELECT *,(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 = 33839 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-24 00:00:00' AND c.`shedule` < '2024-04-28 23:59:59' AND l.id = 33839 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0135  SELECT data1, data2 FROM services_tags WHERE categoryId=206
0.0135  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 206 AND l.year = 2005 ORDER BY l.group_code ASC
0.0135  SELECT group_code, extraName from `leagues` WHERE categoryId=206 AND year=2005