4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Primera B 2012

La temporada finalizó el Viernes, 25 Mayo 2012.
Resultados
« Jornada Anterior
Jornada 42
 
 
25 May 12
20:00 Finalizado 		Acassuso Acassuso 2-1 CA Estudiantes CA Estudiantes más información ...
 
25 May 12
20:00 Finalizado 		Almagro Almagro 2-0 Platense Platense más información ...
 
25 May 12
20:00 Finalizado 		Colegiales Colegiales 0-1 Villa San Carlos Villa San Carlos más información ...
 
25 May 12
20:00 Finalizado 		Comunicaciones Comunicaciones 2-0 General Lamadrid General Lamadrid más información ...
 
25 May 12
20:00 Finalizado 		Sportivo Italiano Sportivo Italiano 2-3 Dep. Armenio Dep. Armenio más información 1
 
25 May 12
20:00 Finalizado 		Flandria Flandria 0-2 Brown Adrogue Brown Adrogue más información ...
 
25 May 12
20:00 Finalizado 		Nueva Chicago Nueva Chicago 1-1 Sarmiento Sarmiento más información ...
 
25 May 12
20:00 Finalizado 		San Telmo San Telmo 1-1 Barracas Central Barracas Central más información 1
 
25 May 12
20:00 Finalizado 		Temperley Temperley 0-1 Def. Belgrano Def. Belgrano más información ...
 
25 May 12
20:00 Finalizado 		Tristán Suárez Tristán Suárez 1-0 Deportivo Morón Deportivo Morón más información ...
Clasificación
« Jornada Anterior
Jornada 42
 
Equipos Puntos J. G. E. P. F. C.
1 Sarmiento Sarmiento 80 40 24 8 8 52 24
  • DERROTA
  • San Telmo 2
  • Sarmiento 1
  • VICTORIA
  • Sarmiento 2
  • Sportivo Italiano 0
  • DERROTA
  • Comunicaciones 1
  • Sarmiento 0
  • VICTORIA
  • Sarmiento 3
  • Colegiales 0
  • EMPATE
  • Nueva Chicago 1
  • Sarmiento 1
2 Colegiales Colegiales 73 40 21 10 9 54 33
  • VICTORIA
  • Colegiales 2
  • Def. Belgrano 1
  • VICTORIA
  • Platense 0
  • Colegiales 1
  • VICTORIA
  • Colegiales 3
  • Deportivo Morón 0
  • DERROTA
  • Sarmiento 3
  • Colegiales 0
  • DERROTA
  • Colegiales 0
  • Villa San Carlos 1
3 CA Estudiantes CA Estudiantes 72 40 20 12 8 49 29
  • VICTORIA
  • Dep. Armenio 1
  • CA Estudiantes 2
  • VICTORIA
  • CA Estudiantes 1
  • Barracas Central 0
  • EMPATE
  • Brown Adrogue 1
  • CA Estudiantes 1
  • DERROTA
  • CA Estudiantes 0
  • Los Andes 2
  • DERROTA
  • Acassuso 2
  • CA Estudiantes 1
4 Nueva Chicago Nueva Chicago 70 40 20 10 10 56 36
  • VICTORIA
  • Nueva Chicago 2
  • Temperley 0
  • VICTORIA
  • Def. Belgrano 0
  • Nueva Chicago 1
  • EMPATE
  • Nueva Chicago 0
  • Platense 0
  • VICTORIA
  • Deportivo Morón 2
  • Nueva Chicago 3
  • EMPATE
  • Nueva Chicago 1
  • Sarmiento 1
5 Brown Adrogue Brown Adrogue 69 40 19 12 9 64 34
  • VICTORIA
  • Barracas Central 1
  • Brown Adrogue 2
  • EMPATE
  • Brown Adrogue 1
  • CA Estudiantes 1
  • DERROTA
  • Los Andes 1
  • Brown Adrogue 0
  • DERROTA
  • Brown Adrogue 1
  • Acassuso 2
  • VICTORIA
  • Flandria 0
  • Brown Adrogue 2
6 Platense Platense 61 40 16 13 11 44 32
  • VICTORIA
  • Comunicaciones 1
  • Platense 2
  • DERROTA
  • Platense 0
  • Colegiales 1
  • EMPATE
  • Nueva Chicago 0
  • Platense 0
  • DERROTA
  • Platense 0
  • Tristán Suárez 2
  • DERROTA
  • Almagro 2
  • Platense 0
7 Los Andes Los Andes 61 40 16 13 11 44 38
  • DERROTA
  • General Lamadrid 2
  • Los Andes 0
  • VICTORIA
  • Los Andes 1
  • Dep. Armenio 0
  • VICTORIA
  • Barracas Central 1
  • Los Andes 3
  • VICTORIA
  • Los Andes 1
  • Brown Adrogue 0
  • VICTORIA
  • CA Estudiantes 0
  • Los Andes 2
