4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Real Madrid - Valencia
Jornada 36
FINALIZADO
40
40
3902 Pts. Elo
2º

3059 Pts. Elo
4º

2-2
Sábado, 09 Mayo 2015, 20:00
0 - 1
 20' P. Alcácer
0 - 2
 25' Javi Fuego
Pepe 56'
1 - 2
Isco 85'
2 - 2

Eventos del partido

Goles

minuto 20'P. AlcácerGol de P. Alcácer
minuto 25'Javi FuegoGol de Javi Fuego
PepeGol de
Pepe
minuto 56'
IscoGol de
Isco
minuto 85'

Tarjetas

minuto 16'José GayàT. Amarilla José Gayà
Á. ArbeloaT. Amarilla
Á. Arbeloa
minuto 25'
ChicharitoT. Amarilla
Chicharito
minuto 45'
PepeT. Amarilla
Pepe
minuto 47'
Sergio RamosT. Amarilla
Sergio Ramos
minuto 58'
minuto 58'N. OtamendiT. Amarilla N. Otamendi
minuto 73'André GomesT. Amarilla André Gomes
minuto 90'Dani ParejoT. Amarilla Dani Parejo

Ocasiones

G. BaleTiro al palo
G. Bale
minuto 13'
C. RonaldoTiro al palo
C. Ronaldo
minuto 18'
ChicharitoTiro al palo
Chicharito
minuto 39'
C. RonaldoPenalti fallado
C. Ronaldo
minuto 46'
minuto 46'Diego AlvesPenalti parado Diego Alves

Cambios

A. IllarramendiEntra en el partido
A. Illarramendi
minuto 26'
Toni KroosSale del partido
Toni Kroos
minuto 26'
Á. ArbeloaSale del partido
Á. Arbeloa
minuto 46'
Dani CarvajalEntra en el partido
Dani Carvajal
minuto 46'
MarceloEntra en el partido
Marcelo
minuto 46'
F. CoentrãoSale del partido
F. Coentrão
minuto 46'
minuto 69'Á. NegredoEntra en el partido Á. Negredo
minuto 69'P. AlcácerSale del partido P. Alcácer
minuto 78'R. De PaulEntra en el partido R. De Paul
minuto 78'André GomesSale del partido André Gomes
minuto 90'Pablo PiattiSale del partido Pablo Piatti
minuto 90'L. OrbánEntra en el partido L. Orbán

Otros

minuto 20'José GayàAsistencia José Gayà
minuto 25'Dani ParejoAsistencia Dani Parejo
Toni KroosLesionado
Toni Kroos
minuto 26'
JamesAsistencia
James
minuto 56'
G. BaleAsistencia
G. Bale
minuto 85'

Alineaciones

Real Madrid

Real Madrid

4-3-3
Alineación Inicial
Suplentes
Valencia

Valencia

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: 2068

