4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Manchester United - Barcelona
Jornada 26
FINALIZADO
00
00
2280 Pts. Elo

2870 Pts. Elo

0(0-2)0
Miércoles, 08 Agosto 2012, 20:00

Eventos del partido

Cambios

S. KagawaEntra en el partido
S. Kagawa
minuto 46'
W. RooneySale del partido
W. Rooney
minuto 46'
M. CarrickEntra en el partido
M. Carrick
minuto 46'
N. VidicSale del partido
N. Vidic
minuto 46'
minuto 46'PedroEntra en el partido Pedro
minuto 46'Cristian TelloSale del partido Cristian Tello
minuto 46'I. AfellayEntra en el partido I. Afellay
minuto 46'L. MessiSale del partido L. Messi
minuto 46'Cesc FàbregasEntra en el partido Cesc Fàbregas
minuto 46'Andres IniestaSale del partido Andres Iniesta
minuto 46'XaviEntra en el partido Xavi
minuto 46'Sergi RobertoSale del partido Sergi Roberto
minuto 46'G. PiquéEntra en el partido G. Piqué
minuto 46'C. PuyolSale del partido C. Puyol
minuto 46'José Manuel PintoEntra en el partido José Manuel Pinto
minuto 46'V. ValdésSale del partido V. Valdés
minuto 66'Marc BartraEntra en el partido Marc Bartra
minuto 66'J. MascheranoSale del partido J. Mascherano
D. BerbatovEntra en el partido
D. Berbatov
minuto 67'
Ashley YoungSale del partido
Ashley Young
minuto 67'
minuto 67'RafinhaEntra en el partido Rafinha
minuto 67'Alexis SánchezSale del partido Alexis Sánchez
minuto 67'Jordi AlbaEntra en el partido Jordi Alba
minuto 67'AdrianoSale del partido Adriano
minuto 67'Martín MontoyaEntra en el partido Martín Montoya
minuto 67'D. AlvesSale del partido D. Alves
minuto 76'IlieEntra en el partido Ilie
minuto 76'Sergio BusquetsSale del partido Sergio Busquets
Nick PowellEntra en el partido
Nick Powell
minuto 78'
AndersonSale del partido
Anderson
minuto 78'
S. WoottonEntra en el partido
S. Wootton
minuto 83'
R. FerdinandSale del partido
R. Ferdinand
minuto 83'

Tanda de penaltis

Nani
Nani
 1 Xavi
Xavi
 Ashley Young
Ashley Young
 2 G. Piqué
G. Piqué

Alineaciones

Manchester United

Manchester United

4-4-2
Alineación Inicial
Suplentes
Barcelona

Barcelona

4-4-2
Alineación Inicial
Suplentes

Estadísticas del partido

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: comment/main_view.php

Line Number: 2065