8 Comunicaciones Comunicaciones 60 40 18 6 16 42 38
  • DERROTA
  • Comunicaciones 1
  • Platense 2
  • DERROTA
  • Deportivo Morón 1
  • Comunicaciones 0
  • VICTORIA
  • Comunicaciones 1
  • Sarmiento 0
  • VICTORIA
  • Villa San Carlos 1
  • Comunicaciones 2
  • VICTORIA
  • Comunicaciones 2
  • General Lamadrid 0
9 Acassuso Acassuso 55 40 15 10 15 43 47
  • VICTORIA
  • Acassuso 6
  • General Lamadrid 2
  • VICTORIA
  • Dep. Armenio 0
  • Acassuso 1
  • DERROTA
  • Acassuso 2
  • Barracas Central 3
  • VICTORIA
  • Brown Adrogue 1
  • Acassuso 2
  • VICTORIA
  • Acassuso 2
  • CA Estudiantes 1
10 Almagro Almagro 54 40 13 15 12 43 39
  • VICTORIA
  • Almagro 1
  • Nueva Chicago 0
  • DERROTA
  • Tristán Suárez 2
  • Almagro 1
  • EMPATE
  • Almagro 1
  • Temperley 1
  • VICTORIA
  • Def. Belgrano 2
  • Almagro 3
  • VICTORIA
  • Almagro 2
  • Platense 0
11 Villa San Carlos Villa Carlos 54 40 14 12 14 32 41
  • DERROTA
  • Flandria 2
  • Villa San Carlos 1
  • EMPATE
  • Villa San Carlos 0
  • San Telmo 0
  • EMPATE
  • Sportivo Italiano 1
  • Villa San Carlos 1
  • DERROTA
  • Villa San Carlos 1
  • Comunicaciones 2
  • VICTORIA
  • Colegiales 0
  • Villa San Carlos 1
12 Dep. Armenio Dep. Armenio 50 40 12 14 14 45 50
  • DERROTA
  • Los Andes 1
  • Dep. Armenio 0
  • DERROTA
  • Dep. Armenio 0
  • Acassuso 1
  • VICTORIA
  • Flandria 1
  • Dep. Armenio 4
  • EMPATE
  • Dep. Armenio 0
  • San Telmo 0
  • VICTORIA
  • Sportivo Italiano 2
  • Dep. Armenio 3
13 Flandria Flandria 50 40 12 14 14 36 44
  • VICTORIA
  • Flandria 2
  • Villa San Carlos 1
  • VICTORIA
  • General Lamadrid 1
  • Flandria 3
  • DERROTA
  • Flandria 1
  • Dep. Armenio 4
  • VICTORIA
  • Barracas Central 1
  • Flandria 3
  • DERROTA
  • Flandria 0
  • Brown Adrogue 2
14 San Telmo San Telmo 47 40 11 14 15 29 37
  • VICTORIA
  • San Telmo 2
  • Sarmiento 1
  • EMPATE
  • Villa San Carlos 0
  • San Telmo 0
  • VICTORIA
  • San Telmo 2
  • General Lamadrid 1
  • EMPATE
  • Dep. Armenio 0
  • San Telmo 0
  • EMPATE
  • San Telmo 1
  • Barracas Central 1
15 Temperley Temperley 46 40 11 13 16 40 45
  • VICTORIA
  • Temperley 1
  • Colegiales 0
  • DERROTA
  • Nueva Chicago 2
  • Temperley 0
  • EMPATE
  • Temperley 1
  • Tristán Suárez 1
  • EMPATE
  • Almagro 1
  • Temperley 1
  • DERROTA
  • Temperley 0
  • Def. Belgrano 1
16 Sportivo Italiano Sportivo 46 40 10 16 14 33 42
  • VICTORIA
  • Sportivo Italiano 2
  • Deportivo Morón 1
  • DERROTA
  • Sarmiento 2
  • Sportivo Italiano 0
  • EMPATE
  • Sportivo Italiano 1
  • Villa San Carlos 1
  • VICTORIA
  • General Lamadrid 0
  • Sportivo Italiano 3
  • DERROTA
  • Sportivo Italiano 2
  • Dep. Armenio 3
17 Tristán Suárez Tristán Suárez 45 40 12 9 19 48 57
  • VICTORIA
  • Tristán Suárez 2
  • Almagro 1
  • EMPATE
  • Temperley 1
  • Tristán Suárez 1
  • VICTORIA
  • Tristán Suárez 1
  • Def. Belgrano 0
  • VICTORIA
  • Platense 0
  • Tristán Suárez 2
  • VICTORIA
  • Tristán Suárez 1
  • Deportivo Morón 0