Real Madrid Real Madrid Valencia Valencia
150 Comentarios + 80 respuestas
‹ Primero ... ... página 1 2 3 4 5 6 7 8 9 10 > ... Último ›
  • adrianylaia
    Hace 9 años adrianylaia dice: todas vuestras esperanzas señalaban el calderón............... .ahora que merengones,pues os dire una cosa iremos al calderón y los vamos a barrer del mapa,el depor nos hara el pasillo el sábado,siendo finalistas de champions,copa del rey,y campeones de liga,decirle a vuestro presidente que va a fichar este año?ya podeis fichar lo mejor de lo mejor que os faltan.hue....
  • adrianylaia
    Hace 9 años adrianylaia dice: os vamos a coger en ligas y en champions en cuestión de 15 años,jajjajajajja si no ver la trayectoria.estamos ya a 7 ligas vuestras,y sin el jugador numero 12 paco.
  • totalfutbol
    Actualizado hace 9 años (Creado hace 9 años ) totalfutbol dice: Ayer no entré porque hubiera dicho tales barbaridades que hubiera sido baneado.
    Hoy pensando las cosas en frío, quiero felicitar al Valencia, por su excelente partido y efectividad de cara a gol...ya que tiraron 3 veces entre palos y metieron 2 goles....Luego felicitarles también por jugar con portero cada semana....otros jugamos con 10 y milagrosamente hemos llegado a final de temporada con opciones...ayer se perdió la liga pero el espíritu de ir a remontar un 0-2 contra un equipazo, contra los postes y casi conseguirlo jugando con 10...me hace ser optimista para el miércoles. Hala Madr
  • VICARIO
    Hace 9 años VICARIO dice: Yo como madridista felicito a todos los cules por esta liga bien ganada.De los fanaticos paso pues solo saben insultar.
  • ezequielperezromero_1
    Hace 9 años ezequielperezromero_1 dice: El valencia que equipazo tiene y nuno es un crack os felicito a los valencianistas por el partidazo k hicieron.Y ahora a por la juve! !!HALA MADRID!!
  • leocadiorodr
    Actualizado hace 9 años (Creado hace 9 años ) leocadiorodr dice: otra liga para el barca ..poquito a poquito ...yo conoci al barca con 8 ligas y tiene ( con esta ) 23 ..se nota que ya no esta el franquismos en españa y ahora el madrid tiene que ganar los titulos a pulso como todos ...!!! FORCA BARCA !!
  • leocadiorodr
    Actualizado hace 9 años (Creado hace 9 años ) leocadiorodr dice: el madrid ya lleva fichados este año a dos chinos ....chin_liga y chin_copa ...le queda fichare a otro chino ...aunque con la juve lo tiene muy facil ...se va a meter en la final a base de esquivar a los rivales duros ...porque de lo contrario el tecer chino ya estaria fichado ...
    y eso que gastan lo que no esta escrito en fichajes ...!! la cantidad de millones que lleva el madrid gastados en fichajes en los ultimos 15 años es para asustarse ...
  • Squall
    Actualizado hace 9 años (Creado hace 9 años ) Squall dice: Como siempre que el Real Madrid empate o pierde por aquí no aparece ni el tato jajajaja solo hay 4 buenos Madridistas que siempre dan la cara, los demás solo cuando ganan, como lo llamaríamos a eso? jajajajaja
  • elcherm
    Hace 9 años elcherm dice: ¡Ánimo también a los madridistas! La liga estaba prácticamente imposible de todos modos, hay que pensar en la Champions.
  • elcherm
    Hace 9 años elcherm dice: ¡Enhorabuena vecinos! ¡El Valencia volverá a estar donde se merece, en Champions League!
  • migue_vcf
    Hace 9 años migue_vcf dice: No pudo ser la felicidad total pero estoy muy contento y orgulloso de mi Valencia y de ser valencianista, tuvimos mucha pegada en ataque como llevamos haciendo toda la temporada prácticamente y nuestro portero es genial, muchos palos y largueros que se nos acusa de tener mucha suerte, bueno amigos la suerte va por barrios, en otros partidos los palos y largueron fueron nuestros. Amunt siempre
  • frangarri
    Actualizado hace 9 años (Creado hace 9 años ) frangarri dice: El Real Madrid ayer demostró lo que es tener pegada, remontando un 0-2 tras tener mala suerte de tirar 4 veces al palo y fallar un penalti, si jugaran todos los partidos como el segundo tiempo de ayer,el Real Madrid sería el campeón de todo,ahí lo dejo..
  • jcg1301
    Hace 9 años jcg1301 dice: No pudo ser la remontada. Enhorabuena al Barcelona por su vigésimo tercera liga y... otra vez sera para el Madrid. HALA MADRID!!!!!!
  • pode
    Actualizado hace 9 años (Creado hace 9 años ) pode dice: A mi parecer, un gran resultado que todos (o yo) habríamos firmado. Bien cierto es que no es lo mismo ir ganando 0-2 y que te empaten (que baja la moral al aficionado) o ir perdiendo 2-0 y empatar (que sube la moral al aficionado) a seguir luchando por la Champions! AMUNT VALÈNCIA!
  • dpadilla
    Actualizado hace 9 años (Creado hace 9 años ) dpadilla dice: Ahí están en el facebook del Real Madrid insultando a Casillas; él no tiene la culpa, el Valencia es un gran equipo que juega con gran talento. Ya se sabía que ese partido iba a ser parejo.
‹ Primero ... ... página 1 2 3 4 5 6 7 8 9 10 > ... Último ›

Partido televisado en...
Canal Medio Idioma País
C+C+ TV Castellano es
Sport TV2Sport TV2 TV Portugués pt
Bein SportsBein Sports TV Francés fr
DirecTV SportDirecTV Sport TV Latino ar
Bet365Bet365 WEB Castellano es

  USO DE MEMORIA  
7,110,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.9942
Total Execution Time  0.9952
  CADENA URL  
/partido/Real-Madrid/Valencia-Cf/2015
  GET DATOS  