Manchester United Manchester Barcelona Barcelona
43 Comentarios + 21 respuestas
‹ Primero ... ... página 1 2 3 > ... Último ›
  • Squall
    Hace 11 años Squall dice: Buen test ante todo un United, para coger el rodaje suficiente, ya queda menos, VAMOS BARÇA!!!!
  • elnen23
    Actualizado hace 11 años (Creado hace 11 años ) elnen23 dice: Voy a seguir este partido en resultados-Futbol.com:

    "força barça"
  • unsko
    Hace 11 años unsko dice: Un gran partido sin goles.
  • unsko
    Hace 11 años unsko dice: El partido ha acabado con empate a cero, lo que ha obligado al lanzamiento de penaltis, aunque se ha tratado de una mini tanda en que vencía el que mayor acierto tuviera en tres lanzamientos. Xavi y Piqué han marcado, Pinto le ha parado el lanzamiento a Young y Nani ha estrellado el balón en el larguero. El Barça sigue sin conocer la derrota en esta pretemporada, en el inicio de la era Tito Vilano
  • unsko
    Hace 11 años unsko dice: Lo mejor de todo ha sido conformar el acierto del fichaje de Jordi Alba (otro Alves por la izquierda) y que Rafinha, como Sergi Roberto, tiene proyección en ese medio campo del Barça pleno de talento.
  • unsko
    Hace 11 años unsko dice: La ausencia de Messi en esta segunda mitad ha servido para ver primero a Afellay y, luego, a Cesc como falsos delanteros centros. El cambio de posiciones ha sido una constante, aunque se ha echado de menos a un nueve auténtico, más con Messi que ha seguido el partido desde el banquillo en toda esta segunda mitad. El Manchester United también ha dado entrada al joven Nick Powell (futbolista de 18 a
  • unsko
    Hace 11 años unsko dice: El Barça ha reaccionado, tras el dominio inicial inglés, con una gran ocasión para Alexis que se ha quedado sólo ante De Gea, tras excelente pase de Alves con el exterior del pie derecho, pero el portero español del ‘Man U’ ha conjurado el peligro (62’). Pedro ha insistido con un excelente cabezazo, ha confirmado que su presencia en el equipo va a ser muy importante, como ya se vio en la parte fin
  • unsko
    Hace 11 años unsko dice: Por parte inglesa, sir Alex Ferguson ha puesto en liza al japonés Kagawa (ex Borussia Dortmund) y su entrada por Rooney se ha notado. Un tiro suyo, tras dejada de Wellbeck, ha obligado a Pinto a efectuar un paradón. Un minuto después ha insistido y, en este caso, el portero barcelonista ha buscado el lucimiento en su parada a remate del japonés al primer palo. Carrick también ha hecho de improvisa
  • unsko
    Hace 11 años unsko dice: Tras el descanso, Tito Vilanova ha cambiado de golpe a seis jugadores, con la sorpresa añadida que uno de los sustituidos ha sido Lionel Messi, algo poco habitual, pero es que el técnico ha querido no darle un exceso de minutos ante el resto de partidos de pretemporada, amistoso con Argentina incluido. Los que han entrado fueron Pinto, Piqué, Cesc, Xavi, Pedro y Afellay. Salieron Valdés, Puyol, Se
  • unsko
    Hace 11 años unsko dice: El Manchester United, que sólo había rematado una vez por medio de Rooney, se ha encontrado con el regalo de un penalti absurdo de Tello a Nani en el que el portugués ha puesto mucho de su parte. El colegiado ha visto pena máxima en una acción de pardillo de Tello sobre Nani (44’). Pero Valdés ha sabido detener brillantemente el lanzamiento de Rooney y el rechace de Víctor tampoco ha sido bien rem
  • unsko
    Hace 11 años unsko dice: El Barça ha creado mucho más peligro que los ingleses. De Gea ha tenido muchísimo más trabajo que Valdés. El dúo Iniesta-Messi ha generado la mayoría de ocasiones. De las jugadas entre los dos cracks ha surgido casi todo el peligro. Andrés ha dado los pases de oro y Leo los ha rematado, obligando a De Gea a emplearse con acierto. Por su parte, Lionel ha dado excelentes pases en profundidad a un Te
  • unsko
    Hace 11 años unsko dice: Eso sí, la primera parte ha recordado mucho a la finalísima de Londres, con un Barça dueño del balón y un ‘Man U’ excesivamente retrasado, con excesivo respeto al equipo que ahora entrena Tito Vilanova y, entonces, lo hacía Pep Guardiola.
  • unsko
    Hace 11 años unsko dice: Barça y Manchester United han reeditado las finales de Champions de Roma 2009 y Wembley 2011 en el ‘Supermatchen’ (superpartido) que ha sido como los organizadores de Goteborg han bautizado al encuentro de este miércoles. Ha sido algo más que un amistoso por la entidad de los dos contendientes, pero se ha notado que no era un encuentro de alta competición y si de preparación, aunque los ingleses h
  • unsko
    Hace 11 años unsko dice: El único pero ha sido una notable falta de acierto en el remate. Se han creado oportunidades de gol claras, aunque ha faltado meterlas y trasformarlas en gol. Vilanova ha parecido querer mostrar a todo el mundo que tenía alternativas para todo slos puestos, aunque le faltaba un relevo para Sergio Busquets al que le ha hecho jugar 75 minutos. El Barça trabaja para satisfacer sus deseos y ya tiene e
  • unsko
    Hace 11 años unsko dice: El Barça ha confirmado que se conoce de memoria lo que debe hacer con el balón. Ha dominado y controlado al Manchester United. Tito Vilanova le ha dado minutos a todos los jugadores para que prosigan esta pretemporada , que va a proseguir ahora con un mini ‘stage’ antes de jugar en Bucarest ante el Dinamo el próximo sábado y luego regresar a Barcelona para preparar la Supercopa de España y el inic
‹ Primero ... ... página 1 2 3 > ... Último ›

Partido televisado en...
Canal Medio Idioma País
TV3 TV Castellano
Gol Play TV Castellano
Fotos del partido
  • Antonio-Valencia-Number-7-Wallpaper

  USO DE MEMORIA  
6,347,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.2451
Total Execution Time  0.2460
  CADENA URL  
/partido/Manchester-United-Fc/Barcelona/2013
  GET DATOS  
$_GET['/partido/Manchester-United-Fc/Barcelona/2013']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (53)  
0.0026   SELECT c.comment_id, COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`league_id` = '1906' AND c.`match_id` = '14028' AND c.comment_id IN (1687336,1686713,1687094,1687093,1687092,1687091,1687090,1687089,1687088,1687087,1687086,1687085,1687084,1687083,1687082) GROUP BY c.comment_id
0.0074   SELECT c.*, c.stadium as real_stadium, 2013 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2013 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Manchester-United-Fc' AND dt2.basealias = 'Barcelona'
0.0055  SELECT c.*, 2013 AS year, dt1.id AS dteam1_id, dt1.nameShow AS team1_name, dt1.basealias AS team1_basealias, dt1.fullName AS team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow AS team2_name, dt2.basealias AS team2_basealias, dt2.fullName AS team2_fullName, dt2.color1 AS team2_color1, t1.name AS team1_Oname, t2.name AS team2_Oname, s.id AS stadium_id, dt1.id AS stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2013 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Manchester-United-Fc' AND dt2.basealias = 'Barcelona'
0.0019   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2013 AS ev WHERE ev.match_id=14028 ORDER BY (ev.action=1 OR ev.action=2 OR ev.action=6 OR ev.action=11 OR ev.action=12 OR ev.action=13) DESC,(ev.action=3 OR ev.action=4 OR ev.action=5) DESC,(ev.action=14 OR ev.action=15 OR ev.action=16 OR ev.action=17 OR ev.action=21) DESC,(ev.action=18 OR ev.action=19) DESC,(ev.action=20 OR ev.action=22) DESC, minute ASC, ev.real_date ASC, ev.id DESC, ev.action DESC
0.0024   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=1906 WHERE dp.id IN (67842,588,298,264,29477,58696,1512,23569,27146,22806,23564,81723,23560,23562,23558,7171,40903,396,504,616,81427,16967,28113,23484,41104,23559,41058,27059,138750,493,68706,128,413) AND (rp.team_id=39844 OR rp.team_id=39002)
0.0019   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2013 AS ev WHERE ev.match_id=14028 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0024   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=1906 WHERE dp.id IN (67842,588,298,264,29477,58696,1512,23569,27146,22806,23564,81723,23560,23562,23558,7171,40903,396,504,616,81427,16967,28113,23484,41104,23559,41058,27059,138750,493,68706,128,413) AND (rp.team_id=39844 OR rp.team_id=39002)
0.0019  SELECT data1 FROM stats2013 t WHERE league_id = 1906 AND teamId = 39844 and type = 33
0.0018  SELECT data1 FROM stats2013 t WHERE league_id = 1906 AND teamId = 39002 and type = 33
0.0018  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 1906 AND id_match = 14028
0.0024  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='1906' AND relp.team_id = drea.team_id WHERE rel.team_number=4290478 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0025  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='1906' AND relp.team_id = drea.team_id WHERE rel.team_number=4290479 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0056  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='1906' AND relp.team_id=39844 WHERE mp.`match_id` = '14028' AND mp.year='2013' AND p.id NOT IN (33648,128,264,125,616,475,493,453,588,27174,413,7171,23562,23484,23559,396,81723,27059,22806,16967,23569,58696) ORDER BY mp.`team` ASC, p.`role` ASC
0.0091  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='1906' AND relp.team_id=39002 WHERE mp.`match_id` = '14028' AND mp.year='2013' AND p.id NOT IN (33648,128,264,125,616,475,493,453,588,27174,413,7171,23562,23484,23559,396,81723,27059,22806,16967,23569,58696) ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT kit FROM kit_data_real WHERE league_id = 1906 AND id_match = 14028
0.0019  SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '14028' and rp.type = 2013 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '14028' and rp.type = 2013 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT *,rel.id as rel_id FROM `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='10' AND rel.active = 1 AND rel.league_id = 1906 AND rel.team1 = 39844 AND rel.team2 = 39002 ORDER BY FIELD(m.location,'es','en') DESC
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 14028 AND year = 2013 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 14028 AND year = 2013 AND channel = 'Footters' LIMIT 1
0.0020  SELECT *,rel.id as rel_id FROM `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='11' AND rel.active = 1 AND rel.league_id = 1906 AND rel.team1 = 39844 AND rel.team2 = 39002 ORDER BY FIELD(m.location,'es','en') DESC
0.0024  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2, c.shedule,c.id, c.r1, c.r2, c.round, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments,c.league_id FROM `calendars2013` 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` = 1906 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 12
0.0018  SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2013` WHERE league_id = 1906 AND round >= 47 AND round <= 47 AND team = 39844 ORDER BY round ASC
0.0019  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 `tables2013` 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 = 1906 AND t.round = 47 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031   SELECT c.comment,c.id,c.author_id,c.author_name,c.last_update,c.creation_date,c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, c.template, NOW() AS difference_time, fau.changeA AS changeA FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id=0 AND c.lang = '1' AND c.language = 'es' AND c.`league_id` = '1906' AND c.`match_id` = '14028' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0019   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1687336' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0019   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1686713' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0019   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1687094' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0018   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1687093' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0019   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1687092' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0018   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1687091' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0018   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1687090' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0018   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1687089' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0019   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1687088' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0018   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1687087' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0018   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1687086' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0019   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1687085' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0018   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1687084' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0021   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1687083' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0019   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1687082' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0021  SELECT dr.name as showName, dr2.name as referee_var FROM calendars2013 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2013 and r.role=1 INNER JOIN datareferees dr on dr.id=r.referee_id INNER JOIN rel_calendars_referee as r2 ON c.id = r2.match_id and r2.year=2013 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 39844 AND c.team2 = 39002 AND c.league_id = 1906
0.0017  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='14028' AND `active` = 1 AND year = 2013
0.0017  SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='14028' AND `active` = 1 AND year = 2013
0.0089  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='1906' AND relp.team_id=39844 WHERE relp.in_squad=1 and mp.`match_id` = '14028' AND mp.year='2013' ORDER BY mp.`team` ASC, p.`role` ASC
0.0174  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='1906' AND relp.team_id=39002 WHERE relp.in_squad=1 and mp.`match_id` = '14028' AND mp.year='2013' ORDER BY mp.`team` ASC, p.`role` ASC
0.0019  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '1906' AND id_match = '14028'
0.0019   SELECT rel.*, dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '4290478' ORDER BY rating DESC LIMIT 1
0.0018   SELECT rel.*, dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '4290479' ORDER BY rating DESC LIMIT 1
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=14028 AND extraId = 1906 AND type_rel = 4
0.0017  SELECT rating1, rating2 FROM calendars_elo WHERE id=14028 AND league_id=1906 AND year=2013
0.0021  SELECT position FROM tables2013 WHERE team=39844 AND league_id=1906 AND round=26
0.0019  SELECT position FROM tables2013 WHERE team=39002 AND league_id=1906 AND round=26
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 14028 AND league_id = 1906 AND year = 2013