18 Def. Belgrano Def. Belgrano 41 40 10 11 19 31 43
  • DERROTA
  • Colegiales 2
  • Def. Belgrano 1
  • DERROTA
  • Def. Belgrano 0
  • Nueva Chicago 1
  • DERROTA
  • Tristán Suárez 1
  • Def. Belgrano 0
  • DERROTA
  • Def. Belgrano 2
  • Almagro 3
  • VICTORIA
  • Temperley 0
  • Def. Belgrano 1
19 Barracas Central Barracas Central 40 40 10 10 20 36 51
  • DERROTA
  • CA Estudiantes 1
  • Barracas Central 0
  • DERROTA
  • Barracas Central 1
  • Los Andes 3
  • VICTORIA
  • Acassuso 2
  • Barracas Central 3
  • DERROTA
  • Barracas Central 1
  • Flandria 3
  • EMPATE
  • San Telmo 1
  • Barracas Central 1
20 Deportivo Morón Deportivo Morón 35 40 9 8 23 39 60
  • DERROTA
  • Sportivo Italiano 2
  • Deportivo Morón 1
  • VICTORIA
  • Deportivo Morón 1
  • Comunicaciones 0
  • DERROTA
  • Colegiales 3
  • Deportivo Morón 0
  • DERROTA
  • Deportivo Morón 2
  • Nueva Chicago 3
  • DERROTA
  • Tristán Suárez 1
  • Deportivo Morón 0
21 General Lamadrid General Lamadrid 31 40 7 10 23 27 67
  • DERROTA
  • Acassuso 6
  • General Lamadrid 2
  • DERROTA
  • General Lamadrid 1
  • Flandria 3
  • DERROTA
  • San Telmo 2
  • General Lamadrid 1
  • DERROTA
  • General Lamadrid 0
  • Sportivo Italiano 3
  • DERROTA
  • Comunicaciones 2
  • General Lamadrid 0
Ascenso: Sarmiento
Playoff Ascenso: Colegiales, CA Estudiantes, Nueva Chicago, Brown Adrogue, Platense, Los Andes, Comunicaciones , Acassuso
Descenso: Barracas Central, Deportivo Morón, General Lamadrid
JUGADORES DESTACADOS

TOP colaboradores para esta liga
Lucas Fiori
Lucas Fiori
1649 pts
Claudio Gonzalez
Claudio Gonzalez
999 pts
Franco Sandoval
Franco Sandoval
328 pts
Más colaboradores en esta liga (6)
¿Quieres ser colaborador? haz click aquí

  USO DE MEMORIA  
6,077,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.4367
Total Execution Time  0.4389
  CADENA URL  
/primera_b_metropolitana2012
  GET DATOS  
$_GET['/primera_b_metropolitana2012']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0105  SELECT type FROM routes WHERE alias = 'primera_b_metropolitana2012'
0.0212  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 = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=206 AND type_rel = 3
0.0113  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.0115  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.0110  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 = 1657 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0116  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.0109  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='2024' WHERE c.parentId=206 GROUP BY c.id ORDER BY c.order_id ASC
0.0105  SELECT type,rule FROM rules WHERE categoryId = 206 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-23 12:06:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-23 12:06:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-23 12:06:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-23 12:06:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  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 = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0106  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=1657 AND rel.round=42
0.0107  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 = 1657 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0106  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 = 1657 AND esl.points > 0
0.0105  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-24" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 1657 ORDER BY creation_date DESC LIMIT 0, 10
0.0109  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-24" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 1657
0.0107  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 `calendars2012` 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` = 1657 AND c.`round` = 42 ORDER BY shedule ASC LIMIT 200
0.0118  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2012 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2012 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 1657 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (87379,87380,87381,87382,87383,87384,87385,87386,87387,87388) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0107  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 `events2012` e INNER JOIN calendars2012 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 = 42 AND e.real_date IS NOT NULL AND e.league_id = 1657 ORDER BY total DESC LIMIT 40
0.0128  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 `events2012` e INNER JOIN calendars2012 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 = 1657 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0138  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 `tables2012` 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 = 1657 AND t.round = 41 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2012` 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 = 1657 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116  SELECT distinct(shedule), round FROM `calendars2012` as c WHERE c.`league_id` = 1657 AND shedule >= '2012/05/01' AND shedule < '2012/06/01' ORDER BY shedule ASC
0.0105  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-23 00:00:00' AND c.`shedule` < '2024-04-27 23:59:59' AND l.id = 1657 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0111  SELECT data1, data2 FROM services_tags WHERE categoryId=206
0.0111  SELECT group_code, extraName from `leagues` WHERE categoryId=206 AND year=2012