$_GET['/partido/Real-Madrid/Valencia-Cf/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (55)  
0.0035   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` = '3775' AND c.`match_id` = '19745' AND c.comment_id IN (5683881,5684043,5676384,5675742,5695475,5662437,5662568,5663653,5676708,5676690,5670523,5668706,5671343,5669679,5662395) GROUP BY c.comment_id
0.0179   SELECT c.*, c.stadium as real_stadium, 2015 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 calendars2015 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 = 'Real-Madrid' AND dt2.basealias = 'Valencia-Cf'
0.0143  SELECT c.*, 2015 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 calendars2015 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 = 'Real-Madrid' AND dt2.basealias = 'Valencia-Cf'
0.0127   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2015 AS ev WHERE ev.match_id=19745 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.0135   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=3775 WHERE dp.id IN (39979,23408,27010,44027,146766,66,61052,23341,54978,138776,29364,72,28185,23437,100715,2100,74892,23343,22230,13324,158753,27030,52003,54466) AND (rp.team_id=69592 OR rp.team_id=69597)
0.0127   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2015 AS ev WHERE ev.match_id=19745 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0139   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=3775 WHERE dp.id IN (72,146766,28185,39979,66,23408,29364,2100,100715,61052,23437,74892,23343,22230,27010,54466,23341,54978,13324,138776,158753,44027,27030,52003) AND (rp.team_id=69592 OR rp.team_id=69597)
0.0132  SELECT data1 FROM stats2015 t WHERE league_id = 3775 AND teamId = 69597 and type = 33
0.0131  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 3775 AND id_match = 19745
0.0144  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='3775' AND relp.team_id = drea.team_id WHERE rel.team_number=107027 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0144  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='3775' AND relp.team_id = drea.team_id WHERE rel.team_number=107028 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0132  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='3775' AND relp.team_id=69592 WHERE mp.`match_id` = '19745' AND mp.year='2015' AND p.id NOT IN (23340,23341,27010,22230,66,2100,44027,54466,28185,61052,72,23437,54978,65710,146766,28231,23408,29364,138776,21325,27030,39979) ORDER BY mp.`team` ASC, p.`role` ASC
0.0130  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='3775' AND relp.team_id=69597 WHERE mp.`match_id` = '19745' AND mp.year='2015' AND p.id NOT IN (23340,23341,27010,22230,66,2100,44027,54466,28185,61052,72,23437,54978,65710,146766,28231,23408,29364,138776,21325,27030,39979) ORDER BY mp.`team` ASC, p.`role` ASC
0.0127  SELECT kit FROM kit_data_real WHERE league_id = 3775 AND id_match = 19745
0.0126  SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '19745' and rp.type = 2015 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '19745' and rp.type = 2015 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  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 = 3775 AND rel.team1 = 69592 AND rel.team2 = 69597 ORDER BY FIELD(m.location,'es','en') DESC
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 19745 AND year = 2015 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 19745 AND year = 2015 AND channel = 'Footters' LIMIT 1
0.0128  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 = 3775 AND rel.team1 = 69592 AND rel.team2 = 69597 ORDER BY FIELD(m.location,'es','en') DESC
0.0130  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 `calendars2015` 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` = 3775 AND c.`round` = 36 ORDER BY shedule ASC LIMIT 12
0.0253  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 = 3775 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2015` WHERE league_id = 3775 AND round >= 38 AND round <= 38 AND team = 69592 ORDER BY round ASC
0.0575   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` = '3775' AND c.`match_id` = '19745' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0129   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 = '5683881' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0130   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 = '5684043' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0135   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 = '5676384' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0132   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 = '5675742' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0130   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 = '5695475' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0144   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 = '5662437' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0129   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 = '5662568' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0127   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 = '5663653' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0128   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 = '5676708' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0130   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 = '5676690' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0128   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 = '5670523' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0132   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 = '5668706' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0129   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 = '5671343' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0132   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 = '5669679' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0131   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 = '5662395' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0140  SELECT dr.name as showName, dr2.name as referee_var FROM calendars2015 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2015 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=2015 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 69592 AND c.team2 = 69597 AND c.league_id = 3775
0.0128  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='19745' AND `active` = 1 AND year = 2015
0.0131  SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='19745' AND `active` = 1 AND year = 2015
0.0167  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='3775' AND relp.team_id=69592 WHERE relp.in_squad=1 and mp.`match_id` = '19745' AND mp.year='2015' ORDER BY mp.`team` ASC, p.`role` ASC
0.0167  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='3775' AND relp.team_id=69597 WHERE relp.in_squad=1 and mp.`match_id` = '19745' AND mp.year='2015' ORDER BY mp.`team` ASC, p.`role` ASC
0.0132  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '3775' AND id_match = '19745'
0.0132   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 = '107027' ORDER BY rating DESC LIMIT 1
0.0131   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 = '107028' ORDER BY rating DESC LIMIT 1
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19745 AND extraId = 3775 AND type_rel = 4
0.0128  SELECT year FROM leagues WHERE id=3775
0.0128  SELECT shedule FROM calendars2015 WHERE id=19745
0.0148  SELECT /*115 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' INNER JOIN bs_news_rel rel ON rel.newId = n.id AND rel.type_rel = 4 AND rel.typeId = 19745 AND rel.extraId = 3775 WHERE n.status = 1 AND n.ln='es' AND n.creation_date>'2015-06-16 00:00:00' AND n.creation_date<'2015-07-08 20:00:00' GROUP BY n.id ORDER BY n.cover_points DESC,n.creation_date DESC LIMIT 5
0.0130  SELECT rating1, rating2 FROM calendars_elo WHERE id=19745 AND league_id=3775 AND year=2015
0.0129  SELECT position FROM tables2015 WHERE team=69592 AND league_id=3775 AND round=36
0.0128  SELECT position FROM tables2015 WHERE team=69597 AND league_id=3775 AND round=36
0.0128  SELECT * FROM futbol.calendars_lineups WHERE id = 19745 AND league_id = 3775 AND year = 2015